Author |
Message |
Topic: Append String to Text Box, Re-append when updated |
mistux
Replies: 0
Views: 7842
|
Forum: Microsoft Access Posted: Thu Apr 02, 2020 7:18 am Subject: Append String to Text Box, Re-append when updated |
Updating the value held by a form control as part of the event handler for the AfterUpdate event. Do this with Me!IncidentDescriptionInput.Value = Output
Retrieving the existing value of a form con ... |
Topic: Remove Directories that say they don't exist |
mistux
Replies: 0
Views: 8321
|
Forum: Microsoft Operating Systems Posted: Thu Jul 19, 2018 2:27 pm Subject: Remove Directories that say they don't exist |
If you can't delete a folder (or file) especially ones that Camtasia makes do this:
1. From the Command Prompt
2. Type in "cd /d xxx" where "xxx" is your path
3. Type "dir /x"
4. Then rmdir / ... |
Topic: New Drive Partition Added To C: After April Update |
mistux
Replies: 0
Views: 5069
|
Forum: Microsoft Operating Systems Posted: Mon May 14, 2018 7:09 pm Subject: New Drive Partition Added To C: After April Update |
The new April Windows Update was a standard upgrade I ran today. After upgrading, there's a new drive letter (H allocated with 449MB of space, with 38.7MB free. As far as I know, there was absolutel ... |
Topic: File Transfer Site |
mistux
Replies: 6
Views: 27068
|
Forum: Management Posted: Tue Dec 09, 2014 10:17 am Subject: File Transfer Site |
We Transfer Up to 2 Gig files
www.wetransfer.com
I have used it to transfer PSD files to clients. |
Topic: Formatting Excel from Access |
mistux
Replies: 7
Views: 18387
|
Forum: Microsoft Access Posted: Tue Sep 23, 2014 11:28 am Subject: Shade every other row |
Shade every other row
With Range("A1").CurrentRegion
.FormatConditions.Add Type:=xlExpression, Formula1:="=MOD(ROW(),2)=1"
.Forma ... |
Topic: Formatting Excel from Access |
mistux
Replies: 7
Views: 18387
|
Forum: Microsoft Access Posted: Tue Sep 23, 2014 10:46 am Subject: Formatting Excel from Access |
This code exports a query then opens the Excel file and does some formatting and shades every other line.
On Error GoTo Error_Handler
Dim strWorksheetPath As String
strWorksheetPath ... |
Topic: Formatting Excel from Access |
mistux
Replies: 7
Views: 18387
|
Forum: Microsoft Access Posted: Tue Sep 23, 2014 7:37 am Subject: Formatting Excel from Access |
With a little VBA code, you can do quite a bit of formatting from within Access.
My code opens the sheet, bolds the columns in the first row, then autofilters the row and auto-fits the columns. Whe ... |
Topic: Formatting Excel from Access |
mistux
Replies: 7
Views: 18387
|
Forum: Microsoft Access Posted: Tue Sep 23, 2014 7:35 am Subject: Formatting Excel from Access |
Your question was about using VBA to create a formatted Excel workbook; TransferSpreadsheet does a basic data dump, with no formatting. For best results, I recommend creating an Excel template with t ... |
Topic: Formatting Excel from Access |
mistux
Replies: 7
Views: 18387
|
Forum: Microsoft Access Posted: Tue Sep 23, 2014 7:17 am Subject: Formatting Excel from Access |
Reading your initial question, it seems that you want to format an Excel spreadsheet from Access, adding conditional formatting too.
Basically, stick to Docmd.TransferSpreadsheet to export the quer ... |
Topic: Formatting Excel from Access |
mistux
Replies: 7
Views: 18387
|
Forum: Microsoft Access Posted: Tue Sep 23, 2014 7:13 am Subject: Using a Macro to create the code for formatting |
Open a spreadsheet and put in some data that looks like what you will be adding. Then turn on the macro recorder and go through the motions of formatting a cell to have the attributes you want. Stop ... |
Topic: Formatting Excel from Access |
mistux
Replies: 7
Views: 18387
|
Forum: Microsoft Access Posted: Tue Sep 23, 2014 7:10 am Subject: Specify columns to be numeric showing 2 decimal places |
Sub exL()
'specify columns H to be numeric showing 2 decimal places
Dim oExcel As Excel.Application
Set oExcel = CreateObject("Excel.Application")
With oExcel
.Workb ... |
Topic: Formatting Excel from Access |
mistux
Replies: 7
Views: 18387
|
Forum: Microsoft Access Posted: Tue Sep 23, 2014 7:05 am Subject: Formatting Excel from Access |
Dim MyExcel As Object 'This is the excel object
'Might need to set reference to Excel in Tools-->Reference
Dim MyBook As Object
Dim MySheet As Object
Sub Acad_Cons1()
... |
Topic: Export Query to Excel |
mistux
Replies: 1
Views: 7273
|
Forum: Microsoft Access Posted: Mon Sep 22, 2014 3:56 pm Subject: Export Query to Excel |
Export A Table Or Query To Excel
COPY THIS CODE INTO A STANDARD (not form or report) MODULE. NAME THE MODULE SOMETHING OTHER THAN THIS FUNCTION NAME AND MAKE SURE TO SET A REFERENCE TO DAO IF YOU ... |
Topic: Export Query to Excel |
mistux
Replies: 1
Views: 7273
|
Forum: Microsoft Access Posted: Mon Sep 22, 2014 3:55 pm Subject: Export Query to Excel |
Here is some code to export a query to an excel spreadsheet:
On Error GoTo Error_Handler
Dim strWorksheetPath As String
strWorksheetPath = "C:\Temp\"
strWorksheetPa ... |
Topic: Resultant Table not allowed to have more than one AutoNumbe |
mistux
Replies: 0
Views: 6889
|
Forum: Microsoft Access Posted: Mon Sep 22, 2014 3:51 pm Subject: Resultant Table not allowed to have more than one AutoNumbe |
Q:
I have a Make Table Query that has several fields from different Tables. I have two fields that I want in this new table of this that are AutoNumber Fields.
Whenver I try to execute this Make ... |
|