Search:

Type: Posts; User: imincorrigible; Keyword(s):

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    8
    Views
    1,064

    Thanks Patt but I am not fimiliar with using...

    Thanks Patt but I am not fimiliar with using OpenArgs. What would the code look like?
  2. Replies
    8
    Views
    1,064

    My plan is to have a print command on the form...

    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.
  3. Replies
    8
    Views
    1,064

    That worked. Thank you very much!

    That worked. Thank you very much!
  4. Replies
    8
    Views
    1,064

    Changing Label Caption on Report

    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...
  5. I took this SQL statement from a query that I was...

    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...
  6. I have come up with some code but get a run-time...

    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...
  7. That worked. I didn't get any errors. When I try...

    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...
  8. That worked without getting an error. Now when I...

    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,...
  9. I tried to put the connection string from...

    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...
  10. The data in the FoxPro database changes everyday....

    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...
  11. I have ODBC drivers but Windows 7 cannot use...

    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.
  12. It looks like that would work if I was running MS...

    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...
  13. Thank you for your patience. Excel 2003 has a...

    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...
  14. I think that acticle applied to people running 64...

    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...
  15. Connecting MS Access to Fox Pro database

    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...
  16. Replies
    5
    Views
    788

    Thanks, I will look at that after I figure out...

    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.
  17. Replies
    5
    Views
    788

    I was wrong. What I found was that I had mapped...

    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...
  18. Replies
    5
    Views
    788

    What I found out was that I was linked to a...

    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.
  19. Replies
    5
    Views
    788

    Hi all, Access 2007 - can any1 think of a reason...

    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...
  20. Replies
    5
    Views
    472

    This looks like a recursive relationship: WIPN...

    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...
  21. Replies
    5
    Views
    472

    There are no relationships between the tables...

    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...
  22. Replies
    5
    Views
    472

    I have products that are made from many sub...

    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...
  23. I set up a query just to view specific work done...

    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...
  24. Replies
    7
    Views
    487

    Thanks for the suggestion. I printed it out so I...

    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
  25. Replies
    7
    Views
    487

    You can't change the value of a control in its...

    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...
Results 1 to 25 of 170
Page 1 of 7 1 2 3 4