'Seek' function problem
Wed, 24 Sep 2008 22:46:01 -0700
Hi. There must be a simple error here but I just can't see it.
I have a table wih two columns, "Diagnosis" and "DiagnosisCode". The
PrimaryKey is the column "Diagnosis".
I'm trying to get the DiagnosisCode associated with a "Diagnosis" using Seek:
Set db = CurrentDb
Set rs = db.OpenRecordset("tbl ...
|
higher of two values
Wed, 24 Sep 2008 17:24:02 -0700 (PDT)
I'm trying to populate a field with the higher value of two other
fields and am not sure how.
field 1 = [buy rate x 15%]
field 2 = [buy rate + 25]
field 3 = higher of the two values
is there a way to automatically populate field 3 with the higher
value?
any ideas are greatly appreciated.
Steve
...
|
InlineShapes
Wed, 24 Sep 2008 13:43:01 -0700
Good day,
I'm trying to modify this vba code;
ActiveDocument.InlineShapes.AddPicture
"C:\AAOForms\signatures\amko.jpg",
LinkToFile:=False, SaveWithDocument:=True,
Range:=ActiveDocument.Bookmarks("Picture").Range
so that instead of using images from hard drive I can use images that are
saved as an OLE fie ...
|
unbound combo box with invisible entries?
Wed, 24 Sep 2008 12:10:06 -0700
I'm working with an unbound combo box to move to a selected record in a form.
I've done this plenty of times before but have never encountered this
problem: though the record source exists, it does not display.
The combo box shows up blank with a blank dropdown and the correct number of
blank lines for ...
|
changing subform source object
Wed, 24 Sep 2008 12:09:04 -0700
Access03/WinXP
A form allows a sales rep to select a Trade Name and assign it to a specific
company. When a Trade Name needs to be added to the underlying source table,
an admin person has gone into the database window and opened the table to
enter in new information; the table is accessed by a label on th ...
|
Slick SWB Toolbar screwing up my insert into command
Wed, 24 Sep 2008 12:05:01 -0700
I downloaded the Slick Switchboard from the internet and it's screwing up my
INSERT INTO command button. I want to keep the switchboard but it's having
issues because it doesn't see the "documents" form. Here is my code:
DoCmd.RunSQL "INSERT INTO tblDMP (DataItemName, Type, Format_Tool,
StorageLocation ...
|
Populate list box column
Wed, 24 Sep 2008 11:42:01 -0700
I have a listbox with 3 columns that populates when the form opens. I'd like
the 3rd column to populate depending on the results of an if then statement,
but I'm having syntax trouble.
Here's the gist of what I'm trying to accomplish:
If table1.field5 = "dog" then
list box column 3 = table1.field2
else ...
|
|
|
Launching another MS Access application within code
Wed, 24 Sep 2008 17:46:51 GMT
Does anyone know how I can close an existing Access application and
automatically launch another one at the same time using code in a button
click event? The following code doesn´t seem to work...
Private Sub cmdClose_Click()
' Launch the new access application
Shell "MSACCESS.EXE " & sDestinationFolderF ...
|
How to refresh a form
Wed, 24 Sep 2008 10:44:05 -0700
I have a form control that is a lookup based on data that is input into the
previous control. How do I get the data in the second control to appear as
soon as I have input data into the first control. I've tried me.refresh in
the on enter event but it doesn't seem to work?
Thanks
Tony ...
|
Help relinking tables
Wed, 24 Sep 2008 10:34:23 -0700
I need to make a form with a button that allows the user to relink tables to
a different Access database on the fly.
can someone help?
thanks
Al ...
|
