Combo box connection with code
Thu, 21 Aug 2008 13:33:01 -0700
I know I close. It displays the number of the first column which is the
autonumber. I want it to display the text in the field called FileLocation.
Private Sub CboFileName_AfterUpdate()
Me!txtFileLocation = Me!cboFilename
Endd Sub
Thanks
...
|
How to open a file.
Thu, 21 Aug 2008 19:54:58 GMT
I have an event that I need to use to open a file as well. Here is the code
and the file location is F:/MyExcel
Private Sub Command63_Click()
On Error GoTo Err_Command63_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "CT2 Paperwork"
DoCmd.OpenForm ...
|
Change Text in Textbox based on Combobox Selection
Thu, 21 Aug 2008 12:30:01 -0700
I am trying to base the text in a Textbox based on a Combobox selection. I
have the value of the combobox tied to a query I built in the query builder.
I can get it to display the first value i select, but it won't do anything
aftet this. I have tried requery commands in VBA but the ones I tried didn't
work. ...
|
after update doesn't update secondary field
Thu, 21 Aug 2008 12:01:06 -0700
I have a combo box that when Afterupdate is actioned, updates two fields
using the code below. This all works fine; but if I change the master data
elsewhere the only field that updates is the combo itself, but I want the
other two fields too update as well just like it does the first time when I
manuall use ...
|
Open Form unfiltered
Thu, 21 Aug 2008 07:51:00 -0700
I just installed Access 2007 the other day (had 2003 previously) and it
introduced a problem that I can't figure out. I have a form (Form1) with a
button that opens another form (Form2). It used to open Form2 in an
unfiltered state, which is what I want. Since installing Access 2007, it is
now opening For ...
|
Access 2002 .adp subform linking using stored procedures
Thu, 21 Aug 2008 06:46:01 -0700
I have an access subform that used to have a recordsource of a SQL Server
View. I am running into sorting issues with SQL Server 2005 and need to
change the view to stored procedure. The stored procedure returns a sorted
recordset without requiring any parameters. I change the recordsource on the
subform ...
|
upgraded Access from 2000 to 2003; subform not working
Thu, 21 Aug 2008 04:56:00 -0700
I built a simple Access database several years ago using Access 2000. When
we upgraded our software to 2003, the subform population (driven by a combo
box in the form) stopped working. I had to make an adjustment on every PC
that would access this database. We have since had a PC to crash and I
cannot rec ...
|
|
|
Open form with Command button Error
Thu, 21 Aug 2008 04:47:01 -0700
Hi All,
Using Access 2007. Here's the code i have for the on_click event of a
comand button:
Private Sub OpenCustomer_Click()
On Error GoTo Err_OpenCustomer_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "ManageCustomers"
stLinkCriteria = "[AccountNumber] ...
|
Code mysteriously runs on wrong form
Thu, 21 Aug 2008 02:31:07 -0700 (PDT)
Hi everyone
I'm trying to get hold of some mysterious behaviour when opening one
form (F2) from another form (F1). By doubleclicking in the first form
(F1) in a datasheet view subform (SB1F1) and attaching code to the
doubleclick event I open the second form (F2) and navigate to the
current record in the subf ...
|
scramble / unscramble text
Wed, 20 Aug 2008 21:50:17 -0700
Hi...
I have a need to save some text record in a file external to Access. I
write them out, and read them back in again from different forms in my
Access application.
One of the records contains a password (nothing to do with Access --- it's
the user's SMTP password for the email system).
On the for ...
|
