Search results for query: *

If I use Application.CreateReport can I link it right to a query, or do I have to set the recordset for the report? I'm sure I could do the latter, but the former would save a lot of time since the query is already created.

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

I've decided to give subforms a try. I think this will fix my problem. Thanks for your help!

Nope. Not that I know of.:) I have lots of experience using VB, macros, and forms with Excel, but this is my first real project in Access. Is ADO something that is often useful when programming Access projects? If so, is there a book or site you would recommend where I can pick up the basics? If...

I tried enforcing referential integrity and it seems to work occassionally but not always. I keep getting an error that I can't add to a second table because the first table doesn't include a comparable value in the related field, but that's not the case. I'm completely baffled. I think one way...

Yes, they are related in the relationships table as well as using the initial table's id as a control source for the other tables' ids.

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

That's what I had done originally, but when I add new fields to my query they are not showing up on the report like I thought they would. Any idea what I'm missing??

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!

That worked great! Now I'm trying to add an attachment and I'm getting an error. Any idea what I'm doing wrong?

Fabulous! I'll give it a try. Thank you!!

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

Oops. I didn't have the outlook reference library installed. Solved my own problem. But now another question, how do I set outlook so it doesn't have a pop-up stating that an outside control is trying to send email and asking for permission with each email?

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

My form is based on a table. I tried putting mytable.myfield in the order by box and this did not work. I realize there must be a very easy solution and it's driving me crazy. The field is indexed. Could this be the problem??

That worked for the combo box, thank you. However, I set the Order By property for the form and it is still not selecting records in alphabetical order. Is there something else I'm missing?

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