Linked tables not updating!
Thu, 20 Nov 2008 06:07:00 -0800
I have a db that is acessed from three front end mdbs over the network.
The problem is that all three use the same tables at the same time and when
one creates a new entry i need it to be unique.
I set up a check for unique entry (dlookup) but since the tables are not
updating in real time the check is wo ...
|
Linking Tables Access 2007
Wed, 19 Nov 2008 21:25:00 -0800
I have a data base on the file server and a copy on the remotes. I wish to
link the tables from the remotes to the server. When I start the process
through External Data, Access Button, Import Data and browse for the data
base, I do not see the listings for acccdb file extensions, only files of
type "text". ...
|
Count Value as half
Wed, 19 Nov 2008 16:57:00 -0800
I have a module that counts how many times a word is used in the table
tblInput and show the number in a text box on my form. for this example I
wnat to use the word "Half Day" and have it show in a text box "txtHD". Here
is what im using to show the value as 1 but how do I show it as .5.
Public Function ...
|
Moving Access Database
Wed, 19 Nov 2008 11:52:15 -0800
I set up a database on my laptop and now want to move it to a coworker's
computer, where she would use it and control it. When I try to copy it to her
computer it transfers as read-only. How do I move the database with all
permissions and access to her computer?
Thanks. ...
|
Pass criteria to open report for selected ClientID
Wed, 19 Nov 2008 11:06:02 -0800
I have Mainform with cboSelectClientID and MyReport report based on query
wich includes ClientID field.
On the Mainform I've put command button and programmed it on click event as
follows:
Dim strWhere As String
strWhere = "[ClientID]=" & Me![SelectClientID]
DoCmd.OpenReport "MyReport", acPre ...
|
program changes document
Wed, 19 Nov 2008 10:28:05 -0800 (PST)
I just wanted to know any one uses user request form for program
changes from your users.
If you have can you please give a me a kind of example?
Your information is great appreciated,
...
|
program changes document
Wed, 19 Nov 2008 10:27:59 -0800 (PST)
I just wanted to know any one uses user request form for program
changes from your users.
If you have can you please give a me a kind of example?
Your information is great appreciated,
...
|
|
|
Data base edit within Excel (2000 user)
Wed, 19 Nov 2008 10:15:01 -0800
Hello all,
I'm Excel 2007 and am trying to link a DB. In Excel 2000 when linking the DB
it would ask you if you wanted to edit the query in Microsoft Query, how do
you get there now? I can find it.
Thanks
...
|
Count Check Box
Wed, 19 Nov 2008 10:04:00 -0800
I have a form (F1) which has a section that lists three check boxes (EL,
Admin, Other). On another form (F2), is it possible to count how many of
those three checkboxes are checked on all records in F1?
In F1, there is another checkbox (Corrected) which I would also like to
count how many records are checke ...
|
export table relationships
Wed, 19 Nov 2008 06:57:55 -0800 (PST)
anyway to export table relationships to another MDB etc?
sorry if this posts twice... ...
|