No announcements
-
4 VotesVBA function for checking email syntax validity
Is there any VBA function available for checking the syntax validity for email ? If you have, appreciate you can share with me. Thank you. TS LimAnswered | 13 Replies | 17831 Views | Created by TS Lim - Tuesday, August 30, 2011 2:00 AM | Last reply by Hector Bohorquez - 30 minutes ago
-
0 Votes
File folder to collect paths for all selected files from folder
Is possible to use a file folder to place all the file locations of the files selected into a table. For instance, say I have a table called Documents with lists the name and file location of ...Unanswered | 2 Replies | 45 Views | Created by NoviceVBAuser1775 - Monday, January 27, 2020 9:36 PM | Last reply by NoviceVBAuser1775 - 36 minutes ago -
0 Votes
ADD EXISTING EXCEL SPREADSHEET TO OUTOOK MESSAGE AS ATTACHMENT.
I am using Access to create shipping documents to send to customers via Outlook when an order ships. I am already using the OutputReport feature to create a .pdf for product specification ... -
0 Votes
count number of unique text strings per group
I have hundreds of different military installations and I'm trying to build a query that will tell me how many squadrons are at each installation.Unanswered | 1 Replies | 13 Views | Created by sscott007 - 51 minutes ago | Last reply by Daniel Pineault (MVP) - 42 minutes ago -
0 Votes
Access 2010 - Docmd.transfertext - Remove space characters on start/end of the string
Hi I use for uploading a csv file this method DoCmd.TransferText transferType:=acImportDelim, ...Unanswered | 3 Replies | 73 Views | Created by technet65 - Tuesday, January 28, 2020 1:14 PM | Last reply by technet65 - 18 hours 50 minutes ago -
20 Votes
VBA doesn't work in accde but does in accdb
Greetings, I have vba code that works in my accdb but does not work in my accde. I have: 1. compacted and repaired 2. decompiled 3. ...Proposed | 16 Replies | 11662 Views | Created by Liz Ravenwood - Wednesday, April 18, 2012 9:19 PM | Last reply by P3k88 - 22 hours 49 minutes ago -
0 Votes
create a powerpoint chart from Access data
Hi all, I am new at Powerpoint automation. I need to create a presentation from within Access 2013. I managed to create the full presentation with the help of the ...Unanswered | 1 Replies | 37 Views | Created by Deon SA - Tuesday, January 28, 2020 11:49 AM | Last reply by Daniel Pineault (MVP) - Tuesday, January 28, 2020 1:59 PM -
1 Votes
Create SIE file from Access
Hi, I have a table from which I want to export the content and create a SIE file. Anyone having an idea on how to do ...Answered | 5 Replies | 472 Views | Created by Spikemannen - Wednesday, March 23, 2016 10:44 PM | Last reply by ForssPeterNova - Tuesday, January 28, 2020 9:13 AM -
3 Votes
How to stop, or change a "/" in a Field later used as a part of a file name?
Hi I have table with a Field "Customer" (datatype ShortText) Content of that Field will later be used when saving a file with the Customers ...Answered | 6 Replies | 81 Views | Created by ForssPeterNova - Monday, January 27, 2020 4:49 PM | Last reply by ForssPeterNova - Tuesday, January 28, 2020 5:58 AM -
0 Votes
How to Auto Resize Access Forms to Resolution on different monitors?
Hi Everyone! I have developed a database successfully. I run it on my system resolution is 1600 * 900, works fine in full screen. but i tried ...Unanswered | 3 Replies | 77 Views | Created by Ghulam Murtaza Kumbhar - Monday, January 27, 2020 1:20 PM | Last reply by isladogs52 - Monday, January 27, 2020 7:21 PM -
1 Votes
Double UNION query issue
0A specific value that exists in the table Accordingly, my combobox has a record source that is a query -- This works: SELECT "NONE" AS ...Unanswered | 3 Replies | 122 Views | Created by Kevin_R_M - Friday, January 24, 2020 9:48 PM | Last reply by Kevin_R_M - Monday, January 27, 2020 3:50 PM -
0 Votes
Run-time Error '-2147024770 (8007007e)': Automation Error The Specified module could not be found vba
I have an access application which runs just fine on one of the term server(remote server 1), but, when I run the same app on diff term server(reomte server 2) it gives me a message ...Unanswered | 2 Replies | 102 Views | Created by sneet7 - Sunday, January 26, 2020 7:04 PM | Last reply by Daniel Pineault (MVP) - Sunday, January 26, 2020 10:57 PM -
0 Votes
MS-Access Database, Forms and report generating
I am a beginner and new to this forum, need help to create form and report. My task is to create database with forms and reports, where, we open New Jobs and ...Unanswered | 1 Replies | 119 Views | Created by AbdulSamadKhan - Friday, January 24, 2020 9:00 AM | Last reply by Lawrence Ellefson - Saturday, January 25, 2020 4:14 PM -
3 Votes
Can MS Access link a PRN file?
New Data Source -> From File -> Text File) OR a similar function to establish link to .PRN files?Unanswered | 3 Replies | 139 Views | Created by CiceroBC - Wednesday, January 22, 2020 2:27 PM | Last reply by Ken Sheridan - Saturday, January 25, 2020 2:11 PM -
0 Votes
MS Access SQL Format function not rendering correctly
Hi Folks - I have the following MS Access SQL query: SELECT DISTINCT 'Changeprop' AS [PARAM1] ,'TREX-WorkingVersion' AS ...Answered | 2 Replies | 85 Views | Created by cdtakacs1 - Friday, January 24, 2020 10:02 PM | Last reply by cdtakacs1 - Saturday, January 25, 2020 1:44 AM -
0 Votes
Editing Textboxes in a for loop, code only edits the last box in the loop. Using windows form.
so my code goes as followed for(int i = 0; i < NumberOfTimers; i++) { ...Unanswered | 2 Replies | 100 Views | Created by Septic Feast - Thursday, January 23, 2020 10:53 PM | Last reply by Septic Feast - Thursday, January 23, 2020 11:54 PM -
0 Votes
how to fill table field with data from Unbound Form?
so I have been making a production and manufacturing database in Access, which has a table that registers invoice documents and has attached a subform where you pick the articles you are ...Proposed | 5 Replies | 546 Views | Created by assasing123 - Wednesday, September 28, 2016 6:42 PM | Last reply by Lawrence Ellefson - Thursday, January 23, 2020 10:21 PM -
0 Votes
Copy Records from one Table to another.
I've recently been put in charge of creating a small database at work. I have two tables, one that is used to list items that need to be reviewed by a supervisor, and one to collect the approved ...Answered | 5 Replies | 29005 Views | Created by Danton Wiles - Monday, October 29, 2012 7:03 PM | Last reply by Ken Sheridan - Thursday, January 23, 2020 6:11 PM -
0 Votes
IDENTYTY_INSERT is set to OFF. (ERR #544)
I have an application made in Microsoft Access and data on MS SQL Server connected with ODBC. Since MS Office updateed on build 12325.20288 I receive ...Unanswered | 2 Replies | 81 Views | Created by DagF - Thursday, January 23, 2020 1:13 PM | Last reply by Karl Donaubauer - Thursday, January 23, 2020 1:26 PM -
3 Votes
The 1912 update to Access 2016/2019/365 breaks the way linked SQL Server tables with identity columns are attached
Repro 1. Create a table with an identity primary key in SQL Server, e.g. CREATE TABLE identitytest (id int ...Answered | 10 Replies | 639 Views | Created by Heinzi.at - Thursday, January 16, 2020 1:09 PM | Last reply by Heinzi.at - Thursday, January 23, 2020 1:11 PM - Items 1 to 20 of 27001 Next ›
No announcements
