Search results

I currently have a textbox on a form where on mousedown it launches a calendar and on click it allows me to select a date. It has a validation rule that controls what date can be selected. However, if I go to a record that has a date entered in the textbox and try to delete the value then the...

Morning All, In a table I have a text field (Meeting Date) which contains the date in the format: "Wednesday 22 March 2006" How do I convert this to a date of format dd/mm/yyyy? I have created another field of type date called MDate, in the same table, and have tried experimenting with an...

Outlook 2003 and Access 2003. I want to set up a mailmerge such that the From address is not the account that I am logged in as, but a different one. i.e. not joe.bloggs but admin@help. How do I do this?

I have a form, A, with a subform B. Form A contains details on software and subform B lists the machines the software is installed on. I currently add a machine manually to the subform B. If I had 40 machines, how can I do this automatically?

I need to update a database from Access 2.0 to 2002; does anyone have any hints and tips? Is there a structured methodology to doing this? At least using the convert feature results in Access crashing (Access has encountered a problem and needs to close).

I have two tables: licence and machine. I've created a form/subform: licence form, machine subform. When I look at a licence the subform will contain a list of the machines with that licence. The machine table is already populated with 30k records and the the licence table currently holds one...

I'm trying to create a form from two tables but it errors out with: The wizard is unable to create your form or report because you chose too many fields; please try again with fewer fields. However, I can't reduce the number of fields and it's not because I don't want to. Is there another way...

I currently import data from a csv file into a table(A), which is then copied into table(B). In table A the fields are of type text since it's from a csv file. The fields in table B are also of the same type. If I change fields in table B to 'number' for example, then I can't copy the data from...

I have two tables: Table A and Table B. Table B is wiped and reloaded with fresh data every day. The PKey is 'MAC address'. I'm trying to create a delete query which will compare the two tables and delete any records in Table A that are not found in Table B, but I'm having problems with the...