Recent content by Jaysc

No, I'm doing date and time fields separate as that is how the data was given to me by the company. Ex: ------- Date Time Minutes ------- What I want is to specify a time range between 9pm and 5am for the time field and only have the records show up that fall outside of that range...

Hi all, working on a simple DB for myself involving cell phone records. I'm wanting to write a query that will ONLY display records that start the call before a specified time (in my case, 9pm) and until another time (say, 5am). I can't quite seem to get the parameters working that will filter...

1. I set the combobox that way on purpose so that it wouldn't also display the MinerID field. I just have those for internal data sorting/display purposes, it's all going to revolve around the actual name. 2. On this, I'm a little confused. Shouldn't the subform that contains the...

*sighs* Found out the issue. I had bound the combobox to Name, so erasing that and turning it into an unbound box has fixed up ALL of my problems, except a persistant one that dates back to my original DB. When I enter a new name in the combobox, it assigns the records of the first name...

The MinerID is an autonumber, yes. The name field in tbl_minerID is what is suppose to show up in the cbo_name combobox. Tried your fix(es), but I'm still having issues. Doing the first fix, I find that it will enter the name in, but I now wind up with a whole slew of errors and problems...

Now, I'm not a (complete) newbie when it comes to Access, but this is stumping me to the point that my head hurts from the desk banging. :p There are two tables in the database, tbl_minerID and tbl_collection with a one-to-many relationship from tbl_minerID to tbl_collection. tbl_minerID...