Search results

Thank's a million guys.

I'm not sure I understand

with one case it appends the firstline of the text file to the table but if i put the other case 2 and three in the statement it does not work.

can you help me this is what i have address1 address2 address3 address1 address2 address3 address1 address2 address3 this is what i want address1 address2 address3 address1 address2 address3 address1 address2 address3

I have a text file that has a record spanning three lines with no delimiter.

I have a text file in this format: Name: Bill Gates address1:One Microsoft Way address2:Redmond, Washington address3:USA and I want it in this format. address1 address2 address3 One Microsoft Way Redmond, Washington USA

tblInvoice TransactionDate Locationid Quantity Price Location Customer ID Sales Representative ID Contact Address1 Address2 Address3 Discount Price Sale Gct Extended Price Card Type ItemCode TransNo InvoiceDate Number of Distributions tblCustomer DigiID Sales Representative ID Customer ID CWID...

I have the customer info in one table and the invoice details in another table. THe option I'm looking for is code to look at the data in the table and generate an invoice number for each set of customer transactions. Numbering of the invoice would normally be done in the application the...

I have a database that generates customer transactions history but no invoice no is generated for the transaction. I need to generate invoice numbers for each line item to produce invoices for the customers problem being a customer can have multiple items per invoice. How can I update the table...

Maybe I'm going about this the wrong way. I neglected to mention that I am new to VBA. The Trim function works when I use it in a SQL statement but it doesn't from code could you guide me.

I need some help deleting leading spaces before a field "ItemCode" but the Trim function does not seem to work. Can anybody help.

I have a table in acces which is actually a transaction history report file from an accounting program. It contains all the transactions for the last business week. I need one transaction for each item where the cost is different. eg. I have ten transactions for the item chicken breast. of the...

I am not sure if what I am trying to achieve is possible but here goes. I want to link to a group of foxpro free tables using VBA reason being the names and the number of tables I am linking to changes periodically so therefore I want to be able to link to whatever tables are within the...

I am not sure if what I am trying to achieve is possible but here goes. I want to link to a group of foxpro free tables using VBA reason being the names and the number of tables I am linking to changes periodically so therefore I want to be able to link to whatever tables are within the...

Hey Alex thanks for the code worked like a dream.

Hi Guys I need some help with copying a folder from a server to a local computer. I need to copy a foler with dbf files the server to my PC. How can I achieve this. I do not want to use a batch file.

I got this code from the web it is supposed to open the browse folder dialog box but I can't get it to work it keeps telling me that cannot find project or library and highlights Space$ I an access newbie and I would really appreciate some help with this. Option Compare Database...

I have a module a database that creates folders using the value in the fname and lname field. I got some help to create this from this forum I now need some help to open these folders from within access using the fname and lname of the current record. can anyone help me please.

I need to update a dbf file with data from access using pass through. can anyone help.

I should have been more detailed in my description. If I use that code it would, i believe, create directories everytime i run the code. what I want is code that will create one folder each time I run it based on the record i'm in on the form. what I was thinking was something more along the...