A Mind Of It's Own?
Jan 16, 2007
I have a simple, simple query based on a linked SQL table with a date/time field called "CHANGEDT." All I want to do - as I have done many times before - is to set criteria for that field of Date()-10 (records changed 10 days ago). Every time I get an empty data set, even though I know there are records in the table for the target date. There are no other criteria in this query, no linked tables or anything like that - just a siiiiiiiiimple query! Sheesh!
What would make a query NOT respond as expected when calculating a date 10 days in the past? I'm thinking that my frustration is causing me to overlook something obvious.
Thanks-
SLH
View Replies
Nov 30, 2005
Ok... I have notice that every body and their dog has asked this question and reading all the other posts has helped me along. However i have hit another roadblock. I know that IT IS possible to have a combo box that, when an item is selected, selected fields are automatically filled. Is it possible though to have those auto filled fields retained when a new record is selected in the form.??
Eg.
I have a table with model#s of a product aswell as unique properties of each model...I set up a form with a combo box to select the model# and auto fill the properties of that model into the fields below. when i change the record (record selectors <- ->) the combo box and related fields stay the same. can i make it so that each record is saved idividually and still use the autofill by combo box ....
man i dont even know if this is gonna make sence to anyone...but if it does any help would be extremly appreciated.
thank you
View 2 Replies
View Related
Mar 8, 2008
I've looked at so many options for writing this query that I can't see the forest for the trees and hoping you kind folks will point me in the right direction.
I have a table called services that includes:
service_id
prop_id
service_year (ie: 2007, 2008)
service_date (ie: 3/3/08)
service_id is a unique ID for each service which relates to data I will need to pull from another table.
prop_id relates to a property ID in another table, not unique as multiple services against one property.
The problem that I have is that each prop_id can have more than one service_date for the same service_year. I need to be able to find the latest service_date on a prop_id and its associated service_year and service_id.
Any pointers would be greatly appreciated. BTW, using this in Access 2003 & 2007
View 14 Replies
View Related
Mar 11, 2008
Hello all,
Using Access 2003, I am creating a db that tracks computers along with what switch and port they are connected to.
I have 5 different networks along with 31 switches.
I have a cascading combobox, in my form, that gives me a list of what switches correspond with the network chosen.
What I would like it to do is give me a list of ports that are open/available based on the switch (available ports ranging from 24 to 48 based on the switch).
Creating 31 tables is a little excessive and I really don't want to have to do that.
Tables I have so far:
tblComputerMaster -
tblNetwork
tblSwitch
along with a few others that don't pertain to the question.
I can dummy down my db if someone needs an example. If anybody has any ideas on how this would be possible I would really appreciate it.
View 14 Replies
View Related
