Search results

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...

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...

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...

I am currently working on a form that calculates the sum of counts and charges for various categories. The form sums the number of items in each category, then the sum of the charges. Where I am stuck is trying to break out the "per unit" charge for each category. The calculation works fine...

I am currently working on a form for my users to look at budget data. I have several listboxes for them to filter queries by. What I was wondering is, if it is possible to have data in one list box be filtered by the preceeding listbox? For example: Three list boxes: Report_Period, Budget...

I am trying to create a form in Access 2007 based on two linked SQL 2005 tables. the form works fine, but when I attempt to update a field, I get the infamous message "this recordset is not updatable". Both tables have a unique ID, and show up in Access this way. My SQL code: SELECT...

I have been tasked with making an addition to my Access 2007 database, we want to create a button on a screen that will open up the Appointment screen from Outlook (not directly create the appointment), and populate the Subject line and invited attendees from fields within Access (user will need...