Recent content by Matthew Snook

Suppose I have a table containing data identified by location and month; for instance: City; Month; Number_of_Accidents. How do I write a query that will return not only rows in which there are actually accidents reported, but a full 12 rows for every City whether any data occurs in a...

to all: My database includes data imported from old Excel files. Since the initial transfer, all data entry has been through Access forms and queries. On one field, [Individual_Egg_Weight], the imported data were in the form 0.00 where all values were less than one and weights were recorded to...

Thanks much for the info, I'm going to give it a try. Matt

No, unfortunately. Mom has XP and I'm running 2000 pro server. I hadn't thought of that. Would that make the report lose it's printer settings? Matt

I have a report which is printed to a Dymolabel printer. After much wrangling, I have managed to get the margins, paper size, and all the settings so that they will work. When I send a copy of this database to somebody else with an identical printer (I bought them both) the report goes to...

Let's imagine you have a button on your main form called "cmd_Sort_GA_Number" and a subform on the same main form which is called "Child_Form." The click event of the button could look somewhat like this: '******************************** Private Sub cmd_Sort_GA_Number_Click() 'establish which...

I have a report which behaves appropriately when placed into report view. I also have a query which can be attached (as a subreport) to this report using the appropriate master/child link fields. However, when I run the report with this query as a subreport I get bizarre behaviour. The...

I am running windows 2000 pro and Access 2002, using an Epson LQ570+ ESC/P 2 dot-matrix printer. The windows 2000 driver does not allow user-defined page sizes. When printing a single 1" label, the printer advances the whole page once printing is finished. I can manually put the sheet back to...

See http://www22.brinkster.com/accessory/general/002.shtml Matt

Argh! Auto correct!?! I should have known there was one in there! Since I have never used such a thing on purpose, I didn't even know Access had one. I've already turned off the one in Word... Thanks much! Matt

Ok, wizards. Here's a puzzle. I have a combo box based upon a query. The query uses a table of personal names, and returns only one field, last name, in ascending order, for all records containing a last name (is not null). It is further limited by using the 'distinct' parameter; so when the...

You should be able to do as you've described. A table could hold query text in one column and a memorable name for it in another. The combo box with this table as a data source would allow the user to choose filters by name, then use the "After Update" event to write the text to the filter...

Situation: Database is split, front-end and back-end. A back-end server sits in La Grande Oregon and is available on the net. Every other machine has an identical front end and a unique replica. These reside in identically named directories on each machine. The machines are in several...

I have a front-end mdb file which exhibits a strange pattern when operating on some systems. Developer system is Office 2002; Access is set to save in 2000 format. The mdb file works on the home system, and others have also used the file without troubles on windows XP and 98 systems, XP and...

Try this (there is no error trapping included; remove the comment quote-mark to use the SetWarnings code): Private Sub btnSave_Click() 'DoCmd.SetWarnings False Dim sql_destination As String sql_destination = "INSERT INTO tblDestination ( country, city, last_name, first_name...