Search results

Excellent, that's worked a treat. Many thanks

Hi, Probably a really simple question, but is causing me problems! I need to be able to limit the amount of characters that can be entered into a field. For text fields I can just enter the relevant field size, but can not find an equivalent for a memo field. Validation rule warns you that...

Many Thanks

Right almost too ashamed to ask this. I need to close a form, once another form has been opened. I've set up the open form button with the following code: Dim stDocName As String Dim stDocName2 As String Dim stLinkCriteria As String stDocName = "Switchboard" stDocName2 =...

Solved it with some help from Len (on Form Forum).

Many thanks. works a treat!

I am trying to open a report, filtered by the selection in a list box. Have tried various solutions to similar problems posted on the forum, but am still having no joy. Have placed an open report button on the form, which have coded: Dim stDocName As String Dim where As String...

How do I use the list box/combo box as the criteria in the query?

Am trying this: Dim stDocName As String stDocName = "Leaflets" DoCmd.OpenReport stDocName, acPreview, , "[6th_Form_Prospectus_Title] = " & Me.lsttitle.Column(0) Recognizes the right value for the field but comes up with: "Syntax error (missing operator) in query expression...."...

Keep getting a syntax error, when trying this. Any examples of code I can look at? Thanks

Hi, Have done a search of the forums and can't seem to find an answer to this. Am trying to open up a report dependent on selection in a list box. Example. Have a list of courses, need to code the open report button to open the report, filtered on the selection from the list box. Any ideas?