Recent content by CBG2112

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

It somewhat worked. Now it's showing an error message. "Run-time error '3061': Too few parameters. Expected 1." Dim sst As DAO.Recordset Set sst = CurrentDb.OpenRecordset("SELECT * " & _ "FROM tblTask " & _ "WHERE tblTask.AddDt...

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" & _...

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

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

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

I hadthe validation code on the click event of the button. I changed it to the before_update event of the form but it still goes to the confirmation messagebox. I'm wondering if the logic to the validation code is incorrect. cboStat.SetFocus If cboStat.Text = "" Then MsgBox...

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

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

I tried using the code you listed but it gives me a syntax error. Your suggestion regarding the .TEXT and .VALUE is very helpful.Thanks!

Thanks. It worked.

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

I'm speaking about the native nav buttons. I tried coding it using the visible property but it won't let me.

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.

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