Search results

Fizzio Each record has the two separate date fields. The dates are chosen from a calender. What do you mean by "If you want to batch update records you will have to be a little more creative" Any hints Fizzio!!?!?!?!

Below is the code used to tick or not tick a check box dependent on two dates - it seems to work the oncurrent event of the subform. It doesnt update unless you click on the relevant record in the continuous list. The information for this continuous list is gained from another subform which is...

Am I loosing my mind?!? I have a form containing a subform, this subform is displayed as a continuous form. Ooooh simple so far... Now, when I change a date on the subform, it automatically ticks a box. This change is not displayed immediately unless I click on the relevant record on the...

Thank you Fizzio it works brilliantly You dont know how many grey hairs I have trying to work that one out. Thanks again Jax

Can anyone help me with my command button problem?

Rich The command button is on a form, your right I want the button to open the calendar on the first click and close it on the second. I have the first bit working with the code: Private Sub Button_Click() Calendar.Visible = True Calendar.SetFocus End Sub I am not sure how to fit your...

Thanks Rich but I didnt quite understand your reply, where does the if statement you suggest go - on the OnClick of the command button or on the calender? Sorry for my ignorance!

I have a command button on a form, it opens a calendar from which the user choses a date. I want the user to be able to click the same command button to close the calendar. Is it possible or do I have to create another close calender button. If it is possible how is the code written? Thanks...

thanks Geoff i will give it a try and let you know how i get on

DJN thanks for that code i will put it to good use. The problem i have with the calender is one of the dates is not always required - I have three date fields, 1.start date, 2.end date, 3.resignation date - the third field is not always filled, but if clicked the user cant close the calendar...

I actually have two problems!! 1. I want a check box to automatically be ticked if another field containing a date is in the future. I get this working but it only shows the ticks if I close the form and reopen it. I am a little confused as to which event to place the code in and where to...

Just for information I solved the problem by changing the setfocus to another field and then making the calendar invisible: Private Sub Calendar_Click() ADate.Value = Calendar.Value Calendar.Visible = True BDate.SetFocus Calendar.Visible = False End Sub Hope this helps someone...

I dont know what i would do without this forum it has stopped me tearing my hair out on many occasions - but I am learning fast thanks to all the replies. Anyway - IIf statments What I have is two date fields. One details the date a person is due to leave office. The other gives the date if...

I have an activex calender control opening to make entering dates easier for users. The calender opens onclick in the text box. The date is selected and is entered in the field but i get the following error message "run time error 2165, you can't hide a control that has the focus". The code I...

I am using a combo box on a form for users to search for the item they want to see , ie choose the name of an office from a list and the form detailing all the information is shown. This is working great apart from it wont search for names that have apostrophes in them. I get the "Syntax error"...

Thanks for that Tess worked brilliantly!!

Thanks for your reply. I am using Access 97, not sure if later versions are different. I used the wizard to create the command button which opens the subform, but the fields are not blank - i need the fields to be blank each time the subform is opened. Thanks

I want to open a subform with all fields blank ready for new information to be entered. I have entered the code below in the event procedure of the command button which opens the subform: Private Sub Form_Activate() Me.Refresh End Sub This doesnt seem to do anything and the first record...

Thanks for the reply. I tried to enter the docmd.refresh in the command button OnClick, but i cant get it too work. Thanks for any help.

I am fairly new to Access and struggling a little. I have a main form which has a command button which opens a subform. I want the subform to open with blank fields so that new information can be entered. I also have a command button which closes the subform, I would like this to also refresh...