Error 2950 The object doesn't contain the Automation object "Funcion&q uot;.
My macro sets warnings off
RunCode (successfully)
Openquery
Openquery
Runcode (Fails with above error.)
This is in a trusted location, it should work fine. The first pi | | 0 | 15 | 11/10/2009 9:56:38 PM |
Out of Memory Error
I get "Out of Memory" error when I change pathnames in a module's "Declare"
statements like
Eg. Change
Declare Function I2PDF_GetDLLVersion Lib
"c: | | 0 | 14 | 11/10/2009 7:45:28 AM |
Access 2007 - how to get at System Tables?
I am looking for the option to turn on view of system tables which was
available in earlier versions.
Thanks for any help.
Ron
| | 0 | 13 | 11/10/2009 7:45:26 AM |
Transfer Control From One Database to Another Using RunTime
Access 2007 RunTime
The application consists of two database. The first one is launch using RunTime. When the user
clicks on the close button I would like to transfer control to the | | 0 | 9 | 11/10/2009 7:45:17 AM |
Object doesn't contain Automation object "function"
I have a macro which runs some code, a couple of queries, then more code.
The final piece of code works just fine if I run it from VBA. It fails
when I run it from the Macro with the | | 0 | 13 | 11/10/2009 7:45:15 AM |
Open A Password Protected Database in a New Instance of Runtime Access
Access 2007 Runtime
I need to open a password protected database in a new instance of Runtime Access. This is on a
machine with only the Runtime installed.
In an environmen | | 0 | 14 | 11/10/2009 7:45:14 AM |
Change SQL to code, use variable to define WHERE
I am looking for a way to take the SQL query
SELECT Timeslip.EmployeeID, Timeslip.Day, Timeslip.TaskName, Timeslip.Hours,
Timeslip.TaskType, Timeslip.Comments
FROM Timeslip
| | 0 | 19 | 11/10/2009 7:45:12 AM |
Connecting String to Teradata
Does anyone have the code to (Using MS Access 2007):
1. Establish a connection to Teradata database and
2. Sample of a passthru of Teradata SQL to teradata.
Many Tha | | 0 | 13 | 11/10/2009 7:45:07 AM |
Missing Mapi Com Library
I am trying to update a new database version and getting this message when I
open the DB on some workstations.
Missing: Redemption and MAPI Com library.
The Redemption.dll | | 0 | 10 | 11/10/2009 7:45:07 AM |
Efficient Looping
Access 2003
I have a table for Sales Orders and one for Sales Order Detail records with
a one-to-many relationship defined on SalesOrderID.
The Sales Order table has over 50,000 record | | 0 | 15 | 11/10/2009 7:44:57 AM |
Alternative to URLDownloadToFile
I have an application, installed at about 90 locations, that downloads a
small text file from my web site when it opens to determine if an update is
required. If it is then it downloads th | | 0 | 14 | 11/10/2009 7:44:56 AM |
Auditing desired Change Requests to Tables WITHOUT updating the ta
I am developing some logging for a multi-user DB my colleague built. I am a
light VBA coder (self-taught).
Our Access MDB will be used for our User community to request changes to
| | 0 | 13 | 11/10/2009 7:44:55 AM |
How to reference a dataset. I do not understand a coule of things.
I do not quite understand VBA programming as it regards Access tables
and such.
I have looked at examples, but some things are not working.
Could someone supply me with a s | | 0 | 19 | 11/10/2009 7:44:54 AM |
Copying into Tab controls
Hi
I have a form open in design view with a tab control which has 4 tabs.
I want to copy the text fields from one tab onto another, It seems I must
re-create all the fields | | 0 | 21 | 11/10/2009 7:44:51 AM |
accdb will not open in 2007 runtime
I don't know the root cause of this problem but I suspect coding somewhere
so I am starting in this group.
I have an app that when run on a PC with Access 2007 Runtime installed it
| | 0 | 16 | 11/10/2009 7:44:45 AM |
close new module without saving
Access 2003.
This seems like a silly question and has bugged me for a long time so I'm
finally getting around to asking it. If I create a new code module (not in a
form or a rep | | 0 | 15 | 11/10/2009 7:44:45 AM |
VBA - Access 97 to 2003
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 | | 2 | 110 | 2/5/2008 6:26:24 PM |
ADODB Help
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. | | 3 | 106 | 2/4/2008 9:37:05 PM |
Create Outlook Appointment
I have code to create a meeting which seems to work. As part of the meeting
i want to use a Resource - a calendar for a meeting room. How can I get the
resource (meeting room) to accept an | | 4 | 83 | 2/4/2008 7:41:39 PM |
SQL parse
Hi:
Can anyone tell me if there is any way to make the following sql work:
SQL = "INSERT INTO ServicesPCA32 ( SexM ) " & _
"SELECT IIf(DLookUp("[Sex]","client","[ClientID#] =
[ClientID | | 12 | 74 | 2/4/2008 5:24:38 PM |
dll File
Two questions ............
1. Can VBA be used to create the procedures in a dll file?
2. Can anyone give me recommendations for free downlaodable tools for
compiling a dl | | 4 | 79 | 2/2/2008 5:45:53 PM |
Is anyone up for a Challenge? Oh I HOPE SO!!!!
To the Best of the Best (yes I am sucking-up early),
Ok here it is:
I am trying to figure out a method that does the following. I have an
employee who works 5 days a week M-F. | | 8 | 78 | 2/1/2008 12:02:01 AM |
help with simple code
Anyone have ready-made code for the following (Ac2k3):
I'd like to take the values from Table1, as an array such as field
1,1, field 1,2 ------field 1,m
followed by field 2,1, field 2,2 -- | | 1 | 92 | 1/28/2008 1:26:17 AM |
Sending reports via Exchange server
I send out daily reports to our sales staff. Currently I send them via my
own e-mail. I have a script that does all of that for me and is run through
a scheduler.
With me departin | | 8 | 119 | 1/24/2008 9:54:11 AM |
Conditional Formating
I have a subreport within a report which includes five fields. Each field
has option 1 through 6.
If the field value is "1" then I want the back color to be Green
If the field value | | 1 | 95 | 1/24/2008 1:03:48 AM |
fit forms to higher resolution screen
i have an application based on resolution 600X800 .
how can fit the forms to 768X1024 screen or more, include forms containing
tabcontrols?
tanks
| | 1 | 104 | 1/23/2008 11:52:31 AM |
appending data
Hi;
Wondering if anyone can suggest a good approach to the following
problem.
I have a table, "tblServices", which I have been using for data entry
into an invoice report. For reasons | | 2 | 82 | 1/19/2008 10:30:08 PM |
odd behavior in dictionary object
Hi, all;
My client has asked for me to allow users to type in a code like this
"33303" which then will be used to add or edit 5 different records (one for
each digit). The problem | | 3 | 85 | 1/15/2008 7:47:56 PM |
retrieve images stored in a table and save it as a file on disk
how can i retrieve images stored in a table and save it as a file on disk?
thanks
| | 1 | 101 | 1/14/2008 10:16:03 PM |
A 2007, Vista, and writing to registry
Hello:
I write and maintain a big app that ran fine under XP. Important settings
that were common to all users (such as database paths) were kept in
HKEY_LOCAL_MACHINE, and individual u | | 34 | 101 | 1/14/2008 5:05:59 AM |
Getting rid of module
I've never made a module before. Now I tried to put a function in a module.
It was saved as Module1. But when I go back into modules nothing is listed
like tables, forms, etc. And when I | | 2 | 107 | 1/12/2008 4:34:10 PM |
Type Structure problem
I have a type structure that I use to store data pulled down from an SQL
stored procedure. The SQL stored proc returns a recordset. I then build
the type structure element by element as fo | | 3 | 89 | 1/9/2008 5:05:50 AM |
MouseWheel Event in Access 2003
I can't get the expected response (and can't disable the unwanted scrolling
to next/previous record when the mouse wheel is used in an Access Form) with
the MouseWheel event, in Access 2003. | | 5 | 147 | 1/8/2008 6:56:10 AM |
control a tif file from access
how can i control a tif file from access to know how many pages in it ,
delete a page and so on?
thanks
| | 2 | 90 | 1/6/2008 2:46:21 AM |
Run-time error '3219'
I need help! I'm not a code writer. My application is created from macros
and queries, mostly. When I split my database into a Fe and Be, I now get
this error message when I try to run a | | 5 | 272 | 1/2/2008 10:39:09 PM |
Function to extract dates...
Hi,
I am responsible to enter records of training which usaully provided to me
in an Excel format. User tend to combine date in a date column like this 4-7
Jan 2007 or in format of | | 1 | 103 | 1/1/2008 2:55:46 AM |
Print Preview
How do I control a form or report's print preview size in VBA? Everytime I
print preview a form or report the size is too big and off the screen...
Please Help...
Thanks
Paul
| | 2 | 94 | 12/26/2007 4:09:28 PM |
error verifying CHECK constraint
Hi,
I recently got an error :
Error occurred while verifying CHECK constraint
This is the first time I see this error. Anyone a clue about what this
could mean? It ha | | 1 | 91 | 12/16/2007 8:15:26 PM |
Output report to Word
I have a series of reports that I output to a Word doc in rtf. Is there a
way to keep the report format in tact? I.e., can I output the report so that
it looks the same as it does in the r | | 1 | 79 | 12/16/2007 11:58:11 AM |
Stored Query vs SQL SELECT statement
I would like to ask for some advice about the performance of stored queries
vs. SELECT statements and when/where to use each.
Which of the following scenarios would be faster/better/more | | 7 | 81 | 12/13/2007 6:41:10 AM |
Classes programing: what's a good way for...
Hi All
I am trying to check access's querydefs and comparing them to a
variable in my class with following function:
------------------------------------------------------------- | | 9 | 81 | 12/10/2007 2:48:40 AM |
Handling apostophes in string expressions
Hi
I am trying to write a procedure that writes to a table an ID, Folder Name
and Parent Folder ID. The table structure is as follows
ID Number (Long Integer)
Folder Text
Pa | | 6 | 85 | 12/10/2007 12:15:52 AM |
Logging changes in combo/text boxes.
Hi
I have an application with a form which holds some 15 combo boxes and 5 text
boxes. The values in both combo boxes and text boxeas are enabled and may be
changed by users.
No | | 4 | 100 | 12/7/2007 10:41:02 AM |
Trying to set up a function
Hello.
I found a function in a module in a database. The function can be called
from within a query. When I copied the module containing the function to my
modules window I get a | | 4 | 81 | 12/5/2007 6:36:01 PM |
reports in access 2007 can't be opened
reports in access 2007 can't be opened
even in edit view
what can be done?
thanks
| | 1 | 94 | 12/3/2007 8:20:24 PM |
access 2007 exports to excel hebrew letters in gibrish
OutputTo acOutputTable, "tbl", acFormatXLS command in access 2007
ends in the excel sheet with gibrish for hebrew letters
what might be the solution?
thanks
| | 0 | 107 | 12/3/2007 7:52:54 PM |
Open Word
This is real beginner stuff, but...
How can I write code in Access XP to open Word? And I need to be sure it
opens any version of Word that may be on the user's computer, in any path
tha | | 29 | 108 | 12/3/2007 7:51:02 PM |
sql query problem
hi im trying to perform a query using the recordset property
here is my sql string
stSql = "SELECT * FROM [tasks_done] WHERE [tname]='PPM Projector #" & projno
& "'" & " AND [td | | 5 | 88 | 12/3/2007 1:17:00 PM |
Test for empty field in a DAO Recordset
Can anyone help me to determine when an integer field contains nothing?
It seems to be different than a null variable and I can't remember how to do
this simple thing.
I'm using a DAO 3.6 | | 6 | 144 | 12/2/2007 5:32:08 PM |
Calling a public function from another public function
How can I tell MSAccess in a module to start Public Function green_two () as
Boolean at the end of Public Function green_one () as Boolean?
| | 2 | 97 | 12/1/2007 12:00:37 AM |