Recent content by dpelizzari

Well, I found a solution online, so I thought I would share. As part of the on-click event for the button, I have added the following code before opening the form: DoCmd.OpenForm "ISD_Lease_Subform", acDesign, , , , acHidden Forms!ISD_Lease_Subform.DefaultView = 0 DoCmd.Close acForm ...

Thanks, Simon, I was hoping instead of me having to create a seperate form/subform I could programmatically change the Default View prior to opening the subform, adding one or two lines of code would be quicker and reduce maintenance, since both sets of form/subform would have identical...

I have a form with a subform where I want to select (via button) which format to open the form in. Opening the form is simple, DoCmd.OpenForm (FormName),acFormDS to open in datasheet, however, the subform opens in default view (single form). Can you programmatically set the property on the...

Thanks, pbaldy, I was hoping to avoid that. I remote into the machine as it is 500 miles away (better LAN speed there to run this stuff).

Oh, yeah, should have mentioned, for some reason, Excel doesn't complain about being run this way, only Access. I have several Excel macros scheduled to run via vbscript, and they work just fine.

Thanks, TJ & Doc, this is on a business network, on a Win 7 Pro-64 machine (no server). So I guess the only solution is going to be to have a machine logged in all the time to run the process. Unfortunately, the security is pretty locked down, but I will give the "elevated privelege" option a try.

I have been searching the web for a solution to this problem. I have created a scheduled task on Windows 7 to automatically run a macro from a command line, however, it seems to only run when the user is logged onto the machine. Is there a way to run Access without the interactive logon? I...

Wow, would you believe I was missing an End If which was causing the compile to throw the error?

I took code I had written previously and modified it to send e-mails in HTML format... but for some reason I can't figure out, after adding the recordset information, I am getting a "Loop without Do" compile error, I have compared this repeatedly to my old code, which works fine... I can't...

I am working on a mail merge process with MS Access 2007 (SQL 2005 back end), and the requirement is to have a table built into the e-mail in HTML format. See word document attached. Creating the e-mail is fairly simple, even adding the requirement for voting buttons (which is a big reason...

thanks, P, the spell check is strong with you :)

Hmmm, played with this some more, must have had a typo somewhere, the error went away.

finally getting back around to this, so, I am able to filter the next listbox by the previous, however, I then realized I needed to filter the third list box by the first two (have a headache just thinking about the 6th iteration)... so, thinking logically, I just need to add in additional...

Marc, kind of a nebulous question... are you adding VB code to a field, writing a module, or... if you are adding something to a fields or buttons event, is that event ever being done? Generally when I add code to an event, I use the wizard so it automatically creates the event (OnClick...

JCorreia, you may need to look further into the format of the field in the table, there are options for showing the date in mulitple formats (long, short, time only, etc... if you have the user inputting just the date (1/1/2013), but the data format in the table is mm/dd/yyyy:00:00:00, it...