Search results

I would add it to the field's AfterUpdate event so when the user changes the field and tries to move away from it, the msgbox will appear.

I have a few fields on a form which count the number of records in a table based on certain criteria. They work fine however it can take up to 30 seconds to display the values. Is there any way of displaying text for example saying "loading" somewhere next to the field while the figures are...

Ken Good thinking.... will try it out! Cheers Gary

Hi Ken Ok here is how it works. The form has two fields which together must equal a unique number, this is a change number and a version number, so for example, 12345 and version 2. I have a hidden field on my form which combines the two, this becomes 123452. I have a query which contains...

Strange one this. I have a form a user fills in. The form it set to only allow an addition. The user fills in a unique number and after filling in all the other fields, I direct them to a button which asks if they want to save the record. If they decide to save it, I have a dlookup...

Didnt work but fixed it by making a new query, then on the button which tells the form to open, I said forms!etc etc .listresults.rowsource = (name of new query) and this works fine. Thanks anyway :)

Yeah I did this already, didnt return any error. The message box says: SELECT ... blah blah blah WHERE Q_Search_All.Site_Name like *abb* FROM Q_Search etc etc etc... Gary

Hi I have a form with a box on it where a user can type something, called searchbox. I want to send a sql statement to a list box on another form, which will look up the name of a site, based on the text typed in the searchbox. I want to use the like statement, so it will search for the...

Hi In my form I have a function where the user can say if a date is not required, for example, if the date something was returned is not needed, they press a button, the field is made black, but in order to identify these records later on, I placed the value of 30/12/1899 in the field. My...

Arrrghh why didnt I think of the Dlookup! yeah that worked, many thanks :)

Thanks Bob yes i'm aware I would need to add some code to the On_Open event on the form to set the variable, but I am unsure of the code I know it would need to be FileLoc = <<the field in the table>> But its the syntax for the <<field in the table>> bit I am stuck with to tell the...

The user may want to change the default location.... The location is currently stored in a field called FName in a table called T_Param. I made a form, which uses this table to show the user the current default location. If they change it and click the change button, it tells the public...

I have a table in my database called T_Param which will contain defaults for the forms used within the database. One form auto creates a folder location, but I want the user to be able to specify where the default location will be. I created a public variable called location and a form which...

Dont know why I didnt think of this before but I have fixed it. I re-wrote it like this if isnull(dob) then <change cell color) else if year(dob) = 1970 then <change cell color> endif endif Thanks anyway!!!

Cheers for the prompt reply but unfortunately same error (invalid use of null) Code is: If Nz(Year(PASSIVE_START_DATE), 0) = 1899 Then Me.PASSIVE_START_DATE.BackColor = 0 Else Me.PASSIVE_START_DATE.BackColor = 16777215 End If Basically, if a date is not required the user wants to show...

Hiya Probably something really quick to fix but I have an if statement which does something if a certain date exists in a date field. So for example If dob = 1970 then msgbox "correct" else msgbox "incorrect" endif This works fine when a date exists in the date field, but...

Sent it to you yesterday morning...

What is your email address I can send you a solution....

Yeah that worked, thankya kindly :)

Hi I have 4 complex Excel files which I am using as a template. I have a database in Access which, when a new record is created, makes a new folder using a set naming convention. The Excel files are too complex to recreate in Access, so I wondered if it was possible within Access to tell...