Search results for query: *

sorry, the code should read:- should say :-stLinkCriteria = "[Ref No]=" & Me![Ref No] & "'And" & "'[Initials]=" & Me![Initials] & "" and the Error should read:-:- Syntax error (missing operator) in query expression '[Ref No]=1073'And'[Initials]=kb'...

Thanks for the info but STILL got probs. I've put in code:- stLinkCriteria = "[Ref No]=" & Me![Ref No] & "'And" & "'[Agent]=" & Me![Agent] & "" but getting error:- Syntax error (missing operator) in query expression '{Ref No]=1073'And'[Initials]=kb'...

Sorry, NOt actually solved it, tried the previous postings but they not worked !! still get type mismatch.

[Ref No] is an Auto number-(long intega) and [Initials] is a text field, does this help ??

p.s. It's a text field (should only have either letters or letters & no's in it)

yes the initials field can contain both letters and numbers but I still get the same error ??

Do you have some VB code to show as an example as I've tried something similar and get an error. I've tried the following code contained within the On Click event of the button :- Dim stDocName As String Dim stLinkCriteria As String stDocName = "FormB" stLinkCriteria...

Can anyone help. I'm having a problem opening a form with MULTIPLE linked criteria. I can open it fine with one linked criteria but not with more than one. i.e. I can open form A and click on a button to open Form B with field 'RefNo' the same. But cannot open form B with BOTH [RefNo] &...

thanks for the help but i'm not too well up on vb programming yet. can you help any further with maybe the full code as both reply's look to me like they contain only part of the answer. if not can you explain, cheers

I have set up a List Box to allow multiple selections (set at simple) but need these mult. selections to be saved onto a table, how do i do this. any info appreciated, cheers

within the forms 'on open' event proc put in :- DoCmd.GoToControl "textBoxname" put in the name of a text box that's at the top of the form.

Check that the 'name autocorrect' options are NOT ticked in the Tools,Options,General tab. (as per thread702-206410)

what type of input box is it & what's it for (i.e. on a Parameter query asking for criteria or something else?)

Good, glad you got it sorted. (p.s. to go into properties you right click on the small box-top LEFT of the form & select 'properties', not top right as i said prev.- type error) cheers

You don't have to 'create' one. Just go into the design of the form and into Properties (right click on the small box-top right of the form-select 'properties') Then click on the combo box- within Data tab you'll see 'control source'. (This is the field on the form you want to save the combo...

Have a look at thread702-19300 or search for 'calandar' in the keyword search above. Brings up loads of threads. Should contain stuff to help.

not sure but one way you could do it is to put spaces in front of the tab names until they're all the same size.

OK, does the Table - VersionSoftware only have the 1 field in it (version) & is this field only used for the drop down menu. If so then you don't need to connect this table to the Clients Table. Create a query from the Clients table containing ALL the fields which should also include a field...

OK, you should have the combo's row source as 'table VersionSoftware' (that's where the drop down fields come from.) Then set the Combo's Control Source as the 'SoftwareVersion' field (this field should be on the Forms Record Source Table/Query) The Combo's Control Source is where the combo's...

It all depends on what you want the database to do but I'd say option 1 is the best and easiest. Make sure your tables are connected OK (i.e. 1 to many, etc.) and use a query. This will enable you to manipulate the data it displays.