Design questions Acess 2007
Fri, 31 Oct 2008 07:13:12 -0700
access 2007
I have been asked to create a database of servers in a data center. It's
realitivly small center with about 250 servers. I need to track things like
IP address, Maintenance window. Rack and space in the rack. Location etc.
(The maintenance window has me a little stumped) This should be a time ...
|
configuration
Fri, 31 Oct 2008 05:01:00 -0700
Every time i open a document office enterprise star doing de configuration...
how can i stop that? ...
|
Next and Back functionality?
Thu, 30 Oct 2008 11:41:18 -0700 (PDT)
I have an Access 2003 form that displays four computer labs and what
is scheduled in each room for a given day. At the top of the form is
todays date and below that are 4 data sheets (one for each lab)
showing the events taking place in the lab for that day. What would
make this even more useful is if at the top ...
|
Newb Query Question
Thu, 30 Oct 2008 09:41:05 -0700 (PDT)
I am using Access 2003. I am trying to create a query that returns
only records for todays date. I've tried now() and date()
unsuccessfully. Can someone give me hint on what to try? Thank you. ...
|
Return one from many
Thu, 30 Oct 2008 07:58:20 -0700
Lets say we have a table containing names and their heights. In the table
there are 10 John's and 10 Mary's all of varying heights, how would one query
this table in order to return only the one John and the one Mary whose height
is the smallest?
Thanks ...
|
Run Time Error #35601
Thu, 30 Oct 2008 07:01:01 -0700
When accessing my form I receive the Run Time Error #35601:
Element Not Found: Possible Causes: You selected a table/query for a child
level which does not correspond to a value from its parent level.
Can someone explain to me what I may do to fix this?
Thanks
...
|
Count days minus days in table
Thu, 30 Oct 2008 05:42:02 -0700
Hello, Im using a module that I use to give me the total days from a start
date from my table named tblPlantInfo. I have a text box on my form to
display the number of days using a test box on a form and its Default Value
is ShowLastLTI(). This is a date that will not change unless we have an
accident and th ...
|
|
|
Combo box-Not in list
Wed, 29 Oct 2008 21:35:00 -0700
I have a Combo box setup to Display last names of People. What I am having
trouble with is everytime I try to add a name that isn't in the combo box
list I get an error saying that the nname is not in the list. Can someone
help?
Scott ...
|
Report numbering based on YYWW##
Wed, 29 Oct 2008 15:34:00 -0700
I am trying to figure out how to create a numbering system based on the year,
week #, and two numbers starting from 01 through 99. The format would be
YYWW##. Lets use today as an example; 10/29/2008.
Since this is the year 2008, the first two numbers would be 08.
10/29 is in the 44th week of the year, so ...
|
unanble to compact dbs
Wed, 29 Oct 2008 15:15:39 -0600
Suddenly I cannt compact/repair any of my dbs
I get the following error:
MS Access can't delete <path>\mydb.mdb after compacting it. The compacted
database has been name <path>\mydb.mdb
Thank you all,
Bre-x
...
|
