Ms-access Questions

I've got an ms-access application that's accessing and ms-sql db through an odbc connection. i'm trying to force my users to update the data

I am attempting to save an rtf file using filedialog and would like to filter using a where clause. this is what i have: set

I have a problem in a query in acess 2003 (sp3). i have a query that includes some tables and a sub query. the sub query and tables are

I am running a query in access database that should aggregate information based on year, month, and type. i set it up so that for the month, it

I have a accessdb macro i want to run from the windows task scheduler which requires access to the mapped network drives of the user running the

I haven't messed with vba much before, or access or sql. but i have a little... and i'm working on a project. so, the goal here is to enter a

I want to export tables from an access database to .txt-files. here is my code: library(rdcomclient) #path of txt file

I have a table in my db that has 2 bit fields, one called active and one called public..for all records active

I have a webpage with a few textboxes; and an access database with columns that contain numeric data, dates and user id's. i need help to

Im creating a stored procedure on an 2008 sql server. i cant find how to retrieve the creation date of a given table in ms access using

I'm trying to retrieve the @@identity value from an access database after i add a row to it. however, instead of using hard coded connections, i'm

Using asp.net as programming language on iis server. the database is access and i connect to the database using odbc. when i fill some

Two users wanted to share the same database, originally written in ms access, without conflicting with one another over a single mdb file.

I have a database in access. the database has 4 tables: [department],

I am working in an ms-access 2010 environment. i have two strings of numbers. i need to compare them and find the missing numbers in list 2. these

What's the best method of displaying report data in a chart format in an access 2003 adp project? i know this can be done in normal mdbs but this

I am very new to c#, and i ran into some issues when i try to perform a sql query with stringbuilder. here is part of the table named :

The problem: we use a program written by our biggest customer to receive orders, book tranports and do other order-related stuff. we

I am working from my previous thread

I don't know what i am doing wrong here. i am trying to call class1.cs in main class, sql command parameter, but i getting the error. i am working

I want to connect python to ms-access but can't install new software (programs/drivers) and don't have admin rights as i'm working on a company

Here is my vba code, which tries to loop through all the tables which contains pb (pb is the first two letters of all of the tables)

I am currently making a case tracker within ms access and cannot get the below update code that is located in a subform to work. i've

I've been getting an error that i've never seen before. i keep seeing this: run-time error '3048': cannot open any more

I've installed sql-alchemy access so that i'm able to use pandas and pyodbc to query my access db's. the issue is, it's incredibly slow

Currently i have these divs using mdb <div class="row" style="margin-top: 8em;"> <div

Example table, turn this custid custname

I'm trying to run sql query with like operator through python to find any values that have "test" in any position. the problem seems to be with

Why do these queries give different results? reference is a single character column and i would expect to have a result giving counts for upper

This is for example what i have(this is the result of a select query from different tables by different conditions let's call it select x) :

I have an access database for which i am the only user. it's the first database i've built. it has 16 related tables, around 40 select queries,

I am creating a database in access 2013 for a library that has multiple copies of different books. i want to create a combo box/lookup list that

I have an access database connected to my code via a connection string as shown: connection = new

I am coding an access database as a workshop project. i am using a form to introduce data in a table but i have a little problem. i have two

So i have two tables i need to join for a client. these tables only share 1 field in common (color, and it isn't a unique key ident). is is

I am facing this error when i try to insert a data row in to table in ms access file. datatable is table i got using select *

I'm making a homework/revision program for my coursework. i'm following this tutorial

This may seem like an ignorant issue, but i am inexperienced with access. this is for a school project. i am in a group of 5 people who are all

I have access from with 3 input fields and "ok" button. when i press this button current form closes with save set to yes. and report opens. in

I'm new to flutter and want to add a drop down list similar to an access combo box, with a text field you can type in which will display a list of

My question is in relation to connecting a vb.net project to an access db. must i have a primary key in my table, or have is there a way to alter

I've been trying to fix this all day and finally figured i can't engineer my way out of this problem :) so, from memory looping through

I'm currently making a report on microsoft access 2013. i've created a query first and then selected the appropriate tables and fields.

My database in microsoft access looks like this:

So i am using xtragrid component from devexpress, set up the connection, the preview (in design tome) actually shows the content of my database

I'm working on a spec for a piece of software for my company and as part of the auditing system i think it would be neat if there was a way to

This is my query : select reference.quote_date as date, customer.name as name , customer.surname as surname,

This request is based in ms access vba. i would like to know what the most efficient way is, to see if an item exists in a listbox control.

Beginner's question here... i have a table of tree measurements being 3 fields: - id, diameter_1, diameter_2 & i wish to get to these 3

Im working on a query where if the records in a table are from the current year, i need only to select records whose day and month are equal or

I'm developing a uwp application and want to read a mdb file to convert this database to a sqlite database. i read that i could use

I'm trying to connect to my ms access database, but for some reason it's not connecting. it's giving me an error, "data source name not found and

I'm trying to create a database with a anysql maestro script. i have the following code: create table klant ( klantnr integer,

Here is full code at the moment what i have done. so basically i'm creating a datatable, then i'm connecting my

I was wondering if there is a better way to cope with ms-access' inability to handle null for boolean-values other than change the

Beginner at access, so sorry if this is a question that has been asked before (i've searched for ages, so maybe im searching for the wrong

I would like to be able to edit data in a datagrid and the changes i make to be saved back to the database from where i take them. my grid

I am trying to extract data in a tabular format with different values for part-time and full-time, to get an output like this:

This problem is taking too long to solve on my own, so i hope someone can help me. i have a simple ms access database: two tables

Is there a way to bulk upload data into fields in existing records in access? for example, i have a table containing records of customer data. i

I am creating a table query where it have different values in every column but when i try to execute its showing me same values in partime jobs

I've been trying to write to a database and save to the file but i cant get it to work, can't tell why either. the error i get is:

I have a table with over 3 million records and some fields. which looks like this:

I have a multi-column combobox on an access form (access 2019 x64, if that matters) and would like to use its additem() method to

Imported a table (i dev) from ms excel, trying to update an ms access table (pla hist). the tables have identical id columns. i keep getting error

I am working for a client who had a website developed and doesn't want the backend changing. unfortunately he is on windows and used an mdb

I have created an application that uses a microsoft access database, which i am having some issues with and so want to migrate to microsoft sql

I am trying to create either a table or a query that contains all the records from table1, but deletes or excludes all the records that also exist

I am not good in sql raw queries. please help to get min max value grouped by the user_id. scenario is: table has

I want python to display data from access by select (sql) but there is an error. the data and database are existed. what is a problem?

I converted a pdf file to an access one. all of the info got put in one field. i need them in 6 different fields. how can i move them all easily?

I am adding some new features to a ms access db for a client. the original db has several queries. the new features that i need to add require

What i have i have a query called qryflightprices. i have a form which is based on this query called

I have a table in ms access where the email field is updated often. using macros, i am able to determine when the entire record is edited.

I have an ms access database which contains a table1 and that table has a column date/time picker (format is short).

I want to retrieve data from two tables 1st table is exp_head which contains exp_id and

I currently have a ms access database of members. i have a form that has a combo box which is populated with just the first and last names

I have an access database table which sometimes contains duplicate profileids. i would like to create a query that excludes one (or more, if

I make two table one is exp_detail and 2nd is exp_head. exp_detail table

Here is ms access database, it contains

I am trying to create a chart that when, at the push of a button displays a chart that shows the user the number of times a record has appeared in

I've three table product - id_product up - id_product - up_sum down - id_product -

I'm using powershell to close access database, download updated access front end to local machines, update

Is there a quick way to duplicate the effect of the count(distinct [f]) in ms access? for example: data table for a single

I have a form with 10 columns, and for 5 of them (project_phase, contract, design_dpm, amm/ucc, 1_or_2 stat) i want to add connected drop list

A client gave me a front end of a ms access database to do some work on. i am now attempting to reconnect it to the back-end on her computer. when

I would like to know how to get the time needed by the insert query in a msaccess database.

I'm hoping someone can point me in the right direction here and hoping i explain this clearly enough. i'm getting undesirable results with my

My code works. after i copy about 10 tables i get an error. dynamic sql generation for the deletecommand is not supported against a

I'm at a client doing some quick fixes to their access application. it was a while i had a go with access, but i'm recovering quickly. however,

Here's my problem: i have an sql query that makes 4 calls to a lookup table to return their values from a list of combinations in another table. i

I have a database in iso-8859-2 format, but i need to create xml in utf-8. this means that i must encode the database before prinitng in utf-8. i

I need to write code that picks up pgp-encrypted files from an ftp location and processes them. the files will be encrypted with my public key

How do i determine whether an object is a member of a collection in vba? specifically, i need to find out whether a table definition is a

When i click the button, only my first query gets executed. the second one insert into afspraken (behandeling) doesn't execute.

I've seen a number threads / forums with examples of progress bars in access databases which unfortunately hasn't resolved my issue. i

I have this code that will save only the top row of the datagridview, can someone help me to modify this code so that it will save all the row in

I have a database project at my school and i am almost finished. the only thing that i need is average movies per day. i have a watchhistory where

I have a database with four tables: table 1, 2, 3, & 4. each table holds the following fields: id (autonumber), date (date/time), name (text),