Recent content by jrubins

Thanks a lot! That worked perfectly.

The problem is I can't re-import the data because I don't have access to the zip code file anymore. Also, I've made changes within my database and if I re-import the zip code file, I'll lose all those changes I've made. Is there some way to add that first "0" to the data I already have...

I have a bunch of 5 digit zip codes that were imported into Access and the zip codes that had "0" as the first digit lost that "0" and just became 4 digit zip codes. I changed the zip code field in the table to a text field with an input mask of "00000/-9999;0;_" but the zip codes that lost...

Ok, I have considered ROW NUMBER() but wasn't 100% about it. But I'll probably try that out now. Thanks again.

Is there a way to have the query prompt the user for the range (e.g. 1-200, 201-400, etc.) instead of having to go into the SQL everytime and update it?

Thanks a lot! That worked perfectly.

I have about 2000 records and I want to view only 200 at a time (so i can print off a list of 200 at a time). This code worked: SELECT TOP 200 * FROM Patient WHERE (((Patient.StudyStatusID)=3)) ORDER BY Patient.[PatientID]; But that only gets me the first 200, and I don't know how to get the...

I'm trying to run a query to limit the number of records returned. I have a table named "Patient" with "PatientID" as one of the fields. I run this SQL statement and get a syntax error. Any suggestions? SELECT TOP 25 * FROM Patient WHERE key NOT IN ( SELECT TOP 0 [Patient]![PatientID] FROM...

Thanks lagbolt. That did it.

I have a report that displays data from a Count Query. Below that displayed data on the report is a link to a word document. I want to write code so that when you click on the link, if the data from the Count Query is "0", the link won't work. This is what I've tried: Private Sub...

Does anyone know whether the SP2 for Access 2007 actually fixes any Visual Basic coding bugs and conversion problems from older Access formats?

I have a database with 4 separate forms. In one form I have a control that is an option group with 5 different options. I run the following code on the option group: Private Sub A5_Click() If Me.A5.Value = 8 Then Me.A5a.Visible = True Else Me.A5a.Visible = False End If If Me.A5.Value = 9...