Search results

Right Now I have created a button that reads the properties of the control. I am going to try to use a case statement. I have limited experience with Controls in Excel. If I change the code to ActiveSheet.Opt1.Caption (or Value) it works now. Thanks for the help

I have Several Option Buttons on a Form. I am trying to write an If statement and I am trying to read the Value and Caption property of each control. But I am having trouble with Object/Property. When I try "Opt1.Value" or Opt1.Caption I get an "Object Required (Error 424 )" message. When I look...

Can't Paste... SOLVED ! After re-tracing my steps, I remembered activating an Add-In that would automatically recalculate the active worksheet. I had set the re-calculate rate to 2 Seconds. When the sheet re-calculates it would loose focus on whatever had been selected on the clipboard. Since...

I have Office 2003 running on XP Professional. I use ctrl+C and ctrl+P to cut and paste in Excel all the time. They worked fine yesterday. Today, when I try to use ctrlP nothing happens. When I try to go to Edit>Paste, Paste Special or Paste Hyperlink those options are grayed out. The Clipboard...

Reply Peter, Haven't had a lot of time to work on this today. Initial attempts were unsuccessful. I am tryiny to de-bug. I will try to work on this over the weekend. Raun

I am importing Data from an Excel spreadsheet into Access As each record is processed, It is assigned a Primary Key value, which becomes the document # for each record this field is called DocNum. I would like to copy the Access number back into the Excel document. I think the best way to do...

I am entering a row of Data from an Excel Spreadsheet into an Access DB After opening the DB I place the valve in each Excel cell into the proper Access field and then update the DB ie: ... DBS.AddNew 'Add a new record DBS!Description = ActiveCell.Offset(0, 1).Value DBS!Location =...

I have a form developed with Access 2000.with command buttons I built using the standard command button wizard for navigation, new record, copy record, save record etc. I have a few small VB scripts associated with these buttons- mostly message boxes. I had to upgrade from Win 2000 Pro to Win XP...

I am trying to count values between 0 and .5 Using COUNTIF to interrogate a Range (K2:K419) I can do a COUNTIF for either value, but not both. I tried to morph a COUNTIF formula and an "AND" operator =COUNTIF(AND(0<K2:K419, K2:K419<.5) )....which doesn't work Could somebody help me?

That's what I was looking for! Thanks.

Thanks, This Works from Design view, but I want to design the query so that it asks the user for a value which will run as a wildcard, instead of making the user go into design view.

I have converted an Old FileMaker Pro DB to Access. There is a record for each of the 22,000 sheets of engineering project documents issued over a period of years. One of the main fields we query by is the "Description" field. If I have the following Criteria: [Enter Document Description] Then...

I want to write a script to add a criteria to an existing query. I am using the following code based to look for the selection of an option button and executed “On Click” from a command button . If optEmpNum.Value = True Then qryEmpData. EmpNum.Criteria = [EnterValue for EmpNum] End If I get an...

Close to what I need This sounds close to what I want to do. I use Access 2000, Office 2000, and Win2000 I have taken the data I need from "sheet1" in an existing Excel file and moved it to "sheet2" where I cleaned it up for my Access table. I can go to Access and, using Get External...

I am trying to shorten a long list of Employees with a build table query that interrogates table tblActCont creates tblACxGL with only the active contractors assigned to a specific group leader. In Query qryACxGL I have three fields: GrpLead, EmpName and Emp# In the GrpLead field of qryACxGL...

This may be a FORMS question, but this thread was the catalyst for my question. I am using Access 2000 on a Win2K box I am making a time entry DB containing form frmTask. In an effort to shorten a long list of active employees in ComboActCont I want the user to select a group leader from...

Reply This will get me there, but what is the proper prefix for declaring a variable, type Date (mm/dd/yyyy). The only resource I could find had three letter prefixes. dtm, str, vnt, etc. The example seems to use one letter descriptors

I use Access 2000 on a Win2K box. I have a form with seven fields. It is a pain to fill out because the values consist of long strings of alphanumeric characters. (I have no control over this) Frequently only one or two values change so I would like to let the user duplicate a previous record...

I am not sure that that user interface is any easier, but I haven't played with the list box as much at text boxes & option buttons. I tried to set one upon the fly, but I couldn't pick more than one option. I would need time to play with it more I was really trying to focus on the code to...

Reply Thanks Tim, Actually I support several different applications[PI (from OSI),AutoCAD and (of course)Excel] with VB6.0. That is, I would be able to support them if I understood VB better. Your first recommendation, Programming MS Visual Basic 6.0, may be right up my alley. Between what I...