Manufacturing Information Solutions Forum Index Manufacturing Information Solutions
Your Place for Support and Discussions
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 460 matches
Manufacturing Information Solutions Forum Index
Author Message
  Topic: Append String to Text Box, Re-append when updated
mistux

Replies: 0
Views: 2577

PostForum: 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: 2981

PostForum: 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: 2419

PostForum: 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 (HSmile 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: 19298

PostForum: 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: 13813

PostForum: 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: 13813

PostForum: 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: 13813

PostForum: 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: 13813

PostForum: 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: 13813

PostForum: 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: 13813

PostForum: 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: 13813

PostForum: 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: 13813

PostForum: 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: 4983

PostForum: 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: 4983

PostForum: 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: 4495

PostForum: 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 ...
 
Page 1 of 31 Goto page 1, 2, 3 ... 29, 30, 31  Next
All times are GMT - 5 Hours
Jump to:  


Powered by phpBB © 2001, 2005 phpBB Group