Search results for query: *

My report consists of only 1 field. When viewed in Access no blank lines are visible. When exported and viewed in Notepad, there is a blank line inserted after every 3rd line.

I am experiencing the same problem. I've been searching this site for hours and I've seen multiple questions about this issue. Unfortunately, no one ever seems to get an answer. I'd give plenty of stars to anyone who could give us an answer here.

I am experiencing the same problem. Is downloading that applet the only way to fix this problem? Personally I would rather not download any applications.

Hello Everyone. An interesting problem has come up at work. Our report generating software created a report that produced 799 ".csv" files and places them in a folder. These files contain a single cell that holds the "Total Sales" for a specific store. I need a way to open each file, select...

DrSimon, You don't know how much time you just saved me. I've been looking for this answer all morning. Thank you, thank you, thank you!

Thanks for all your help OnTheFly. I think this will work just fine.

I tried using this but it didn't insert anything into the table. strSQL="INSERT INTO Table1 SELECT * FROM Table1 WHERE ID=" & lngID

Okay that's working great! Thanks. Next question: My table have many many fields. Is there a way to select all?

could you possibly give an example of some syntax?

Could this be done in the on-click event of a command button?

Hello everyone. I'm using access '97 for this. I have a form that uses a tab control to display a large amount of data. Sometimes 2 records, due to customer requests for quotes, are very similar. To save time for the users and eliminate reentering data I am trying to allow the user to copy...

*Bump

Could you be a little more specific? Could anyone explain?

Hello everyone. I'm using access '97 for this. I have a form that uses a tab control to display a large amount of data. Sometimes 2 records, due to customer requests for quotes, are very similar. To save time for the users and eliminate reentering data I am trying to allow the user to copy...

I'm having a huge problem with this because the form i'm using it with contains a tab control. It is only copying and pasting the information on the first page of the tab control. Can someone PLEASE tell me how to get around this?

Thanks PHV. This is what I ended up using. DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdPasteAppend It works exactly as it did when I was doing in manually.

*bump

Anyone??

Yes that's what I was talking about. And I believe that you should be able to. I created a sample table in which the primary key was an autonumber called RecordNo. I then created a sample form for this table. I then went to Edit->Select Record, then Edit->Copy, then Edit->Paste Append...

Hello everyone. I'm working in Access '97. I have a form that records information on quotes. In this form there is a subform that holds a great deal of information about the part numbers contained in the quote. Sometimes the parts as very similar and my users want to be able to copy a record...