Search results for query: *

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

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

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

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

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');

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...

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

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?

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.

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

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"...

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.

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

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. :-)

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?

thanks skip this code does not work for some other reason because when I add the semi-colon it blows up again I have decided to use a much simpler statement and move on I appreciate your help. I think I have a typing error in this.

OK I am trying to insert all the info from a temp table (las-temp) to a permanent table (las-invoiceitems) I keep getting a message about a missing semi colon at teh end of the statement but I do not think that is what is wrong can someone help? Dim strsql As String strsql = "INSERT...

and again THANKS!!!!!!!

What is the syntax when I add the second fields?

You are the wonderful! this worked THANKS SOOO Much!