Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sprite

    On Timer Event Not Working in Access Forms

    PHV, o my gosh. the first time i tried it, "=0" didnt work, now it does. thanks for your help.
  2. sprite

    On Timer Event Not Working in Access Forms

    oops, I spoke too soon. after i took out todays date in my table (i was using it to test), it didnt work right. it kept running over and over. seems like there shld be something in the code that evaluates todays date and if todays date is in the table. if not then dont run. if todays date is in...
  3. sprite

    On Timer Event Not Working in Access Forms

    Hi Duane and PHV, Actually I figured it out, the value there should be <> -1. It works now. Thanks for everybody's help. Robert
  4. sprite

    On Timer Event Not Working in Access Forms

    Hi Duane, here is my code: Private Sub Form_Timer() If Nz(DLookup("SchedDone", "tblEmailLog ", "SchedDate =#" & Date & "#"), 1) <> 1 Then DoCmd.RunMacro "macAutoEmailMasterbaseToNicola" CurrentDb.Execute _ "UPDATE tblEmailLog " & _ "Set...
  5. sprite

    On Timer Event Not Working in Access Forms

    Duane, ok, that works except now im back to where i was b4 where it keeps running over and over continuously. i need something back in there to tell it not to run if its already run before. thanks.
  6. sprite

    On Timer Event Not Working in Access Forms

    hey, thanks guys. got one last request. i've decided to list specific dates, like: if date() = 12/30/2009 or if date() = 01/14/2010 or if date() = 02/21/2010, etc. but whats the right way of doing it. here is the code i have so far: Private Sub Form_Timer() If Date = 12 /...
  7. sprite

    On Timer Event Not Working in Access Forms

    Thanks Duane, that worked, but youre right I don't want to send more than one email. How would I do that? So, if I opened the db this morning and the email was sent, then I close it, but I open it again later, its gonna send another email. I thought about some kind of counter or somethin, like...
  8. sprite

    On Timer Event Not Working in Access Forms

    Any idea why my On Timer event won't work in my Access Form? I've tried many different timer intervals from 1 to 1000000. Here is my code: Private Sub Form_Timer() ' Check to see if today is Tuesday and if true ' import weekly data If Day(Date) = 3 Then...
  9. sprite

    file error: data may have been los

    I am getting the same message in an Excel XP file. It happens everytime I open an Access db that is linked to the Excel file. When I open the Excel file, all the data has been moved around. Its the weirdest thing I've ever seen. The only way to prevent it from happening is open the Excel file...
  10. sprite

    Linked tbls using ODBC and passwrd issue

    Ok, I have several Access dbs with linked tables in them from a teradata db using an ODBC driver. My problem is that whenever my password for teradata expires, I have to go into every Access db and re-link the tbls with my new password. I checked "remember password" when I originally linked the...
  11. sprite

    How do I do Text To Columns in Access?

    HORRAY!!! Many many thanks to PHV and Leslie! It works. I could never have done it without you. This is awesome. I have been trying to do this for so long. Hope our paths meet again. Sprite
  12. sprite

    How do I do Text To Columns in Access?

    Oh, wow, we're gettin real close now. I did as you suggested and here is what my output looked like (at bottom). I think there maybe just a little somethin that needs to be tweaked. What do you think? My tblaccountidstest table looks like this: BL AI 111805332 3444548 133060812...
  13. sprite

    How do I do Text To Columns in Access?

    PH or Leslie, I have been trying to figure out how to take the string and put it into a format that is usable (query, tbl, etc.) for a week now. I'm brain dead. Please help. Again, here is the code I've got: Private Sub CreateAIList_Click() Dim db As Database Dim rs As Recordset Dim strAI As...
  14. sprite

    How do I do Text To Columns in Access?

    Leslie, I have no idea how to do that though. I thought it might be easier to create the table. If you can help me, that would be greatly appreciated. Sprite
  15. sprite

    How do I do Text To Columns in Access?

    I have to display it in a table that can be exported to Excel by the end user. It also has to be displayed in a report for the end user. Thanks, Sprite
  16. sprite

    How do I do Text To Columns in Access?

    Maybe I'll be able to figure out the string space problem. I need to create a new table that has 2 columns "BL" and "AI" that looks like the example in my first post. Thanks.
  17. sprite

    How do I do Text To Columns in Access?

    Me again. I think we are getting closer. Why would I get an error message that says "Run Time Error 14, Out of String Space"? I thought maybe there were too many numbers (there were 30 total) so I deleted some to test just 6. I didn't get an error and I think it worked but where would I see the...
  18. sprite

    How do I do Text To Columns in Access?

    Thanks , I hate to be a pest but now I'm getting a "Object Required" message. When I debug, the line: "strAI = rs1!AI" is hilighted in yellow. Do you know why that would happen? Thanks, Sprite
  19. sprite

    &quot;I want to see each item and all its parts on one line&quot;. - User

    John, Im trying this and I cant get pass step 1. How do I add a logical field to the table to record when each line processed? Thanks, Sprite
  20. sprite

    How do I do Text To Columns in Access?

    Thanks Leslie, I'm getting a "Loop without a Do" error message. Here is the code I have: Private Sub CreateAIList_Click() Dim db As Database Dim rs As Recordset Dim strAI As String ' string to contain list of competitors Set db = CurrentDb Set rs = db.OpenRecordset("SELECT...

Part and Inventory Search

Back
Top