Getting Started

Form not allowing updates
when I try to update/edit in my form I get the message, "The recordset is not updateteable" Using Access 2007, on properties it says my recordsource is the correct table, allow edits is set to yes, it is not locked. I based the form off a query that pulls fields from three different tables and it seems to po... 28 May 2008 16:37

Tables & Forms
I'm very new to access. I need to design a form that has different sections in it. I know I have to start with building a table but do I put each section in a different table? Then do iI build the form off of all the tables? Thank you in advance. ... 28 May 2008 15:02

DateDiff
Hello all, How would I run a query that would give me the total days in between the original date and the current date? The only date that I have in the database is the original date. How would I tell access to subtract that from the current date to come up with the number of days in between? ... 28 May 2008 15:02

conecting to Access Database with excel
In Excel I am trying to connect to a Access database using the New Data Query Wizard When I get to the choose Columns screen and click on the Available table and columns I receive an error Undefined function 'Date' in expression. (The database does have a function with this name that works correctly I cann... 28 May 2008 13:27

unused items from list
Hi! I am trying to create database of customers and market areas they have reserved. Now I have made a list of areas, as list of numbers. Problem is that I can select same number more than once. I have this kind of SELECT sorting out numbers, doesn't work. Area is table to get all numbers and AreaReservati... 2 Jun 2008 06:56

A way to see when data WITHIN a table has been changed?
Is there a way to see when each item within a table has been last edited? Dummy me saved my Alumni database on BOTH my hard drive of my laptop AND my server (desktop in basement). I wanted to 'play with' a form without altering the original, so I saved the entire database at a new location. Now I have edited... 1 Jun 2008 17:38

Concatenate 4 fields
I have Duane Hookam's generic module for concatenate, but SQL & I just don't see eye to eye. I need to concantenate each field (EmpName, Equip, trucks, subs) by themselves, not into one field. Can someone help? SELECT tsch1.JOB, tsch1.BEGDT, tsch1.ENDDT, temp.EmpName, teqpcpconca.EQUIP, tsch1.TRUCKS, tsch1.subs... 30 May 2008 11:53

read only mode
I want to put my access database on a shared drive in the office but need it to be on read only mode so that no one can play with th einformation is this possible and if yes how? You reply will be highly appreciated. Thanking in you in advance for all your efforts Ray ... 28 May 2008 16:37

Max & Min field table
Hi, now i have the crosstab query as below. I want, in my report, to show the following below the crosstab query table: ABC ABC XYZ Date 12345 55555 9876 1/1/08 100 -200 500 1/... 28 May 2008 09:17

Expand Series Field Names
Hi, I created a pivot chart using the Forms Pivot Chart. My problem is I can't seem to expand the Series Field Names. Why is this so? Thanks, Dolphin ... 6 Jun 2008 04:34