|
Open remote connection
hello,
i have a database with a linked tables in another remote pc, and the problem
is every time i log off to my desktop pc and when i ran my application again
after logging in, i still need to supply the username and the password of the
remote pc where my BE database resides. and my question is ther code that can
automate my connection to my remote pc?
please help
resti...
|
1 |
22.08.2006 14:59:02 |
|
|
combo box NotInList Event
Hello Need Help Again
Trying to set up a combo box to add a new customer name, got this code from
the Access help. I get a SQL; error ?? Also I will need to add a new number
to my primary key field (this is set to auto number in the table)
Private Sub Customer_NotInList(NewData As String,Response As Integer)
Dim ctl As Control
Set ctl = Me!cboCustomer
If MsgBox("Value is n...
|
5 |
22.08.2006 13:26:02 |
|
|
Access concatenation question
I have a table that has 3 similiar fields. Let's call them Issue fields-1,2,
& 3. I need to take all the issues from all fields, sort them together to
find the Top 5 issues for a certain timeframe. How do I concatenate these
three?
What I need is this.
56
75
67
56
56
Not this 56, 75, 67
56
56
I am rather new to Access 2003 so please be detailed.
T...
|
3 |
22.08.2006 12:57:01 |
|
|
IF statement in Access
I have a master database containing vehicle information, including leins.
However, not every vehicle has a lein on it. How do I skip over entering
this info. I have a field that is either YES/NO to the question "Is there a
lein on the vehicle?"
Thanks,
Les...
|
5 |
22.08.2006 10:36:02 |
|
|
Send email using addresses in query
Hi all.
I want to be able to send an email to a selection within my contact
database, and to aviod having to enter all the email addressess all the time,
or have to keep a seperate address book in Microsoft Outlook, I am wanting to
be able to push a button on a form, and have a blank email come up with all
the email addresses in my contact list within the database.
The database is us...
|
5 |
22.08.2006 04:17:09 |
|
|
Running Fireworks from Access
I am developing an ASP web site using Access. I am using a routine in
VBA to pick photos and instert their path in the database. The routine
also copies the photo to the images folder. At that point I would like
the module to run a function that would open fireworks, run a script
that would resize the chosen photo as a thumbnail, place the resized
photo in another folder and close fireworks.
...
|
5 |
22.08.2006 03:56:50 |
|
|
Updating form after adding record
I have a subform whose record source is a query. The subform lists all
persons associated with a case. (The main form has the case information) I
open another form to add a person to a case and when I close the new form
after adding the person to the bridge table I want my subform to update and
show the new person I just added. I tried using some requery commands
unsuccessfully. my subfo...
|
2 |
22.08.2006 02:26:12 |
|
|
A2000 ADO Connection String Error
Hello everyone,
I am trying to get a connection string to work and I have tried a variety
of things but to no avail. I have used the same connection string in an
A2003 and it works fine. The code is below:
Dim OConn As ADODB.Connection
Dim strConn As String
On Error Resume Next
Set OConn = New ADODB.Connection
OConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Sou...
|
5 |
22.08.2006 01:52:34 |
|
|
Receive a 3134 error
I am getting an error with my insert statement. The code is very long but
here it is.....
strInsert = "Insert into Maintable (CourseTitle, Assignee, Location,
StartDate, EndDate, " & _
"LocationRvedDate, DateInstructorCleared, PostMTB,
PostTCRS, PostSATERN, SWRDte, RoomCapacity, " & _
"CoordProvDte, CloseOutDte, InvoiceRecved, EvalTechSent,
DCNConf...
|
10 |
21.08.2006 19:47:39 |
|
|
Making a query from vba
I'm trying to write a query that will do a Union of all of the tables with a
certain naming convention (that start with CL_ or something like that). I
would like this to be run automatically when a query is called. I was hoping
not to have to open Access. This query will hopefully be called from an Excel
file import call. The tables will be linked Excel files. I would like to
build the...
|
1 |
21.08.2006 19:36:03 |
|
|
Mailmerge via VB
I am experience problems and solution from Microsoft is not favorable. Before
my department was upgrade with new workstations, we were using Access and
Word 2002. One of our Access databases would open Word mailmerge documents,
create the new letters, and then store them on the file server. This was all
done in Visual Basic using Access.
Now, with 2003 the same code is not working. I lo...
|
2 |
21.08.2006 17:49:02 |
|
|
I get an Error when I type Me.ID="Code, Me" for VBA in Access.
...
|
7 |
21.08.2006 16:57:01 |
|
|
fill in a form from a table
My table and form have same field names and textbox control names, every
field in table has a textbox. I have the user select the key to the table
record they want. How do I use the table data to fill in the form textboxes? ...
|
5 |
21.08.2006 16:22:02 |
|
|
Excel - GetSaveAsFilename - Is there an equivalent in Access
In excel I use the follwing code:
fLog = Application.GetSaveAsFilename(InitialFileName:="Extract_log.txt", _
fileFilter:="Text Files (*.txt), *.txt")
If fLog = False Then
MsgBox "Log file has not been provided. Processing Cancelled."
Exit Sub
End If
open fLog for output as #20
....
This is an easy way to create a new file and gives the user the flexibility
to co...
|
3 |
21.08.2006 16:11:02 |
|
|
Link a master table to 16 tables, good or bad???
hi, i'm having a big problem. Before i have a Project table that is
linked to the Milestones table. The relationship was one to many. As
there is a limitation on the number of columns in one table i can't add
columns in the Milestones table which i need to.
Therefore i thought of creating 16 tables for 16 milestones.How ever, i
getting an error "This recordset is not updatable" when i try...
|
8 |
21.08.2006 15:42:02 |
|
|
Email using CDO
I am using the following code:
Dim ObjetoMail As Object
' Create CDO object
Set ObjetoMail = CreateObject("CDO.Message")
' Configura email
ObjetoMail.To = "someoneelsesemailaddress"
ObjetoMail.From = "myemailaddress"
ObjetoMail.Subject = "The subject"
ObjetoMail.HTMLBody = "I'm the body of the <b>message</b>"
' Sending ma...
|
6 |
21.08.2006 14:05:03 |
|
|
Quit Access
Hi all
I found a very nice way to hide the access application window on the web.
http://www.tek-tips.com/faqs.cfm?fid=2562
I created on my switchboard a command button, which should close the
application including Access, which is running in the background.
Unfortunately, if I do a "DoCmd.Quit" in VBA or a macro with "Quit", only the
my application closes, but not Access, which rema...
|
3 |
21.08.2006 09:37:01 |
|
|
CurrentProject.Connection failure
Hi all.
I'm having a serious problem when i'm trying to use the
CurrentProject.Connection property for some ADO manipulation.
Here's the error message i'm getting:
Run-time error '-2147220999 (800401f9)':
Method 'Connection' of object '_CurrentProject' failed
In the immediate window, i try to execute this statement:
Msgbox CurrentProject.Connection
but again i get a funky er...
|
9 |
21.08.2006 07:02:13 |
|
|
Access Data Projects (ADP) and compile error
I have an ADP with the following command
set goADOCommand.ActiveConnection = currentProject.Connection
When I goto Compile this I get the following error:
Error in Loading DLL an d it hightlites the above .Connection
Any help would be greatly appreciated as this is hasa been very frustrating
to fix from home (slow connection) and I need to fix it fairly quickly.
Thanks
--
Fa...
|
1 |
20.08.2006 23:27:02 |
|
|
3rd request about pictures
I am developing a database that will track customers coins. I need to know
how a different customer will be able to add pictures of his coins into the
database. Something like push a button and he can brouse for his pictures on
his desktop then enter them into the database. The customers are not
programmers. It is kind of like one of those websites wehere you can enter
your pictures for ...
|
8 |
20.08.2006 21:33:01 |
|
|
Entering Data to Word Doc from access using VBA......please advise
How do I create the fields in a word document to accept data from a database.
I want to be able to export data from the appropriate database fields into
the word document with similar fields within the text......
Very simplified Example.......
It took "X" light years to travel.....etc.............X will be the data
from the database?
Any example or link to an example w...
|
3 |
20.08.2006 20:46:02 |
|
|
Runtime error...
Hello,
I have built an application (access2003) which works perfectly on my pc
while it gives Runtime error on users machine.
What's worst is that the procedure that end uo with the error doesn't even
come up with the error!!
Let me try to explain. There's a form which has a combo box name 'searchID'
which list all the ID for subjects recorded in a demographic table. The form
is unbound...
|
1 |
20.08.2006 18:33:01 |
|
|
Change value of a column in a listbox. Help!
I have a list box with several columns.
Once an item in the listbox is selected, I would like to be able to
change the value of column 4.
Some detail about what I am trying to do.
My listbox is ordered ascending using Column 4 wich
contains sequential numbers. So for example, if I have 8 rows,
column 4 will contain the numbers 1 thru 8
I am trying to create a procedure behind a button cal...
|
4 |
20.08.2006 18:19:54 |
|
|
Arguments for Class Object Methods ...
Hi everyone,
I wrote a Class Module for the Customer object, "clsCustomer". It has the
following methods, each has an argument, "strCustomerID".
Public Function Age(strCustomerID As String) As Integer
Public Function CreditScore(strCustomerID As String) As Integer
Public Function FullAddress(strCustomerID As String, _
Optional strTargetAddress As AddressType = Correspondence) As St...
|
6 |
20.08.2006 18:17:45 |
|
|
Linking Maps.google.com to a form in a Access Database to produce
Hi,
I'd like to do the following:
Create a link inside of a form where there is an address field to
automatically upon request by pushing a command button to produce a map from
map.google.com, brought up in a separate browser. This should produce a
separate map for each client, without having to type in the address myself.
Any assistance would be helpful.
Thanks.
...
|
6 |
20.08.2006 16:24:02 |