Recent content by rubyred

Hi!:rolleyes: On your subform, in design view, click View on the menu bar, then click on Tab Order and see what order they are in here. You can drag the controls to any sequence needed. The "0" Control should be the first one in the list. If it isn't, find it in the list and drag it to the...

You're Welcome. Glad to have helped!:D

In Design View of the form, click on View from the Menu Bar and chose Field List (it may already be there when you first go into design view) - look for it first somewhere near the top right of the form. If it isn't there, then click on View and chose Field List. It will be a small dialogue type...

Oooops! Fernin8R, I'm sorry, I didn't see your question to just a second ago. The first AfterUpdate Event for the stoptime is in the stoptime's control. Why do you ask?? Should it be in the form's. This is actually a subform of, of course, in a main form. Just the two. Main form with...

OK! That did it!!!!! Thanks to both of you!!! I'll be back shortly with a few more questions :D I hope I won't be a pest. Before I ask a question, rest assured I have already spent a couple of hours trying to figure it out, but because I am so green, it's really hard for me at this point...

Thanks cogent1 for your reply and help. It works!!!! I am very grateful. . . . However, it has somehow caused my data entry to be a litte amiss. Now when I key in stoptime as a regular entry, the focus goes immediately to the next record's stoptime instead of going to the next control on...

I have 2 fields on a form - StartTime and StopTime. To prevent any gaps in time, the field "StopTime"s value is automatically copied to the next record's StartTime field. This form in in datasheet view.The problem arises when we go back and change a "stoptime" value after a few records have...

Thanks so very, very much. You have certainly made my day! I have been wondering about this for a long, long time. I have looked and looked in Access help for an explanation but have never been able to find anything! I appreciate you taking the time to answer and you explained in such a way...

Great David!!! Thanks so much for that explanation. I understand and feel much better now. By the way, I am using Access 97 here at work. But, how does it work when stLinkCriteria information is not declared or defined as in the code I posted above? The code I was looking at (exactly like I...

When you use the wizards to do certain things, Microsoft uses the expression StLinkCriteria a lot. I can't understand what it is exactly doing. Here is an example: Dim stDocName As String (I understand this) Dim stLinkCriteria As String (??????) stDocName = "NewCustomer"...

Do another query (using the original query as the source). Bring down the Item field into the design grid. Click on the aggregate function symbol at the top (looks something like "E".) In the criteria section of the Item field, type in "Routers" and use "Group By" in the Total Row. Create a...

Rich, Just wanted you to know that I am just about to let this database go active. I used your "valued" advice for starters and then went from there. It was a struggle, but I believe my DB is normalized to a high degree (5? - maybe). Table 1 has Date, Shift, AuditorName and then Transaction...

I am assuming you have the Row Source Type for this Combo Box filled in with Table/Query and then in the Row Source property: SELECT [QueryName].[CustID],[QueryName].[Customer],[QueryName].[Phone] FROM [QueryName]; Then in the AfterUpdate Event of Combo Box: Me![Phone] = Me![Phone].Column.(2)...

Rich. . . . It's me already. I am confused. I report a failure on one of the looms but in addition to knowing that there was this particular failure present (from Table 1), we need to know how many there are. Let's say for example, Loom #1604 has Floats (one of the items in the Audit Item...

Thanks once again Rich. I am going to experiment with it later this afternoon. I'll let you know how it goes. I may need to seek your assistance further once I get it going. I hope that is OK with you??? I sincerely appreciate you taking this time to help. Most of my databases to this...