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...
I'm using the ocx "Microsoft Office Document Imaging Viewer Control" for displaying faxes in an Access 2003 form.
Since one week the ocx fail to show anything (on all the pc I test). Access...
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 ...
I have an Access database that I have created a form where the user can check multiple reports and when I press a button I need it to export each as a PDF. Here's the catch. I want the user to...
I'm currently utilizing a function that creates a worksheet, and then pulls data from an access database query to populate the new worksheet. In particular, I'm querying an Access query based...
Hi
I have a table setup with one of its fields setup as a listbox lookup field, the lookup field has 2 columns, the bound column which is hidden and the text column which displays in datashee...
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...
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)...
I logged a question yesterday
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24642779.html
Because the database I have created now and again corrupts an entry when it ...
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...
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'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...
I have seen posts explaining how the set the CF properties within VBA but these solutions must be triggered explicitly by the user during runtime. I need to have individual rows in a continuo...
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 ...
Below I have attached outlines for two basic tables: Person and Address.
The Address table holds a pointer to the Person to which it belongs.
The Type field in the Address table has values c...
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...
I have created a form in Access which displays info required by a govt dept. It contains 1 form + 2 subforms (subforms are datasheets). Is there any way I can import it into a word template? I...
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 have a popup form that can have several records related to the parent form. Every record has an OK command button beside it. When I press my OK command button, it copies the information for...
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...
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 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...
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...
Hi, I have a select query in MS Access 2007 that I am exporting to a .CSV file. I am using the export wizard to do this. This .csv file will be imported to our Accounting system so it requi...
I'm pretty new to Access so please bare with me.
I have a split form that pulls data from single table. It has a data column with a date formatted like this: 10/31/2008
I need to create ...
