Recent content by JustPunkin

Great responses, thanks everyone. You have given me a lot to look into and research. I'm sure I'll be back with more questions!

I suspect this is a pretty basic question, and I also suspect I know the right answer, but would like some confirmation. I have created a database that will store various features of our product. I have a backend that contains the tables. I was in the process of creating one front end that...

I am not looking for criticism for the reasons behind what I am doing. I am simply doing what I was asked by the people who need this database. Essentially, there will be very few times the user will need to enter more than one record; so I'd like to limit it to just one record at a time, and...

I think that may be exactly what I am looking for. That way they are not working live in the table, but rather adding to the table after they are done entering the data.. right?

Is there a way to restrict a user to only entering one record when entering data on a form. I've removed the record selection buttons, but still run into the problem of a user hitting enter in a field and having it move to a new form. I'd like to force the user to only enter one record at a...

That would be me. Glad I've been able to help you on AUGI. Sorry it's been so long to reply to this, but I've been doing actual AutoCAD work lately, so my database has gone by the wayside for the time being :)

Thanks so much. DateDiff was just what I was looking for.

Thanks, I'll have a look at that tomorrow.

It appears that, after entering an issue date, the document no longer shows as due, so I think it's going to be OK. I hate working on projects that other people have started; they never do things the right way - you know, the way I would do them :D Thanks again!

she just wants to be able to run a report that will show what documents are late. There are no flags or anything like that. The query searches to see if the field for issue date is null (which means nothing has been sent) and if so, checks those records to see if the submittal date is prior to...

Working on a project where we want to return a results of how many days overdue a document is. We have a submittal date (which is the due date). I want to query all overdue documents (which I already do), but in that query, or the report of the query, I want to show how many days late a...

It's not as simple as setting the criteria for Submittal Date " < (Now) " is it?

I'm not even sure where to begin with this question. I am trying to come up with a query that will report on documents that have a submittal date prior to todays date. We have a database that tracks when drawings and documents are due. I've designed a query that will allow me to return...

I did not ask the original question in this thread; I asked the question in the thread that I created, the one I linked to. This thread simply led me in the right direction for a solution.

I tried a few times, to no avail. I found a solution and it seems to be working. I have posted it here