Search results

I thought you ment using vba in access to extract the addresses from outlook express on the fly. Do you need to proccess the CSV directly or are you importing the file first.?

So close, if you had looked in the help you wouldnt need to post.(its what i just did) INSERT INTO target [(field1[, field2[, ...]])] [IN externaldatabase] SELECT [source.]field1[, field2[, ...] FROM tableexpression So insert into BuildingNumberName (BuildingNumber, BuildingName)...

Setting the control source to "= [field] /1000" should work fine, i have just tested it.

No probs.:D

1st the docmd is the VBA root not the macro root, which is it you want to do. as for finding out how the functions work and what they do i sugest looking in the help, its very informative and contains info on every function of access.

Create a new Button, and chose [cancel] to the window that apears(assuming it is displayed) Right click on the control, then chose [Build event] and use the code builder option, all you have to do then is cut and paste CJBIRKIN's code. or just do it in the macro as CJBIRKIN just posted...

Its easily done in VBA, filename = dir("c:\*.dat") do call Process(filename) 'or what ever you do with the file filename = dir if filename = "" then exit do endif loop

Doh!!:rolleyes: Didnt c that i must be going blind...............................

Its just a way in VBA code of using the export option located in the menu.

Dont worry its a easy mistake to make, the dir fucntion is a bit weird try If Dir("C:\leads_folder\daily_declines\dailydone.txt") Then Kill ("C:\leads_folder\daily_declines\dailydone.txt") retval = shell(" c:\leads_folder\daily_declines\dailyconversion(tom ).bat", vbMinimizedFocus) Do...

I think what your look ing for is Docmd.minimise - minimises the form Docmd.maximise - maximises the form Docmd.Restore - restores the form to original size They work just like the buttons in the corner. Hope this helps :cool:ShadeZ:cool:

If you dont know any VBA then your a bit limmited Open up your form and go to [FILE] in the menu, there is a [Export] option click this; one of export options is to use excel. the excel export isnt very good tho. :cool:ShadeZ:cool:

I could do it very easily with outlook or lotus notes, but i dont know how to get the address list out of outlook express. If you can find this out i sould be able to help you. :cool:ShadeZ:cool:

have a look at the CreateControl() Funtion

NP, I think both methods for the like should work. i just prefere to use vba to do function call like LEFT, Its a bit faster than letting sql do teh work

Ok the only problem i can c with your code is lack of " and ' i am assuming [Rec_Install], [tk_item_name] and [tk_item_name] are textboxes located on the same form as the code sql = "UPDATE tbl_Temp_Tools_Import, tbl_TK_Items SET " & _ "tbl_Temp_Tools_Import.F1 = '" & [Rec_Install] & "'...

your querey posted seems to be a miss match. try posting your code and query versions seperatly and i should be able to help. Wont be till thursday as im out of the office tomorrow. :cool:ShadeZ:cool:

IC lots of problems. 1st your Quotes are all wrong try strSQL = "UPDATE [dbo_tbl_transactions] SET [sdt_transaction_date] = #" & updated_trans_date & "#" &_ "WHERE [int_member_id] = " & int_id 2nd, You will probably need to format your dates, (Dam americans) :cool:ShadeZ:cool:

ok, - Havn't actually done this before, but i know its possible First, Do you realy need to embedded the file? Can you get away with storing the path to the file on disk? - This method i know. Second Have a look at the OLE object, This could be the answer to all your needs. If you cant use...

yes:p