Search results

thanks Thanks namliam works great, Will do. :) Ant.

Hi all, I have a form with a command button on and the following on the OnClick Event of the command button:- Private Sub CmdEditLearnerProduct_Click() On Error GoTo Err_CmdEditLearnerProduct_Click If Me.List3.ListCount = 0 Then DoCmd.RunMacro "NoFunding" 'Displays message if no Funding...

Jon, Exactly what I wanted. Thanks Mate, greatly appreciated. Ant. :)

Hi Jon, Thanks for replying, however the list box still displays products for all contracts. I am trying to get it to only display products with the same contractID as that of Text5. Regards, Anthony

Not sure if it is any more help but attached is smaller version of what I am trying to accomplish. Many Thanks Ant.

Hi Mile-O-Phile, Combo6 does contain field names, however with the code you provided I receive no errors however no information is listed in the Listbox. Regards, Ant.

Hi guys thanks for the speedy replies. I used michaellysons code and I am getting the Dubug window and the message: Run-time Error '2447' There is an invalid use of the .(dot) or ! operator or Invalid Parentheses. Any ideas? many thanks, Ant.

Hi All, I have a form with A text box, Combo box and List box on. On the OnChange event of the text box I have the following:- Private Sub ProductSearchtxt_Change() Dim txtSearchString As Variant Dim strSQL As String txtSearchString = Me![ProductSearchtxt].Text strSQL = "SELECT...

Hi All, Can anyone tell me what Autonumbers Highest Value is? Thanks Anthony.

Exactly what I need. Thanks Mile-O-Phile Ant :)

Hopefully an easy one to answer. I have a form with a command button on with an On_Click event of DoCmd.GoToRecord , , acNewRec. What I would like to happen is when the user clicks this Add New Record command button it stays on this record until either the record is saved or it is cancelled...

Hi all, Have a form which is a calender made up of unbound textboxes with the days of the month in. What i would like to happen is if one of these text boxes matches a date in my table then make the backcolor = 255. The unbound textboxes are called Date1, Date2, Date3 and so on and my table...

Worked it out. Thanks :)

Thanks Ghuson & aaron.orrell, I looked at the following:- API: BrowseFolder Dialog http://www.mvps.org/access/api/api0002.htm I have put this in a module and called it from a command button and it works fine:- '************** Code Start ************** 'This code was originally written by...

Thanks Again :)

Thanks Mile-O-Phile, If i use the DMAX function will it effect the outcome if a record is deleted? Ant

Hi Mile-O-Phile, Basically i need to know the last record added. I do this my recording the SubmissionNo field to the unbound text box. This way there is no way they can delete any previous records as the last record added submission number would be stored in the unbound text box. However i...

Save As Dialogue Hi all, Have a form with a command button on which used the docmd.transfertext command. Was wondering if when clicked I can have a prompt where the user chooses a save location. Is this possible at all? Thanks All Anthony

Hi all, I have a form with an unbound text box and when I click a command button a value is passed to this text box. Problem is that when I close and reopen my form the value is gone. Is it possible to store this value in the unbound text box so it stays stored until changed via use of the...

Thanks Pat will do. Ant