Search results for query: *

You may find some info to help you here; http://support.microsoft.com/default.aspx?scid=kb;EN-US;287642 Take care, Phil

Well, the length of discussion here suggests that UP has more power than IF. To add my own favourite to the discussion, Fat chance and slim chance, both mean not much chance at all. BTW going right back, Knocked up has a 3rd meaning, to tire in endeavour and fail to finish, eg He knocked up...

Hayde, Here is some code that is working for me in a similar fashion. I had a lot of trouble with field [Paid] not being updateable to start with, so perhaps that is the source of your trouble. But the check on it's status before changing it seemed to solve that issue. Private Sub...

Thank you AceMan, Knew it would be something simple that I was overlooking Will get to learn all of this stuff one day, just got to work out on how to live to 125 ! Take care, Phil

I have added a calendar that opens as a pop up to change dates on a main form that has two linked subforms. Now my subforms do not update after the calendar has done its job and changed the dates. Form still works if I enter the dates into the fields, so what am I missing. This is the calendar...

Thanks fellows. Will have to play around with a few ideas. Take care, Phil

Perhaps DLookup can help you. Take care, Phil

Have been tinkering with the idea of doing a form as a weekly summary, just as you can do a report. I can find in queries the monthly summary, but don't understand the coding that is needed for a weekly summary. Any ideas? Many thanks, Phil

Is there anything wrong with using in the On Current event of the form; Me.comboname = Me.whatever_field_the_combo_looks_for Just seemed a little more direct to me :) Take care, Phil

You have to take a step back, and create two fields. One Product Price that can be the original Price and Order Price. Order Price can be a Dlookup or combo based on Product Price, but either way, every order will have it's own Order Price therefore allowing you to have seperate prices for each...

Thanks, Now it works just like you expected it too :) Many thanks for all your help. Phil

AceMan, In your original reply you gave me; In the AfterUpdate event of the Form, copy/paste the following: CODE Me!CheckboxName = True In the OnCurrent event of the form, copy/paste the following: CODE If Me!CheckboxName = True Then Me.AllowEdits = False Me.AllowDeletions =...

I must have made a blue somewhere in the code, will check that again. It was working as you said, excepting that on a new order, it would cease allowing the edit when the focus moved from the main form to the sub form. This means that order details cannot be entered as planned. Could the reason...

Thanks AceMan, That bit of coding wants to work, the only hitch now is that the coding closes the edit option when it enters the sub form, any hints on how to proceed? Thanks Phil

I tried the docmd method, that only gives me an error message that the command isn't available now. the allow edits and allow additions sort of worked in that it will open a new form, but it is missing the subform that goes with it. My code for opening the form from another form is; Private Sub...

I would like to be able to have a form that shows past orders as read only, and have a command button on that form that would allow the entry of new orders. Is this possible? I have tried some VBA without success. Many thanks, Phil

I think you are looking at Rudy's code as the neat one. Mine is usually in the format you are speaking off.

I don't know if it is an addition to the available program, I am using Access 2003. Click on the query you wish to look at, then click on Design then click on View and select SQL View. Also available from the arrow beside the icon that switches view from design to table. Phil

Yes on each field in the select statement

Rudy, This seems to create a query requiring input to run, my idea was a query to check what had been entered into the table to ensure that an address hadn't been entered twice, and to display addresses that had two entries on a form for correction. Many thanks, Phil