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 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...

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?

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.

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...

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.

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..

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...

We have a form that someone built using EXCEL. It is a several page input form. In one section there are a series of questions with a radio button to the left of each question. If someone clicks the first radio button, then clicks the radio button for question #4, the first radio button is...

I am testing a routine that has a table with an autonum field. I have entered about two dozen records via testing. How do I reset the autonum to 0. If I remember, If I delete all the records, the next record will be whatever the internal counter is +1.

How can I obtain the name of the current control in a form. I have a form which calls form 2. From form 2, I need the name of the control from form 1 which called form 2.

I have a series of check boxes, that when the user checks it, I open a form. I pass in the name of the check box to the second form via OpenArgs. I want to force the check box to unselected. But I want to make the routine generic. Instead of setting the field like this line...

I have a form with a bunch of check boxes. When the user selects the checkbox, another form opens, and they fill in info. What I am looking to do is...when the user deletes the record on the second form and control passes back to the calling form, I want the checkbox to remove the check. What...

I am having a little trouble with the concatenaton I want to concatenate the ID and the document name for lookup... sSQL = "Select * from [issues] Where ID " & Me.txtLinkID.Value & " And " & "DocumentName = '" & Me.txtDocument & "'" How should this read? Thanx

I want to close a form that is open. This works when I use a macro, but I dont want to use a macro. DoCmd.RunMacro "macCloseIssuesForm" How can I use the DoCmd.RunCommand what is the syntax? Thanks