Search results

thanks !! added to your reputation

hey group How can i have something like this loop to run from ccess application which is already currently opn and where work is done ? With objActiveWkb.Worksheets("Reconciliation Sheet") For ii = 5 To 200 If Range(ii, 9) = "NO" Then Range(ii + 1, 9).Interior.ColorIndex = "yellow"...

Hey I did a Macro with TransferText Action Its transferring query (type - Export Delimited) to csv file On a csv file when its created date fields have 12:00 00 am next to them, which is ruining a format. If I change a table the query is based to thave them as text, the format is text instead...

I have the proper 'proper import script' with 'transferSpreadsheet' already !! >>I have a procedure that imports excel spreadseet to access table ever today. that was the first line in my message. There are no integer fields, only text & date. i'll check 'text' sizes again and set thewm to...

Hey I have a procedure that imports excel spreadseet to access table ever today. today it failed. Forrmat was the same as yesterday. I did 'copy/paste special/format' from yesterday's file; still today's file wouldn't import. Tried to copy manually to the table, got the error message about...

uploaded. (it was a reall tiny file; y zip ?)

says "Invalid File" (when it try to upload) whats that about ?

What can be the reason ? i'm doing it through a regular "Import Spreadsheet Wizard", and get a message "an error occured trying to import file" File is not open. Made a copy under a different name; still can't import..

i was planning to do that; but i wanted t ocheck first if i can just extract the number.

Is it possib;e to create a query that would all the dates withn a range of Date1 and Date ? Ex if I have Filed Date1 Date2 x 1/1/07 1/3/07 c 1/6/7 1/8/7 for query to show Field Date x 1/1/7 x 1/2/7 x 1/3/7 c 1/6/7 c 1/7/7 c 1/8/7

in the query design how can I extract a number out of string. ex 25 bp 234.56 bp etc. ? I would have expected INT(FiledName) but it's not it

Dim USER USER = ENVIRON("UserName")

Yes, the form should be open; that's where the date is coming from. in the form you just type regular date - like 10/25/31 What I did for now - put a table with one date value, and form now picks up that date. (would be nicer for the old way to start working again)

Well it's not "mine" in any sence of the word.... It's very nice, the person who wrote sure knew what they were doing

Hey Banana I finally did it with 10 separate Subs (each with it's own OnErrr), and then one main sub is calling all of them More or less does what i had in mind..

Banana, nope. just checked. This is really some kind of mystery. I just opened backup version from few hrs ago. There 'On Error' works fine. After few changes in that version is mystriously stopped version

Hey DJKarl I can't do 'Exit Sub', since i got other things importing after "MAN" However it's not even going to MANError ! It's breaking on DoCmd line...

I am sorry, i copied it incorrectly it's resume next, not exit sub On Error GoTo MANError pathbgc = Path & "\Man.xls" DoCmd.TransferSpreadsheet acImport, , "B_Man", pathbgc, vbYes MANError: If Err.Number = 3011 Then Resume Next that's what not working

Hey This worked fine for some short (but blissfull) time On Error GoTo MANError pathbgc = Path & "\Man.xls" DoCmd.TransferSpreadsheet acImport, , "B_Man", pathbgc, vbYes MANError: If Err.Number = 3011 Then ExitSub '--------------------------------------------------------------------------...

Here's the first 2 lines from Excel files. (i can also do attachment) Colun thats creating a problem is Issuer Deli. Oblig Once I get rid of period in its name, problem disappears.. Refer # Broker Id Buy/Sell Protection Amt (M) Prod Issuer Deli. Oblig 2007709765 Rafferty Capital Markets SELL...