putting a function in directory path VBA
Mon, 27 Oct 2008 11:43:02 -0700
I have a function that I created which returns the machines name
=GetUserName
Now I call a shortcut to start a program from within Access,
Application.FollowHyperlink "C:\Documents and
Settings\USERNAME\Desktop\Shortcut.lnk"
The MACHINENAME is going to be different for everyone that uses it, how can
...
|
Conversion to A2007
Mon, 27 Oct 2008 11:43:01 -0700
My client decided with no notice to convert to A2007 today from A2003...25
tables, 200 queries, etc....
Anyway, I've gotten in and solved a few issues, but one is being difficult.
I have a text box on the main form (in a tabbed control) that refers (in its
control source) to a subform as follows:
=IIf(sfm ...
|
Loading Combo Boxes on a Continious form
Mon, 27 Oct 2008 11:18:31 -0700
Hello,
Iâ??m looking for some direction. Iâ??m developing a survey tool in MS Access
2003 for a local department in our organization. For the survey setup, I
store the questions in one table and the valid answers for the questions in
another table, each question could have a different set of valid answers. ...
|
Tab Subforms
Mon, 27 Oct 2008 11:18:21 -0700
Hi,
I have a form that uses tab control to switch between multiple subforms.
Each subform references a different table as a recordsource. I have no
trouble using refresh/requery on combo boxes to reflect additions performed
in one subform and another.
I can't get this technique to work when a value is edite ...
|
Locking individual records
Mon, 27 Oct 2008 10:36:12 -0700
I'm attempting to use SharePoint 2007 lists as tables for an Access
application (long story). My understanding is that Sharepoint doesn't do a
very good job of handling record locking, so I thought I might try to
implement my own.
My concept was that I would lock each record, as it is displayed on the fo ...
|
Records question
Mon, 27 Oct 2008 08:27:02 -0700
I have the following code in a new database to list records on form current.
How do I use this code when there are no records as this is a new database.
Me.Dynaset.MoveLast
Me.txtRecordTotal = Me.Dynaset.RecordCount ...
|
Update form with newly added data
Mon, 27 Oct 2008 08:16:01 -0700
I have a form (frmCustomers) with a combo box. I have code in the combo
box's Not In List event that opens a form (frmAddCustomer) so users can add
new data. What I'd like to have happen is for the data in frmCustomers to
update to the newly added data as soon as frmAddCustomer closes.
Any help is appre ...
|
|
|
Unexpected variable or procedure, not module
Mon, 27 Oct 2008 07:47:02 -0700
I worked with this database on my old computer without a problem, but on my
new computer I get a an error message for each on current event.
The expression On Current you entered as event property setting produced the
following error: Expected variable or procedure, not module.
The on current event is simple: ...
|
2 opening arguments
Mon, 27 Oct 2008 07:36:01 -0700
I am attempting to open a form from a continuous form. I can get the open
statement to work when I have 1 opening argument, however, when I combine I
get a Runtime Error '13' Type Mismatch. This is the command I am using:
DoCmd.OpenForm "frmNonCountablesEdit", , , "[TestID] =" & Me.TestID And
"[BoxNumber] ...
|
Null coding
Mon, 27 Oct 2008 07:14:05 -0700
I have a form that will create a new form if one has not been created or go
to the existing form if one has been created, this code used to work now it
does not.
I am not sure what is wrong with this code
If IsNull(Me.txtRWNId) Then Call Create_RWForm Else Goto_RWForm
In all cases now a new form is create ...
|
