Search results for query: *

Does anyone know how to return a master-detail query in a single row. I know how to link through a form/subform or even a report/subreport Example. I have a student enrollment database table students -------- sid data:1 student data:peter classes ------- cid data:1 data:2...

I need to calculate the time taken to resolve support calls in an msAccess query. Now i've seen all the tips on not including weekends / holidays etc. but I don't think they are relevant to my problem. maybe i'm wrong. anyhoo

I've got a customers form with an orders subform. The subform is a continuous form, with a button next to each record that should open a report based on the order next to it. Now it works fine with the first customer, but when i move records on the main form, the report comes up blank. The...

I've got a problem transferring data from msaccess to sqlserver. the set up is as follows. on the remote site i have an asp file that writes an xml file to the response object. on my side of things (sql server) i open a recordset to that page rs.open...

I've got a problem transferring data from msaccess to sqlserver. the set up is as follows. on the remote site i have an asp file that writes an xml file to the response object. on my side of things (sql server) i open a recordset to that page rs.open...

I've got a problem transferring data from msaccess to sqlserver. the set up is as follows. on the remote site i have an asp file that writes an xml file to the response object. on my side of things (sql server) i open a recordset to that page rs.open...

I'm using msde with access 2000. I've got a problem with insert triggers, and I don't know what's causing it. Update and delete triggers work fine, but insert just ain't cuttin it. The trigger saves fine, but when I enter a new row directly into the table access throws up the following message...

Does anyone know how to wait for word to finish printing before quitting the application. I've got a button on a form that automatically prints out a word document, but at the moment I either get 1. A copy of WINWORD.exe is left running on the system when I don't use the...

This is a strange problem. I've got an image on my form that I update using the On Current event. The image is not stored in the database, the path is stored in a varchar field. When I move between records, the mouse moves to the center of my screen. This is particularly annoying when you...

I'm just upgrading our local database to access 2000 and MSDE. The problem I'm having, is that views don't seem to be all they're made out to be. I had this query in access that calculated an amount due, based on the amount of hours a person has worked. There are three different rates; first...