Search:

Type: Posts; User: djsmith; Keyword(s):

Search: Search took 0.00 seconds.

  1. Thank you, but actually the number that should be...

    Thank you, but actually the number that should be assigned to BdMbrCount is a number 1-7 based on how many members are assigned to a district. If countofORG_Name = 5, then the BdMbrcount forthe 5...
  2. Making slow progress - I think

    I have created a countQuery to tell me how many members are with each district, which will allow me to set the Counter to the CountofORG_NAME. And I think I have figured out how to start setting up...
  3. I have looked at the link you provided above, but...

    I have looked at the link you provided above, but still struggle with loops. I now have a new issue.

    I have 397 school districts that have any number of members between 1 and 7. My goal is to...
  4. We have to download data from an online database....

    We have to download data from an online database. I then run that data through macros to prepare the data for use in Access. I found that my XLSTART file was accumulating the download files I was...
  5. Personal.xlsb new recorded macro is not available in other workbooks

    I have been using the personal.xlsb file to hold several macros that are used in various files when download for our online database. Today I created a new macro assigned to persoanl.xlsb and it...
  6. Replies
    3
    Views
    1,116

    Thank you, I had thought of that, but I am...

    Thank you, I had thought of that, but I am depending on users to click both buttons before using the final data. I was hoping to find a way to make sure that they only have to click one button.
  7. Replies
    3
    Views
    1,116

    Access 2010: Parameter Action query

    I have a couple of things I am trying to accomplish.
    1. Allow users to select one or more than one title from the list and run a parameter query.
    2. Append this data to a table that will make sure...
  8. EXCEL 2010 VBA: Range("A2").CurrentRegion.Selectg

    I have a worksheet where the range of cells change with each download of the data. The downloaded data gives me duplicates on some information. I am using excel to remove the duplicates on the...
  9. Thank you, already have it bookmarked. It seems...

    Thank you, already have it bookmarked. It seems to explain things in simple terms, I have been told that I am a visual person and that is why programming is more difficult for me. I have taken...
  10. Your correct, that worked. But I still would like...

    Your correct, that worked. But I still would like to learn how to write a loop based on data from a query. Thank you Djsmith
  11. Access 2010 VBA: Loop through records in a query

    I know just about enough programming to get me into trouble and frustrated enough when I don't understand how to proceed. Hence, I have come for assistance. I have been trying to figure this out for...
  12. RG: Thank you for the well described...

    RG: Thank you for the well described instructions. It worked like a charm and must of know, I would not have know what to put into my Query to call my function. Thank you very much.;)
  13. Access 2010 VBA: Multiple nested IIf then else statement

    I have a number of conditions to test for and each has its' own value if true. I can get this to work in the Query design window until I get to the very last piece then I get a message that my...
  14. Replies
    12
    Views
    5,079

    Thank you tgw7078 for your suggestions. I will...

    Thank you tgw7078 for your suggestions. I will definitely look into revamping this database. Especially since the end user wants to create more tables and reports than previously provided. I am...
  15. Replies
    12
    Views
    5,079

    Just this morning, I replaced the data in the...

    Just this morning, I replaced the data in the tables of a known working version of this database and that worked. With this process I used the original table structures. I discovered that someone had...
  16. Replies
    12
    Views
    5,079

    The database when opened from SharePoint, saves a...

    The database when opened from SharePoint, saves a local copy of the database. When entries are complete the "Publish to SharePoint" button updates the copy on SharePoint.

    Unfortunately, I do need...
  17. Replies
    12
    Views
    5,079

    Thank you, I have looked at the references and...

    Thank you, I have looked at the references and those are fine. I am been trying to work through the issue using a known working version of the database. It seems to work fine until I import the...
  18. Replies
    12
    Views
    5,079

    Access 2010: Error 2105

    I have a database that was created in Access 2003 and has since been upgraded to 2007 and now is being used in 2010. This database currently resides on SharePoint where it is download, updated and...
  19. Replies
    10
    Views
    5,112

    Sorry, I have been tied up with a few other...

    Sorry, I have been tied up with a few other projects. Just tried the statement suggested by Cronk--Thank you a thousand times, works like a dream. I appreciate everyone's help out here.
  20. Replies
    10
    Views
    5,112

    Thank you both! I have removed the 'as string'...

    Thank you both! I have removed the 'as string' from the function declaration. and declared it as a variable. Then I added SplitPart = LSTRSP_EML_DOMAIN before the Return.

    I went through my VBA...
  21. Replies
    10
    Views
    5,112

    I have attempted to address each of the points...

    I have attempted to address each of the points you made, I just am not sure I am really clear on some of the terms. Below is my updated SplitPart () with comments to see if I am understanding your...
  22. Replies
    10
    Views
    5,112

    No, but that could well be my problem. This is...

    No, but that could well be my problem.

    This is a drawn out process that I am trying to simplify with code. An Excel file is created from a report pulled from an online web database. This report...
  23. Replies
    10
    Views
    5,112

    Access VBA 2010: Undefined function

    I have a function
    Public Function SplitPart(LSTRSP_EML_EMAIL)
    Dim LSTRSP_EML_EMAIL As String

    'Dim LSTRSP_EML_DOMAIN As String

    Split([LSTRSP_EML_EMAIL], "@", 2) = [LSTRSP_EML_EMAIL]

    ...
Results 1 to 23 of 23