Access Development

4 answers

Could Not Use Database; File Already in Use

I have an Access Database that I created with Access 2016 on my home computer no one has the file open and it is stored locally on C:\Users\username\Documents Folder. No matter what i do i cannot compact and repair without getting this message…

asked

Stan Lightell 1

answered

DBG 2,301

1 answer

Set email from Access when not signed in

Windows 10 Access 2016 Access database opened as a scheduled task to determine if a backend SQL database is running If I get an error message on trying to open a table I want to send an email message The code works in I am signed in to the PC but…

asked

Bob Vitter 181

accepted

Bob Vitter 181

0 answers

Can I get the location of each objects in RTF file ?

Hi, I need to extract all the objects from .rtf file, .rtf file may contain text, images, arbitrary shapes like rectangles, lines etc. Along with objects I need the respective information i.e. for text I need font size font color font style font family…

asked

Shivanand Pandey 1

5 answers

Query/Report Generation

Hello, I have two tables tblA and tblB that contain a common field called WO. WO is not unique and can have multiple repeats occurrences in each table. In tblB there is also a field (QTY) that I would like to sum based on equal WO values in tblA and…

asked

Randal Flinn 311

answered

DBG 2,301

1 answer

Access Report to Multiple PDFs based on Field Data Changes

I'm trying to automate a PDF report in Access so that it splits itself in to multiple pdf files based on one data field. I've never used VBA and extremely new to Access, so this has been fun! Important Info Database: 2021_S3_DS Field Name:…

asked

kcamp_17 1

answered

DBG 2,301

9 answers

MSAccess vba dsnless connection to sql server; password issues

I am trying to create a DNSless connection to an SQL server we host that is managed by someone else. I want to be able to create an accde front end so others on the network can run reports I’ve designed in modules I’ve created in vba, from data on said…

asked

Connie S 21

accepted

Connie S 21

1 answer

Error: Could not find installable ISAM

I have a software in Access that is microsoft 365. I want to open a table in another Access database and show some of information of this table in my form. I want to use ADO. But when I execute my code, I get the error: Could not find installable…

asked

Amir 181

answered

Tom van Stiphout 1,701 MVP

3 answers

Query Multiple Tables - Sort on Multiple Table Fields

Hi all OK, I know the data structure I am about to describe probably breaks all the rules of logic and normality, but this is a data retrieval operation only. The situation is that I will have five queries, each possibly returning info from different…

asked

Phil S 261

commented

DBG 2,301

1 answer

Handling meeting bookings in Access

I want to set up a simple meeting booking application in Access. There are multiple people who can be booked The slots have a defined duration of 30 mins Each person has a schedule (days of week and times of day) A person once booked for a…

asked

Pankaj S 1

answered

DBG 2,301

0 answers

Unable to set Duplex mode in VBA

The following code does not set the printer to duplex but is does change color mode to B&W DoCmd.OpenReport Report_Name, acViewDesign, , , acHidden With Reports(Report_Name).Printer .Orientation = acPRORPortrait .ColorMode = acPRCMMonochrome …

asked

Bob Vitter 181

1 answer

Import FoxPro 6 Data to Access

Hi all I have been tasked with recovering a FoxPro database and hoped to pull the table data/structure into Access. The table data from FoxPro is in the form of individual DBF files for each table. The Access import feature lists three DBF file…

asked

Phil S 261

accepted

Phil S 261

1 answer

Is This Even Parse-able?

Hi All I have inherited an old FoxPro database which stores the Parts List for engineering drawings as a long text string. Some elements of the string are plain text, defining e. g. item number and quantity, other elements are primary key entries for…

asked

Phil S 261

accepted

Phil S 261

1 answer

ODBC Error - The Configuration Process failed

I'm unable to create a new System DSN entry / ODBC 64 bit Using a MS Azure VM server Error "The configuration process failed". When you cancel another message says "Drivers ConfigDSN, ConfigDriver, or ConfigTranslator failed. …

asked

antz_h 1

commented

Cris Zhan-MSFT 6,616

2 answers

How to link multiple forms to a single form

i've posted this same issue on this website www.accessforums.net/showthread.php?t=83680 I want to link 6 forms to a single form calling an especific form with a button based on an option selected on a combobox with this code Private Sub…

asked

cesarced 1

commented

cesarced 1

4 answers

Issue to ACE.OLEDB

Hi, For issue below [InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.] Is this a version issue and server machine must be with 32-bit version of Microsoft.ACE.OLEDB.12.0?

asked

Peter_1985 2,586

commented

Timon Yang-MSFT 9,586

1 answer

Access 2016 how to register a list box in one form and show it on another form

I have two forms, one is used to record data in the table and the other is used to query. I need to put 21 data on the registration form that are requirements of each registration, some registrations need only 7 of those requirements, other 3…

asked

cesarced 1

commented

cesarced 1

10 answers

Microsoft Access - Hyperlink Error

I am using Microsoft Office Professional Plus 2016. Recently from my Form in Access - my Hyperlinks stopped working - and I get the error "The site reports that the request is not valid." on every one of them. These links have worked for…

asked

Edward Carr 1

answered

DBG 2,301

2 answers

Sum value in query

I have a table containing records of transactions: Account Date Amount 12345 1/1/21 $100.00 12345 1/2/21 $100.00 99999 1/2/21 $100.00 12345 1/3/21 $100.00 I'd like to be able to create a query that sums the total…

asked

Ken Ravazzolo 21

commented

DBG 2,301

1 answer

Open another access database from the current database and user their data

I have an Access program that is as FE and the BE is SQL database. In startup of the program and for getting information for relinking Access tables to SQL, I want to open another access database in my PC that has some information of the server. How can…

asked

Amir 181

accepted

Amir 181

2 answers

How to send live message and notification to all the Access Database logged on users.

Hi, Guys, Please help. I've built the Access database which 40 staff are working together in a same network. when it comes to updating the source file, I have to call them and ask them to close the Front end ever single time and when ever I have to…

asked

Elise 131

accepted

Elise 131

Filter

Content

859 questions with Access Development tags

Could Not Use Database; File Already in Use

Set email from Access when not signed in

Can I get the location of each objects in RTF file ?

Query/Report Generation

Access Report to Multiple PDFs based on Field Data Changes

MSAccess vba dsnless connection to sql server; password issues

Error: Could not find installable ISAM

Query Multiple Tables - Sort on Multiple Table Fields

Handling meeting bookings in Access

Unable to set Duplex mode in VBA

Import FoxPro 6 Data to Access

Is This Even Parse-able?

ODBC Error - The Configuration Process failed

How to link multiple forms to a single form

Issue to ACE.OLEDB

Access 2016 how to register a list box in one form and show it on another form

Microsoft Access - Hyperlink Error

Sum value in query

Open another access database from the current database and user their data

How to send live message and notification to all the Access Database logged on users.