Search results for query: *

I currently have a report linked to a query. This query is created in VB and the fields and numbers of fields are always changing. The report doesn't show the new fields each time the query is altered. Is there a way to create a report in VB so I can be sure to have the correct fields each time...

Hi, I have a multi-page form that links several tables. The tables are related by an ID number. One the first page of my form, the ID number is auto-entered for the first table, then when data is added to each additional page/table the ID number is automatically updated to what it is on the...

Hi, I want to use VBA to create a report from an existing query. Is this possible? My code already creates a query with a varying number of fields but I'm not sure how to create a report that when opened will be based on the latest version of the query. Thanks!

Hi, Is there a way to set an optionbutton so if you click on it a second time it is no longer checked. I have yes and no option buttons, but I can only uncheck the yes by checking the no. I simply want to be able to uncheck one of the buttons so they both can stay blank. Thanks!

Hi, I am using an excel macro to automatically send email to numerous recipients. Is there a way to include paragraph spacing in the body of the message? This is the type of code I am using.... Sub SendEMail() Dim objOL As Object Dim objOLMsg As Object Dim objOLRecip As Object...

I am trying to send email from Excel. The code I have will insert the subject and body from an excel sheet and send the email, but won't insert the recipient, so it just gets sent to me. This is what I have: Sub SendEMail() Dim objOL As Object Dim objOLMsg As Object Dim...

Hi, I am trying to create a userform that would go through my database based on a field sorted alphabetically. It is currently moving through the database based on the index number. How do I fix this? I would also like to create a combobox in a form that lists entries alphabetically. I can do...