Searching for DB
Wed, 20 Aug 2008 14:18:57 -0400
I recently upgraded from Office 2000 to Office 2007. When I launch Access
now, I get a message "searching for referenced file utility.dba," which is a
dba I don't recall. How do I get rid of it so it stops searching for the
dba?
I'm using XP.
Bob
...
|
Convert Long Time to double
Wed, 20 Aug 2008 08:22:03 -0700
Hello,
On a form I have two text boxes that contain different times, the text boxes
are formatted as Long Time.
Text114 is the system time. JETime is a time stamp.
I need to convert these two long times to doubles so I can compare the values.
Something like:
Dim NTime As Double
Dim JET As Double
...
|
Print a Single Label
Wed, 20 Aug 2008 07:18:54 -0700
Folks
One of my users lost an un-backed-up (aaaggghhhh) database, which he was
using to print labels. I don't know Access at all, but I've managed to
re-load information by importing from a spreadsheet, and have used the Label
Wizard to create the labels.
My big problem now is that I don't know how to p ...
|
Total noob question
Wed, 20 Aug 2008 06:18:00 -0700
Hi,
I have a requests table and a shops table and the shop name field is linked
in both tables. When I choose a shop on the request table, I'd like the phone
number and contact name from the shops table to come up automatically. What's
the easiest way to do this?
Thanks ...
|
Errors from the Expression Builder
Wed, 20 Aug 2008 02:13:01 -0700
I'm trying to create a form where users can input default values for certain
fields for all new records, since they will be creating lots of records with
similar data, but it will change too often to use a global default on the
underlying table. It seemed simple enough in principle: I have an unbound
contro ...
|
Summing Fields
Tue, 19 Aug 2008 08:21:01 -0700
This hopefully is a very simple answer but I just can't seem to get it. I
want to track my orders with my venders. I'm trying to use a Main Form/ Sub
form format. The main form has my vender and ordeer fields from that table
and my sub form shows the order details (I.E. Quantity, description, unit $.)
I ...
|
How to make a series minimizable text fields in one view pane, to.
Tue, 19 Aug 2008 08:00:12 -0700
I am looking for a way to create a 'database' notebook of many
minimizable/expandable text boxes. The idea is to have one place to track
work done on numerous related tasks, and the minimized version of each
section should ideally show three lines: the title of the work area, date
last addressed (and by wh ...
|
|
|
Link table fields
Tue, 19 Aug 2008 06:51:01 -0700
I'm using Access 2003. First database design.
Database is for courses employees go on. So each course will have many
employees and each employee will go on many courses. I have a table of
employees and a table of courses. I also have a link table with 2 primary
keys - employeeID and courseID. In the info I go ...
|
Dlookup returns AutoNo
Tue, 19 Aug 2008 02:21:50 GMT
Hihi, I have been trying for days.
I'm using dlookup but is returns the autonumber of combo box.
I have simplify it and here is how it goes,
I have 2 table name [tbl_Process] & [tbl_Stations]
[tbl_Stations]
Auto= AutoNumber(primary)
Stations=Text
[tbl_Process]
Auto=AutoNumber(primary)
Model=Text
...
|
Creating a query to show the most recent "many" entry
Mon, 18 Aug 2008 23:44:27 GMT
I have a Notes table linked one-to-many with the Clients table. The Notes
table has a date field to record the date a note was made. I'm trying to
create a report that will show me just: client name & the age of the most
recent note entry. I don't know how to make a query that will select JUST
the most recent ...
|
