Recent content by Poduska

Thanks xwb for pointing the way. A Star of course I wanted to post what I was finally able to get to work to start my project in case it can help others. Pretty basic but one must start somewhere. Code is here #include<stdio.h> #include<string.h> #include<stdlib.h> int main(){...

Newbie here, Access programmer VBA for years but trying to learn "C" is killing me! Simple start of book exercise, Using "GCC" compiler What my code should do: Read each keyboard entry into Array called "Words" Keep accepting keyboard entries until the word "Devo" then print out each entry...

Rats, Excel also reads +PF-LOT as #NAME? so I cannot read from Excel. Funny a text editor reads the CSV file just fine. And it started out such a good day this morning! I'll keep trying.

Sorry if I wasn't clear, I realize it how hard it is to help others without being there! :-) Excel is not involved at all, I have users who do a download from a system of which access cannot read, and the source program creates a CSV file and saves it on our network. I then go and...

Thanks Skip However in Access 2007 I am utilizing the Import Specification window and Windows (ANSI) is not an option. I am using this as the original file is 255 fields and I am only importing about 35 fields. I will try other CHARACTER SET options within the import specification.

When I use an import specification (the field is TEXT) and import from a CSV file I receive a value of #NAME? for fields with values starting with a "+". Why would TransferText not be able to handle text starting with a + ? Any ideas? This process has been working correctly for several years...

Conversion of code from 2003 to 2007. I have used this code from http://support.microsoft.com/kb/198755#top for several years to show who is actually attached to 2003 MDB, IT IS PRICELESS, however it does not run now since we have converted to 2007. I made one change to the MS KM code where...

Dhookom, I sure wish I would have read you post sooner as you pointed out EXACTLY what my problem was. My wife would say I have more than just ONE problem but that's another story...... Thanks all.

As SkipVought is always right and as I was STILL receiving my error I thought "What about garbage data?" Apparently out of 6,000 records TWO do not have a DASH which is the character I am searching for using the InStr function. Therefore I am am receiving a Zero from InStr and passing this on...

Have been given a form with a combo box which no longer works. The combo box is to show one instance of each string found in a field for ever record in a table. For example: For records "ABC-12345" "ABC-67890" "DEF-12345" "DEF-67890" should return "ABC" "DEF" one instance of everything...

I have seen this done in XL but cannot seem to come up an idea that works in my Access form on my OLE Class "Microsoft Chart Graph". I have a simple line graph based upon a query, 3 lines of data horizontal and a continuous X-Axis by Date, about 150 days at a time along the bottom. It is a...

Wow, Will try first thing in the morning but it appears to be exactly what I need. I LOVE the idea of using a function, makes it portable. Thanks

I have a query with about 40 statements like this Like "XXX*" For example Not Like "9?9*" And Not Like "499*" And Not Like "835*" And Not Like "432*" And Not Like "47*" And .... The entire statement is together as criteria against one field. The number of characters (X's) and the value of...

RATS. This command works PERFECT if I use START\RUN "C:\Program Files\Microsoft Office\Office11\Msaccess.exe" "c:\northwind.mdb" /cmd = "Employees 000005" But I receive "Cannot open the Specified File" from a hyperlink. Funny, why would Word\Outlook remove the beginning and ending double...

Well, it is not a direct method but it does work. I use an autoexec macro and a public module to allow me to open the database to a specific form which shows a specific record. "C:\Program Files\Microsoft Office\Office11\Msaccess.exe" "c:\northwind.mdb" /cmd = "Employees 000005" This passes...