Search results

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

You're right. I had to put the SQL statement in the GotFocus property of cboStatus. Thanks. Private Sub cboStatus_GotFocus() If IsNull(Me!cboTaskSearch) Or Len(Me!cboTaskSearch) = 0 Then cboStatus.RowSource = "SELECT StatusDescTx " & _ "FROM tblTaskStatusTypes "...

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

Thanks! It worked.

The form has the functionality to filter the records through several combo boxes. One of them is cboAssigned which lists all the users for the database by full name. I use the function fOSUserName to check if the user has access to the database. I want to take the fOSUserName, individual's...

The solution you presented worked in storing the value to the combo box but I actually wanted a different result. I want the data taken from the SQL statement to be the value selected in the combo box. I hope this makes sense. Thanks for the help.