Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by vburrows

  1. vburrows

    print a single form

    oh the answer is in http://www.tek-tips.com/viewthread.cfm?qid=1419810&page=48
  2. vburrows

    print a single form

    I found my answer after a couple hours of searching this thread can be closed Thanks all for looking
  3. vburrows

    print a single form

    I have a program that prints checks but I only need it to print the current form. I am not finding this for access 2007. and everything else I have tried fails to work. Any help would be appreciated
  4. vburrows

    insert into with table values as well as form field values

    OOh yeah overlooked that one. I really appreciate it that fixed it [2thumbsup]
  5. vburrows

    insert into with table values as well as form field values

    ok I am getting 3134 error "syntax" the debug.print INSERT INTO Outgoingserver (from, Subject, message) VALUES ('rgparker@transposvc.com','D:\Development\Cartwright\calendar\outgoing2\20080606123456.pdf','Change this text Before you send any Emails testing');
  6. vburrows

    insert into with table values as well as form field values

    OK I am sending mail messages to a customer list I am trying to send the list to be mailed to a table in ACCESS I need to use the information on the form as well as the query I am calling to I am trying to use an insert into sql statement what am I doing wrong heres is the code. Public Sub...
  7. vburrows

    SQL Query in tables

    Thank you all so very much!!! I just realized I bid to little to take over a project this size lol
  8. vburrows

    SQL Query in tables

    thanks and That is great now is there a way that I can pull the actual query (the sql text) out of the query itself?
  9. vburrows

    SQL Query in tables

    I am trying to figure out how I would go about using vba to pull all the queries out of a db and in to a memo field in access table. Basically I would like to be able to use a queries to iniitate a query.
  10. vburrows

    List all fields on a form

    Thank you very much Remou I found an error in the 2 varibles and it is working great!!!!
  11. vburrows

    List all fields on a form

    Ok I am putting into a module the above code edited in this manner Sub BuildFormsTable() Dim tdf As Object Dim fld, fn, tn, strSQL 'Create table 'strSQL = "Create Table tblForms (TableName Text (100),FieldName Text(100))" 'Clear existing table 'strSQL = "Delete From tblForms"...
  12. vburrows

    List all fields on a form

    PHV thank you very much that is a great piece of software/scripts My problem is I have to have the code because of limitations of RDC (remote desktop connection) I cannot paste anything there but text.
  13. vburrows

    List all fields on a form

    That is awsome all i need now is to figure out how to get each field listed that is on those forms
  14. vburrows

    List all fields on a form

    I need help with getting the fields on forms this only tells about tables and relationships. Thanks thought that will be usefull on some documentation that I have to do today as well. :-)
  15. vburrows

    List all fields on a form

    I am not very good with the access object model How would I create a list of all the fields on a particular form or all forms in a particular .mdb?
See more

Part and Inventory Search

Back
Top