Search results

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "queryReportName", "spreadsheetFilename" Bye, S.

Try to use the Begintrans, Committrans and Rollback function to undo operation even after hundreds raws of commands or records; I found them very useful. Hope this helps you, S.

The only way I know to write something in two different tables using one form is to link the tables (in a query) using a common field (eg Student's name) and define the query as form's datasource. If you are able to use code yuo need common field for linking the tables, too. Bye, S.

Sorry Hershey, I spent lots of days with my pc off; try to open your report in design mode, use the previous code, printout, and finally close the report. Commands you need are: DoCmd.OpenReport "Myreport", acViewDesign ........... (prevoius code) DoCmd.PrintOut DoCmd.Close acReport, "Myreport"...

On the report event "On open" try this: If control1 & "A" = "A" then 'Control1 is empty Label1.visible = false else Label1.visible = true end if Hope this helps you, Stefano

You have to use the ansi code for wildcard characters; for example Chr(42) = *, Chr(34) = " strCriteria = "[Field 1] = 'I cannot ty" & chr(42) & "'" strCriteria = "[Field 1] = 'I cannot ty" & chr (34) & chr(42) & chr(34) & "'" Good Luck

The Y subform is a X form control; to refer using code yuo have to specify that the control you need is in a subform : "[UniqueFieldName]=Forms![subformName].Form![UniqueFieldName]" Hope this helps you Stefano

I think that the only way to do what you want is to export the table in excel where your users will be able to move and modify the records. Good luck, S.

The subform origin should be a query with these criterias: [Start date]: >= [report date] [End date] <= [repot date] or Is Null Link just the department fields Hope this helps you

In the event properties of yuor memo control (called Text0) simply report the example (Copy / paste) and join it PS: you better don't copy the first (Private ...) and the last instruction (end sub) Bye

It works, you are great: I'll call the new form "Travis" Thanks a lot

I need to use a memo to store variable text depending on users works; is it possible to enable the "Tab" key not for activate the next control but for tex spacing ? (like a grid or a table in a word procesor) Sorry for my english Thank you in advance

Yuo can try with a macro (after update event on combo1); the command yuo need is DLookup; so yuo can update the combo2 using combo1 as "criteria" Good Luck