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 ...
|
|
|
VBA - Access 97 to 2003
Tue, 5 Feb 2008 09:37:48 -0500
Hi All.
I'm having a heck of a time here trying to sort some code out in an attempt
to convert a few VBA modules from 97 to 2003 and compile them.
At the moment I'm getting this error:
Error: Object variable or With block variable not set
from this code:
Function ref_intStartNewAccess() As Integer
...
|
ADODB Help
Mon, 4 Feb 2008 12:32:44 -0800 (PST)
Hello everyone,
When I run my code to retrieve the RecordCount via SQL SERVER, why do
I end up with a -1? I'm baffled.
Sub Testit()
Dim Conn As ADODB.Connection, rs As ADODB.Recordset
'Dim strSQL As String
On Error GoTo TestIt_Err
Set Conn = New ADODB.Connection
Set rs = New ADODB.Recordset
...
|
Invest smart
Sat, 2 Feb 2008 13:46:17 -0800
How much profit can you make with one dollar?
Check out this website www.forbuck.com
Without any obligation, registering or other ties make cash!
...
|
