Getting Started

Creating Scatter Graph Pivot Chart without autocal on (x,y) values
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 which returns my data in the format shown below: label, timestamp, time Action1, 2008-07-05 08:30:10.737, 13680 Action1, 2008-07-05 08:30:25.027, 1088 Action... 11 Jul 2008 08:54

"Apply Filter" and "Filter by Form" shortcut
Hello, I am working on cleaning up some data in a database and it requires a lot of filtering and I am wondering if a keyboard shortcut exists for "Filter by Form" and "Apply Filter." If not, does anyone know how to create one? I am not tech savvy at all so if you could give detailed instructions that would ... 9 Jul 2008 11:38

Access Query - INSTR function?
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 strip off everything after & including the "/" so that I get the following results. 85123147 85123147W TEX-M Do I accomplish this using the INSTR fu... 9 Jul 2008 18:52

Formatting: Subreport does not expand to content in report
I have a one to many relationship from TableA.id to TableB.tblAId. I have created a report for Table b that lists all of TableB.columnC and shows a running sum of the group. This report uses TableB.tblAId. I inserted this report in a report for tableA. I can see that it works, but it does not expand to the conten... 9 Jul 2008 12:41

making a form for people to fill in
basic question, i have an inventory table and i want people to fill in a form to add to my table database. When I use my form I never see what was added to my table untill I do a search for in this table. i.e. I type in (on the form) sample name: bla bla and when I go to the table I do not see the bla bla und... 9 Jul 2008 11:38

Excel->Access Import Frustration
Hi all Can anyone advise on the best way to approach an import from Excel please? The background: Traditionally we have created lists of valves for purchase using Excel. I have now been asked to assist with importing these into an Access database to make use of reporting/querying features etc. I am of the ... 9 Jul 2008 11:38

How to use ID to fill in other cells in a form
Hi My problem is that i cant find a way to link my employees table with my form such that when i type in the employee ID the employee name, job title,country etc are automatically filled in the form, from the employees table, which contains full records of the employees. Please give example with the employee ... 9 Jul 2008 10:37

Showing un-matched fields in a basic query
Hi there, I have 2 sets of data created into 2 seperated tables. They are linked through a single PRIMARY KEY. Access's query is able to link and display fields from these 2 tables if the PRIMARY KEY is correct. BUT what about displaying all the fields where the PRIMARY FIELDS do not match? example: - Tabl... 9 Jul 2008 11:38

Sort Order For all objects
Access2007 Is there any way to make the sort order for tables, queries, forms and report to always show the most recent at the top of the list instead of at the bottom when each is opened? Can one write a macro to do this on start up? OMEd ... 10 Jul 2008 13:25

Read Only Record
I use access database to create invoices from a standard form. Is it possible to make the invoice record read only after I have created an invoice. ... 8 Jul 2008 20:18