I am trying to create a basic data entry form, however, it is turning into more trouble than I anticipated.. I have the form created, now I am just trying to INSERT the data into the DB (TEST). I am receiving an “Object Required” error. Any suggestions? All of the txt boxes are verified to be correct. This is all
Tag: ms-access
SQL NOT EXIST returning duplicate value in query results
Hi Seem to be getting duplicates from this sql code it suppose to find records on BO Data that is not on Order Data by using the following as a key Keyorderstatus all my query results are on the Order Data already, How can a remedy this issue? Answer As @dfundako said – hard to check without data tables to
Access VBA update a column to concatenate
I was trying to update a column from a table in my Access database with following VBA code but it did not work as nothing happpened to that column. I would like to concatenate 5 columns into one. This update statement would work in SQL server but obviously not here. Any advice? Thanks. Answer Perhaps some fields are Null? Try
to use module in sql ms-Access-2010
I have defined a procedure in my module, returning the path of the database and I want to use that path in my sql query. Procedure in module : I am using the function above in my sql query : It is giving me the error: “error in from clause” but when I am using it in vba code ,
How can I select rows from database where column Name contains exactly 5 digits
I have a database with some count of rows. They contains information about books. And I need to select books with Name which contain EXACTLY 5 numbers. I tried to select by But result by this query returning books with names which contain more than 5 digits For example, I have some rows (Names of books): To Kill a Mockingbird
Not possible to use HAVING clause in transform sql statement?
Is it possible to use the HAVING clause with the transform statement in MS Access 2010? I keep getting “Syntax error in transform statement” My sql is I tried testing the select statement by itself and it works fine Is what I’m trying to do not supported by access? Answer Indeed, Having is not available when executing a Pivot. A
How can I restrict access to sensitive columns in Apache Drill view based on user permissions in another view?
Background: I have users connect to Apache Drill with Kerberos authentication to read from a Parquet file so basically a single table with multiple columns. Some of the columns in that file are known to be sensitive and only certain users can see them. Apart from the data table Drill has access to another table with information who has access
What does the following SQL query do?
The drawing logs at that the company I work for use are written in MS Access VBA. The original code was written 15+ years ago by someone else, and we’re now running into errors with the reporting functionality that we can’t find a solution for. The query I’m having an issue with is the following: Does anyone know what the
Return sums even if no data exist in given day
I have a table with amounts only on some days, e.g.: How can I query the data and get: I tried like: But still it doesn’t return 0s for days without data, any ideas? Answer In Access, you can create a series of dates between the first and the last date, and then create an outer join to your summed
SQL Insert Into New Table from Old Table
I’ve got two table which are near identical, the only difference is the newer one has different field names. Basically the old table was outdated and needed to be re-worked; I’m trying to extract all the field where the VendorNumber = Vendor_ID all the field that are being copied to are guaranteed empty. The below SQL code if very large,