Search results

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

I believe I have found the solution to this problem. After realizing that it was most likely a windows issue instead of an access issue, I did a little more research. Apparently, this is by design. From the Microsoft support page I have found this: Symptoms: After you programmatically...

This is an old post, but it's given me a direction to look on my very similar issue. I have all of my reports set up to print landscape, but they all preview and print portrait unless I go to printpreview and change the property in the printer. I'm using XP. I can't test it on 2000, but I'm...

I went in and changed my default printer to landscape, and it seems to have fixed it. I guess I wonder why it doesn't take the page setup in the form. Is there a way I can override the default printer and have it take the setup the way I have it in the form? Why do I always type forum instead...

I have all of my reports set up to preview and print in landscape. When I run the report, the preview and print are in portrait. I have looked, and there is a suggestion to change an option for "Name Autocorrect". I have tried that to no avail. Any other suggestions? Access 2003 SP2.

:o Thanks. That was quick and easy.