Search results

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...

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...

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...

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 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.

I've got this bit of code that is giving me a hard time. If IsNull(Me.txtCustomer.Value) Then strCustomer = "Like '*'" Else selectcase Me.frmCustName.Value Case 1 strCustomer = "Like '" & Me.txtCustomer.Value & "*'" Case 2 strCustomer = "Like '*"...

OK, I have made some good progress on this program, but I've found a flaw in my thinking. I'm using a SQL string to call a query. In that SQL string, I'm using a lot of If/Then statements. It's working the way I want it to work. You generally have three choices Yes, No, NA. If it's Yes, it...

I'm in the process of writing a query to search for multiple attributes of our projects. I've been able to write the code to run the query for all of the information I need that is in my main table. I now need to add a bit of code to search for some information that is in a secondary table...

I actually have two questions. 1 - Is there a limit to the number of operators in a sql string. In other words, how many times can I say AND or OR? 2 - I think a little background is necessary. I have a table that includes a wide variety of mechanical information regarding a product we sell...

OK, bear with me. I am a total novice at this stuff (access, SQL, vb). I am working on creating a form that will allow me to query our project database based on several varying criteria. I get the idea of creating a query on the fly, and I can get this to work for the data we have that is in...