Search results for query: *

I have a data table that contains zip code in each record. I would like to print labels for all of the records in this table (sorted by zip code) and print a separator label for each group of zip codes. How can I force this separator label to print?

I am trying to create a text box that contains Spanish text in a letter. Is there any way I can embed special characters in this text like I can do in Word? Thanks, Gerry Goldberg

Can someone tell me the html syntax to display a .pdf file on my web site? Thanks, Gerry Goldberg

I would like to create an Access table with the same structure as it's corresponding table in my SQL database. Is there someway I can query an SQL table so that I can build one of the same structure using VBA?

Is it possible to create a query that uses an excel spreadsheet as input? If so, how do I specify this in SQL? Thanks, Gerry Goldberg

I have a table that contains Age and Gender for a series of clients. I would like to be able to query this data into gender (Male or Female) totals like: Age Total Males Total Females <1 xxx yyy 1-5 xxx yyy 6-12...

I am writing an Access program that extracts data from an Excel spread sheet, but I don't know how to find out which is the last line of a spreadsheet. Can anyone tell me what Excel property or method to use to get this information? Thanks, Gerry Goldberg

I am looking for a program that will allow me to search the SQL code for a list of user SQL queries and replace certain words or table references without having to do this by hand. Does anyone know of such a program? Thanks, Gerry Goldberg

I would like to check a bound field entry to see if it is between two other fields on a form. I assume that I should do this in the BeforeUpdate event. If the field is between the two other fields, I want to accept it. If not, I simply want to warn the user, but all him to accept it if it truly...

I have a table that contains: Client ID Gender Race Zip code Birth date Visit date I would like to produce a table that contains one record for each Client in each Zip code for each month that a visit occurs. How can I structure a query to do this? I have the same requirement for...

Can anyone tell me how to delete an import specification? I know that the specifications are contained in the hidden system files mSysIMEXColumns and mSysIMEXSpecs, but I don't know how to delete entries from them. Thanks, Gerry Goldberg

I have an Access 2002 application that runs on my network, but something has happened to the database that causes two of the work stations to have the following problem. When trying to run any form in the application, I get an error when the system tries to execute a function that is specified...

My application shows a list of transactions. When one of them is double-clicked, another form is opened that is an edit form for the selected transaction. Based on which user is logged on, I want to allow/disallow editing of this transaction data on the edit form. I use a filter to display the...

I am trying to figure out how to bypass the startup autoexec macro only for certain users (my program handles it's own login processing). Does anyone have an example of the basic code to do this? I am running Access 2002.

I have a form that is bound to a table. This table has Input masks defined for several fields. When I enter into this form, it appears that these masks are ignored, even though I haven't specified masks for these bound fields on the form. The only way I am able to use the input masks is to...

When I am in form design mode using Access XP, my &quot;Edit/Undo&quot;UNDO&quot; function in the toolbar is grayed out. How can I enable that command? It worked just fine under my installation of Access 97. Thanks, Gerry Goldberg

Recently, I upgraded to Access XP 2002 and now I can't undo any changes I make in forms design mode. The UNDO option is always grayed out. Is there a setting somewhere that I missed? Thanks, Gerry Goldberg

I am creating a procedure to copy the tables from an SQL database to a split database on a laptop (for standalone operation) and then link them up to a newly refreshed copy of the application data base. I have a form in the backend folder that does the following: a) Import all SQL tables into...

I would like to give the user the option to &quot;Print&quot; or &quot;Preview&quot; a report. I am trying to run this report from a &quot;popup&quot; and &quot;modal&quot; calling form, but when I choose &quot;Preview&quot; for the report (OpenReport &quot;report1&quot;,acViewPreview), the...

I know how to use CreateGroupLevel in VBA to customize a report 'on the fly', but how to I delete a group level from an existing form using VBA. Thanks, Gerry Goldberg