Search results

I think you need to use OR instead of AND. Try: "020" OR "040"

If only one person uses the database at a time, you can select the compact on close option. This can be found in TOOLS, OPTIONS, GENERAL TAB, Compact on Close.

Thanks Pat, I have Access 2003 SP2, thats down to our IT dept. Therefore I will stick with my modified code that opens the report twice.

I have exactly the same issue with my report opening portriat the first time, then landscape the next, I am running Access 2003. I tried turning off the "Name Autocorrect" options in Tools/Options but it hasn't fixed it, any other ideas? Degremont, did this fix it for you? Help much...

Ummm, unfortunately ADODB and DAO are alien to me at present. Whilst I appreciate the code I will have to learn how to implement Access functions and pass variables to them. My experience with Access is less than 6 months. Definitely something for me to find out more about so thanks. For...

I must say that the idea of splitting the backend is brilliant and would most likely suit my application as I have one main table that is updated daily, and several other lookup tables that are only updated by me. The tables will soon get pretty big. I have Access books, often read tutorials...

You suspect correctly, when the import sheets are overwritten the charts lose their link. This was a trap I literally dived into head first! Never come across Get Remote Data before, but this might be difficult to use as most of the queries are generated from forms where the user selects...

Hi, I am having some difficuly trying to find the easiest way of producing charts from my data in Access. Initially, I created pivotcharts in Access, only to find that getting these into reports was a little tricky, and I found the charts behave slightly differently to Excel (need exactly the...

Thank you for all your responses, I had a reserved name that was used throughout my database (only differing by capitalisation). To play safe I have changed the name, and this being my first Access project I'm happy its all still working okay :)

Microsoft application note 286335 (List of reserved words in Access....) gives a list of reserved words that we should avoid. Does anyone know for certain if these reserved words are case sensitive? ;)

I would walk more if it were safe. Tried it once and got assulted by muggers, lucky I escaped them, but I won't walk around Harlow again!

Thank you CodeMaster, that is absolutely brilliant! I can now automate my metrics at long last :-)

I have created a crosstab query that displays data by month, using SLQ statement 'Expr1: Format([Date],"mm-yy")". 'Date' is a field in my table that is formatted as dd-mm-yyyy that is entered for each record. My problem is that I can't figure out how to restrict the query to display data for...