to specify a read-only Recordset in Access 2003 Visual Basic
Wed, 3 Dec 2008 20:07:02 -0800
I'm trying to program a Database with Access 2003 where Several Rotas may
occur on a Weekly, 2-Weekly or Monthly basis staffed from a pool of
volunteers.
More than one rota, coded A, B, C (for example) may occur on the same Date.
The Rota Table's primary Key is Date and RotaCode.
A Volunteer may not appear in ...
|
code to unlink a table?
Wed, 3 Dec 2008 16:09:01 -0800
I want to link to a table, run a query, and then unlink from the table.
I have the code working to link to the table:
DoCmd.TransferDatabase acLink, "Microsoft Access", _
"c:\data\db.mdb", acTable, "sourcetbl", "linktbl"
Does anyone know how I can unlink (in code, not by clicking)?
Thank you,
...
|
Second click on Tab Control page/tab re-runs OnChange event - Prev
Wed, 3 Dec 2008 15:36:01 -0800
Hello
I have a tab control on a form that displays records selected from a drop
down.
The On Change for the Tab Control is
Private Sub TabCtl0_Change()
DoCmd.Requery
End Sub
Which works fine.
However, if a user clicks one of the tab/page and then clicks the SAME
tab/page (ie the one that is ...
|
Bookmarking
Wed, 3 Dec 2008 15:18:02 -0800
Hi,
I am trying to setup a subform double-click event on a textbox to set the
focus on one of the main form's tabs forms and then goto a specific
recordset. Here is what I have but which is not working.
NumChng = Me.[ChgNum]
'Move focus to the appropriate control
Me.Parent.[118-Changements M ...
|
Linked table problem
Wed, 3 Dec 2008 14:14:33 -0800
We have two different Access databases, the SAR database and the Use Case
database. The SAR database has code to "kick out" users which needs to be
done daily in order to make code changes and/or compact & repair the db. The
Use Case db wants to link to a table in the SAR db to provide information for
a re ...
|
Touch screen
Wed, 3 Dec 2008 14:03:33 -0800
Is there a way to create an on screen keyboard to be used with a touch screen? ...
|
Turn On Num Lock
Wed, 3 Dec 2008 11:26:38 -0800
How can I turn on the "Num Lock" key with VBA, XP?
Thank you
Ross ...
|
|
|
Multi Select List Box
Wed, 3 Dec 2008 11:06:52 -0800
I am using a multi-select list box to populate a table. I have items that
undergo several different tests and I add a separate line for each test in
tblTestDetail. I have successfully written the code to add these records. My
problem is I would like to edit these records. Ideally I would find the item
and al ...
|
Calendar Help
Wed, 3 Dec 2008 10:52:05 -0800
I am designing a form the will allow the user to enter in time worked for
variouse different items. Each row will contain the item and hours. I
also need to use the calendar to allow them to select the friday of that week
and have the form then show the dates for that week as heading on the column
and to ...
|
VBA To Import Tables
Wed, 03 Dec 2008 18:28:31 GMT
I have a project that I have been assigned where I need to import about 100
tables from an ODBC database daily, run a query on these tables, and then
delete the table. The table names are all located in a table on the database
titled Catalog Update and the column/field is title Tables. I am pretty new
to VBA a ...
|
