Search results

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

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

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

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

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

Here is some suggested code straight out of a help file: Dim dbs As Database, rst As RecordSet In trying to solve another problem, I have attempted to define variables as a database several times now, and the option is not available. Am I missing something? When I type "Dim as" and...

I have tried unsuccessfully to find a way to programmatically read the sql statement of permanent queries. Is this possible? I have even tried setting a variable as an object, then looping through the objects in the querydefs collection to search for a certain query: this I can do, but the...

OK, I feel stupid. I can figure out replication and visual basic, but charting some data is driving me crazy! 1) I create a report based on a query; 2) Insert a chart, using the wizard to choose fields, etc.; 3) In print preview I see sample data. Now the help says that this is normal, close...

I have a database with data recorded along with the date of an event. Current state of the database can be reported using the most recent data, and monthly reports can be generated for any particular month. Now what I need is an historical monthly report. For every month back to the origin of...

Disregard! Problem not solved, but I found a way around it... OK, this is a new one on me. I have created a form "fsub_Summary." This form uses sql as the recordsource. In most ways, the form is functional. I use it as a subform (hence the name) and I've created some code which rewrites...

I have the following code straight from the lookup field wizard: Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Fish_ID] = '" & Me![Fish_IDLookup] & "'" Me.Bookmark = rs.Bookmark It works. Now I also want another form to locate the same bookmark I have just...

Imagine a "Tbl_Event" table for recording events. (This is a database of fish culture info.) Fields are: Event_ID (unique to each event) Observation_Type (selected from limited list) Event_Date (a date) Entity_ID (linked to a fish entity) This table can be linked to any other table in the...

In developing my front end functionality, I have used the JRO library to both compact and synchronize my backend database. It all works as designed. When I use it on the development machine, that is. When I copy the front end database to other machines, I start getting error messages...

Is there a vba way to check for internet connection status before launching into procdures which assume a connection is present? Matt

If anybody has used the TsiCompact utility from http://www.trigeminal.com perhaps you can help. The following code correctly runs the CompactMyDatabase function from a class module if I'm compacting a database with no security setup: Public Sub CompactMyDatabase(Source As String, Destination...

I am writing a procedure for a combo notinlist event. A form for data entry pops up to allow some data manipulation etc. when the event is triggered. However, I still get the default message box (in addition to my own form) informing the user that "The text you entered isn't an item in the...

I have a nested form structure: frm_Fish_ID contains: frm_Pathology, which contains: frm_PathMetricEdit. The Pathology form is linked to the main Fish_ID form through linking fields. The PathMetricEdit form is linked, but the data source query allows only edits, not data entry (because of a...