Search results

I would separate the LogBook and the TRnumber into two fields. Then you can use code similar to this to get the last number from the table for the particular LogBook selected. Me.TRNumber = Nz(DMax("[TRNumber]", "TableNameHere", "[LogBook] = '" & Me.LogBook & "'"), 0) + 1 I have assumed that...

The ProductID field in the Products table should be an autonumber and the Primary Key for the table. It should look bold in your Relationship window. The ProductID in the related table should be a Long Interger data type and does not need to be a compound key as in the Northwinds example. Here...

Hooray! I am glad you got it solved... Jack

I would suggest that you validate your controls in the forms Before Update event. This way if the user tries to exit the form the code will check to be sure that the required fields have data. Open any form in design view and open the property sheet. Under the Event tab place the cursor in the...

All I can say is you have your work cut out for you. Trying to find matches is not too hard but finding the right ones (all of them) and putting them all together is going to be some fun, but I am sure it can be done... Jack

Your users should not have access to the tables if there is a chance they will enter data directly. Hide the table(s) or use Access security to limit access to your table(s) and this should insure that the data is entered through your form(s). Jack

Hmmmm. What if you have Smith R. and Smith, Ruth and Smith, Rose and Smith, Ruby, which is the correct first name for that particular Smith R? You can parse the names using the Left(), Right(), Mid() and InStr() functions in Access and this article should help you get started... Jack

Instead of indexing the field I would use code in the controls Before Update event to validate the entry. This way your code will stop if "ABC" = "abc". Also, you can pop up a nice message instead of the message Access gives you.... hth, Jack

The only thing you want to put in the table from the lookup table is the ID of the record you select otherwise you will have the same data in two places and that is not good. If you want to add a person, for example, to a table you would use a combo box bound to the PersonID on a form that is...

Take a look here. hth, Jack

I don't know how you are doing the name, but if it is [Enter A Name] in the criteria line of the query then it should not work. The code I suggested works because the query doesn't have a criteria for the Dates field if you leave the entries blank. Take a look at the query and you will see that...

Add this code in the line directly below your current one: Between [Enter From Date] And [Enter Thru Date] Is Null hth, Jack

I have looked at the picture of your form and you do not have your table normalized. You should not have the memo fields in the table but in a related table. I would suggest that you normalize your tables before you go any further or you will have a lot of difficulty later on when you try to...

Base your form on a table or a query and show the fields that you want the user to see. When the form is finished create a combo box using the Wizard and on the Wizard's first screen select the 3rd item, "Find a record...". Finish the Wizard and then the user can select the UserName from the...

In the Control Source of an unbound control: =[Quantity] * [UnitPrice] In the After Update of the Quantity or UnitPrice Control: Me.Price = [Quantity] * [UnitPrice] Change the names to reflect the actual names of your controls and do not save the value from the calculation in your table. In...

Maybe the attached Access2000 demo will give you some ideas... hth, Jack

If input masks were a bit better I would agree with you completely. I just find them difficult and not very 'user friendly' so I use the same system that you are using now... A bit more work for you, but a better product for the user, in my opinion... Jack

I wouldn't use an input mask but validate the input in the Before Update event of the control and then let the user know if it is wrong, and why, and let them try again... hth, Jack

Set the Field Size for the field in the table that holds this number to Single or Double. hth, Jack

Use an append query to add the selected items ID to the table that is related to the order that I assume you are filling... hth, Jack