Search results

Hi Im trying to use Duane's concatenate function in a query. Basically I have two tables, one contains all the main records, the other table contains all the comments people have added relating to that table. The comment field in the comments table is a memo field. In the query, im simply...

Hi I'm trying to store the location of a file chosen by the user using the file chooser dialogue box. This code is taken from Microsoft. However, the MS code shows it for a list box. I just want it to store 1 file location in 1 field, called FileList. Here is the code: The bit is red is...

Here is my problem. I have a "main form" on which I have some fields. For one of the fields, I want to say that if the date field is blank, it is to use the date field (for the same building) from another table. Ive built a query which shows the date from the other table, depending on the...

Is there any way to set the docmd.runcommand acCmdZoomBox so that when the expanded text window appears it is read only? Just I have a memo field on a form I want people to be able to click on and read everything in it, but not edit it.....

I want to insert some values into a table but cant get the syntax right. I have four fields in the table: Date, Time, User, Action When a user logs in, I want it to insert the date, time, the username and action performed. The username I get from another script. So I declare the...

I've seen this done so I know you can do it but dont know how to do it myself. I have a form, which is continual, so the fields repeat all the way down the field. Lets say that I tell the form that if a field is blank, I want to change the background color of that field to red. Easy to do...

I have a form which has the file folder location contained in a file called Document Location. On the form is a button which runs a macro to export a report in Word format. All works well, except the Macro prompts the user for the save location for the file, and defaults to the name of the...

I'm getting a "criteria mismatch" error when trying to execute some code, im sure it has something to do with the formatting of the field but cant see where. I have a table called T_locks which I want to record the record number, username and date and time opened for files in a multiuser...

I have a form with a lot of fields on it. I am toying with the idea of making the field change colour (say turn the background yellow) when the field has focus, and then go back to white when it loses focus. Is there a quick way to do this to all the fields rather than adding a few lines of...

Ok i'm banging my head against a wall with this one. I have a field on my form (Date to complete IA). What I want is if the date to complete IA is within 5 days of todays date, I want the field to turn orange. If the date has past, then I want it to turn red, provided that the IA Status meets...

Ok I did this years ago and cant remember now how to do it. Right, I have a form, in the form header I have placed the good old ActiveX Calendar control. In the detail, which is continous, I have my data fields, such as Date, Time, Event. What I want is: 1) when the user clicks on a...

I would have thought the lines in a sub are executed in order, but I have a sub which updates the data in a list as such: sub anexample() me.statusbox = "Please wait..." me.listbox1.rowsource = "Select blah blah blah" me. statusbox = "" End sub Theroetically, I would have thought...

I have 6 tables, with a field relating to a change number, then fields starting Jan06 through to Jan 2015, the tables record resource useage for every month through this time period for a change. As you can see this is a lot of numeric fields. The problem I have is that I now want to be able...

Never seen this happen before in all my 10 years of using Access. I have a table with a primary key field (record number) which is a autonumber field. Been using it fine for months, now all of a sudden, after record number 1105 it reverts back to 430, which of course already exists. I have...

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

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

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

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

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