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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ROUSOUG

    Adding a Filter or Where Condition to a Send Object String

    i was also trying to use filters on the OutputTo method. i found a way to do this using the OpenReport method before the OutputTo. So the OutputTo will include in the rtf file only the conditioned data Se below id = Me!listboxinvoiceids stDocName = "Test1" DoCmd.OpenReport stDocName...
  2. ROUSOUG

    Print Reports Throught VBA

    the OutputTo may not accept criteria, but it can be combined using the OpenReport. See below: id = Me!listboxinvoiceids stDocName = "Test1" DoCmd.OpenReport stDocName, acPreview, , "[InvoiceID]=" & Me!listboxinvoiceids DoCmd.OutputTo acOutputReport, stDocName, "Rich Text Format (*.rtf)", "c:\"...
  3. ROUSOUG

    Print Reports Throught VBA

    Is there no condition to get specific data? (linkCriteria)
  4. ROUSOUG

    Print Reports Throught VBA

    That seems to work. Now, what is the code to save this report on the hards disk as an .rtf file? When i preview the report, i can press the W button and the rtf file is created. how can i do this with the press of the buton?
  5. ROUSOUG

    Print Reports Throught VBA

    Before i had the condtion set throught a query (named SelectInvoice) as follows: invoiceid = forms!.main!.listboxinvoiceids which worked. I have entered the above condition in the button code as follows: stDocName = "Test1" DoCmd.OpenReport stDocName, acPrint, , invoiceID =...
  6. ROUSOUG

    Print Reports Throught VBA

    I have done this but i am not able to make the linkcriteria to work
  7. ROUSOUG

    Print Reports Throught VBA

    Table Structure (called "Invoice Details"): ID Invoice No Date Other Details I have a report (named "Invoices"). When i run the report, it desplays all invoices of the table. What i want to do is to create some sort of code that will print Invoice No 1, close the report, then Invoice No 2...
  8. ROUSOUG

    Create Records through VBA

    Thanks The final Code is: ublic Sub addrange2() Dim db As Database Dim rs1 As Recordset Dim rs2 As Recordset Set db = CurrentDb() Set rs1 = db.OpenRecordset("TelephonesPerLocation") Set rs2 = db.OpenRecordset("Ranges") Dim StartNo As Long Dim EndNo As Long Dim LocationCode As Long Dim count...
  9. ROUSOUG

    Create Records through VBA

    I have found the between operator but how can the query get the value1 and value2 (Between value1 And value2) from record1 of a table and then run the query again for the values of record2?
  10. ROUSOUG

    Create Records through VBA

    I am trying to find out how to use the Between operator but there is no reference on it. Can you provide me with an example?
  11. ROUSOUG

    Create Records through VBA

    I want to avoid storing all these numbers, but i did not find the way to use a query that gets the criteria (from, to) from a table.
  12. ROUSOUG

    Create Records through VBA

    Yes it is like the For i = 220001 to 221999 The table name is "NUMBERING" and the fields "LOCATION" and "NUMBER". I have tried to do this through a query using as criteria: >= StartNumber and <=EndNumber. However i had to put every time the numberrange in order to get the data of that range...
  13. ROUSOUG

    Create Records through VBA

    Hello all, I am working in a telephone company. We were given a list of locations and the ranges of telephone numbers each location can handle. for example: Location Number Range A 220000 - 221999 A 232000 - 232199 B...

Part and Inventory Search

Back
Top