Search results

I did some search and found the specs are stored in the MsysIMEXspecs, MsysIMEXcolumns system tables. They can't be edited directly (adding/deleting a record is possible) but they can be edited using code. Unfortunately I can't find the import file location in there :( I also found some code...

I tried using the Wizard and create a spec. Seems to work fine. Is there any way to tell it where the file to import exist? or will it open a file open dialog if it won't find the file?

Sorry Not yet.

Attached the file I'm trying to read errors are in lines: 848 849 946 1065 1066 1067 1147 1151 1205 1314 1329 1335 1361 1364 1381 1382 1389 1408 1412 1438 1439 1457 1462 1470 1471 1477 1522 1524 1527 1531 1536 1571 1629 1631 1666 1677 1678 1681 1682 1696 1699 1712 1724 1739 1740 6294 7191 7387...

What is it ?

I'm not using any Import/Export wizard

Thank you all for your comments I did several test by putting a test line into my TXT file and there is no doubt the quote cause this line to fail, when using DoCmd.TransferText method. I'll try using OPEN FOR INPUT to read the file.

Thanks, See my reply to Colin

Thanks, I had some ImportErrors I noticed they all had Quote in them. I use the DoCmd.TransferText acImportDelim to import the file using the acImportFixed require the Specification file. I import all data into a single field.

I need to import a text file into my db If there are any Chr(34) in the file it won't import these lines. Is it possible to edit the file and replace all Chr(34) into Chr(44) ?

Im using a "progress bar" form. It has no buttons, and i close it when job end. In some cases im using a progress bar on the form, as Isladogs suggestet.

Thanks this is the code I'm using. It works perfect now The problem was it had the Exit Do command :D (In one case I save 50+ images under the same "imageName") Public Sub pbExtractImage(strImageName As String, strPath As String) On Error GoTo errHere Dim rsParent As DAO.Recordset Dim...

Thanks for your comment These are small icons, that takes 2mb only. I already saved 50+ of them and they added almost nothing to my db size. Normally they are on a local folder, and I don't extract them. 5 of them, which are imortent, will be checked and extracted on APP startup if the user...

I see what you mean How can I read the names of the attached files inside the field ? is it flName = rsChild.Fields("Filename")

Why don't you recommend using an attachment field? The ribbon is working great, Thanks :)

The code in the example I pointed to in Post #12 is much simpler :) http://www.ribbons-access.com/ms-access/ribbon-creator-builder-and-editor-part-5.asp He also saves the images in the table as attached files, which is much simpler to extract. Now I'm only trying to find out how to extract...

This one closed the issue :) I'm now happily can use transparent PNG files :D It was in the example, not in the code on the page.

You can either use the loadImage="LoadImagesFunction" at the beginning, or use getImage="GetImagesFunction" for each icon require to be loaded. Without seeing your LoadImages function it won't help me. In your case all the icons are imageMso so they are taken from the Office Ribbon, and...

Not sure what link you refer to

There is no built in Application.LoadImage() command I'm trying to follow Gunter's GDI use in IconInRibbon App, but feel kind of lost there