Search results

hi again Khawar, I attached my database, table documentos (like invoices) and documentoslinhas (details of invoices) are attached tables from access2.0 database. The purpose of it all is to gather all invoices from the details that are from a specific customer, then export all to a txt file...

hi Khawar, Thanks for your help, because of you this is working pretty nice :) I just need one more thing, when the user selects to create a new invoice, the new invoice number must be created on all records in a table that doesnt have that field. To explain when the invoice is created...

this is the code i used to export just the header: Public Function CreateTextFile() Dim strTIPOLINHAH As String * 2 Dim strFILERH1 As String * 1 Dim strCODENTIDA As String * 9 Dim strCODTIPENT As String * 8 Dim strNUMFACT As String * 8 Dim strANOMESFACT As String * 6 Dim strDATAENVIO As...

For example, when i create a new Invoice, i need it to get the last one issued then increment one, then go to a temp table and fill the header number for that recordset

Hi all, I've been putting some questions, and developing as i get some answers and find solutions, although i dont know if im making a big turn around to get where i want when someone with expert knowledge would get there in no time, so im asking for sugestions. I have an old database...

hi, I used this on a piece of code, it worked very nice. I have a problem though, although i have a number with decimals, like 1500,29858 it displays on the main form as 1500,00 What am i doing wrong? Thanks Luis

hi again Khawar, Sorry i didnt explain well, when the user opens the form, it displays something like: Your last invoice was number: 10 want to create number 11? Then on clicking yes it will create the number 11 record and open the form on the number 11 also. Thank you.

hi, That's great, just what i needed. Thanks khawar I need now on another form, that displays the last record number on a table, then by pressing a button it goes to the form on the same record number. Thanks again for your help.

Hi all, I have a make table query i need it to create some new fields, one for record count, one for total of one field, and another that has to do to a document table check the last value and enter it in all records. Is it possible?? Regards, Luis

Hi, I need to display on the main form the total number of records in subform plus a total of a column. :confused: I've tried some solutions i found but didnt work like Dcount on a control. Thanks for your help, Luis

The details are on another table how do i do it?

The small code i adapted for text export 1 table Public Function CreateTextFile() Dim strTIPOLINHAH As String * 2 'specifies width of 2 characters Dim strFILERH1 As String * 1 Dim strCODENTIDA As String * 9 Dim strCODTIPENT As String * 8 Dim strNUMFACT As String * 8 Dim strANOMESFACT As...

Hi, I'm developing a small access db to comply with some specs that were asked. Its a small hospital we need to send to one of the ensurance company's a report of the things we billed. Ill be attaching the table of our billing software to make a query for those records. Now comes the problem, i...

Hi, I'm developing a small access db to comply with some specs that were asked. Its a small hospital we need to send to one of the ensurance company's a report of the things we billed. Ill be attaching the table of our billing software to make a query for those records. Now comes the problem...

Hi, I have 3 tables i need to export to text, i already made the code to write one of the to text the others think its the same, the problem is that i need to put them like this: header table to text in first line of text file detail table with 999 rows just after header footer table 1 line...

Hi again, I know have for the header: Public Function CreateTextFile() Dim strTIPOLINHAH As String * 2 Dim strFILERH1 As String * 1 Dim strCODENTIDA As String * 9 Dim strCODTIPENT As String * 8 Dim strNUMFACT As String * 8 Dim strANOMESFACT As String * 6 Dim strDATAENVIO As String...

Forgot one thing The first and last line of the text file come from different tables like a header and footer.

Hi all, I need to export data from a query to a text file. Hope you can help me with a simple way of doing it. Im going to import data from a access database to a new table, from that table i need to export data to a fixed width, and name the file with some of the data. Some of the fields must...