Recent content by Goot

One of the ways we use Access is to query DB2 databases via ODBC. One of the tables is quite large There is a vsam file which needs to be converted prior to our moving the information into Access so we can run queries vs this information. Does anyone know how to convert a vsam file so that...

I am using the hyperlink address property in code to open a document. The user can select any file type. The routine works fine for txt files, XLS and DOC files. The selected file will load with no problem, except in the case of a PDF. The screen flickers for a second, without the document...

I have a column in an excel spreadsheet. It is to be used to store text. How do i make it multiline. I want the column to wrap around...like a multiline text box in Access. Thanks

I set up an icon on a user pc today, and noticed security prompts "Unsafe expressions are not blocked"... To unblock, install Jet ervice pack 8.0... I have not seen this on other pc's in my company. Could it be that it is not running XP? By the way this is access 2003.

I got It.... Thanks anyway

I am using an option group. There are 3 choices, in my save routine, I am getting runtime error message 2427 you entered an expression that has no value. One of the buttons was selected. I am a little confused here. This is probably an easy thing.

I have a list of account names (254 in total) that a user wants me to cross reference against our database. If I join the two tables on the account name, it matches 2 records. I would like to match on the first x characters to see how that looks. I have been trying to do it in the query...

Thank you.

I am trying to run a query based on name. I have names in both tables that I am trying to match to. How can I match on say the first 5 characters of the name? I need a mid$([FieldName,1,5) somewhere?

Thanks for the info, but this user is not up to the task of following those steps. Is Microsoft out of its mind!!!! This is a 68 year old person, tinkering around in the registry.... What a crappy company they are!

I have a friend that is trying to remove Office 97 and is having issues. Are there any known tricks as to its removal. He is getting an error message about "shell" being mentioned.

Hi I just got the query to work, actually the records are not deleted.

I am using ODBC to access a DB2 database. I have taken over a query that someone is working on. I am getting #Deleted in the columns from the table on the right side of the join. Infact, if I try to open table in the Query tool, I get #Deleted for all the columns, Can someone explain what this...

Right.... Thanks all.

In excel, I want to do a copy and paste, but I want to paste the info vertically so I can print it in a report type fashion. I have done this before, I just don't remember how.