I want to simply update a date column within a table where a status exists. Here’s what I have I have tried the following Nothing has gone through, no errors, just not updating. I can update the field manually. Answer Answers were correct, silly issue about the Trust Center ‘enable’ bar not showing, therefore…
Tag: ms-access
Error Using the iif statement in MS access
The completion_metric field from this query I made in MS ACCESS keeps giving me zero percent for all the records. I think something is wrong with my IIF statement. Also, how would can I populate a text box on a ms access form with this query. For text-boxes there seems to not be an option to let my record sou…
Insert Query only inserting the first value?
I looked around quite a bit figuring someone else must have had this issue, but I didn’t see it. It’s driving me nuts, that something so simple isn’t working and I can’t figure out why, and so I’ve spent 3 hours now on something that should have taken a couple minutes… So h…
Is there a way to SELECT a database table using a variable?
I tried this statement: string query = “SELECT question FROM ‘” + GlobalVariables.dbQCode + “‘ WHERE [question_code] = ‘” + GlobalVariables.questionCode + “‘ “; and when I run the code it is giving me an exception: Syntax error in query. Incomplete q…
Import an Excel Sheet with File Dialog in Access
I have a splitform where I want a button to choose and import a file into a table. I have something like this: I set the reference to Microsoft Office 16.0 Object Library. When I tried using this button there was this error: Method ‘FileDialog’ of object ‘_Application’ failed. Answer I…
Alter Table Auto Increment starting number criteria from another query or field
I have a database that stores all our distribution partner sales. Every week I get updated sales that I load into what I call tblImport. I then have some queries I run that parse out new sales lines to tblUpdate and tblNewAccounts. What I am struggling with is automating what I call the Bill To ID(BT_ID) fiel…
Query to Return Records with Consecutive Dates by Group in Access 2016
I have a table with a date and an ID field. An extract is set out below. I would like to run a query to return all records where the same ID appears on consecutive dates. There may be no consecutive dates or two or more consecutive dates. Here is the extract: Date No_ID 09/06/2021 24694000 09/06/2021 20102886…
MS Access query requires a Parameter to be enter by the user if I have combined custom columns and have a criteria in that column
In the following query everything works well But if I want to add a criteria to column gtotal Access will ask for parameter values for copy1, copy2, and copy3. Why does the search criteria trigger the parameter requests? I get no request without the criteria and total shows the expected values. Answer Prompts…
MS Access SQL query – Count records until value is met
I have an Access query (qr1) that returns the following data: dateField stringField1 stringField2 booleanField 11/09/20 17:15 John Nick 0 12/09/20 17:00 John Mary -1 13/09/20 17:30 Ann John 0 13/09/20 19:30 Kate Alan 0 19/09/20 19:30 Ann Missy 0 20/09/20 17:15 Jim George 0 20/09/20 19:30 John Nick 0 27/09/20 …
How to terminate SQL statements when using DEFAULT value and OleDB?
Using C# and the JET OleDB driver (Microsoft.Jet.OLEDB.4.0) to connect to an old Access database (think Access 97). The following SQL statements work fine: But terminating the statement with a semi-colon (;) causes problems: Can SQL statements with DEFAULT be terminated? Answer Default values can (and probabl…