One of my clients has several PCs running Office 2007 Pro. Our supplied database is written in Access 2003 for which we provide a run-time licence. This works on all of the machines, but a c...
Hi Experts,
Can anybody give me a working example for data access over internet using ADO through VB6 application?
1. Connection to a remote machine
2. Reading and Writing data from/to ...
Hi,
I have two tables. [TblProject] is set up with the following fields:
ProjectID (AutoNumber)
ProjectName (Text)
ActiveProject (Yes/No)
and this table has a one to many relationship...
hello,
I have a form and i'm using the form's "after update" event to trigger a code.
the code checks if all the data is entered correctly in the form, and if not it shows a msgbox to the...
I need to have a button that opens a "Save As Dialog Box" that will convert image files (EX: jpg )to .bmp to insert into a Bound Object Frame ("OLEBound" is the name of the Bound Object Frame)...
hello,
i'm using VBA code to define a string that uses me to define a form's filter property.
one of the form's underlying fields is "DueDate" (of type Date/Time).
i understand i need to wr...
I have got office 2000 installed with word and excel only. I have accdb file which i need to open and modify and save changes. Is there anyway i can do this without installing access 2007. Thi...
Over the weekend I rebuilt the server for a client and restored all their data, including several Access database files.
Now the employees are unable to enter data into one of the tables i...
No success in getting Windows 7 to add Foxpro ODBC Driver v6.01 under Data Sources (ODBC)
Anyone have any ideas?
i'm attempting to import a text file using TransferText in a Macro. The file being imported contains a date timestamp in the filename (P01.FLG.mmddyy.hhmm.TXT). In the TransferText parameter...
Hello,
I have an Access 2007 front end app, (Accdb not ADP) that uses ADO connections to access tables and stored procedures on a SQL Express 2008 server.
Everything appears to be fine ...
I am getting an error trying to insert these fields from an Access form into a table. When I step through the SQL is picking up the correct values but on my db.Execute (strSQL) I am getting a...
OK. I am having this same problem. Mature application. FE Access 2007 pointed to BE Access 2007 tables. Normally the tables are 100 or so MB and the FE is 27MB. I can sit and watch as 5 s...
Hello All,
I am working on MFC SDI application which has MS Access as Backend.I need to create a table which has a column of type Autonumber with field size Replication ID.I ...
I have some Canon PowerShot A470's in operation. They cannot be set to act like a disk drive, and expose a drive letter in Windows Explorer. Consequently, the filesystemobject cannot manipul...
How can I determine if a table exists in the current database,
1. using the least number of lines of VBA code
2. taking the least CPU time to execute
3. both.
I need the code to create a login form that checks the user name and password against data stored in the database. Which gives it a set number and from the number it views data from a differen...
I'm running a query that needs some format help. I want to group records by hour, but I only know how to group minute-by-minute. Here's the relevant SQL:
GROUP BY Format([DateRequest],"mm/d...
I have mapped a network share to a drive letter that contains multiple Access databases along with other documents and files. When ever I try to open one of the Access databases I get the erro...
I need help with transposing a table in MS Access 2003 - for a report. See attached file showing what I want the table to look like and the table format in Access.
I want to change the row...
I have an Access 2007 front end with a MySQL backend application. I need to know how to insert and view images using the OLE Object data type on a form (Any Image Type). The only option I hav...
I have a txt file :
000123456;1;0000000000000000;00555;2009/08/07;0000000999;1;1;1;YYYY/MM/DD;0000;
000134326;1;0000000000500000;00655;2005/08/04;0000000889;1;1;1;YYYY/MM/DD;0200;
without a...
Is there any way to have a pivot chart include a grand total?
Basically I have my data in my weather table grouped by day. For each day I have 24 columns with temperature data. How do I add a column in my query that will find the max of the 24 columns?
I have a query that uses the values on a form to retrieve its criteria. Here is an example of the code I put into the Query in design view to retrieve the criteria. This makes it easier for th...
