Code to "Save As" and Open Database in Access 2007
Wed, 15 Oct 2008 07:25:01 -0700
Is there a code to "Save As" an open database? I was able to do it manually,
but cant find the code to for it.
Thanks very much for your help.
Magnivy ...
|
Index number not working properly with variable
Wed, 15 Oct 2008 10:10:21 -0400
OS: Windows XP, SP2
Access 2002, SP3
MDAC 2.8
DAO 3.60
Using DAO Coding
I have a code within a class module and the variable used for the index
number with the TableDefs doesn't work like it should.
Dim l_lngCurrentTableDefCount As Long
Set m_dwsCurrent = DBEngine.Workspaces(0)
Set m_objD ...
|
I need to start a vb.net 2008 program via Task Scheduler
Wed, 15 Oct 2008 06:50:01 -0700
I wrote a vb.net 2008 program using 3.5 .net Framework, installed it to my
local PC and set it up to run automatically at a certain time using Task
Scheduler. When the program executes it brings up the Visual Foxpro Error.
I'm not sure why I do not reference Visual FoxPro anywhere in my code.
This progra ...
|
Automate Excel from Access 2007
Wed, 15 Oct 2008 05:55:00 -0700
The following protion of code worked perfect with Access 2003 and after I
updated 2003 to 2007. Now we have new computers with a fresh install of
Office 2007 and now I get Run-time error '-2147417851 (80010105)': Method
'Add' of object 'Workbooks' failed when the compiler hits the last line.
---------------- ...
|
List all procedures within a module
Wed, 15 Oct 2008 05:19:01 -0700
Is there a way to list all the procedures within a module?
TIA,
...
|
Upload File with Access 2000
Wed, 15 Oct 2008 03:08:01 -0700
Hello
I have a simple form created in Access 2000. What I want is to be able to
press a button and choose a file, which is then uploaded to a destination
folder on a server. Is this possible to do in VBA?
Thanks
Matthew ...
|
Access Shift By Pass
Wed, 15 Oct 2008 02:54:00 -0700
Hi There, I am tring to create a Shift ByPass Key for my access database, but
getting error "Compile error: Expected end of statement". The code I managed
to find is:
Private Sub Command0_Click()
On Error GoTo Err_bDisableBypassKey_Click
'This ensures the user is the programmer needing to disable the By ...
|
|
|
Possible Combination with same Total
Wed, 15 Oct 2008 00:19:15 GMT
Hello,
Need help in coding this problem in microsoft access.
I have a table with values 1,2,6,7,9,11,15. These values are taken from
between 1 to 50, no the same value on the table.
What i would like to implement is from a given total, the code pick 4
numbers and give the possible combination ...
|
What has focus?
Tue, 14 Oct 2008 16:59:01 -0700
This should be easy! I'm looking for a command that would return the name or
object type that has the current focus. Something to the affect of
Msgbox CurrentProject.HasFocus
But obviously that doesn't work. . . I need to know it it's a form, table,
query, or report.
Thanks! ...
|
Problem with Runtime Error 2448
Tue, 14 Oct 2008 12:19:01 -0700
Hi I have modified a microsoft template to track our office mail. I am
having problems with a code. I have a search form. I keep getting the error
2448 Cant assign any value. When I go to debug the code the last to lines
keep highlighting yellow. its using the string strwhere. Here is the code its
the very ...
|
