Search results

I am working with varying degrees of luck and satisfaction on Access 97. On one form I select a vehicle (Shop) to place in service. Once In Service I want to note when it was placed in Service and by whom. I can get it to assign the times and date, but on returning to the form and attempting...

I've come a long way on Access 97 in a few days thanks to all here. Now I have another problem. I have a form based on a table of Vehicles. The header of the form states who is using the program. This is shown on an unbound field "User" and comes from the table LogOn. I need to assign the...

I appreciate the help, but it still is not working at all, much less properly. It still moves from that box straight on to the other with no message box or any indication that it notices anything wrong. By any chance, should it be written in a different manner for Access97?

Still learning the wonders of VB. Right now I am wondering how to have a Message box appear if the user has or is exiting a control and leaving it blank. I want the message box to return the user to the empty control once the OK is clicked. I tried using the validation properties, but it...

My VBA experience to this point is rather limited. Hopefully that will be changing soon. What I wish to do is create a primary key for a table based on the date and the number of records created on that date. My hopes is to have the data shown as an integer in the following format. yymmddrec#...

I'm looking for some simple code that I can put in a form for the "on click" event. All I want is for it to open a second form, maximize it, and then minimize the first form. If possible I would also like it to run a macro that loads some information on the second form between the minimize and...

Thank you both. I'll give it a try as soon as the weekend comes to a close.

In creating my forms I have taken off the close and resize buttons, and placed a macro that tells the form to maximize on opening and current. A group of macros runs a variety of reports and places them in print preview. The report form has a resize button but not a close in the upper right...

I have a form that uses a combo box to find the proper record in a table to add, delete and change data in. I have a curiously interesting problem. In the form I have 3 columns of data that would be manipulated. When I click on any of the choices in the combo box it deletes the data in the...

I've tried the check for duplicates query, but it does not seem to do what I need. If I understand it correct it is checking ofr duplicates in a table. What I am trying to do is see if adding the equipment will create a duplicate. In essence I wish to check before assigning the equipment to a...

I have a total of 3 tables monitoring the use of vehicles and equipment assigned to them. Each vehicle is assigned equipment as it goes in service and the equipment is returned when it goes out of service. The "Vehicle" table shows the status of the trucks, while the "Equipment" table shows...

I have created a setup roughly based on the Norhtwinds sample. I am trying to work with the data from a series of linked tables; Orders, Order Details, and Items. Each item has a category and subcategory. I've created an order form and an order details subform in which I wish to have a...

This may have been posted twice. I apologize for that, but the initial post had poor formating on my part. For many this may be a rehash of info, but I can't seem to grasp the technique properly. I am building a series of tables very loosely based on the Northwind sample. The purpose is to...