Search results

This is one way of doing it: docmd.openform "Second Form", acNormal docmd.Maximize DoCmd.RunMacro "Name" DoCmd.SelectObject acForm, "First form" docmd.Minimize I assume you already have made a macro that you want to use.

Thanks for your answer. I will try your solution. Thanks alot for answering my question. Best regards Kenneth

I need a import and export function in my database. But the import and export wizard that is already in Access, is not good enough for what I want to make. I have a database with 5 tables and lots of fields in them. I want the user to select the correct item to export, and then it should collect...

I need a import and export function in my database. But the import and export wizard that is already in Access, is not good enough for what I want to make. I have a database with 5 tables and lots of fields in them. I want the user to select the correct item to export, and then it should...

I'm using Access 97. I have a report that displays a number on my report. And the number desides whether subreport 1 should be displayed or subreport2 should be displayed. I can do this with the form, but are unable to do it with the reports. As the reports don't have a OnCurrent event. I can...

When I initiate the code, and uses the word Dim like for an example: Dim FieldName as Long Dim RecordsetName as Recordset "Some code underneeth, where both objects are beeing used." "At the end of the code:" FieldName = Nothing RecordsetName = Nothing ------ end of code When I program in...

Yes, I know. But that doesn't solve my problem. I need to refresh the underlying query behind the subform. And then go back to the first subform and continue the procedure.

Try this, this worked for my db. Set these values in the property of the control: Set the format: Percent Set the inputmask to: "0",00"%";;_ Set the Desimal places: 0 Set the Default value: 0 Make sure the format in the table is Percent also and it should work just fine. Now you can type in...

I have a form, with a record source with SQL. In this form I have two subforms, each with a SQL query as the subform record source. One of the two subforms is used as a reference. For example, the subforms tells me how many tonns of cargo is left on the ship. In the other subform I type in how...

I need help with linking the crosstab report with the main report. So that the crosstab report is the subreport for another report. And the two report should be binded together with a referencenumber from the main report. I have to use dynamic headcolumn for the crosstab report. Please send me...