Recent content by mysterybks

I have a table with these fields: title month year sales I want to take the data in that table and make a tabular report that will show each title along the left and then put the appropriate sales in a column by month like: (headings)title 2011-June 2011-May 2011-Apr Title 1...

Got it to work using some macros instead.

Only way I can get it to work is if I had Refresh All EVERY time. :( It works great in one database but won't in this new database. I've tried EVERYTHING.

Now it's broken again. It won't change the data in the combo box when I select an author for a new record. Only goes to the record that ties to the first record. I've tried it on OnCurrent for the form. I've tried it on AfterUpdate on the Author Field that decides which author I want the 2nd...

THANK YOU! I fixed it. I had typed it in the On Current in the Properties dialog not the VBA Window. You are right. I wasn't sure which way you meant at first. Thank you!!!! I am still learning VBA.

Here's what is in the Code Window properties: =[Me].[SeriesName].[Requery]

Tried that, but it says "The object doesn't contain the Automation object 'Me .'

I have a form with 2 combo boxes: AuthorID and SeriesName I have SeriesName tied with a query whose SQL is: SELECT Series.AuthorID, Series.SeriesName FROM Series WHERE (((Series.AuthorID)=[Forms]![Books inputting]![AuthorID])) ORDER BY Series.AuthorID, Series.SeriesName; The first...

Thank you. I did some searching and found this good code: Sub ListLinks() Dim IeApp As InternetExplorer Dim sURL As String Dim IeDoc As Object Dim i As Long ‘Create new instance of IE Set IeApp = New InternetExplorer ‘Make it visible - some things don’t work...

Is it possible with VBA to have it take info from a database and open an Amazon page, extract data from the page, and save it to the database record?