|
Getting Access records from a Word reference
Problem: A Word doc contains words (usually in a footnote, but doesn't have
to be), which are keys to records in an Access database. How can these Access
records be displayed when the Word items are clicked, or selected and
clicked? ...
|
3 |
26.09.2006 18:56:02 |
|
|
Where is the If statement going wrong?
Hello, I have the following code which keeps telling me that I don't have an
"End If" defined, but I have the right amount of Ifs and End Ifs. I think
the problem is in the "Exit For" statement because if I remove it and do a
regular If test then it doesn't error out. Am I doing something wrong with
the Exit For? It's only the second time I've used it. Thank you in advance
for your h...
|
6 |
26.09.2006 18:48:02 |
|
|
print ADO recordset in Excel
Instead of Debug.Print rst.fields(0)
how can i open a new Excel workbook and print the field in the first cell?
--
Billy Rogers
Dallas,TX
Currently Using Office 2000 and Office 2003...
|
3 |
26.09.2006 16:59:02 |
|
|
2003 compatibilty
I have an application which is complied at Ver 9 (Access 2000) as an mde
database. I have another application also complied at Ver 9 (Access 2000) as
a mdb database.
If I open the second 2K mdb database using Access 2003 it opens fine but
when this 2K database tries to open the first 2K mde database from within a
vba module using the OpenDatabase statement it fails with error 3041 'Cann...
|
6 |
26.09.2006 16:56:02 |
|
|
Error 3188 - Couldn't update; currently locked by another session
I have an Access 2003 MDE FE/BE solution that is getting an error 3188 on a
specific record. The error only occurs when the user selects the entry and
clicks the "Update" button (the entry is added without any problem, it is
only when they want to update/add aditional text to the memo field). The
code below is what is used to do the update:
dbIASSecure.Execute "UPDATE [Strength]" &...
|
5 |
26.09.2006 18:48:01 |
|
|
Audio when command button is clicked
I am trying to associate very short audio files with command button "click
events". Is there a way to open the Windows Media Player or some other audio
softare to'play' a short *.wav file when the user clicks a command button? I
can code something behind the click event if I could figure out how to start
execution of a generic audio software with a certain audio file. Thanks....
|
5 |
26.09.2006 15:59:03 |
|
|
ADO test for empty recordset
How do i test a recordset before using the fields? Can you simply test for
If not (rst.eof) and not (rst.bof) then
debug.print rst.fields(0)
End If
My only concern with this test is that I don't know if a recordset can open
at EOF or BOF even if it's not empty. I only want to skip empty recordsets
to avoid errors. My recordset is a SQL query.
--
Billy Rogers
Da...
|
4 |
26.09.2006 15:50:02 |
|
|
How to get a control's default value to update when changing recor
I have the following situation:
In a Form, I have an Unbound Control whose Default Value is equal to a Bound
Control in the Record Source, but when I change from record to record, the
Unbound Control does not update (though the Bound Control does). It stays on
whatever Default Value was put in place when the form was first opened. Is
there any way to make the Default Value update itse...
|
3 |
26.09.2006 15:01:25 |
|
|
AutoExec in VBA
How do I write code in a module that will act like an AutoExec macro?
Basically, I need the same results that "sub Auto_open()" would give in
Excel. ...
|
5 |
26.09.2006 14:03:02 |
|
|
ADO print all fields in recordset
I have 80 fields in a recordset and need to print them all. Is there an
easier was to do it than this?
Is there some sort of command that where you say something like
debug.print rs2.allFields ????
Do Until Rs3.EOF
Debug.Print Rs3.Fields(0) & "; " & Rs3.Fields(1) & "; " &
Rs3.Fields(2) & "; " & Rs3.Fields(3) & " ;" & Rs3.Fields(4) & " ;" &
Rs3.Fields(5) & "; " & ...
|
6 |
26.09.2006 13:12:02 |
|
|
Getting the properties of a file
I need to be able to get some properties from files stored on a server (in
particular the date modified and size).
I've come across the FileSystemObject on the TheAccessWeb web site, but it
requires installing and registering dll's and VB runtimes and the like.
Is there another, simpler way to get these properties?
Thanks
Vilem Sova
...
|
2 |
26.09.2006 12:03:23 |
|
|
save email to drafts folder
I have an automated email code and have replaced the line
..send
with
..save
This puts all the emails in the drafts folder which is great but ithen when
I drag and drop them into the outbox they dont move unless i open each one
and send. Any suggestions please...
|
2 |
26.09.2006 11:50:13 |
|
|
How do I disable a form tab using VB
On a form with tabs, Tab1 and Tab2, with both enabled for editing.
If I set a value from 1 to 2 somewhere, how do I get Tab2 to disable to read
only state? It is set to open the form from a VB command....
|
2 |
26.09.2006 11:22:50 |
|
|
How do I access a remote server
How do I get access to query a remote site with SQL to verify information.
Example, Database sends a statement to web based SQL to receive a True or
False response....
|
1 |
26.09.2006 05:04:02 |
|
|
update a main form combo box from subform info
In my main form I have a subform to hold job titles. In the main form I have
a combo-box that uses the titles from the subform as a criteria for a query
to produce a job description report.
Once I have entered a new job title, how do I automatically update the combo
box to include the new job title(s)?
cheers in advance...
|
2 |
26.09.2006 00:21:33 |
|
|
Problems with qureies and VBA
I have a qurey saved in an access DB. in the SQL code for the qurery it
references back to a text box on a form. when the form is open a user will
input a date into this text box. The qurey then get reciepts for that date.
HERE'S THE PROBLEM: If the form is open and the text box is filled out. I
can go to the database window and open a report based on the query just fine.
Howeve...
|
1 |
25.09.2006 23:32:02 |
|
|
Using VBA, can I format data so a web server will regard the data as a struct?
I've been an Access developer for five years now, but I am woefully
ignorant when it comes to processes and technologies outside of
Access/VBA. If what follows is clumsily worded, and if I misuse
terminology, please be patient...
We have an access database that tracks client information and we want
the database to open a session on a website, transfer data to that
website, and receive in r...
|
4 |
25.09.2006 20:29:56 |
|
|
Syntax error on Insert Query
I'm having problems getting a SQL query to run. This append query doesn't
seem to work, and there is something in the syntax, I think, that is causing
it not to work. Any thoughts?
- Jeff C.
DoCmd.RunSQL ("INSERT INTO tblCustomers (ID, Last_Name, First_Name, Company,
Street_One, Street_Two, City, State, Zip, " & _
"Phone_One, Phone_Two, EMail ) SELECT dbo_Customer.custid,
dbo_...
|
3 |
25.09.2006 20:21:03 |
|
|
VBA search coding problem
Hi, I'm trying to develop a search function for my form, and found a similar
code for the website. After changing it, I've almost made the search work but
the problem I have right now is that the pop up function does not
differentiate between a correct ID and an incorrect ID. I think it has to do
with my If.. Else code. It will not do the 2 tasks in sequences. Below is my
code.
rivat...
|
13 |
25.09.2006 19:57:32 |
|
|
Losing the A: Drive.
I have many programs that writes files to the A:\ Drive.
The Clearwin program seems to be the only prgram with a problem.
Here is what is happening. The Clearwin program makes "MPA" disks. Not
important what "MPA" is. The program works fine. The queries fill the table
and then the program creates a space delimited file on a floppy disk.
The problem is: At lest once or twice a week ...
|
3 |
25.09.2006 17:36:02 |
|
|
open word document
My problem is that the coding (below) I have to print a document (from a
template) based on the current record (MSAccess Form) works fine for the
first instance, but after that I get an error message of "THE REMOTE SERVER
MACHINE DOES NOT EXIST OR IS UNAVAILABLE". If I restart the database the
document will print but I get the same error when I try to print any others.
The code is:
P...
|
1 |
25.09.2006 17:25:01 |
|
|
print excel ole object
I'm using/openning excel ole object directly from db (it's saved in a db
table's field).
I'm using the following code:
Set db = CurrentDb
Set rst = db.OpenRecordset(strSQL)
With Me.oleBoundObj
Set oSheet = .Object.Sheets(2)
oSheet.Cells(2, 2).Value = rst![dAvAN]
oSheet.Cells(3, 2).Value = rst![dAvBN]
......
...
|
2 |
25.09.2006 16:24:02 |
|
|
How do I display the Navigation Pane in Access 2007 programatically?
I want to show and hide the Navigation Pane with a button on a form. I
found mention on the web how to close the Navigation Pane by doing
this:
DoCmd.SelectObject acForm, , True
RunCommand acCmdWindowHide
This works just fine, but I can't figure out how to open it again other
than going to Access Options | Current Database | Navigation | Display
Navigation checkbox.
This set...
|
1 |
25.09.2006 16:09:51 |
|
|
Creating multiple text boxes...
In a subform, how do you create a multi box imput field? i.e. -
Date Notes
By this I want to be able to have multiple lines that can be added in this
subform with different dates? i.e. -
9/25/2006 Notes Test One
9/26/2006 Notes Test Two
This are on the Table and I want to have the table and the form to show and
record the multiple entries??...
|
4 |
25.09.2006 14:40:30 |
|
|
SQL or VB find and replace table records?
I have an table in Access that was imported from an Excel spreadsheet. It is
very large and contains about 75000 records. Many of these records are "null"
and the ones of interest are the text character "X". Fields containing an "X"
represent a BOOLEAN 1 (one) or TRUE condition. This "X" character needs to be
replaced throughout the table by a variable that changes frequently. Below is
a...
|
4 |
25.09.2006 12:57:02 |