Search results

the problem is the limit in Excel 65536 lines. (last version about 100000) I have 500000 and more sometimes.

Excel does list prn as an export option, Access does not. This is my problem.

We have the Excel tamplate formated the certain way. So when we create prn file from Excel it has determined spaces and stuff. Can you help? PLease

No, Ii tried doing that. It creates txt file that have different structure. It doesn't work for the upload.

so looks like nobody knows....

Hi there, I need to export the table from access 2003 into .prn file. By some reasons we use that kind of files for uploading into anther DB in AS400 (which is stupid, but we can't change that). I can't find the option in Acess to export as .prn I can do that from excel but amount of lines is...

Thank you guys a lot! I think i can go through now.

Hi, I have a query picking Top 3 of something. Sometimes I need top 4 or top 8 and this is a part of my adjustments. All other adjustments are in the form. I want to make this Top 3 thing as an adjustable parameter and manage the query from the form. I tried diferent ways, but SQL...

I found the script to compact the Access DB using VBS script Just in case sombody's searching '==================================== ' File: CompactDB.vbs ' Author: Q-Built Solutions; www.QBuilt.com ' Date: 20 Aug. '04 ' This script can be used to compact an Access ' database on a...

Well I did that in one script I just close and open it again. But anyway there should be a way. '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''''''''''''''''''''''' 'Update Microsoft ACCESS database Option Explicit dim oaccess set oaccess =...

think what is what. What is a customer? - name, address, phone number, representative and stuff What the product is - product line, product code or model and a list price (no promotion prices). What a promotion is: It's a combination of event name, customer and product. So put in you table...

neee ... I need to compact it after i deleted the table. Otherwise it can't populate the new one as it's too big. There's no sence to compact it after the table has been populated. I'm so close to it! Please help! Thanks.

Wow! That's a grate thing! Thanks! It works fine, but how I can compact it?

Looking for vbs script or something to do the following things during the night time while I'm home: 1. Open the Access DB 2. Run the Delete queiry in Access DB 3. Compact the Access DB 4. Run the macro in Access DB to build and update the new table. 5. Close the DB Thanks to everybody

Hi there, I have long file (1 mil records) downloaded from AS400 as .csv text file. there 2 feilds - shipping date and receiving date. I need to calculate the lead time in days as RecievingDate - (minus) ShippingDate. It would be easy in Excel, but i have too many lines. So there are 2...

Thanks! It works.

Hi, Let's say I have a table Group VALUE A 12 A 8 A 3 A 20 A 1 B 35 B 2 B 12 B 6 B 54 How I can get top 3 of each group in one veiw? Thanks

This is actually Delete quiery So I tried to put the whole thing in there and make something like this: dim strSQL = "DELETE T1.* FROM MyTable T1 WHERE T1.[$COGS] < (SELECT MIN(T2.[$COGS]) FROM MyTable T2 WHERE T2.item = T1.item AND T2.[$COGS] IN (SELECT TOP " &...

Let's make it more complicated! OK Now. Let's make it more complicated! What if I want to make this TOP 4 adjustable. Let's say I have a Form whith a feild to enter this number. I tried to make it like SELECT TOP [Forms].[FormName].[FeildName] T3.[$COGS] ..... But it dosen't work. What...

Here you go! That's what I need. Thanks