Recent content by stretch66

Have attached example solution :)

Hi John, No still can't get it to work. I have created a test DB if you go to record 3 and then select Add New Record you will see the problem I am having.:confused:

Hi, I have a a sub form where records are viewed but need to change the properties to allow edits and data entry. If there is no current record then the form is not shown and so I need to go to a new record and so was using Using the OnClick Event of a Button on the Main Form. I have tried...

Hi, Got caught up on other stuff so couldn't reply. This is the problem I had put a break point in and it still pops up with the Modules form? I know I am not well versed in debugging so must be missing something simple.

Hi, Maybe this is a stupid question but I am trying to run debug on some code behind a form but everytime I press F5 some Modules screen pops up? Do I have to have some sort of seetings from the View and Debug Menu?

Hi, Can anyone tell me what I have done wrong here please as I cannot get it to work. Private Sub dateTO_Change() If Me.dateTo < Me.dateSTART Then MsgBox "The date you have entered is and earlier date than the Start Date" Cancel = True End If End Sub Thanks

Brilliant Thanks!!!!!!! How do I connect from another access database?

OK, Hvae tried to connect to my db from an Excel speadsheet and understand that I need to change the properties of the Data Link to include the pathway of the .mdw file however I cannot find the right property. Have attached a screenshot of the two forms and would be greatful if someone could...

What will the IsLoaded function do? I am ordering stock for a person and so cannot save or close the current form so that I can add an employee, will it still update?

Thanks Dave, I was trying something similar but when I went back to the original form it wasn't updating the list in the combo box but will try and implement yours. Cheers Adam:)

Hi, I have a combo box that includes 2 columns one being a Autonumber and the other is Name. I want to be able to add a Name to the list but cannot set property of "LimitToList" to No. When I try it says that "The first visible column, which is determined by the ColumnWidths property, isn't...

Thanks Roy that worked!!

Hi, Am trying to get this to work but for some reason it doesn't. Can anyone tell me what I have done wrong please? If Me.StartDate >= (1 / 1 / 2006) Then Me.lblContract.Visible = True Else Me.lblContract.Visible = False End If Thanks

Hi, I'm trying to create a stock and ordering system and have a value for number of items ordered named [Quantity] Have a control on a subform that records goods received named [TotalReceived] On the parent form I have a control called [Outstanding] which is obviously the sum of [Quantity] -...

Not sure how it works but went back to the query and did Month Format([Field],"mmm") and then put another attribute in for sorting and it worked. Tried it before but couldn't get it??? Anyway works now. Also if anyone wants to know how to change the legend in future as have seen a lot of people...