I'm using a query and need strip out data. Here is an example of the data I have to work with: 85123147/RS08 85123147W/RS08 TEX-M/SS09 I need my query to...

Is it possible to share one database with multiple users at one time? I sort of thought this was part of the point of a database...I created several on my...

Private Sub cmdDel_Click() On Error Resume Next DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6,...

Hello, I have a split database. A continuous form in that application has it's Record Locked property set to 'Edited Record'. The database...

I have a list of contacts that I would like to add a table that would do the following: In a single record view (if it is available versus table view) I...

Vista, A2007 Following sub used to work in .accde but not now. Now it only works in ..accdb I searched and it says something about VB 5 or 6 which I don't...

I have been using Access since Office 99. While I am not a power user, I am quite comfortable with it to create nice applications for small numbers of...

I'm trying to figure out how to link a field in one table to other tables. For example say you have the following...

I have a DB that tracks work in our building. The dates that items are due can change due to production requirements or scheduling. I have an update query...

Hello, I need help on getting a list of Case ID with the very last updated date. Case Table (Case ID, Section ID, Section Update Date) Sample Case Table,...

I have a very simple database (access 2002) at work. This database is used to track support calls from customers. It currently tracks customer information...

Hello, I'm involved in a performance testing project and I'm trying to use the pivot charts in access to quickly present results for me. I have a query...

I've never seen this before...Today when I created a new database in the tables I had these tables listed. What are they and why is this happening now? Can...

Hi all, I'm a newbie who is finding out his knowledge is much more limited than is his imagination :-) I'm trying to create a form in which I will have a...

I have a piece of paper that has 30 names going down the left side and 6 weeks worth of dates going left to right across the top. This makes a grid of a...

I'm trying to Build a Front-End Database for a data entry. After I made all the tables with it's headers, I was trying to make a relation between the tables...

Hi, I have two tables; Case Table (Case ID, User Name, Customer Name, Customer Address, Date) Change Table (Case ID, Old User Name, New User Name) I am...

I read and followed jurseygirl54 progres however i am stuck: the idea is for a research assistant to update data on a list of patients and rather than...

I have 3 tables that I am pulling information from for a query - the tables are related but when I run the query it duplicates the information....when there...

I can create a count on a field in a report but is there a way to force it to only count specific names from that field. Example: the field is tool_code...