Recent content by thundermane

I just discovered, tabbing to that text box works fine. But when I click on it, Access insists on displaying it as "hh:mm:ss AM/PM"

Sadly, it still does. It only happens when there is an already existing value and I try to edit it. For new records it works fine.

In order to make data entry faster on my form, I have the following: txtUseTime (on form detail, continuous) ControlSource = [UseDate] (date/time field, stores both date and time) Format = "Short Time" InputMask = "00:00;0;_" (short time) GotFocus event = removes the date part of any existing...

Yes, but my combobox is not unbound. It is bound to its own underlying field in the subform. Only the RecordSource is blank at certain times. Anyway, I do understand your point. I've done all your recommendations. I'm just faced with other problems at the moment. Thanx again for the help.

OK, thanx. I didn't know that's wrong. I just figured, since I want to implement a rudimentary inventory function for Products later on that I just have to separate that table from Extra. Despite my wrong way of doing things, I noticed a couple of things over the weekend: 1. When I sort Type as...

That Continuous Form Combo example you gave may not be working right on my Access 2007. I changed the first record to Category4 then clicked on drop down arrow for Service but it still shows the choices for Category1. On my database file though, changing Type immediately populates the correct...

I believe I can attach a zip of the file. Please check this out. Open the main form 'Transac Cont' and look at the details below on the first record. On the 1st detail, the Type is 'Main Service' and Subtype is correctly blank. But on the 2nd, the Type is 'Extra' but Subtype is blank as well...

On a whim, just now I tried that same Select Case statement on the Load event. It doesn't work either. Combo2 remains blank where there is existing data. Though clicking on that blank Combo2 suddenly shows it.

Both Combo1 and Combo2's ControlSource are tied to their respective fields, namely Type and Subtype, both numeric. They are both on a subform. But since Combo2's value can either be 0 (if Combo1's value is 1) or come from 2 different tables (if Combo1's value is either 2 or 3) I left its...

Hi everyone, Sorry if this was asked before, but all I could find were posts regarding not working comboboxes. I have two combo boxes on the detail of a subform. Combo1 is a value list, called Type, with 2 columns, Boundcolumn 1, and the list something like "1;Main Service;2;Extra;3;Products"...

Wow, thank you very much! It really is a lot more complicated than I thought. Not being a programmer, it is going to take me a while to study your code. I'm just doing this to learn something new while trying to automate a few of the tasks here in my little home business. Thanks again.

Thanks for the help. Here is the DB...

Thanks for the reply folks. @Brianwarnock: That's actually one of the problems I've encountered. I guess it doesn't really matter, as long as I could group to the last record that is nearest to whatever grouping number I choose (yes, the 5 could change). Even if the 3rd record had "3" I would...

Hello everyone. I have a names table linked to a 2nd table where I have a date/time stamp field and a quantity field. Is there a way to summarize the quantity field for every n, and show the corresponding date/time stamps? For example, I have these data for a guy named "Stephen" Date/time...