Search results

As my client has requested it.

Hello all, Im at a stage of my database where a certain field need to have and automatic symbol as well as numerics. The symbol needed is an omega symbol (Ω). For instance if i put 2.4 in the field it will show 2.4Ω automatically. Regards, Topham

Cant get this to work so ive tried putting code into a private sub. Code used: what i need done is once the query has completed. I need Result from CustomerID from the query to be inserted into the CustomerID Field of a form that is open.

Boblarson Ive changed the Query name to ContactSearch so intead im using: Forms![Main Booking Form]!CustomerID=DLookUp("[CustomerID]","ContactSearch","CustomerID=" & Chr(34) & Forms![Main Booking Form]!CustomerID & Chr(34)) But im getting Error 2950. Im using a button with OnClick:Embedded...

Thanks for the quick replies. Im taking on this database half done, so im not too sure if the form is bound or not. Also the CustomerID is used in Bookings and Rides tables to associate bookings and rides to that particular Customer.

Hello, Im having some issues with dlookup. Im trying to get a value from a query and insert it into a specific field on a form. Here is the code im trying to use: Forms![Main Booking Form]!CustomerID=DLookUp("[CustomerID]","Qry: Contacts","CustomerID=" & Forms![Main Booking Form]!CustomerID)...

Hello all, I have a subform created with a set of fields, 2 being a Drop Down, and 1 input text fields. The 2 drop down fields are used for which type of test is done (Electrical, mechanical, structural, etc) and who done the test and the input text field is for when the test expires. The data...

forgot to say that both forms are open at the same time if that makes anything easier.

Hello, Im not sure if i have poste in the right place. Im currently doing a Database for a Ride inpectors company. What it is, Ive created a form where you create New Customers, with customer id and that and then on this form i have a button to open a new form for 'New Rides'. Now this Form...

Thank you Mr B for your advice i got it working the way the company wanted it. I created a query with the CustomerID, RideID and Ride name columns and for the search criteria i set it to use what ever was in the CustomerID field on the Booking form. Then for the drop down box i got it to show...

Hello, Sorry about the wrong read just thought id need to explain what i needed. Ive been creating a Database system for my mums partner's business. He is a thrill ride inspector, therefore he inspects rides you get in fairs. He has Customers Information and the customers rides. Everything is...