Recent content by ggoldberg

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

That worked perfectly. Thanks!

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

I tried it in the form_open sub and also in the form_Load sub. In both cases, the form still let me make edit modifications. Thanks, Gerry Goldberg

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