Search results

  1. C

    Update checkbox value using SQL

    I'm trying to update the following fields using SQL. The code used to work until I added the COMPLETE_FL part. When I run it, it returns with an error message "Syntax error (missing operator) in query expression "'[COMPLETE_FL]=-1'. I've tried different variations using the quotation marks but...
  2. C

    Help in Building SQL Statement in VBA

    I'm trying to retrieve records with an AddDt that are 7 days or older from today. I think that the error lies in the DateAdd part of the statement. I'm not sure how to properly write this. Thanks. Set sst = CurrentDb.OpenRecordset("SELECT * " & _ "FROM tblTask" & _...
  3. C

    Declare and Call Questions

    I'm trying to create a script that will pull data from a mdb file and display it as a table in an html file. How do i declare access fields of the text and data variety and call it to display in the table? Here are parts of the code that I'm declaring the data types and displaying them. Any...
  4. C

    General Question regarding Access Queries

    I created a standard query with the following SQL SELECT tblStatusHS.StatusDt, tblStatusHS.StatusUpdateUser, tblStatusHS.DOCS_REVIEWED, tblStatusHS.DOCS_ERROR, tblStatusHS.StatusTx, tblStatusHS.Batch_ID FROM tblStatusHS GROUP BY tblStatusHS.StatusDt, tblStatusHS.StatusUpdateUser...
  5. C

    Help on RunTime Error '2427'

    I need to count the number of records in a subform once a selection is made from a combobox. If there’s no record present, I would like to record it as a 0. I’ve added Text22 in the subform’s footer as =NZ([CountOfBATCH_ID],”0”). When I try to run the code, I receive a “Run-time error...
  6. C

    Check Boxes Help

    I have a form with one combobox and several check boxes. When a user selects a certain value on the combobox, i would like for a messagebox to display if the user does not mark one or more of the check boxes. Here's my attempt but it still saved the record without displaying a messagebox...
  7. C

    Object Required Question.

    Please help. I'm trying to pull every 5th record for a record that has PS3 as a console. I would like to change the ConsoleCt of Console_ID 1 with a value from 1 to 5. When it hits 5, it will mark a flag as yes, return ConsoleCt to 1, and restart the process again. I get an object required...
  8. C

    IF statement help

    I have several consoles listed in a table. When the user selects either a PS3, XBOX, or WII, the NEWGEN checkbox will be automatically marked. I would like to use one IF statement instead of three separate ones. Thanks in advance. If txtCONSOLE.Text = "PS3", "XBOX", OR "WII" Then...
  9. C

    Navigation Buttons Help

    I'm using the same form to enter and browse records. I would like to make the navigation buttons invisible when user enters records and visible when users are browsing through them. Is there away to code this on the form? Thanks.
  10. C

    SQL statement help re: missing operator

    Please help with the following SQL statement below. When I try to run the statement, the error message, "Syntax error (missing operator ) in query expression "QC'd - Okay' WHERE [BATCH_ID]=9807', appears. I can't figure out what's missing or incorrect. Thanks. cboStatus.SetFocus strSQL...
  11. C

    autopopulate fields on FormB with data from FormA

    I would like to autopopulate and display data on some fields of FormB when the user presses btnAddRec on Form A. The data will be coming from FormA. I have added code below on the OnLoad event of FormB but it does not work. I only want these fields to be autopopulated when it's a new record...
  12. C

    Need help in storing data from SQL statement to a combobox

    I would like to populate cboAssigned with the UserFullName value taken from a SELECT statement. I'm trying to populate the combo box so only assigned records are filtered on a form when a user opens the database. Do I run the SQL statement first or can i just run it directly to the code. I'm...
  13. C

    ComboBox Help on a Form

    I've created a search form based on several unbound comboboxes. Two of them are cboTaskSearch and cboStatus. When the form opens, cboStatus is populated with all Status values and cboTaskSearch is populated with all Task values. When a user selects a value in the cboTaskSearch, the form will...
  14. C

    UPDATE SQL statement problem

    I need syntax help for an UPDATE statement. I'm trying to update StatusTx with the value listed on the CBOSTStatus and the StatusDt with the date/time the value was updated. It's producing a Run-time error '3144': Syntax error in UPDATE statement. I have listed the code below. I appreciate...
  15. C

    Date Issue for a report

    I have two unbound text boxes in a form called startdate and enddate. On form open, the two fields are populated with dates with the code below. Private Sub Form_Open(Cancel As Integer) Me.StartDAte.SetFocus Me.StartDAte.Text = Format$(Now - 7, "MM/DD/YYYY") Me.EndDate.SetFocus...
  16. C

    Coding Update SQL in an Event Procedure

    I'm trying to store the value from cboStatus to StatusTx and from txtChangeDate to StatusDt where StatusID is equal to Status ID. I've searched and was able to get this. I am not familiar with SQL or VBA. I appreciate any help I can get. Thanks. DoCmd.RunSQL "UPDATE tblTask SET...
  17. C

    2 Required Fields to Display 1 Message

    Hi. I have the following code below where after user makes a selection the code will check if the other necessary fields are filled in or not. Then, a message will be displayed if any or both required fields are not filled. I am able to do this with only one necessary field but unable to...
Back
Top Bottom