Search results

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

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.

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

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