Getting Started
in [Access]
|
Adding controls to a calendar in a form 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 check box on each date of a calendar to simply indicate whether an employee had worked that day, but I can't figure out how to include multiple check box ... 14 Jul 2008 15:46
Help with Data Control Source New User ok! need to write a query and not sure how. want it to say basically. If "AccountType" = Local (from the Products Table) the use LocalPrice from the Products table or if "AccountType" = Agent then use AgentPrice from the Products table. I have a products table that has my items in it, and I hav... 11 Jul 2008 12:00
Typing info into text box Hi, I have a text box of wich the value depens on a yes no answer, it is either an hourly tariff or daily. These values are looked up with an sql statement and then the appropriate one chosen with the statement =IIf([day tarif]=0;[unit price];[Day Rate]) where [day tarif] is the yes/no answer. What I w... 11 Jul 2008 08:54
Create new database... Hello all, I just installed Office 2007 Ultimate on this computer with Windows Vista. I'm trying to create a new blank database, but Access 2007 won't give me any option to provide the name or the location for the new file. All I have is the option to open an existing one. Can you tell me what's wrong here ? M... 12 Jul 2008 19:43
What on Earth 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 I get rid of it. Should I? Thanks DS MSYSACEsi MSYSQueries1 MSYSRelationships ... 11 Jul 2008 09:56
Compact and Repair I have set the Compact and Repair to occur on closing the Data Base using the Options in Access 2007. However, when I closed the Data Base, the Data Base was deleted completely, and I cannot find it anywhere on the Computer. With the previous version of Access, I used Tools, Compat & Repair without a problem!... 11 Jul 2008 01:45
Have Fields Automatically Calculate I would like to have a field add numbers from two other fields. so Total= subtotal1+subtotal2 I want this done at the table level. I was able to acheive this at the form, but then it wasn't writing the value to the table. ... 12 Jul 2008 20:44
Vista I am trying to run Access 2003 on Vista but when using forms, it only displays the character states that already have values, the other character choices for any particular character are not visible. I can add a new item, I can not add any values to any of the characters even though the character set is visible... 10 Jul 2008 20:38
Multiple Parameters I am using a form to run a query with parameters. Below is what the form looks like:(------- <--represents a text box and there is a search button) Age: ----------- Salary From: ----- To: ------ Date Hired From:---------- To:----------- Employe... 11 Jul 2008 10:58
How to show rows above an input record number Hi In my query , I want a popup to ask for a record number , and then display all the rows above that number looking down the autonumber column. I'm a little stuck for syntax - I'm hoping someone can help. I'm using this presently in the autonumber column : Like [Show Records Above : ] & "*" This g... 11 Jul 2008 10:58 |