Search Results - VBForums

Search:

Type: Posts; User: scoobster

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: Access 2010 - Import Specifications not listed in MSysIMEXSpecs table

    any thoughts on why?
  2. Replies
    1
    Views
    242

    Re: how to change record source of a form

    don't worry. I solved it myself.



    mysql = "SELECT [Sheet99$_ImportErrors].* FROM [Sheet99$_ImportErrors]; "

    DoCmd.OpenForm "frmViewImportErrors", acFormDS, , , acFormReadOnly...
  3. Replies
    1
    Views
    242

    how to change record source of a form

    I have a form with a command button and a list box. The list box has the name of "$_importerrors" tables from within the current database. A user will select one of these values and click the command...
  4. Access : Update field in table for a selected item

    I have a list box on a form which is having unique values read from a table. WHen a user clicks on a row in the list box then I would like a field (of 'yes/no' type and called 'refresh') to have it's...
  5. Access 2010 - Import Specifications not listed in MSysIMEXSpecs table

    Hi

    I've read a few places that the import / export specs for Access 2010 are stored in the MSysIMEXSpecs table. I have access to this table and I can see just a few of the import specs which I've...
  6. Re: Access 2010 - return a value only if it appears in a group of specific values

    Great. Thanks

    and I can use a SELECT statement to return the EU countries in place of hardcoding those within the query? Some thing like;



    where C.Country in SELECT country from Eligible...
  7. Re: Access 2010 - How do I update field in table based on partial value in other tabl

    That is perfect. Many thanks for replying.
  8. Re: Access 2010 - return a value only if it appears in a group of specific values

    Many thanks to you both for picking this up and offering your thoughts and advice.

    tg - I setup this example in a test database but was unable to return the result I need. That is, "show products...
  9. Access 2010 - return a value only if it appears in a group of specific values

    I have a table which lists the countries in which a product can be sold. One product can be sold in some countries but not in others. Below is a small example of how the data looks;

    Product ...
  10. Re: Access 2010 - How do I update field in table based on partial value in other tabl

    Thanks for that. So it's better to use code rather than a query as this is MS Access? And if it's a query then how best to set that up. I do have a single query that does the update and I could pass...
  11. Access 2010 - How do I update field in table based on partial value in other table

    I have a table that I need to update one field based on values held in another table. My main table (called MAIN) has 50k rows and contains 2 columns;
    yes/no field called 'include'
    text field...
  12. Re: count non blank cells in data area within table object - result isn't what I expe

    fixed it using the following;


    Application.WorksheetFunction.CountA(Range(ListObjects("Header").DataBodyRange.Address))
  13. Re: count non blank cells in data area within table object - result isn't what I expe

    Sure. thanks for that.

    I just want to make sure I'm not missing any "table" related function / feature that gives the same result. I mean, most what is in the COUNTA is covered using table...
  14. [RESOLVED] count non blank cells in data area within table object - result isn't what I expected

    Hi

    I have a 2 row table object named 'Header' that fills range A6 to L7. Row 6 is the header and row 7 has the data. I want to count the number of non blank cells in row 7 but I only get the...
  15. Re: returning the worksheet code name for a sheet & a simple RANGE question

    Thanks for the feedback. I now understand what the code is doing so many thanks for that, vbfbryce. But it still leaves me working with the worksheet name and that can always be changed by a user. So...
  16. Re: replace part of text held in a merged cell

    I'm on a roll ... it works exactly as I want it to now. I used the following;
    [CODEON]With shtDest.range.usedrange[CODEOFF]
  17. Re: replace part of text held in a merged cell

    ah. solved it. Originally I was using a range set with just the columns (A:Z) and once I changed that to include row numbers then it works! No clue why.

    So I used this;
    With...
  18. replace part of text held in a merged cell

    Hi

    I have a merged cell and within that I have some text. So the text is something like;

    "the company name is {Company Name} and the contact is"

    I'm using the following code to replace part...
  19. Re: returning the worksheet code name for a sheet & a simple RANGE question

    hi there. sorry to replied delay but no chance to get online.

    Thanks for the code sample. As I read and understand the code, the issue I still have is shown in your code on the following code;
    ...
  20. Re: returning the worksheet code name for a sheet & a simple RANGE question

    Thanks.

    So I'm better off storing the sheet name and corresponding 'code name' in the listbox because then I know how to reference the sheet which the value selects from the listbox?
  21. Re: returning the worksheet code name for a sheet & a simple RANGE question

    sometimes I will copy from them to another sheet.

    Other times I might just want to read the range content.
  22. Re: returning the worksheet code name for a sheet & a simple RANGE question

    yep, I'd need to rename the content of the listbox. And I would refresh the listbox content on OPEN and whenever the worksheet changed. But it's the part after that I'm struggling with. How do I...
  23. Re: returning the worksheet code name for a sheet & a simple RANGE question

    If I have 3 worksheets in a workbook (Bob, Jon, Harry) and in VBA Editor I can the following;

    Sheet1(Bob)
    Sheet2(Jon)
    Sheet3(Harry)

    A user selects 'Jon' from the listbox and then I would like...
  24. Re: returning the worksheet code name for a sheet & a simple RANGE question

    I mean the sheet number that Excel automatically assigned when a sheet is created. That wont change if a user changes the order or the name of the sheet within Excel.

    I can see the sheet number...
  25. [RESOLVED] returning the worksheet code name for a sheet & a simple RANGE question

    Hello forum members,

    I have a listbox that contains a list of worksheets held on a workbook. The user will select a single value from the listbox and I will then copy the contents of that...
  26. Re: Selecting a directory and looping through all outlook PST stored in the directory

    Thanks for the tip. I'm not at all familar with coding for Outlook access. Any snippit of code available or do you know where I can find examples? I have trawled through a lot of Google results but...
  27. Selecting a directory and looping through all outlook PST stored in the directory

    Hi

    I need to pick a folder on my computer which is holding many PST files. Once the directory is selected then I would like to open each PST and carry out some processing. I already have the code...
  28. Re: [RESOLVED] Adding a border to a cell within a table range when values are missing

    Many thanks.
    I amended to use the 'borderaround' parameter to save a few links of code;
    .BorderAround ColorIndex:=3, Weight:=xlThin
  29. Re: Adding a border to a cell within a table range when values are missing

    19 columns wide as of now. Shouldn't grow any wider.
  30. Re: Adding a border to a cell within a table range when values are missing

    Almost perfect. It works but I wonder if I could lose the hardcoded columns in the select statement? Can I read those from a cell on the workbook?

    Thanks for you help.
  31. Re: Adding a border to a cell within a table range when values are missing

    That's great. Many thanks. If I wanted to check only columns 3,4,6,9,12 rather than all, can the loop be modified?

    Thanks again.
  32. [RESOLVED] Adding a border to a cell within a table range when values are missing

    Hello Forum

    I have an Excel table range and I want to flag where data is missing after a user clicks a button to kick off some processing. All I need is a way to identify the offending cell(s) and...
  33. Re: generating a sequence of numbers from a specified value range (1-5 = 1,2,3,4,5)

    Many thanks. I turned it into a function and now it works exactly as I need it.
  34. [RESOLVED] generating a sequence of numbers from a specified value range (1-5 = 1,2,3,4,5)

    Hello Forum

    I would like a function that returns a string of values based on a range of numbers entered into a cell.

    For example, if a user has entered 1,2,3-9,14,17,24,21 then I would like a...
  35. [RESOLVED] Return the column position of found value within a range

    Hi
    I have a named range that sits in range D1 to H1. My program uses the FIND method to check that a value exists in the named range. When the value exists then I want to return the position within...
  36. Re: [RESOLVED] Filter range, copy specific columns and paste to new workbook

    Many thanks - that helped a lot
  37. Re: referencing a workbook and table object from a called function or procedure

    Ah, it's working now. I replaced 'sheet4' with the actual sheet name and now the values is returned. But isn't it better to use the 'internal' name of the sheet in case somebody remains the sheet at...
  38. Re: referencing a workbook and table object from a called function or procedure

    Hello Yowser

    I do pass the 'Thisworkbook' object by reference to the function but when I get an error when the line runs; 9 - subscript out of range. I setup a test to see if the called function...
  39. Re: referencing a workbook and table object from a called function or procedure

    Thanks for your reply Westconn1

    If I am in a function and want to output some values to a table then I need to pass the name of the table + worksheet + column heading into the function so that I...
  40. Re: how can I automate the writing of text value into rows and columns that can vary

    Many thanks for the hint. Code is now working perfectly.
Results 1 to 40 of 90
Page 1 of 3 1 2 3



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.