Recent content by davegillian

I've got a form, let's call it mainform. On mainform is subform1, on which is subform2, on which is subform3. Having inputted data on subform3 I want to click on a command button "hide_button" on subform1 which will hide subform3. I thought initially that clicking on hide_button would also set...

Thanks for your reply. I was hoping to do this automatically through VB code, SQL or a macro. The DB will be used by non-computer literate users so I want to be able to get the query result as a field containing csv email addresses, this would be displayed on a form and a private sub would take...

Hi, I have a select query that selects certain customer email addresses and I want to output the results as csv, which can be used directly in a "To:" field to create a group email. The SQL of my query is: SELECT [Customer Details].[Email Address] FROM [Customer Details] INNER JOIN [Orders]...

My database has a linked table that looks at my email inbox. A lookup query takes the fields from, subject and body from this table, sorts the records (emails) alphabetically and then outputs 1 record (email) as I have set the Top Values property to 1. I also have 3 forms - one that displays...

Hi if anyone sees this post and identifies with my problem then I've found a solution so I thought I'd share the love! In the Macro design view use the GoToRecord Next command. Once the last record is reached a blank data entry record will be displayed. The next line in the Macro should be...

I have devised a Word form that will be sent out to 100s of people, completed and returned. I can currently export the data from Word to Access by going to OPTIONS and SAVE then checking the "Save data only for forms" box and then saving the file as a txt file. This txt file is a linked table...

The update query is a side point really. I want to disable navigation buttons and the close button so that the only way out of the form is to click the "move to next record" command button. I only want the field to be updated to "checked" if the form has been viewed (checked) and the command...

I have an update query to update my field but how will that help with the do until loop? The point of this bit of code I'm stuck on would be to DO run update query and move to next record UNTIL record=last (EOF?) THEN run update query and close object (form). Cheers, Dave

I have a form that filters certain records out of a table "Customer Details" in my database via the Y/N field Checked where the value is No. I want a command button on the form that will run a macro that will update the Checked value to Yes and then move to the next record (displaying it in the...