Search results for query: *

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...

I have Access 2000 software loaded on my pc. When I open Access, my first screen states, "Create a new database using": (1) access database wizards, pages, project (2) blank access database or (3) open existing file. I created my database using option 2 - blank access database. I originally...

I understand what you're saying regarding splitting the database. I'm confused when you say...."create your runtime". How do I create the runtime? Do you mean identifying my program database name in the 'target' shortcut that will reside on each users pc? I'm sorry I don't understand...

I do still have the original mdb. Today, I have 3 users accessing my database over our company's network. All 3 users can access the db. at the same time. I'm not certain if I've answered your question correctly...hope so.

Thanks for the response. One more question. Can a remote user see my database tables if I do not have the database split? I only have the database as a mde. I do not have any access security on the mde. Thanks.

Hi, I have an application on Access 2000. At the time, my ofc mgr stated I could not use the runtime version of Access. Now I am being directed to deploy my application to a group of remote users as a runtime application. I'm not certain if the remote group is currently using runtime 2000 or...