Recent content by ssgagosto

Yes Yes Because of the way I designed it, it will be easier for me to make a form to edit the eventCheckDesc1, 2, etc. I know it sounds nuts, but in tblEvent, I only care if there's a '1' in the field for the eventCheck1, 2, etc. Any other number is irrelevant. But it works for my...

If you'd rather not use the switchboard, you can do something like this: 1) Create an autoexec macro that opens your desired main form 2) For your main form, create an On Load event with the following code (but don't execute it yet) Private Sub Form_Load() DoCmd.SelectObject acTable, , True...

I have multiple tables I'm going to be putting into a query, but I'm getting stuck on one thing. I have a main table called 'tblEvent' with data similar to the following: eventID | eventCheck1 | eventCheck2 123 | 0 | 0 124 | 1 | 0 125 | 0 | 1 126 | 1 | 1 ...which is related to a table called...

After playing around a bit, I ended up getting it. I used a query looking at max date, max time and number+1, then used dlookup to display the number+1 value. I seems to be exactly what I need. Thanks for steering me in the right direction. I just started to learn access a week ago. Thanks!

I realize what you're saying and understand. I was playing around with a query that reference the table that my form source derives from, and takes the max of date, max of time and takes the tgtnum+1 and give me 3 fields showing one date, time and number(+1), but since the form source comes...

I've got a form that is used to enter specific data. The first box is a number associated with the total record. I already have an autonumber formatted ID column that is unique per record, but the record number is formatted as a number and allows duplicates. The validation range for it is...