Search results

Hello Guys, I have a section of my form that may contain no data what so ever and therefore i need to have a code that if theres no data a field to put a space and if there is a value to put the value in. Heres the code im using and yet im getting Error 94 Invalid use of null If...

Hello im new to VBA and im trying to get one button to do 2 things depending on a value in a certain field of a form. Please see code below. Regards,

I have a created a query that filters a table. The data is shown is CustomerID,FName,SName. There is a Field that alread has the CustomerID in and i have a button to open the query with the criteria of what ever the ID is in the CustomerID field. This all works great but how do i go about...

Hello all, On a form i have a search button that runs a query which searches for a person, This works great but how do i get the query results to view on the same form where the search button is? Regards, Topham

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

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

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

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