Search results

Any idea's? I can assign a normal query to a button by using the button wizard but the delete query doesnt appear with the normal queries. As always - any help would be great.

Thank you all for your help and input - the problem is sorted now.

The error boxes are coming up promting the user to type the data in the correct box. However the record is still being added with the blank data. :mad:

P.S I tried using the 'Required' property but for it kept bringing up errors.

Can someone explain the following? This is the coding i have now used for the button, yet when it is pressed it STILL enters data even though in theory it shouldnt. Now to my understanding this shouldn't submit the record if data is missing but for some reason it still is :confused Is there...

OK, The Form is bound to a table named 'TblBookings'. The reason it says record added when the user clicks the 'Add Record' Button is because i created a message box to do this The code i have used in the 'Add Record' button is shown below, You are right though MAC this could cause confusion...

Thank you all its fixed now. When i click the button it still says its added the record but unless data is entered in all fields it doesnt actually submit the record to the table. :)

How do i make the fields 'required'?

Thanks a lot :)

I have a database which stores visitor information. I would like to set up a query so that a user can click the query, input a country name and then be shown the visitors from that country. At the moment i can only enter criteria such as '=England' into the criteria box which is ok but what...

I have a table with various data input boxes. I have created a button (using the button wizard) which adds the record. However the only problem with this is, if some fields are left blank by the user and the button is pressed the record is still added. Does anyone have an idea how i can stop...

Its not a command button - its a cell in a subform. There is no place to put a hyperlink only an option, hyperlink yes/no. All for the want of a mouseover :)

Firstly, thanks for your help with the previous question i asked. Im getting into the final stages of my database now and have a new question to ask :) Whats the command to turn the mouse pointer into a hand on mouseover. Seems simple enough i know but i cant get it to work. I dont want it to...

Ok, Thank you. The hard part is now comparing the current date with the date in the date of departure field and then clearing the date of departure field if it is equal to or more than the current date. This i assume would be done by using a macro but i cant find the correct code.

I was wondering if any of you could help me, I have created a database an need a validation method. Here is the scenario, I have 3 fields Room Number // Date of Departure // Room in Use Here is what i want to happen, when the database is opened i need to check the current date and compare...