Simple Event Order Problem

Aug 23, 2005

I have a form with a test list. Each test is a record with a yes/no checkbox, and controls for testdate and examiner. I don't want the user to be able to exit a record if the yes box is checked and either the testdate or examiner fields are blank. The code I am using is:

If IsNull(Me.Examiner) And Me.SelectTest = Yes Or IsNull(Me.TestDate) And Me.SelectTest = Yes Then
MsgBox "You must enter an examiner and a test date for each test you select.", vbCritical + vbOKOnly + vbDefaultButton1, "Missing Data"
Me.Examiner.SetFocus
Cancel = True
Else
Cancel = False
End If

I am having trouble with which event should be used with the code, however. In both before and after update I have had the following problem. If a user accidentally checks the wrong test and then unchecks it, they still get the message as if the box were still checked yes. Can anyone tell me why and how to avoid that?

Thanks in advance,
Carly

View Replies


ADVERTISEMENT

Trouble With Event Order??

Apr 26, 2005

Can anyone point me in the right direction on this...

I have a field on a form where data can be added or edited.
I would like to have a message box appear when the data in the field has been changed.

I do not want the message box to appear when a new record is added. I tried using the On Change Event, but then every time a key is pressed they get the message box and had to click "ok" before typing the next letter. This included new records as well.

Is the a way that I can summon my message box only after a previously created record has been edited and the person has finished typing?

Thanks for any pointers!
Carly

View 3 Replies View Related

Simple Sales Order Entry Application

Jun 3, 2006

Hi, I am using a wet and cold holiday weekend to learn about Access. I want to create a simple sales order entry function.

I have set up 2 tables Orders and Order Details. The Orders table holds order number, customer, due date, etc and the Order Details table is to hold the line items (product, quantity, price, etc). So far, so good.

I have created 2 forms and made the Order Details form a subform of the Order Header form. So far, so good.

I have 2 questions arising from this.
1. How do I get the cursor to tab from the last field of the header form to the first field of the details subform? When I get to the last field of the header form it just goes to create another order.

2. Is it possible, and if so where do I get info on how, to enter (and show) many detail lines for the one header. This is a normal sales order situation, customer stuff followed by 5 or 6 lines of products on the order.

I have two old (Windows 95) MS Access tutorial manuals, beginners and advanced but can't find the answwers there. I am using MS Access 2000.

Any help or pointers to where I can get the help would be appreciated.

BD:confused:

View 2 Replies View Related

Simple Order By Stmt Need Expert Answer

Mar 14, 2005

I have a very simple SQL stmt

Select * from MyTbl order by MyID

The error: "Syntax error in ORDER BY clause"

If I remove the order by clause, it works. Now, I have been programming for 30 years and for the life of me, I cannot figure this one out. It is my first use of 'order by' on this ISP so I am assuming there is a server thing? Can anyone suggest to me what this might be? Thank you very much.

-Extremely Frustrated (Ken)

View 10 Replies View Related

Simple (?) Timer Event Problem

May 24, 2005

I created a form to list the number of customers in my lobby. In the Form Footer I placed a field to count the number of customers waiting (Name: CC1, Control Source: =Count([LName]). Works fine.

I want a Beep on the form if the customers exeed 5. I placed the following code in the Timer event but I cannot get the event to work. I believe it has something to do with the field name but I'm unsure. Any help would be appreciated.

Private Sub Form_Timer()

Requery

If [CC1] >= 5 Then

Beep

Else

End If

End Sub

View 6 Replies View Related

None Working "simple Code" On Close Event?

May 16, 2006

I have witten a code in the close event of a "Primary" form that would update a Combo boxe on a "secondary" form only if the "secondary" form is open.
ie:

Private Sub Form_Close()
If Forms!frmEnquiry.Open Then
Forms!frmEnquiry!CboCustomer.Requery
Else
DoCmd.Close
End If
End Sub

This code keeps giving me an error, is anybody has got any idea why?
Thanks in advance.

View 7 Replies View Related

Allow More Than Order In ORDER Form

Apr 4, 2013

I have a problem when I want to create an "ORDER" form, that will allow user to enter more than one order.

I have no clue how to do it.

View 14 Replies View Related

Simple Question For A Simple DB

Dec 29, 2006

Ok I am right now making a simple Vendor/Product database to create a line sheet for some sales folks. I have 3 tables: Vendors, Products, and an associate entity Vendors_Products to relate the two. I have a form currently that draws the Vendor Name (primary key) from the Vendor table and the Product Name from the associate entity. This allows me to create new vendors and select current product types from a drop down box. The problem is that the drop down box is too long and it is tiresome when 1 vendor has 10 product types.

Can anyone tell me how to resolve this? I thought it would be better to have option buttons and display all available products. Then you could just click all of the option buttons that apply to that Vendor and it would create the relationships...is this possible?

View 1 Replies View Related

Order By

Feb 10, 2008

Good morning,

I have a table ID (primary key) and

ID
--
FEASSDDE
RDSAAASE
NEESSDSD
AEIERIEIEE

and I want to do a select of these values, order by ID ASC, and see the position of each one in this order, something like this:


POS ID
--------------------
1 AEIERIEIEE
2 FEASSDDE
3 NEESSDSD
4 RDSAAASE

View 2 Replies View Related

Tab Order

Feb 17, 2005

I have a startup form with three buttons. All three buttons have Tab Stop set to No. However, when I open the form, there is a highlighted box around what would have been the first button set in the tab order had Tab Stop been set to Yes. Is there a way to not display the light green box around the text in the button?

Thanks,
SKK

View 2 Replies View Related

Tab Order Help

Nov 7, 2006

My tab order is the way I want it and when the user enters after the last field on the form, they get a new record. Problem is, the cursor is putting them in the last field on the form instead of the first one. I don't get it. The first field is first on the tab order list. Help.

View 1 Replies View Related

How To Order A Sub Form

Jun 16, 2005

I have a form (Members of the club), linked to a sub form (payments of membership).

When I open the record of Mr John, I want to see all his payments order by date of payment.

How do I do?

Thanks in advance,

Jackske - Belgium
:confused:

View 6 Replies View Related

ORDER By Date (SQL)

Sep 14, 2005

I have a query which i've ordered by date with:

ORDER BY status_reports.date;

But I want it to display in reverse order with most recent date first for example i want it in order of 18/sept/05 then 15/sept/05 then 10/sept/05.

im guessing i just need to add to the above SQL but im not sure what!

Can anyone help please

Thanks

View 3 Replies View Related

Sort Order

Oct 10, 2005

How do you change a file's sort order from ascii to international?

View 3 Replies View Related

ORDER BY Question

Dec 9, 2005

Hi, is there any way to do an order by, but specify that a particular value is listed last, or first.

E.g. ORDER BY t_name ASC ... but feature Simon first and not with the other names beginning with 'S'

Thanks.

View 2 Replies View Related

Why Need To Order MS Access?

Dec 15, 2006

Hi,

I have a question.

why do we need to order MS Access application when the user request it in the company?

Suppose one user buy MS Access application, then we can install the other workstation, right. But, everytime, we need to order MS Access for that user account/workstation.

In contrast, ms word, ms excel, powerpoint, we don't need to order it, every workstation must have them, except ms access.

Can anybody response me why we need to order ms access for each user account/workstation?

Thanks.

View 10 Replies View Related

Record Order

Jan 30, 2007

Please help,

I have sorted my table by the primary key as when i open the form that loads fields from the table, i would like the most recent record entered to appear instead of the first record that was entered. The problem i have is when i run the form it still shows the first record even though i have sorted the primary key field in descending order. How do i fix this?

View 2 Replies View Related

Tab Order Not Working

Aug 28, 2007

Hi everyone,

On a form, I want to fix the tab order of the text boxes. So I go to the tab order property of the form and when it opens, it doesn't let me change the order. Can anyone help me on this?

Thank you very much

View 7 Replies View Related

Field Order Changes

Jun 13, 2005

I'm using Access 2003 and a week ago I ran into a very strange problem with one of my tables. The table has 15 fields named Field1, Field2, Field3,....Field15. The weird thing that is happening is if I open the table in design view it will list the fields in order (Field1, Field2, Field3....Field15), but when I open the table in datasheet view Field10 and Field11 get flipped (.....Field8, Field9, Field11, Field10, Field12....). Has anyone every seen this before? I'm guessing it somehow got corrupted. It wouldn't be a real big deal for me to just delete the table and create a new one, but if there is a fix to it then I was wondering if someone could share that with me. Thanks.

View 2 Replies View Related

Order Details

Nov 7, 2005

Hi Folks,

I'm working on an order management database for a small company and have an order details form which I hoped to list each product of the order. As each customer has a different price per product I have a combo (based on a query) to choose the product and display the unit price (working fine) - the quantity and product ID are also input on the form and stored in the order details table (un-tested). My problem is on the first line of the order you choose the product and it and relevant details are shown, however, on line two, three etc when you choose the product - the other lines change to this too. How do I fix this???

Many Thanks in advance for help given!!

Mary

View 6 Replies View Related

Date Of Last Order!

May 31, 2005

Hello,

I have a database which in one part records customer orders. What I would like to is identify customers who have not ordered for a given time period i.e. 30 days.

I know once I have built the query, I will require a parameter for the time period i.e.30 days.

I started by trying to record the last date ordered for a customer in a query, but am having problems with this. I had a query including information from my table for Orders (tblOrders). This had:

Order ID
Customer Name
Date Order Required

I do not need any more info apart from these fields.

The results would include all orders, so for some customers there would be numerous 'Order ID' & 'Date Order Required'. In the query, I did try to select the summary option, to group information by Customer - but the 'Date Order Required' was always the first date ordered. What I would like is only the last ones for all customers to be shown.

Can someone provide some guidance on how I can achieve my objective.

Thank you.

View 1 Replies View Related

Column Order

Jun 8, 2005

I have got a number of queries that query an MSSQL database that were running fine, but then I decided to tidy them up by giving them more meaningful column headings eg Pupil ref instead of tblPupil. Some of the queries are still fine but in some of them I can't get the columns to display in the order I want. In one, I have got columns called Round, Pupil ref and School but I can't stop the Pupil ref column coming first. If I delete it and put it in again, I can get it to go where I want (ie second) but as soon as I name it, it comes first and stays there even if I remove the name.

Please can anyone help
Fiona

View 4 Replies View Related

Order By Question

Jun 22, 2006

I have to run a seniority query but have an issue. I have job descriptions but can't put them in ASC order because they wouldn't be by seniority.
For example:

Docker
Docker supervisor
Dock Chief
Shift Supervisor
Section Leader

In SQL I would do a decode function and assign each a number and then put them in order by thier number assigned.

What are my options in Query to perform this function. Thanks.

View 2 Replies View Related

Order By Not Asc - Desc

Mar 5, 2007

I want to sort my query results by VendorNumber (which is an AutoNumber won't be sequential due to deletions). I want to sort the query by what vendor number the current form is on. So if my vendor numbers are 1, 2, 14, 16, 17 and the vendor number on the form is 14, I want the query to be sorted with the Items from vendor 14 first then 16, 17, 1, 2.

Your time is appreciated,
JOe K.

View 7 Replies View Related

Order By Expression

Mar 7, 2007

Hi,

Is there anyway that you can order a query to be descending by an expression in your query rather than an actual field from a table. I am trying to do this but the following message keeps appearing:

The Microsoft Jet database engine does not recognize '[ExpressionName]' as a valid field name or expression.

Any ideas?

Thansk in advance.

Lee:(

View 1 Replies View Related

Order By Clause Not Being Following

Jul 18, 2007

Hi

I have a problem with an Order By Clause.

Basically, my database holds records of sites in the UK, and I have a select query (qry_SumGIS3) that opens up a summary report (rptSumGIS3) when a button is clicked on the menu page. The report opens perfectly, showing me all the information I need to know about all the sites in my database. However, it is ignoring the Order By Clause I have specifically told it to do. I want to order the records that appear in the report by a calculated field (OBJ_WS_OVERALL_CALC) in descending order (highest to lowest percentage). Instead, it is ordering it by the site id (RTP_ID). How can I stop it doing this?

This is my code (that was created in the SQL view of the query design):
"SELECT MEASURE1.OBJ_WS_OVERALL_CALC, [Tab 1: Factual].RTP_ID, OBJECTIVES.OBJ_ID, OBJECTIVES.OBJ_NAME, MEASURE1.MEASURE_ID, MEASURE.MEASURE_NAME, MEASURE1.MEASURE_SCORE, MEASURE1.MEASURE_WEIGHT
FROM [Tab 1: Factual] INNER JOIN (OBJECTIVES INNER JOIN (MEASURE1 INNER JOIN MEASURE ON MEASURE1.MEASURE_ID = MEASURE.MEASURE_ID) ON OBJECTIVES.OBJ_ID = MEASURE.OBJ_ID) ON [Tab 1: Factual].RTP_ID = MEASURE1.RTP_ID
ORDER BY MEASURE1.OBJ_WS_OVERALL_CALC;"

The red line is the part of the code that I think is being ignored.

Anyone that can help me is a lifesaver!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved