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...
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...
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 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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.