A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 27
Search took 0.13 seconds.
Search: Posts made by: Jeff Monroe
Forum: Using Forms March 12th, 2013, 12:08 AM
Replies: 0
Views: 3,817
Posted By Jeff Monroe
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: 3,488
Posted By Jeff Monroe
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: 2,180
Posted By Jeff Monroe
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: 3,687
Posted By Jeff Monroe
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: 5,489
Posted By Jeff Monroe
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: 5,668
Posted By Jeff Monroe
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: 2,334
Posted By Jeff Monroe
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: 2,334
Posted By Jeff Monroe
Macro: Insert formula for each row of data

I have a variable sized data set in a work sheet. Simplified it's like this:

A B
1 data1 =Today()
2 data2 =Today()
3 data3 =Today()

(Column A...
Forum: Using Forms August 28th, 2009, 09:11 PM
Replies: 1
Views: 84
Posted By Jeff Monroe
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: 196
Posted By Jeff Monroe
MG: Thank you very much for the tip. It worked...

MG:

Thank you very much for the tip. It worked exaclty as I needed. You saved me hours of manually deleting the characters I don't want.

Jeff
Forum: Running & Setting Up Queries February 10th, 2009, 10:22 PM
Replies: 2
Views: 196
Posted By Jeff Monroe
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: 142
Posted By Jeff Monroe
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: 123
Posted By Jeff Monroe
Requiring Data in a field based on another field's entry

I have two fields on a form: NCR_No and Insp_Date. I want to make it so if a user enters an NCR_No, an error message appears if the user did not enter an Insp_Date telling them an Insp_Date is...
Forum: Setting Up & Running Reports March 2nd, 2007, 11:23 PM
Replies: 2
Views: 92
Posted By Jeff Monroe
-- Worked like a charm. Thanks for the help Jeff...

--
Worked like a charm. Thanks for the help

Jeff Monroe
Forum: Setting Up & Running Reports March 2nd, 2007, 01:13 AM
Replies: 2
Views: 92
Posted By Jeff Monroe
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: 119
Posted By Jeff Monroe
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: 119
Posted By Jeff Monroe
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: 119
Posted By Jeff Monroe
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: 99
Posted By Jeff Monroe
Thanks Lynn and Crystal. I'll look into...

Thanks Lynn and Crystal. I'll look into that.

Jeff
Forum: Database Design January 2nd, 2007, 10:13 PM
Replies: 3
Views: 105
Posted By Jeff Monroe
-- 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: 105
Posted By Jeff Monroe
-- Rick: Yes, I understand the risks of doing...

--
Rick:

Yes, I understand the risks of doing security this way, but it will serve my purpose for this application.

Thanks for the tip. I will try it out later this evening.

Jeff
Forum: Database Design January 2nd, 2007, 06:01 PM
Replies: 3
Views: 105
Posted By Jeff Monroe
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: 65
Posted By Jeff Monroe
Thumbs up JRS: It sounds like you should open the database...

JRS:

It sounds like you should open the database while simultaneously holding the shift key. This will bybass the "AutoExec" macro (or opening the form specified in the Start Up window).

From...
Forum: Using Forms January 1st, 2007, 10:14 PM
Replies: 5
Views: 99
Posted By Jeff Monroe
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: 99
Posted By Jeff Monroe
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)....
Showing results 1 to 25 of 27

 
Forum Jump

All times are GMT +1. The time now is 06:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.