Search results for query: *

I wrote a event procedure tinside a form to call a module; Example If Me.Combo215 = "wspec" Then DoCmd.RunMacro (MACRO1.CON_WSPEC) ElseIf Me.Combo215 = "WROCI" Then DoCmd.RunMacro (MACRO1.CON_WROCI) End If I get the following error. Object Required. What am I doing wrong? Thanks Gary

What expression can I used to show only current month in a querry automatically? Gary

What does this mean when I trying to open a chart. Cannot use the crosstab of a non-fixed column as a subquery. Thanks gary

How can I used a command button in a form to filter all records in which a check box is checked on that record. Thanks Gary

I used to be able to put a hyperlink in a table and connect to a Object in this database. Now I can't do this in a table only a form, why is this? Gary

How do you attach a Word Doc to Outlook using the SendObject in MS Access Marco section? Gary

Is it possible to have a command button in Form1 change the Backcolor on a Label that's in Form2? Gary

I have a combo box (Combo1) with 2 columns (Column 1 and Column 2) Combo 1 displays column 1. How do I get Column 2 to display in a text box? Thanks Gary

How do I convert date that arte formatted like DD-YY-MM to MM-DD-YY? Please Help Gary

How - with a cmd button on a form in a database open another form in another database? db1 form1 db2 form2 Thanks Gary

I have a table with a records listed below. (Sample) ID Date Finished Section Code 3 3/1/2004 Yes rmqe 2439 4 6/1/2004 No rmqo 2439 5 8/1/2004 Yes rmqo 2439 6 12/1/2004 No rmqe 2439 7 2/1/2003 Yes rmqe 2439 8 6/1/2004 Yes rmqo I want to have make a query that will exract records with a...

I have a query with a field titled "location", with data like - Buld. 109 Buld. 17 Buld. 8 How can I sort this data sort it come out looking like this Buld. 8 Buld. 17 Buld. 109 etc.......... Thanks Gary

I'm geting error messages when open my form. The expression On Load you entered as the event property setting produced the following error: A problem occured while Microsoft Access was communicating with the OLE server or ActiveX Control. Also same message but for on current. Here's my code...

In my form, when I open it, I get the following messages. The expression On Load you entered as the event property setting produced the following error: A problem occured while Microsoft Access was communicating with the OLE server or ActiveX Control. Also happen On Click, and once I'm in the...

Is there a code that can filter by selection on a form instead of using the button located on the menu bar? For example if I selected a field on my form then click a command button I would like it to filter on that selection. Thanks Gary

Is there a way to covert a text field with a date in it to a date field. I imported a spread sheet from excel which had a date field as text.

If I have two date fields (Date1 and Date2) how would I get a date3 that's between date1 and date2? I’ve tried DateAdd("d",(DateDiff("d",Date1,Date2)/2),Date1) Date3 = Date1 + (Date2 - Date1) / 2 When I tried both of these codes into my date3 field I get a return of #Name?............what...

If I have two date fields (Date1 and Date2) how would I get a date3 that's between date1 and date2? Thanks Gary

To look at data for the past 2 years in a querry, would the expression look like this >Date()-720?

What I want to do is be able to open excel files (TA1, TA2, TA3, etc) by typing the file name into a text box on a ms access form and then click a button and the excel file opens. Help please....Gary