How to avoid the ' at the start of each string when using TransferSpreadsheet?
Fri, 15 Feb 2008 13:44:24 +1100
Hi,
I create a spreadsheet using the TransferSpreadsheet method:
If RptType = ".xls" Then
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, RptQry,
BookName
etc
My problem is that I need to output a number as a 6 character text string
without the " ' " at the start of the string. I want a s ...
|
If file not exists, copy it
Thu, 14 Feb 2008 09:21:13 -0800
My form is based on tblmyLabel linked to C: drive cisCdrive.mdb. If file
does not exists, I copy from S: drive.
My code below gave error message: File not found c:\Program
Files\elac\cis\cisCdrive.mdb
What did I do wrong?
Private Sub Form_Open(CANCEL As Integer)
If Len(Dir("C:\Program Files\elac\ci ...
|
Failure with GlobalFlags API
Thu, 14 Feb 2008 07:25:57 -0800
Hi,
I have an Accees 2003 application distributed in MDE form to a large number
of clients. Most use Access 2003 runtime (which is distributed with the
application) although some have full Access 2003 and don't use the runtime I
provide. Most use Windows XP, although some use Windows Vista (and a couple
...
|
compile error in hidden module when creating Access 97 mde
Tue, 12 Feb 2008 22:58:34 -0000
In Access 97 I cannot create a mde and get "compile error in hidden
module" - module1. I have tried all the workarounds as suggested by Dev
Ashish on Access Web but still cannot create mde. OS is XP home.
Any other suggestions would be most welcome.
...
|
Date Management
Mon, 11 Feb 2008 10:03:37 -0500
Access 2000 and 2003
Anyone have an idea how I can do this?
I need to know that 2/11 (Feb 11) is between 12/15 (Dec 15) and 6/1 (June
1). The year is not entered because the dates can span multiple years.
Specifics...
I have start date and end date fields in my table. They both hold just
month and day: ...
|
set macro security to low programmatically
Sat, 9 Feb 2008 17:04:55 -0800
Is it possible to set macro security to low programmatically?
...
|
Access 2007 cannot publish report to Word?
Sat, 9 Feb 2008 16:54:11 -0800
I use Access 2003 to make .mde
Some users have Access 2007 installed. Everything is fine except when they
click 'Publish to Word' when my report displayed, it crashes. All Access
2007
users reported same.
I know how to export to PDF but users want to use my report as a base to
modify it in Word.
Any VB ...
|
|
|
Problems with DSum using date criteria
Fri, 8 Feb 2008 17:59:00 -0800
I have been trying to get Dsum to accept a date criteria from a variable or
control with no success. It works OK if I hard code the date but as soon as
I try and replace the date with the variable name (dim as date) the procedure
tells me the action has been cancelled when I try to run the procedure. Any
s ...
|
Our new website
Fri, 8 Feb 2008 15:04:25 -0800
This website is for artist, freelancers, programmers, writers, translators. All who is looking for work.
If you are a skilled professional use page "Add profile" to create your profile.
Also this website is for those who is looking for skilled professional.
If you are looking for a professional use page "Pr ...
|
Custom Sizing of Popup forms
Thu, 7 Feb 2008 04:26:00 -0800
I have popup forms in my application that can be manually resized and
repositioned in the screen.
Usually strickly saving the popup form does not work (for size and postion).
I found one trick (from this website) for saving the size and position of a
pop-up is to enter CTRL S from the keyboard. It works pe ...
|
