Search results

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

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

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