No announcements
Found 27523 threads
-
2 Votessuperviser
convert currency to textUnanswered | 4 Replies | 503 Views | Created by William Burns sr - Saturday, December 19, 2020 5:58 AM | Last reply by AccessVandal - Tuesday, December 22, 2020 9:46 AM
-
2 Votes
Custom Group Disappears
Hello: In the Navigation pane to the left of Access, I created a Custom Group. Then, after no longer needing it, I deleted the custom group. Now Access won't let me ...Answered | 3 Replies | 212 Views | Created by RichLocus - Monday, December 21, 2020 6:57 PM | Last reply by isladogs52 - Monday, December 21, 2020 10:14 PM -
2 Votes
Run a subrutine multiple time
I have a subroutine that adds a new boxID to a table. How can I run subroutine multiple times based on user input in lable box?. My code is: Private Sub ...Answered | 1 Replies | 220 Views | Created by Geir Arne Hansen - Monday, December 21, 2020 6:02 PM | Last reply by isladogs52 - Monday, December 21, 2020 6:55 PM -
3 Votes
Automate Compact and Repair of split back end database
So I have a database that's split. The front end is on the user's on the C Drive and the back end Access database is on the network I want to automate the ...Unanswered | 2 Replies | 400 Views | Created by General_Fear - Saturday, December 19, 2020 5:26 AM | Last reply by Daniel Pineault (MVP) - Saturday, December 19, 2020 2:41 PM -
2 Votes
Microsoft access
Hello, I am trying to get the value of a textbox in the MainForm in Microsoft Access to run the following Query, but the value of the textbox ...Proposed | 4 Replies | 541 Views | Created by Francis Sleibi - Friday, December 18, 2020 1:02 PM | Last reply by Albert D. Kallal - Friday, December 18, 2020 9:34 PM -
5 Votes
Connecting to remote Mysql - ODBC
We have an Access app using MYSQL as backend. We set up users in Mysql, and have a login form that connects and refreshes tables. 1st question: how would users reset password? ...Answered | 6 Replies | 334 Views | Created by donnyc - Friday, December 18, 2020 2:32 AM | Last reply by donnyc - Friday, December 18, 2020 9:31 PM -
2 Votes
Printing PDFs from a remote Printer
Hi All, I have an access program that prints PDFs perfectly on my default printer when in the office. The user wants to work at home and log into a remote machine that ...Unanswered | 4 Replies | 418 Views | Created by Kody_Devl - Tuesday, December 15, 2020 3:45 PM | Last reply by Kody_Devl - Wednesday, December 16, 2020 2:40 PM -
2 Votes
Access occurs errors since Office 2013 upgrade to Office 365
2046 error Application.SetOption "Built-In Toolbars Available", c_blnFALSE ...Answered | 6 Replies | 524 Views | Created by Sunshine1031 - Monday, December 14, 2020 6:13 AM | Last reply by Sunshine1031 - Wednesday, December 16, 2020 8:22 AM -
10 Votes
Retain position on continuous form through requery
I have a continuous form that, for reasons of efficiency, must use an underlying query that groups records and provides totals. Therefore, the underlying recordset is (correctly) not updateable. ...Answered | 16 Replies | 4363 Views | Created by Brian D. Hart - Tuesday, January 27, 2015 6:12 PM | Last reply by John Tsioumpris - Tuesday, December 15, 2020 11:35 AM -
0 Votes
Compile Error: User-defined type not defined despite referencing Word Object Library
Rerefences>Microsoft Word 16.0 Object Library). What else can i do to fix the error? Many thanks! -
0 Votes
Microsoft Office Spreadsheet 11.00
I am trying to confirm if Microsoft Office Spreadsheet 11.00 works in the most recent copies of Access? Microsoft Office Spreadsheet 11.00 was part of Office-2003-Office-Web-Components which was ...Unanswered | 1 Replies | 310 Views | Created by G man 7 - Tuesday, December 15, 2020 12:06 AM | Last reply by Tom van Stiphout (MVP) - Tuesday, December 15, 2020 1:25 AM -
1 Votes
Access 2010- Adding a new record programmatically
I am just starting to learn VBA and SQL. It is my desired goal to learn how to programmatically add a new record to a table using VBA code. I found the following partial sample code which at first ...Answered | 5 Replies | 75093 Views | Created by Steven Schuyler - Saturday, March 3, 2012 9:44 PM | Last reply by Hans Vogelaar MVP - Monday, December 14, 2020 4:58 PM -
0 Votes
Custom ribbon images disappear (Access 2010 - 2016) - upon pending Windows-Update???
Dear experts I noticed the rather annoying fact that in the Access (2010-2016, runtime and full version) Ribbon custom images sometimes disappear. The built-in ...Unanswered | 3 Replies | 602 Views | Created by papa_bear - Monday, July 9, 2018 10:00 AM | Last reply by WebCoolNo - Monday, December 14, 2020 3:25 PM -
1 Votes
Control Source for a field from two independent forms, possible?
Hi, I've been working on a form-based work-order documentation system, and I have run into a bit of a snag. I have set up a couple of forms that start from the ...Unanswered | 2 Replies | 327 Views | Created by NikS7 - Sunday, December 13, 2020 9:32 AM | Last reply by Imb-hb - Sunday, December 13, 2020 3:41 PM -
6 Votes
How To Add a Sequential Count in Access Query That Resets on Change of a Field
Hello: I need to generate sequence numbers in a query. To use a simple example, let's say I have a table with two fields: State, City I ...Answered | 5 Replies | 2279 Views | Created by RichLocus - Saturday, December 12, 2020 7:36 AM | Last reply by RichLocus - Saturday, December 12, 2020 7:54 PM -
1 Votes
Accessing a textbox on a different tab
Not sure how to explain this, but here goes, a picture tells a thousand words. This is what it looks like Samuel | bob | name3 | name4 ...Answered | 1 Replies | 326 Views | Created by goldeliz - Saturday, December 12, 2020 3:25 AM | Last reply by goldeliz - Saturday, December 12, 2020 4:50 AM -
0 Votes
Printing PDF from Access - Choose number of pages with vba
Hi All, I am using Access vba to print large numbers of PDF documents. I currently have two identical documents to print. 1 of the documents has 4 Pages 1 of the ...Unanswered | 7 Replies | 802 Views | Created by Kody_Devl - Tuesday, December 8, 2020 2:36 PM | Last reply by Kody_Devl - Friday, December 11, 2020 6:19 PM -
0 Votes
Microsoft Access
I have been using Microsoft for more years than I can remember and this is the first time that I have come up against a problem. I got updated the other day , I thought automatic updating was in ...Unanswered | 2 Replies | 956 Views | Created by eddiesherrard - Tuesday, November 26, 2019 4:57 PM | Last reply by isladogs52 - Friday, December 11, 2020 1:56 PM -
1 Votes
Sharepoint 365 - Access Database
Hi All, We recently moved one of our databases to be a Linked Microsoft SharePoint database in Access, so changes made in Access are sync'd to Sharepoint and ...Unanswered | 2 Replies | 952 Views | Created by Jono Leahy - Monday, December 7, 2020 2:01 AM | Last reply by Albert D. Kallal - Friday, December 11, 2020 12:51 AM -
0 Votes
Using a scanner in Access
Hi all, I am trying to use a scanner in the MS Access application. I have searched the web, but are unable to find what I am looking for. I want to add a button ...Answered | 3 Replies | 514 Views | Created by Deon SA - Wednesday, December 9, 2020 1:08 PM | Last reply by Gustav Brock - Thursday, December 10, 2020 9:24 AM
No announcements
