Search results for query: *

Thank you very much Ken, I will be trying that out. Another form has decided not to display now even though I haven't touched it and it was working this morning. I have a very bad feeling the database is corrupt.

Hi It's one of those major work-stopping Access crisises! I changed the name of a text field in a subform, saved and now the form will not open in design or form view! There are also problems with the back up so I will need to do all I can to try fix it. The text box I renamed is not called...

For some reason the format function won't work in this instance and the query does not return any records. I don't get any error messages. Any ideas on why this would be? Thanks Sel

I am just using a prompt box to get the date from the user not a form (i.e. in the criteria of the query <=[Enter Date]). Is there anything I am leaving out of the criteria (to prompt for the date)? Thanks, Sel

Hi I am having a wonderful date problem when trying to limit records in a query. I am trying to return all the records with a date (entered by the user) earlier than the calculated field, TargetDate TargetDate: DateAdd(&quot;m&quot;,2,[Request rec'd]) The expression works if I hardcode the...

I have had a search through the forums but haven't found exactly the answer I need. I want to compare the data in 2 Access databases in multiple tables. Does anyone know of a tool like the RedGate SQL compare tool for Access? I could have sworn there was a compare database tool in Access but I...

LMAO!!! This is a great post - the Government Department (need I say more) I work for insist on using Excel as a database so I can deeply empathise! I constantly bring up the foolish notion that Excel is for calculations (hence in similar office suites it is called Calc etc) and Access is for...

Thanks heaps John - worked well and saved me a huge headache. Selena

Thanks, I'll give it a go and let you know. Selene

Would someone be able to tell me what is wrong with this SQL statement? - I am trying to work around the spaces in the field names as they can't be changed. INSERT INTO tblAppraisal![Appraisal ID], [Personal ID], [Date] &quot;.... quite a few more fields SELECT * FROM tblAppraisal1 I have...

I have a form with textboxes a couple of combo boxes (filled from another table) and some checkboxes bound to a table. I'm getting the &quot;Field is too small ...&quot; error and can't work out what is causing it. I went nuts and changed every length I could to 255 chars but to no avail. I...