All Questions
19 questions
1
vote
2
answers
61
views
Method 'columns' of object '_Global' failed error - VBA Access
Good morning everyone. I am trying to format an Excel file generated by exporting an Access query, I can correctly export the query and save the Excel file in the relevant folder, but when I call the ...
- 53
-3
votes
2
answers
186
views
MS Access VBA / Formatting emails w/ MS Word template vs. using code
I'd like to use an MS Word template to format emails for a mail merge. I currently use MS Access / VBA / MS Outlook to generate emails, but all of the formatting I'm looking for I hardcode (e.g. {b}, {...
1
vote
1
answer
845
views
Importing Data from Excel file to MSAccess formatting each column in VBA
I'm coding a system which import a excel file to a ms access database, but I would like to know if is possible format every column before import to the database.
For example:
EXCEL FILE (xls or xlsx): ...
1
vote
1
answer
402
views
Send query result in Outlook Email with Number formatted table
I want to send an email in Outlook that includes my query result from Access. The body of the email includes a table (columns/rows) with the results. I want to use a Number format with commas xx,xxx ...
- 23
0
votes
1
answer
854
views
Access 2016 Alternate Row Color
I am trying to alternate my row color on a report that utilizes grouping. The issue is when moving from one group to the next, the color always starts as white. This can lead to awkward chunks of ...
- 93
0
votes
0
answers
821
views
Microsoft Access report margins are set incorrectly, but only when they're created from my system
Sometime after last Thursday morning (3/5/2020), the product datasheet that I've been automatically generating and printing for years from a VBA-enabled Access database now comes out with the margins ...
- 367
0
votes
1
answer
348
views
How to write a numeric field in a VBA expression using MS Access 2016?
I have a code line referencing a field as a Date format. I need to reference another field as numeric format.
This is my code for a date format field:
Private Sub cmbsearch_Click()
Dim varFilter As ...
1
vote
2
answers
1k
views
Write multi-line email by looping query and format into columns in VBA Access
I have an access query which I aim to loop through and write the contents to the email body of an outlook email. The below code does the job, however if there are a lot of lines, it doesn't look ...
- 57
1
vote
1
answer
43
views
formatting combobox elements
In my database serial-numbers are stored as an Integer.
I want to represent these numbers in a Access-frontend combobox with a different formation:
"121212345" --> "12.12.12345"
When a number is ...
- 35
0
votes
0
answers
47
views
Access conditional formatting report when mailing
I'm currently at work making a database that sends out contract reports.
This gets filled in in a form, where afterwards this get sent in pdf format to the entire organisation.
Afterwards, ...
0
votes
0
answers
459
views
Column Header Not Exporting to Excel Correctly
I have an Access database which I am using to build data for transfer to an Excel template I have created. I have a field called "# of OA Directs" in my query, and the field name shows properly when ...
0
votes
1
answer
282
views
MS Access - Formatting Labels
I am using a form in MS Access 2010 to enter data into a table. I have got the basic functions set up and added some VB code to format it as desired. One of the things I am trying to do is to update ...
1
vote
1
answer
495
views
MS Access VBA format Excel
Hi I am trying to format an excel spread sheet created by my MS access macro. I wanted to select rows with only values in it. So for example I want to select the first row and text wrap it
I thought ...
- 67
0
votes
2
answers
510
views
How to format Date & Time stamps while inside create table function?
In my (newbie) DAO db, my table is successfully being created, however, no data is being entered into the date and timestamps. My goal is to have the local user's current datestamp and timestamp enter ...
0
votes
0
answers
107
views
Access Format Excel Row as Short Date (Always reverts to US)
I have an annoying issue whereby I have csv files that get saved in a date format I need to change e.g. dd-mmm-yyyy to dd/mm/yyyy.
My sub will work if I enter the file name and path directly in the ...
- 831