Search results for query: *

I am developing an Access application for a client. I'm using Access 2003 SP2, but the database is saved in Access 2000 format. Said client has an existing Access application, developed under their version of Access (2002 SP3) but also in Access 2000 format. Since my app will draw some data...

I'm trying to open a PDF file (path and filename supplied through a string) from VBA code. I've played around with two solutions so far that both don't really do what I want: 1. Using Shell: Shell ("C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe " & strFileName) This works fine on my...

I'm aware of how to usually link/embed an OLE object to an OLE object field (Insert -> Object etc.) but would it be possible to do the same through a programmed SQL query? I've tried it by simply passing the path of the file I want to link to an INSERT or UPDATE query, but that results in the...

I am trying to run a query on two tables with a one-to-many relationship which gives me all columns from the first table and one calculated field that counts the number of related records in the second table. Query so far is as follows ("Col1" is the primary key in table 1 and the foreign key in...

I have a DataList control populated with an Adodc control, and I want to be able to select the first item in the list through code. Is there an easy way to do this? I found that moving in the ADO recordset doesn't affect which item is selected, and the .SelectedItem property which looked...

I'm having a VB6 application find (and subsequently replace) certain strings in a Word template, and I've now run into trouble when I'm trying to replace string in the footer. Evidently, the method I'm using only works for text in the main document and skips over the footer. Doing it as...

I've finished up a VB6 database application using MS Access, and created a setup package to install it on several client systems (various Windows versions, most XP like my development computer though). When I run the setup package, it starts out by installing seven files - .dlls mostly - before...

For my current VB/Excel application I could use a way to figure out which page (under the current print settings) a specific cell is on. Is there a property I could query for this? I've gone through the Object Browser a bit but wasn't able to find what I'm looking for. I initially had a...

In one of my queries I am trying to retrieve the month from a date field. Using the DATEPART() function for this as follows: SELECT DATEPART("m",[Datum]) AS Datum_uitgifte FROM Norm This query works fine if I execute it in the query design window in Access, but as soon as I try to use this...

Having trouble getting an INSERT query unleashed on an Access 2000 database from a VB6 application to work. The following query works fine: INSERT INTO Progress(GameID, TimeSpent, Progress) VALUES (1,1,'text') However I've got a date field in there as well, and as soon as I turn the query...