Search results for query: *

If I understand you correctly, It sounds like you may be looking up the wrong column. e.g If your columns are like such: Column 0 Column 1 Column 2 IDField, FirstName, LastName then you will want to change your code from If List0.Column(1, intRow) = strA Then to If...

Are you manually entering in the value for date1. If so then your code should work fine. In the After Update event. I'd also place the same in the On Change event as well. You could also do without the "If" statement and just use: Private Sub Date1_AfterUpdate(Cancel As Integer)...

Many thanks for the responses. I have a difficult time trying to communicate my problem without going into a lengthy post. Laois: Your suggestion was very close to what I am trying to accomplish and lead me right to the solution I needed. Once again thankyou both for your suggestions. PDeeney

In Access 2000 I am trying to change the caption of a label through code after the click event of a button control until the next time I open the form and click the button again. I tried the below but each time I close and reopen the form the change is lost. Me.lblLastApproved.Caption =...

Thanks for the tips and replies back. After working all night until 5:30am I finally figured it out. Now if I can only figure out how do include the file name at the end of the path string to update the Path field. Once again thanks so mmuch for the help. Here's the working code thus far...

Can someone help me out with this? I have a database to track Artwork. The artwork filenames are named e.g. 714329-00A.zip, 714329-00B.zip where the letter is the revision of said artwork. In the revision table I have the following fields: RevisionID, ArtworkID, Revision...