Recent content by John Williams

Hi I am using the "like" parameter like"*"&[Enter Invoice]&"*". If I put an invalid or non exsistant invoice in I go to a blank form. Is there a way of giving a message instead of the blank form

All I have had a reply saying that the method I am using is not very reliable. I will test this on some real forms I have in my office. These froms are single sheet excel forms. This will tell me whether or not using"last"in a query is acceptable. My last task is to create a " find box". I have...

All I have resloved my issue by using the "Last" record in a query table and then linking to a new query which holds all the information. I then ran a report on query which gives the last or newest record. I can now print, save, e mail or print Preview the last record. I did have to add a save...

Hi I will look at SQL. I have a basic understanding so will spend some researching this on line. In the meantime my project is still alive. I didn't mention what the project was. I am creating a centralised database so that particular task I do as part of my job which is currently done on...

All I have created a workaround until I can resolve the criteria issue. Basically I have added a date and time field to my table. I have created a query with a criteria of date(). I have then created a report using the query. I have then added this report into the expression and removed the...

All. I am really pleased with the response I am receiving. I have taken the strCriteria out of the DoCmd and using HTML I get an HTML page showing all the records in report format. I now have to understand the replies I am getting and work on this part so that I can get only one record. While I...

None. I save and debug ok. No errors. I forced an error on just to see if Debug was working. It's only the Save/output that gets the error. Print report works ok. I can print individual forms in report style ok.

I have created a form that I want to save and print the current form. Print works ok but I get an error when clicking the save button. The error is: An expression you entered is the wrong data type for one of the arguments. This is my code. I have tried looking at various web site and access...