Search results

I have completely forgotten how to create a form that will olny allow the user to add a new record into a table...and will not let them view or change any of the existing records. Kind of like a sign up form. Where they enter their info, hit enter and it stores in an existing table as a new...

How would I pull a field from the last entry of several records to put into a report? The table will be updated 3x per week, so I'd always like to have the report reflect the most current data. I think I saw an expression on here before, but can't find it? Any help would be greatly appreciated.

O.K. Here's another one. I have a database that has phone numbers in the (XXX)XXX-XXXX format, but in the table properties it's not set up with an input mask or validation rule (Just limited to 13 characters). I believe the input form was set in the (XXX)XXX-XXXX fomat. Whickh explains why...

I'm doing a database merge, but the one of my merge fields from the old database was set longer than the new one. Does anyone know what criteria I could use in my old database to run a query that would find any records that have more than a certain amount of characters in a field so that I can...

Can anyone give me tips on creating a form with a text box that will populate the criteria field in a query and have it run upon submit and display the results in a table?

You guys are probably gonna laugh me out of this forum, but I need help! I haven't used Access in over 5 years and I used to think I was pretty savy, but no more. Anyway, here's the scenario. I have a CUST table and an INVENTORY table They both contain CUSTID fields. The CUSTID in the CUST...