Search results

Glad to have been of service. :)

If the file is saved as .csv then it is, you've just got your system (default) setup so that excel opens it. Right CLick Open With notepad, to check it is true csv. Where you select fields for your query, right click build and put the expresion in there, you'll need to put your field names in...

Here you go Private Sub Import_Files_Click() Dim FileName As String Dim objFSO Dim objFolder Dim objFile Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.GetFolder("J:\Britvic File Import\File Imports\") For Each objFile In...

Check this out http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=35849

If I read you correctly then you want to read file names from folders? the FileSytemObject will do this for you. If you'd like an example I could post one tomorrow when I get into work.

Records or fields? I don't know of an easy way to delete duplicate records but there are basically two methods, the easy way and the hard way. 1. The easy way Your lucky and the records are genuine duplicates, including id numbers. Create a query select all fields and click the group by...

If your codeing it....... Open your recordset While NOT rs.EOF n = n + 1 If n = 200 Then n1 = n1 +1 n = 0 End If rs.MoveNext Wend (but give your variables meaningful names)

Do you have to use code, access provide some pretty usefull importing tools that can be automated. In any case always post your code.

Create a query with the data you want and the format you want it in. Create a macro that in the action filed set "transfers text" (last on the list) in the action Arguments at the bottom, set to export delimited, give the file a name of "yourName.csv". Table name should be the name of your...

If the fields on the form are linked to the table then the table would be automatically updated from the form. If you want to code it then (please correct me if I'm wrong) you'll have to use a recordset.

Hi Suzi How is the db/external source setup, is it to excel/word.....? linked/exported.......? do you want to be able to edit it in access but not the external source?

I would write the for like this For i = 0 to intEmail EmailSend.Recipients.Add Email rsEmail.MoveNext Next I also find that recordcount always gives me a value of 1 if there are records and 0 if there arent any, don't ask me why, but it might be worth checking the value ou get. Also I...

i have a db that imports excel files, due to [my] poor design of the spreadsheets some of the records will be imported with missing data, but the data will be on the line just above it. when all the spreadshhets come back I'm expecting about 50 odd, I'd rather have a way of updating it in...

i had a similar problem the last time I used Tabbed forms, I found that there just isn't a property for the individual tabs, but that was a while ago and using 97. I'm not sure if that is still the case. There are other ways around it though, chakc out the event properties, onFocus onLostFocus...

Nightmare!! The only solution I can think of for this would be to hard code the file export, where you could use the chr(number here) to get #. It's alot of effort considering Access has the built in function, is it worth the effort? If it is then what you'd do is create a recordset from you...

I'm trying to run a delete query from a button, but when I use the wizard to create the event, it doesn't show me the delete querys as an option, just the select queries. It's not a problem I can just script it, but I was wandering whether anyone else had come across this, is it a bug, or is it...

Sometimes Access shares the autonumber field across tables, so if you create a conact and an address the unique numbers would 1 & 2 respectivley, the next time you add a new contact and address the numbers would be 3 & 4, thus giving you 1 & 3 in your contact table and 2 & 4 in your address...

Brilliant, works a treat.

Does anyone know how I can?

First thing to do is to make sure the SQL works. Create a new query, and where you normally click the design/table view (top left) click the drop arrow and select SQL. Paste your SQL into there and run it to see if it works. If it doesn't then that's the first thing you need to sort out...