Search results for query: *

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.

Form 1 has a save button on it, I would really like to invoke that save button right after I set the value of the checkbox. Is there a way to do it from form2. I have tried a few different variations for instance Call Forms.frmAccount!(Me.cmdSave) Thanks

I have a form (form 1) that calls another form (form2). Users can change and save info on form2. When they save the form2 record, I check off a check box on form 1. Forms!frmAccount!(Me.txtCheckType.Value) = 0 However, when control passes back to form1, the user might cancel the form, or...

I have a friend who is having trouble removing Office 97. It seems he is getting an error message with "Shell .." Is there a way to get it off. What might be some tricks. Like re-install it, and then remove it. Perhaps there is a corrupted file somewhere. Thanks..

Thank you, I will try it.

I have an Excel sheet that was created by another user. It has a series of radio buttons that I need to change to check boxes. Only thing is, how can I get the sheet into some kind of desinn mode to remove the radio button. I have unprotected the sheet, then if I click the radio button, it gets...