I would like to know if there is a way to retain records of deleted items? I have two tables: one for assets, the other for employees. Within the same form...

Any guidance would be really appreciated. First, I have had some great suggestion from the query group but I am still having such a hard time with this I just...

Hi - I have a A2k3 db which is used to record project details...but it is static in design. It is able to track project details and milestone dates as...

I'm trying to measure points on an image and need to have better control of the mouse pointer. -- AccessRAM

Hello. Listed below are three tables that I am trying to solve a duplicate value problem. The FRMID is the primary key. I use the Provider table as a lookup....

I have added datetime picker on to user form and I want this to be saved into the field called date in the table how can I get this to stored. Is there...

I am trying to write a function within Access to add a number of days to the current date. However, I want the returned date to only be a weekday; never a...

I currently have a database that we use to record Donations, currently as you add donations new records are created as it should. The problem is if we have a...

Is there any way that you can create a column in the table that references the column before and finds the answer based on this? I am currently creating a...

I have made a DAP showing invoices and stuff. However, I get duplicates of the second level group, probably becase there are two entroes. Is there a way to hid...

I am looking for a template or help setting up an employee journal database that needs to include Name, Employee #, Hire date, with space for a...

How should I design the tables/queries? I have an action item list that I want to put into access but it isn't always one line per action item, not sure how...

I have created a Call Tracking Database that I want to see the historical comments in a different field. I create a Comments field where text can be entered,...

Not sure if this is the right place so let me know!! My company has a access app that is having a problem, it does a DB for each year,since its 2006 we need...

I get a comma delimited file that I throw into an Access DB One filed is a combo of things department, user, group example: 320 Hurst, T ADM 320 KERNER C...

Over a year a go I got the error "your Microsoft Access database or project contains a missing or broken reference to 'dao2535.tlb" version 3.5. The database...

I have two tables (tblClients and tblEmployees). Field in tblClient uses the PK of tblEmployee as a lookup. Currently, the PK is a text field containing the...

Hi, We have a staff database which stores and manipulates all information relating to our staff. Originally we needed a field in the staff table called...

Can I set an input mask or format that will convert ALL words in that field to title case, even if there are several words? Also (but unrelated), how do I...

Hello, I have one table: SURVEY_tbl with a primary key: FORMID I split the SURVEY_tbl into eight separate forms for data entry. I used macros to open the...