Recent content by ElvisR

Resolved! Thanks.

Great news, it works; to a point. It only generated the PDF for the first record. As it loops thru all the names show up in the immediate window. Kindly review the code for me:

Thanks. I changed the where statement to a string, but getting error on the SQL statement. When I used your where statement, I get a parameter popup for ID

I am now learning recordsets and how they can be used. My code below is supposed to open a table and loop thru it and create a PDF of the 2-page report for each record. The only part that is not working a intended is that the PDF being generated is for all the records that comes before the rs...

Issue solved. It was a rookie mistake: I was ref a field [COUNTY] that I did not have in the table. It should have been: Confusing I know, but its New York geography. Thanks all!

Thanks for all the qualified responses. I used to TJ's abbreviated code, and included Cronk's suggestion to debug. Results: No change. Well, I am now getting the message box that the code was not found when Queens is the county. I eliminated the other 3000+ codes and left only 5 just so I can...

I have a table I am running DLOOKUP on to get data. It works as it should, except for when the Criteria is "QUEENS" - it does not pull any data from the table. In VB's immediate window, it does not print any data. Please see if anything is off in the code. Suggestions welcomed. Thanks.

Thank you all for helpful input. I am not really trying to make a permanent database out of this data, I just need to extract data based on specific info. I have attached an example of the type of data I am dealing with, for your input.

Thanks for the response. I tried putting each Class in a different columns, after I received the data in Excel format, but did not have much luck their either. What is your suggestion?

Hi all, it has been a while since I delved into Access, but here I am. I have a table that contains two columns (names and classes attended). In the Classes column, the entries are separated by commas, so it look like: 1st, 2nd, 3rd etc. I am trying to run a query to show all in a specfic...

Thanks Bob, and all others. Problem resolved.

How do you say WooHoo in VBA? Do.Cmd WooHoo :) Thanks alot guys. It is only now I regret the fact that I never followed up programming. Now I just have one thing with the On Current: When it encounters a blank record - like when I click Add New - it returns the runtime error. Which is due to...

Can you show me how you would that, since there is no OnCurrent in the Property Sheet. I am trying to have the code below refresh everytime I switch records. Dim strID As String strID = Me.[STATE] & Me.[ID] Me.[IDD] = strID Me.[IDD] is a textbox. Also, I have a textbox that is bound to a...

Works like a charm. Thanks. You guys are really teaching this newbie some good stuff. I just bought a book, but it is VB6 oriented, not VB access, but the structure is pretty much the same.

No. I want it to look like this FL003. FL is taken from the STATE field and 003 is taken from the autonumber ID field. Rhett: I am gonna try the requery. Thanks.