Search results

Hi, I'm not sure what you really want to do... Maybe you can explain something more? What do you have in your form and where do you want to put it? Did you think about Pat's second remark? When you want to create an update query: first create something with the build-in query-builder. You can...

Hi, Use this: Me.TxtBox.DefaultValue = """ & strVariable & """

Hi Mary, In the property "Inputmask" of the textbox, type: password

Are all objects (forms/reports) closed when you press that button, except the one with the button? Is there any other code running at the same moment (like un UnLoad-event of the form or something like that)?

Try to set both, PopUp and Modal to Yes

Please tell us: what doesn't work? Is your second form opened by the OnClick-event of the button on the calling form? If Yes, then try (while the second form is open) by going to the immediate window typing this:? Forms!SecondFormName.OpenArgsThen press Return. Is the name of the calling form...

Hi, Let me break into the discussion... while the pad to your database has spaces in it, I'd think this will work well:DoCmd.TransferDatabase acLink, "Microsoft Access", _ "T:\www.bemrosebooth.com\OnLine_Marketing\Link Building\Link Survey databases\" & _ Chr(34) & strfilename & Chr(34) &...

Hi, Why do you want to get the right format in the query? When it's set well in the table, the query will present it as well. Else you can set it in your 'presentation medium', form or report Greetz

Ok, you're working in a macro. Then take these steps: 1. OpenReport 2. RunCommand -> beneath select somthing like 'PreviewTwoPages' 3. Close Form You actually don't have to open the query. The report does dat itself.

:D :D :D

Can you set a breakpoint in the Unload-event-code te see if it's running?

I've got a form running in this style with: Pop-Up = Yes Modal = Yes BorderStyle = Dialog (doesn't matter I think, but it is) And it's working fine.

Moose, For me your problem is clear enough, but I really don't know how you can do that. But I've got a solution for the second problem: After opening the report with: DoCmd.RunCommand acCmdPreview you give the command: DoCmd.RunCommand acCmdPreviewTwoPages

Marie, Use:Kill "c:\myfile.txt"

Maybe, but that's the setting for each control, so use it as 'default' and for all others use the given functions.

Thank you, you're right :D

When you want te ignore the warning only for that command, use:DoCmd.SetWarnings False DoCmd.RunSQL .... DoCmd.SetWarnings TruePersonally I think that's better, because you then still have to confirm the actionquery when you start it (by abuse) from the db-window.

Okay, it seems to be clear to me now. First: you use: Forms![name of main form]![name of subform].Requery DoCmd.GoToRecord, , acFirst Only the first line is necessary, because after a requery the subform always select the first record. Further: Write this into a standard module:Public...

In VBA you've to use: If IsNull(Me!rr) Then...

Use this:Dim mstrForm as Form Set mstrForm = Forms(curButton.Tag)The Tag-property already is a string. The result have to be: Set mstrForm = Forms("popfrm_BankEntries")