Search results

they are definitely on the onclick event does anyone have any other ideas? :(

Thanks for your help. So far the query itself works, but the text box does not update automatically yet. I haven't tried making the text box unbound, because I need the data to be saved to the table - I have a query that looks up expiry dates in the next 14 days. Is there another way around this?

No. What do you mean about refresh? I haven't come across that before...

Damn I feel silly now. I was using "" :o

I have 2 fields called "start date" and "expiry date". The expiry date is always 6 months, less a day, than what the start date is. Rather than the user calculate the expiry date in their head when filling out the form, I'd like it to appear automatically as soon as the start date is entered. If...

I have some fields in my table that aren't "required", but would like a way of searching for records with a certain field that has been left empty. What would I put in the criteria of a query to show these records?

I have a search form which uses a query to retrieve results. The search criterea is chosen by the user, from 2 combo boxes. A "search" button runs the query. In the criterea section of the query I have for each field to be searched: [Forms]![FormName]![ComboName] (obviously I put the correct...

I have a main menu which has buttons to open other forms. Most of them work fine except for 2. When the buttons are clicked the corresponding forms do open, BUT they hide behind the main menu. Its only when I click the same button again that it pops up properly.... I've checked all of the...

I can't believe I didn't think of that! Thanks a lot I will try it now :D

I have a client table, with a field called "status" which says whether they are "current" or "past". I have a delete button on a form to delete clients, but would like to only permit past clients to be deleted. I would like incorporate a message box to say "you cannot delete a current client"...

I have a form to browse through entries of a table. I have a field called "status", which is either "past" or "current". When browsing through the entries via the form I would like all "current" entries to appear first, and the past ones at the end. Is there a way to automatically sort entries...

I have tried this too, but for some reason it seems to create a new record in the table, instead of changing a specific one. Any ideas why this is happening? Cheers

I want a macro to change the value of a field in another table - its a combo box stating "available" and "unavailable". I would like to change these values automatically, based on what I enter in another form. I have tried using SetValue, but it does not seem to work without error.

On my data entry form, the ID (primary key) is shown, and its an auto number. I have shaded the text box differently to make it obvious to the user they don't have to enter a value into it. However, when the form is loaded the cursor starts in the ID field. I would like it to start in the next...

When deleting a record, Access displays its own warning message. I would like to use my own message for when users delete a record via a form. Is there any way the default message can be customised or overridden? (I am using Access 2003).

I currently have a search form that runs a query with parameters defined by the user. It’s a simple form, with a text box for user input, and a search button to run the query. I’d like to add a further button called “clear” or “new search”, which basically just empties the text box for the user...

I have a form I wish to be used to browse and edit records only, not add new ones. In the form properties I disabled additions by selecting “no”, but now when I view the form it is blank, why is this? (I use Access 2003). :confused: