Search results for query: *

hi you dont need the parameters properties of ado, and referencing the textboxes directly is supposed to work, it just means you didnt code it right, the difference is where this code being run? on the form with the textboxes or in the report's Open event? i'll assume it's in the report's...

it is not possible to do such a thing without the use of a form. Erez.

hi there in the open event of the form there is a "Cancel" variable, that when set to non zero value , cancels the opening of the form. so have your check there, and if you want the form not to open, set cancel=1 something like: Private Sub Form_Open(Cancel As Integer) If [whatever...

use DMax function to find the maximum value and add 1 to it. say the subform is based on a table named CDtracks with fields (cdID,TrackNum,TrackName...) then using DMax("TrackNum","CDtracks","cdID=" & txtcdID) will return the highest value in TrackNum - to which you...

you just change the stLinkCriteria to include both conditions (in this example i assumed that the text box containing the class is named SearchClass) Private Sub Command15_Click() On Error GoTo Err_Command15_Click Dim stDocName As String Dim stLinkCriteria As String stDocName =...

hi there you can simply use lstComponents.ListCount to return the number of rows in the listbox (and i think that means you dont need column 3) good luck, Erez.

hi there if i got your point, you can use "Select field1,field2... From TableName where Mid(field1,7,2)=[whatever you're interested in] this will check characters in position 7 and 8 (together) hope it helps Erez

there is no problem emailing from access, but as far as i know, if you want to send them a report, you gonna need to: 1. save the report as a snapshot 2. the students who receive it will need s snapshot viewer to see it (ships with ms-office) so if raw text is good enough for you (that way it...

hello there try this: on the computer that says MISSING:... on the line of the DAO reference, try to find other DAO versions (their names all start with microsoft dao #.##...), and tick them INSTEAD of the missing one, then compile. aim for newer versions than the missing one (eg: 3.60)