Tagged Questions
0
votes
0answers
6 views
send html format mails in MS-Access
Is there any way to send a mail in html format (and if possible with attachments) when your default mail client isn't Outlook?
Many thanks for any solution.
0
votes
0answers
20 views
Access - pasting clipboard to specific access fields
Currently I am using Access database 2013. I have a program that I automated the process of copying six select items that need to be placed into the database onto the clipboard. This information from ...
0
votes
1answer
19 views
procedure declaration does not match description of event or procedure having the same name in Access-Vba
I receive this message in vba, can someone analyse this question? I have to finish this work, however it's been shown difficult with this errors.
Private Sub ListTarefas_DblClick()
Dim idtarefas ...
0
votes
0answers
31 views
The text file specification does not exist
I'm trying to run a simple access program that exports data from a select query. However I keep getting the error:
Run-time error '3625'
The text file specification 'Deposits Link Specification' ...
0
votes
1answer
82 views
Convert DAO to ADO
I am trying to create a function that will check all the check boxes in a form with a
datasheet subform.
Since we moved to Office 2013 this code stopped working and it seems that moving to ADO is the ...
-1
votes
1answer
211 views
MS Access VBA SQL query debugging select case
In MS Access 2013 VBA I get a syntax error in this SQL-string:
strSQL = "INSERT INTO [man_year] ( man_year_val, year_int, main_research_area, organisation, man_year_source ) SELECT KU.[2007], '2007' ...
2
votes
6answers
171 views
Combobox null in if statement
I am trying to code an if statement where if a certain combobox is null, then it runs a certain part of code if it has data in it then it runs another. I wrote up this:
Private Sub ...
1
vote
1answer
168 views
Use VBA to get value of specific control in report?
I can't remember for the life of me how to use Access VBA to get the value of a specific control in a report.
My report has multiple rows (it contains a table with the results of a query). I want to ...
0
votes
1answer
117 views
outputting Access data to multiple Excel worksheets via VBA
I have a database that outputs 4 reports to Excel. These are all in different workbooks.
However I would like to output these all to one template workbook but in different worksheets.
Any help would ...
0
votes
2answers
130 views
Increment ID# MS Access VBA
I need to be able to create a unique ID# which uses the date, selected in a textbox. And when there is more than one record with that month/year I need it to count the number of records with that ...
1
vote
1answer
33 views
setting a text to a date in future with AfterUpdate for another event
I have a form that has a couple of text fields with date entries and I want the afterupdate of one text to update the value of another text field to a date that is 10 years after the date updated in ...
0
votes
1answer
2k views
Rename a file with FileSystemObject while looping through files
As a preface, I'm writing code in Access 2003, but will have users using Access 2013, and so I need it to be compatible for both. I have a loop that uses the Application.FileSearch to loop through a ...
1
vote
1answer
349 views
I wish to export the vba source code from all of the Forms, Reports, and Modules in an ms-access 2013 database
Here is a sample code module. The methods I used in previous version of Access do not work because the AllModules collection no longer contains objects for Form and report modules. If you have a code ...
0
votes
1answer
125 views
MS Word 2013 changing chart data from vba
Well, in classic fashion, the VBA code I was using to manipulate MS Word 2010 from MS Access 2010 doesn't work 100% since I upgraded to 2013.
One of the problems I'm having is I've lost the ability ...
0
votes
1answer
103 views
MS Access Reference to LATEST Excel/Word/etc
I haven't seen this exact question yet:
I have multiple installations of MS Office (don't ask, just need it!). Anyway, I've developed a database that will create and interact with Excel sheets and ...
0
votes
1answer
252 views
Determine if Attachment field is empty
How can you determine if in Attachment field in Access does not contain an attachment using VBA? I tried
If IsNull(rstMassBalance.Fields("FileName"))
and
If rstMassBalance.Fields("FileName") = ...
1
vote
1answer
275 views
Referring to the filename of an attached file in Access 2013 with VBA
If I have Files in Attachments fields, how can I get a filename as a string using VBA? They're excel files so I want to do something like this:
xlApp.Workbooks.Open("M:\strFilename.xlsx")
0
votes
2answers
45 views
Issue using VB in access to open up form with OpenForm
I have a Inventory form. I want to create an Update button which, when clicked, will open up a new form frm_add-remove, which will contain only the selected inventory item and will allow you to edit ...
0
votes
1answer
114 views
Writing continuous form data back to table
I have continues form that is bound to a query (see query below). The query is the record source for my continuous form, and is non-updateable.
The query filters data down to provide a list of ...
0
votes
1answer
349 views
Access Custom Primary Keys
eI'd like to create custom primary keys in my Access database.
The database is going to be multi-user, so I need a method that ensures each key is unique even when multiple users are trying to add ...
0
votes
1answer
273 views
Trying to open an image from a URL without the extention - VBA
I am currently trying to work on a database that stores a collection of cards, and I'm trying to fetch Images from Magic's Gatherer service in order to help identify the card.
This is the code I am ...
