Search results for query: *

Thanks, but that's a little too much vb code than what i'm looking for.

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

thanks, I got it sorted. The problem was coming from the recordsource of the report. I don't think i had the query built properly. It's working anyway.

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

in order to track changes, you need to restrict users from accessing the database itself, and using your asp pages exclusively. then, any time updates are made to your database using asp, just add a log to a simple text file, or to another table in the database, recording the old value, the new...

I know this is trivial, but when i copied your code into notepad, i noticed that there is no space between calendarinfotable(DepartmentSchool this, as far as I know, is wrong. it should be calendarinfotable (DepartmentSchool

I'd use an msxml.xmlhttprequest object. here's a bit of code that might be of help. This function takes a string containing a path to an xml file, and the url to post that file to. if it succeeds, the function returns 0, otherwise it returns -1. You also need to create the listener.asp page on...

there is a way to do it with xml data islands. check out some of the xml examples in msdn.microsoft.com

make use of the response object in your asp page to write the xml you want to display in your control back to you. try organising data flow like this vbclient -> post xml to asp -> asp updates server -> asp uses response.write to return confirmation to vbclient ->vbclient receives...

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

now, why would you want to do that. there are countless already available. try http://www.beseen.com/guest/index.html for starters

here's a snippet of code that hopefully will help you out. strSQL = "SELECT * FROM products" dbPath = server.mappath("myDatabase.mdb") dbConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath set conn =...

Lucky, I earmarked it for notification. anyway here's the code. Dim objWord As Word.Application Dim sFilename as string sFilename = "C:\mydocument.doc" Set objWord = New Word.Application objWord.Documents.Open FileName:=sFilename objWord.PrintOut , , , , , , , 1 ' the one is the...

great men fall by the narrowest of margins

on the menu bar open tools > options uncheck windows in taskbar tada

yet another of my own problems answered. The problem has henceforth disappeared. The reason... I got out my trusty techNet service packs, and installed service pack 3 for sqlserver 7.0 and msde 1.0 now i can get on with my replication pflangan

quick reply, but no dice. There are no constraints on the notes table. It's just a test table with two fields: noteID int primarykey hitman;-) varchar and the same is true of the tblAudits table When i change the trigger type to update or delete, it works fine.