No announcements
-
0 Votes
Can't delete new record in MS Access
Hi guys, I've recently just linked MS SQL Express with MS Access. So, everything works just fine when I add a new record. However, when I try to delete a newly inserted record I get the message ...Unanswered | 2 Replies | 321 Views | Created by N1ck810 - Wednesday, December 11, 2019 4:01 PM | Last reply by Lawrence Ellefson - 2 hours 16 minutes ago -
0 Votes
Reserved Error (-3004)
I am getting this message when trying to open a datasheet with a sub datasheet in my Access 2013 database. The relationship is one-to-one: Reserved Error (-3004); there is no ...Unanswered | 4 Replies | 639 Views | Created by APat1 - Monday, June 27, 2016 2:24 PM | Last reply by George Loudaros - 6 hours 36 minutes ago -
0 Votes
ODBC Timeout property doesn't impact how long it takes for a query to timeout
Per docs and postings the ODBC Timeout property is supposed to define the number of seconds before an query's odbc connection attempt is ended. But I've experimented and find that it has no impact ...Unanswered | 2 Replies | 128 Views | Created by lexxicon - Thursday, December 12, 2019 5:07 AM | Last reply by ridders1952 - 21 hours 31 minutes ago -
1 Votes
How to go around the error 3073 (operation must use an updatable query)
Hello all, I need to update 2 fields from one table with 2 diferent sums of fields of another table. The tables are linked on a one-to-many relationship and the update tries to work ...Unanswered | 1 Replies | 67 Views | Created by nabucox - Friday, December 13, 2019 11:17 AM | Last reply by Hans Vogelaar MVP - Friday, December 13, 2019 1:19 PM -
2 Votes
The Microsoft Access database engine could not find the object ''. Make sure the object exists and that you spell its name and the path name correctly. If '' is not a local object, check your network connection or contact the server administrator.
Hi , I am trying to access the excel from sharing drive and having permission. But i am getting below this error: The Microsoft Access ...Answered | 16 Replies | 89383 Views | Created by am Looser - Saturday, April 21, 2012 8:39 AM | Last reply by I might have found the solution - Friday, December 13, 2019 3:26 AM -
0 Votes
The Navigation Pannel barely wide enough to show first 2 chars of names of table or other Access object CANNOT MAKE WIDER.
Mark JAnswered | 10 Replies | 492 Views | Created by PuzzledByWord - Sunday, December 1, 2019 12:25 PM | Last reply by PuzzledByWord - Friday, December 13, 2019 12:50 AM -
0 Votes
Creating Queries to Modify Data into a Plottable Form
I've broken this post into 3 parts due to character limit. Hello, I’m trying to figure out how to organize data from lab results so that the table ...Unanswered | 17 Replies | 1004 Views | Created by TommyLynch - Wednesday, November 27, 2019 11:35 PM | Last reply by Ken Sheridan - Friday, December 13, 2019 12:15 AM -
1 Votes
Run Time Error 3043 Network access interrupted
2012 R2, Dell PowerEdge, Windows 10, 1903 PCs, Access 2016 front ends local on PCs, back ends on server Small network with 4 - 6 active Access users Errors ...Unanswered | 21 Replies | 1159 Views | Created by BVitter - Saturday, August 31, 2019 9:22 PM | Last reply by BVitter - Thursday, December 12, 2019 11:01 PM -
1 Votes
Downloading Runtime question
When they ask you to make a choice from these 2 downloads is this the Access 32 or 64 bit, or the operating System Thanks for any ...Unanswered | 2 Replies | 124 Views | Created by TurnipOrange - Wednesday, December 11, 2019 11:45 PM | Last reply by Albert D. Kallal - Thursday, December 12, 2019 10:48 PM -
1 Votes
Access front - SQL back wrong date format issue
Hello everyone ! So i'll try to be as clear as possible concerning my issue. Recently I was asked to transform an Access Backend into a SQL Backend. The Frontend ...Proposed | 3 Replies | 132 Views | Created by Lucas Réveil - Wednesday, December 11, 2019 3:37 PM | Last reply by Albert D. Kallal - Thursday, December 12, 2019 10:13 PM -
0 Votes
output to action was cancelled
I have recently started getting the "output to action was cancelled" error frequently, but not consistently with my code. The module generates Access reports as a pdf file ... -
0 Votes
Checking for consecutive values
Hi I have a table of StaffIDs and WeekNumbers; for weeks of year that a staff has worked. How can I get a list staff who have 12 consecutive week numbers, to show ...Answered | 1 Replies | 84 Views | Created by Y a h y a - Thursday, December 12, 2019 4:29 PM | Last reply by Bruce Hulsey - Thursday, December 12, 2019 5:32 PM -
2 Votes
VBA to update SQL in all db queries
Hi All, I'm looking to generate a simple procedure in access that would iterate through all queries search for a specific piece in the script and replace it according to the ...Answered | 5 Replies | 150 Views | Created by Vaokt - Wednesday, December 11, 2019 3:17 PM | Last reply by Vaokt - Thursday, December 12, 2019 10:49 AM -
15 Votes
How To Import Into A Table with Multi-Value Fields
Hello: I have a table with a multi-value field that contains states in which a company does business. It is multi-value because there can be more than one state. I tried ...Answered | 24 Replies | 19444 Views | Created by RichLocus - Thursday, June 17, 2010 5:15 PM | Last reply by ridders1952 - Thursday, December 12, 2019 9:44 AM -
0 Votes
ODBC reset on Windows 10 PRO
The server PC OS is Windows 10 PRO and the client PC OS is Windows 10 PRO. Currently, 32-bit ODBC Microsoft Access Driver (*.mdb) driver is used to ... -
1 Votes
Macro to execute Linked Table Manager -> Refresh
Is There anyway to make a macro (like Excel) to mimic the key strokes to bring up the "Linked Table Manager" to "Select" to "Refresh" option in ...Unanswered | 1 Replies | 90 Views | Created by MikeChicago - Wednesday, December 11, 2019 9:25 PM | Last reply by Tom van Stiphout (MVP) - Thursday, December 12, 2019 2:45 AM -
2 Votes
ACCDE won't run any VBA
I have an Access 2010 accdb that works quite well. It runs VBA on opening via an autoexec macro and the form it opens to has simple code that checks the current username to determine permission levels ...Unanswered | 15 Replies | 1421 Views | Created by Chad McColm - Thursday, January 19, 2017 7:12 PM | Last reply by Daniel Pineault (MVP) - Wednesday, December 11, 2019 9:28 PM -
0 Votes
Setting Bi-Monthly Dates based on current date
I have a report that needs to run bi-monthly and I'd like to default the start and end date based on todays date. If todays date is between the 1st and the 15th, then the start and ...Unanswered | 2 Replies | 124 Views | Created by JHarding08 - Wednesday, December 11, 2019 7:08 PM | Last reply by Imb-hb - Wednesday, December 11, 2019 9:27 PM -
0 Votes
Refreshlink AWS
I have an Access table that is linked to a AWS table. I didn't set this up, the consultant who did is gone. I need to Refreshlink the table on a Form load. I can run the code below to RefreeshLink on ... -
0 Votes
Updating via subform
I have a Customer Form which has two subforms - Salesperson and Division. It follows the structure: Customer ...Answered | 1 Replies | 149 Views | Created by JHarding08 - Wednesday, December 11, 2019 3:58 AM | Last reply by Hans Vogelaar MVP - Wednesday, December 11, 2019 12:12 PM - Items 1 to 20 of 26931 Next ›
No announcements