Forum: Using Forms
March 12th, 2013, 12:08 AM
|
|
Replies: 0
Views: 13,020
Data Entry Form with List Box
I would like to create a simple data entry form for entering new data, in addtion there's a list box to view and edit existing data in the table.
Form: frmDefectEntry
Table: tblRefDefects...
|
|
Forum: Worksheet Functions
March 28th, 2012, 05:59 PM
|
|
Replies: 0
Views: 5,543
Radio Buttons on Worksheet
I am just trying to add simple groups of radio buttons to a worksheet for yes-or-no questions to be filled out by the user. No funtions, no data being entered. I just want, when the form is filled...
|
|
Forum: Using Forms
March 17th, 2012, 11:38 PM
|
|
Replies: 0
Views: 4,400
Cascading Comboboxes
I need help trying to get three combo-boxes to cascade. I've searched and coped databases and codes with no luck. I've attached a sample of the database into it's simplest form with the code I have...
|
|
Forum: Running & Setting Up Queries
December 14th, 2011, 04:51 PM
|
|
Replies: 0
Views: 5,708
Prompt Date To Use In Query Formula
I have a query where I would like a date entered by the user to be used in a formula for each record. The user is prompted to enter a date, and then that date is used in a form.
The formula:...
|
|
Forum: General Discussion
September 15th, 2011, 08:51 PM
|
|
Replies: 0
Views: 14,374
Import Excel Worksheet Macro
I am trying to import a specific excel worksheet into Access 7 creating its own table via a macro.
The spreadsheet has several worksheets so I need specify a particular sheet. I cannot find the...
|
|
Forum: Setting Up & Running Reports
August 30th, 2011, 11:35 PM
|
|
Replies: 0
Views: 14,863
Use SQL Statement In Report Text Box
In Access 2007 I have a report where I would like to use a SQL statement inside a text box's control source. In the text boxes control source I copied the SQL statement from a query:
SELECT...
|
|
Forum: Worksheet Functions
August 23rd, 2011, 12:52 AM
|
|
Replies: 2
Views: 4,539
Tarquinos:
That formula works. The only problem...
Tarquinos:
That formula works. The only problem is there is now information in those cells. Because of that, those rows are included in any sorts I do (unless I filter out the blanks). This actually...
|
|
Forum: Worksheet Functions
August 18th, 2011, 01:11 AM
|
|
Replies: 2
Views: 4,539
|
|
Forum: Using Forms
August 28th, 2009, 09:11 PM
|
|
Replies: 1
Views: 140
Autonumber (Using Dmax) on Continuous Forms
I have created a continuous that I want to increment a number (by 1) each time a record is saved. I have found when using the code below, the field increments to the next number in the new record...
|
|
Forum: Running & Setting Up Queries
February 11th, 2009, 06:16 AM
|
|
Replies: 2
Views: 347
|
|
Forum: Running & Setting Up Queries
February 10th, 2009, 10:22 PM
|
|
Replies: 2
Views: 347
Delete Specific Characters From Text
I am trying to create an Update Query that will strip out certain characters from a string in a text field (specifically hyphens and slashes) while leaving the rest of the data in the record alone....
|
|
Forum: Using Forms
May 5th, 2007, 05:31 PM
|
|
Replies: 1
Views: 187
Using Form to Build SQL Statement
I have a form that gives a user three methods to dynamically filter an existing report. Two of the selections are combo-boxes (Supplier and Part No). The user selects a supplier(s), part number(s)...
|
|
Forum: Using Forms
April 24th, 2007, 05:19 AM
|
|
Replies: 1
Views: 238
|
|
Forum: Setting Up & Running Reports
March 2nd, 2007, 11:23 PM
|
|
Replies: 2
Views: 152
|
|
Forum: Setting Up & Running Reports
March 2nd, 2007, 01:13 AM
|
|
Replies: 2
Views: 152
Yes/No Boxes on Reports
I have a report where I would like display two check-boxes like this:
Required? Yes[] No[]
In the data entry form, the input is a standard Yes/No check-box. If the user inserts a check, it means...
|
|
Forum: Using Forms
January 29th, 2007, 03:41 AM
|
|
Replies: 5
Views: 193
Doug:
Now that you mention it, the book directs...
Doug:
Now that you mention it, the book directs the reader to use the Norhtwind.ADP (supplied on the dis) database. When I tried to use it, it didn't work (it couldn't find the datatables). I went...
|
|
Forum: Using Forms
January 26th, 2007, 03:50 PM
|
|
Replies: 5
Views: 193
Crystal:
That worked, thanks.
Do you have any...
Crystal:
That worked, thanks.
Do you have any idea why the tutorial book uses ADODB.Recordset? It's throughout the whole chapter? Does it have anything to do witht the references selected? Version...
|
|
Forum: Using Forms
January 24th, 2007, 09:44 PM
|
|
Replies: 5
Views: 193
Trouble With Recordsets
I have a form with navigation buttons (First, Next, Previous, Last, New). I am trying to make them "Smart" by enabling and disabling them as per the position in the recordset (with the help of a book...
|
|
Forum: Using Forms
January 24th, 2007, 09:32 PM
|
|
Replies: 5
Views: 204
|
|
Forum: Database Design
January 2nd, 2007, 10:13 PM
|
|
Replies: 3
Views: 161
--
Rick:
It worked, thanks.
BTW: Do you know of...
--
Rick:
It worked, thanks.
BTW: Do you know of any tutorials or guides out there to help me in utilizing the Access Security feature (if I wanted to use it)? I know I need to be careful, because I...
|
|
Forum: Database Design
January 2nd, 2007, 09:41 PM
|
|
Replies: 3
Views: 161
|
|
Forum: Database Design
January 2nd, 2007, 06:01 PM
|
|
Replies: 3
Views: 161
User Logins & Access Levels
I have a database where I have customized the user login function. My table (tblEmployees) contains four fields (lngEmpID, strEmpName, strEmpPassword, strAccess). When launched, the user selects...
|
|
Forum: Using Forms
January 2nd, 2007, 05:18 PM
|
|
Replies: 3
Views: 118
|
|
Forum: Using Forms
January 1st, 2007, 10:14 PM
|
|
Replies: 5
Views: 204
Crystal:
Thank you for the response to my...
Crystal:
Thank you for the response to my question.
Can you break it down into more detail? I am having trouble getting the AccessLevel criteria (i.e., "admin", "user", "viewer") of the person...
|
|
Forum: Using Forms
December 28th, 2006, 07:12 PM
|
|
Replies: 5
Views: 204
User Logins - Restricting Buttons/Forms
Hello:
I am creating a mutli-user database and need help with controlling access to forms and buttons based on the user's profile. First of all, I am not using the built-in security wizard (mdw)....
|
