Recent content by mjesser

This is probably a simple question but it hasn't worked for me yet. I have a lot of data kept in a quote details table and I would like to copy exactly to a new record from a previous record when I call it up on a form. There is a control function for "duplicate record" but it didn't work on the...

Is there a simple way to ask a user how many days he would like to see data for, and then have a formula to take the user input value and subtract it from today's date to receive records for say the last 30 days, or 15 days, etc. Currently, I have them entering the beginning and ending dates...

I guess you just explained that gnawing feeling in my gut. Thanks.

I was using the Autonumber field to automatically assign the next "quote no." to the record. The problem was that I form assigned the next number to the record, but it didn't show in the underlying table. I was able to work around by creating a new table with the records that I wanted with...

I have entered data in a form and it assigned it an Autonumber field, then when I went to check the main table the data was gone. The problem is that the Autonumber is a unique project number. I have tried to delete some records on the bottom and compact the database but the database seems to...

I am using Autonumber as a data type for a Project# field. I created a form to enter the new projects and it worked fine until I changed a field REV to required in the table. I didn't have this field shown on my form as it was supposed to default to "A". The form appeared to work and it gave...

I am trying to import a rather large excel spreadsheet into a new table in a database I am creating. When the data is imported, it changes my formatting on 2 of the columns from date to number, along with it changing the data to a text string. The strange part is I have 4 columns in a row with...