|
ADO conn to two diff. backend db
Hello,
I have A2003 using a front end and back end configuration which works just
fine. However, I have a need to pull data from another back end database.
Essentially, the tables are linked from 2 seperate back end databases.
In a procedure, I run two different queries. One goes against one backend
database#1 and the other goes against backend database#2.
The query against backe...
|
6 |
12.09.2006 07:26:24 |
|
|
Dynamic Data from Excel
Hi,
Currently I'm linking an excel table into Access, subsequently queries are
run on this table and then subsequently a form-subform shows the results of
the query on the Main Page.
If the Main Form (and subsequent subforms) are open (as they normally will be)
this locks up the excel file so it can't be updated. The excel data will be
coming from a 3rd party export and I was planning on...
|
10 |
12.09.2006 09:01:01 |
|
|
" runtime error 2753 an error occured while communicating to OLE server or ActiveX control"
i need a help..i have a database for loading images in access...i have
38000 images to load in that database..i have try to load all the
images...but the problem now is after 1027 images that i have been
load,suddenly it stopped and there are an error message said " runtime
error 2753 an error occured while communicating to OLE server or
ActiveX control" ..what does it mean??? is there any so...
|
1 |
12.09.2006 03:29:12 |
|
|
Empty String
Hi all,
I guess I am doing something wrong here and not really understanding what.
I have a bit of code that you look to seee if the field is empty and if
empty the assign it a string value.the code I am using is:
DIM CS as Sting
If Me![contract subform]!CSO.Value = "" Then
CS = "no CSO"
Else
CS = Me![contract subform]!CSO.Value
End If
The CSO Value is the Customer Service Off...
|
2 |
12.09.2006 00:43:38 |
|
|
Forms not visible
Hello, I have created 5 forms in an Access database and only 3 of them are
visible in VBA. I have opened all of the forms in all modes, I've exited the
database several times, and still they cannot be seen. Thank you for your
help....
|
2 |
11.09.2006 21:05:01 |
|
|
VB References Objects clarity
When opening the VB Editor from Access; and then going to Tools - References
- am looking at a long list of References. Begins with "Visual Basic for
Applications" and ends with "ZF-FedEx Library"
only the first 4 boxes are checked:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Not sure if this is correc...
|
3 |
11.09.2006 20:52:02 |
|
|
Package Wizard
-- Does anyone know how to identify a file as a shared file when using the
Package Wizard in Microsoft Office Professional 2003 with Developer
Extensions? I was able to do this with Office 2000, but I don't see anywhere
to do this in 2003. Everything works great and I can run the install and
uninstall, but I want to identify a file as shared so when the user goes to
run the uninstall, ...
|
2 |
11.09.2006 19:02:02 |
|
|
Edit Hyperlink
I have a form that has a data box that leads to a hyperlinked field in a
table. Is there a way to add a click button that will take me directly to the
edit hyperlink properties rather than having to left click the box and then
select hyperlink\Edit?...
|
2 |
11.09.2006 17:56:44 |
|
|
access2003 can't hyperlink to adobe.pdf file
My machine was upgraded to windows/XP SP2, Access2003, my database has a
hyperlink field that points to a folder containing vendor specification files
(.doc, .xls,
..html, .pdf, etc.). I can view all of these files except the adobe.pdf
files.
I tried re-linking, but screen just blinks. ...
|
2 |
11.09.2006 17:26:02 |
|
|
Table name as parameter in SQL query built with VBA
Dear all,
I have several tables based on exactly the same fields
(Key/Date/Price1/Price2).
I do some statistics on the prices.
However, as I have many different tables (the tables are different because I
directly import the data from a .csv file), I do not want to create dozens of
queries to be able to get the results of the different tables.
Therefore, I would like to create a quer...
|
5 |
11.09.2006 17:16:17 |
|
|
Dollar change routine
I'm looking for an example of what a routine, either an If, Do or Dowhile
etc., to make change for a dollar would look like.
Thank you...
|
2 |
11.09.2006 17:11:04 |
|
|
Me!
I read a few postings and they a syntax with Me!. For example...
Me!ControlName.Colomn().
What does that mean exactly?
Sorry, I'm a newbie to acess databases....
|
5 |
11.09.2006 14:32:02 |
|
|
Killing an open instance of EXCEL from VB6 - HELP
I am developing a program en VB6 that extracts data from ACCESS and fills in
an EXCEL. While developing it, if the program crashes, it leaves behind an
open instance of EXCEL, which then I have to kill by hand, else the program
does not run.
Since it is at development and debugging time, I need to know how to detect
if there is an open instance of EXCEL and kill it, while loading the VB6
f...
|
3 |
11.09.2006 12:48:16 |
|
|
grouping data
i have a list of data which actually have duplicates, thus i will like to use
group by to group them together to prevent the duplicates. i'm grouping them
according to the id available. however, some data does not contain id num,so
when i do grp by, all data that does not have id will become one records. is
that anyway i can sort my data where duplicates records will become one
record an...
|
4 |
11.09.2006 10:22:59 |
|
|
Export query, changing one criteria multiple times, to Excel
I have a two part question. I am exporting a query to an Excel spreadsheet
every week with each tab containing query results with one criteria changed.
I have 24 different results for different areas. I originally set up
multiple queries in Access, each with the one changed criteria, and then
exported them using the DoCmd.TransferSpreadsheet.
'DoCmd.TransferSpreadsheet acExport, acSpre...
|
5 |
10.09.2006 23:46:01 |
|
|
Combo box crashes if text field has apostrophy (like O'Neil)
In Access, if I use a Combo box it crashes if text field has an apostrophy
(like the name O'Neil). Any suggestions?...
|
2 |
10.09.2006 22:57:43 |
|
|
file that automatically runs queries to update tables
Hi, how can i implement a file on my pc that automatically runs queries
at 10pm everyday in order to update few tables in my ms access 97
database.
...
|
4 |
10.09.2006 20:41:02 |
|
|
Temporary Recordset in Memory
I have a situation where I need to populate a temporary recordset, then
process the records in it and then delete it. This process is done for each
individual in my database (a couple of thousand) and at no time do I need to
save the data to disk - it's just a temporary recordset I need to use while
doing other things for each individual in my database.
Is there anyway to do all this i...
|
7 |
10.09.2006 16:29:19 |
|
|
How do I remove a Locked File that is occuring after closing.
...
|
1 |
09.09.2006 19:44:02 |
|
|
filter form using combo box control
Hello,
I'd like to filter a form using a combo box control (just as the
toolbar does). I'm new to access so please take it easy on the tech
talk.
Thanks in advance
...
|
2 |
09.09.2006 17:08:02 |
|
|
Undo record problem
I have a form that inputs data into a table. I have 3 click buttons. One Adds
the Record to the table (Goes to next record), another Clears the form(Undo
the Record) and I have a third that closes the form. If there is no text
entered, form closes. If there is text typed, and then form is closed, the
text still gets added to the table. Solution to stop that, I had the
Close_Click() Undo ...
|
3 |
09.09.2006 13:29:46 |
|
|
InputBox Question/Error Handling
I built a little automated survey tool with normalized tables to hold
questions divided up by department etc. For each department being surveyed I
have a command button that activates the the following on it's OnClick Event:
Dim Answer As String
Dim MyQ As String
Dim CurDept As String
Dim Acct
Set Acct = New ADODB.Recordset
Acct.Open "Accounting", CurrentProject.Connection, adOpenSt...
|
2 |
09.09.2006 03:17:01 |
|
|
Insert Text into a field
On the VB Code of a form, Is there a way to place text into a particular
field of a table, just by clicking on a click form button. If so, what would
be the syntax for that?
...
|
2 |
09.09.2006 02:33:43 |
|
|
How do I remove a unknown password from Access codes?
Someone in my office placed a password in my application codes and now I
cannot get to my Reference library. Where is this file placed withen Access
or Windows or the Regedit.
I realy need some help ASAP. email me at
belcredit@yahoo.com
Thank you for your assistance
Ivan Roberts...
|
2 |
09.09.2006 02:25:01 |
|
|
How to validate data in a field?
I created a form where the user has to enter data. For one of the fields, I
would like to validate their data entry. I want to create an error message,
if the user does not enter "PK" or "TR" into this field. However, with the
below code, when I type "TR" or "PK" into the field it gives me the error
message("You must enter PK or TR"). Can you tell me what is wrong with my
code?
If (M...
|
4 |
08.09.2006 23:52:17 |