Search:

Thanks Patt but I am not fimiliar with using OpenArgs. What would the code look like?

My plan is to have a print command on the form that gets filled out. The print command button prints 4 copies of the report. On each copy of the report the label will change. Thank you for replying.

That worked. Thank you very much!

I have been able to change the caption on a label in a report from a command button on a form in the past but I am not able to now. I don't see what I am doing different. Attached is a very simple...

I took this SQL statement from a query that I was using before I upgraded to Windows 7. For it to work in VBA I had to add some paratheses & quote marks here and there. I might not have gotten all...

I have come up with some code but get a run-time error '-2147217900 (80040e14)' on the rsOE.open command line.
Private Sub Command21_Click()
Dim con As Connection
Dim rsOE As Recordset
Dim...

That worked. I didn't get any errors.
When I try to put some code with it I get a compile error: syntax error.
Private Sub Command21_Click()
Provider = "vfpoledb;Data Source=F:\oe\;Collating...

That worked without getting an error.
Now when I try to put some code with it I get a compile error: syntax error.
SELECT OEHDR.CNO, OEHDR.[ON], OEHDR.DRD, OEHDR.WOD, OEHDR.ORDSTATUS, oedtl.quan,...

I tried to put the connection string from connectionstrings.com in a command button to run the code. I was just trying to see if it would run but I get a compile error: syntax error.
Private Sub...

The data in the FoxPro database changes everyday. I combine that data that I retrieved from FroPro with the data that I keep in my Access database that changes everyday.
I have not used connection...

I have ODBC drivers but Windows 7 cannot use them. When I try to use them, it tells me to download the latest driver. When you go to the download page it tells me to use OLEDB which I downloaded.

It looks like that would work if I was running MS Access Project & MS SQL Server which I am not. I will look into running these programs.
Is anyone running Windows 7 in the XP Mode? If you are...

Thank you for your patience.
Excel 2003 has a connection wizard but Access 2003 lacks a connection wizard. Without the wizard I am lost as to how to make a OLEDB connection in Access. What am I not...

I think that acticle applied to people running 64 bit machines.
On the download site it says ODBC is not supported to use OLE DB. Visual FoxPro ODBC Driver
The VFPODBC driver is no longer...

I have upgraded my os to Windows 7 Pro 32 bit. Now my ODBC connection to a Fox Pro database does not work. I downloaded and installed vfpoledb.dll that is suppose to let me make the connection but I...

Thanks, I will look at that after I figure out why the second computer that has just the frontend cannot edit the records no matter how I link it to the backend.

I was wrong. What I found was that I had mapped the backend to drive Z which was on 1 of the computers with the front end also. When I open the backend from that computer through the Z: drive the...

What I found out was that I was linked to a backend that was Access98. All you can do from Access2007 frontend is look at data, not edit it.
Thanks all for looking.

Hi all,
Access 2007 - can any1 think of a reason I cannot make changes in a table from the frontend to the data in the table in the backend but I can make changes to the data in the table if I am in...

This looks like a recursive relationship: WIPN 1007 (in tblWIPBillMat) involves 1000, which involves 1001, which involves 1002, which involves 1003 and 1004; 1003 involves 1006 and 1004 involves...

There are no relationships between the tables (and several tables don't have a primary key). This makes it hard to find out how the data fit together.
I added a relationship table and added a...

I have products that are made from many sub assemblies. I would like to get a total for each sub assembly but my problem is that some of the sub assemblies are made from other sub assemblies and I do...

I set up a query just to view specific work done by a manager. If the manager goes into the query and sees a record that she highlights and wants to print a form out by just selecting the record in...

Thanks for the suggestion. I printed it out so I can take a look at it and try it later.
And YES I am still incorrigible. http://windowssecrets.com/forums/images/smilies/rolleyes.gif LOL

You can't change the value of a control in its Before Update event. I'd simply remove the line that sets the value to Null, and leave it to the user to correct (or clear) the value.
OK. Thank you...