Search results

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.

I have those buttons already, but I an not sure how to have it do a requery. Can you show me via a example? Hmmm that sounds like a good idea. Let me try that. Rhett, please take a look at my last post and see what I am trying to accomplish. I may be going about it the wrong way. Thanks.

Thanks Psyh. What I meant was that at one time, the Ucase worked, but it stopped somehow. I just attached it to the Show All Records button and it worked. Here is what I am trying to do with the first code: I have two fields (ID and STATE) that I want to merge into one field. I am not sure the...

I am a novice to VB. That being said: Some VB scripts in my forms do not refresh the data as I switch records. For example: This script is links an autonumber field with another. It works fine. However, when I click next record, it just stays to the same data: Dim strID As...

Novice here. I am using Access 07. I am trying to add a button on a form that, when clicked, will perform the action as the Filter button on Access' Home Menu - which brings up a combo list of sorts with options based on the selected field. I have seen a couple of VB scripts that access menu...

I have a simple form. When I load it, it displays an old search result, i.e. Lastname Smith. I am not sure what I am not doing right. The form is in two parts: the search form and the data entry (results) form. Here is the code for the Results: Option Compare Database Private Sub...