Recent content by kat25

I have a table that has old data as well as newly inputted data. The table is named FIBER. The field name is named CABLE and the other field name is NUMBER. I want to find every record that has a value loaded in the CABLE field and then list the value of what is shown in the NUMBER field in...

I will try this. Thank you so much for your quick responses.

I see the following example: DLookup("[UnitPrice]", "Order Details", "OrderID = 10248") In this example, you would be retrieving the UnitPrice field from the Order Details table where the OrderID is 10248. ********************************************************* If the "orderid" could be a...

I have a main form (RingArch)that has a command button on it to open another form,(Est.NewRing), On the Est.NewRing form the user can enter an alphanumberic value in the RingID field for a new ring number to be added. The users do not know if someone else has already entered this number into...

Thanks. You've heard the ole saying...If I had a brain I would be dangerous... I have been thinking today was Tuesday and that's why I used '3'. Once I broke for lunch...the cobwebs cleared out. Thanks for responding. Kat

No, your note was not confusing. The code worked great for me. Thanks again. Kat

Thank you so much. I appreciate your prompt reply. Have a great day.

I was given this code back in May and it worked fine for me. I lost my database that I tested this event on and now I'm trying to rebuild the event on a new test database, but its not working for me now. The only difference I am doing today is changing (date)=6 to (date)=3. Assuming '3' is...

First, let me say the title of this message does not match the question originally asked. The original message in May had several questions within the post. Now, on to my question/problem: I was given this code back in May and it worked fine for me. I lost my database that I tested this event...

When I copied/pasted from your note, it worked like a charm. Thank you kindly for all your help! Kat25

I also forgot to mention that whenever I type the + sign between vbOKOnly and vbInformation, the system removes the + sign. That is why you don't see it in my above example. Thanks.

AJN2004 I am getting a coding error - Expected Expression This is what I typed. The word "for" highlights in red. If I try to add the message a different way, then the entire message highlights in red. Thanks. ****************************************************88 Private Sub Form_Open(Cancel...

Thanks, I will give it a try. Have a good day.

Thanks. I will give this a try. In the coding "(Date) = 6..." do I type in the actual date in ( )? Such as. If Weekday(05/14/04) = 6 Thanks. I am still new to vba coding.

Thanks GDGarth and AJN2004. I really appreciate your prompt replies and assistance. One last question, which is not regarding runtime. I work Mon - Thurs and would like to be able to keep users from using the database on Fridays. Is there any code I could incorporate that would 'block' the...