Search results

If you have excel , make your lable there using its 45° angle prorties, then copy and paste it to access.

i have a macro that opens a report. Then the second line of the macro defines a value report!reportname!dateclosed.visble = false with the condition statement report!reportname!dateclosed = null. In theory if the date closed is null then its text box on the report would be invisible. when i...

i import text file a lot. To avoid similar problems of double import my macro runs a delete query with the condition if id >0. I also set warning to off befor i run the query, then the transfer macro is run. I then set warnings back to on, this way if i accidently double click i just have the...

You can run the dictionary on the contents of a table, but how can you double check the spelling of your text box lables on a form in design view. I do most of by programming in French, and would like to make sure that my forms, report titles are correctly spelt properly. Suggestions any one.

copy your headers to excel, rotate them there,and paste them back in your report.

You can do as Pat suggests or make a new report on your 2 nd 3rd and 4th query etc, but include them as sub reports joined buy the appropriate variables.

I need to improve my Access macro skills. Is there a sample data base that is more of a self teaching tool on macro programming from beginning to advanced. Merci.

1) create a random number in the query where your questions are. 2) create a macro that runs the query. 3) and prints your report 4) i suppose you can put a button on a form to do this and click on it 10 time for 10 copies. 5) rap your macro around a do repeat command. good luck