Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: herd
  • Order by date
  1. herd

    Module Question

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

    Filter by Month

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

    Error Message?

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

    filter

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

    Hyperlink question

    The field is a Hyperlink
  6. herd

    Hyperlink question

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

    Macro

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

    Form/Code question

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

    Combo Box

    Thanks PH
  10. herd

    Combo Box

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

    Date Help

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

    Database to Database (MS Access)

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

    Standard Deviation

    ((([DATA1]^2+[DATA2]^2+[DATA]^2+[DATA4]^2+[DATA5]^2)-(5*((([DATA1]+ [DATA2]+[DATA3]+[DATA4]+[DATA5])/5)^2)))/4)^0.5
  14. herd

    Query Question

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

    Sort Question

    It works, but how do you get them to apperar only once?
  16. herd

    Sort Question

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

    MS Access Error Message

    Here is the FiveSec function Public Function fivesec() If Me.username = "larsong" Then Me.Text243 = "RMQX" End If If Me.username = "buckc" Then Me.Text243 = "RMQM" End If If Me.username = "abramd" Then Me.Text243 = "" End If If Me.username = "combsc" Then Me.Text243 = "RMQE" End If If...
  18. herd

    MS Access Error Message...Help Please

    Different Maschine - same error Comment out - same error used new code - same error. My form would work for about 1 day (24 hours) then with know warning it would start getting this error message.
  19. herd

    MS Access Error Message...Help Please

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

    MS Access Error Message

    I get the error even after the form is open, each time I navigate to the next record it give me that message but instead of saying "The expression On Load", it says "On Click". Could the code be to confusing?

Part and Inventory Search

Back
Top