Search results

Hi, I have a DB which I would like to be viewed by all but only edited by one person. I have a form which hosts a reports menu; this is all the other users need to see. At the moment I have a very insecure password form, which basically uses a code to say "if password = password value then open...

If not i did have a similar system which resulted in 2 unbound textboxes. One with the number corresponding to the weekday of the date and the other to the combobox value as a number. I just need the code to fire when the two are eaqual. Im trying this but am unsure as to why it wont work but...

How do i specify these "cases" within the code. i am trying this to no avail thanks, almost there!

Actually that is okay, I have the code working if i "manually" input an integer. All i need to know now is how to identify an unbound textbox's value and state that the masgbox will fire if the Weekday(Me.Text295) = the unbound textbox's value. i have tried me.textboxname.value but this does...

How would i incorporate this within my code The combo box has a value list "monday; tuesday.......". Would i need to specify these as an integer or can I display the date as a weekday and show the msgbox if the two are =. thanks

Hi, I have a field which calculates a date in the form dd/mm/yyyy. I would like a msgbox to appear if the weekday e.g. monday is equal to a preselected weekday within a combo. The first hurdle is understanding how to define a date as a weekday, if possible at all. Thanks a lot for any help Nick

thanks a lot

Hi, very simple. I have this code How do i specify if the value = nothing/zero/empty if you see what i mean. Thanks Nick

How do you create a memo box with those 3 little lines in the bottom right hand corner which allows you to stretch the box larger. Hard to explain but I hope you know what I mean Thanks Nick

Thanks so much, JanR's code is working a treat.

So sorry, still having some issues. With boblarsons code in specific "exit here" throws up an error. with JRs it is the naming of my button and which seems to be an issue. Its not even starting to run the code. I have named the button =SendMassMail("","") is that right? Sorry for being so...

At the moment just this: Heres a screenshot of my query (not sure if it helps)

I have filled in the appropriate information to the code "boblarson" suggested, how should I use this in relation to Mike's code? Thanks again

I am having problems with the line Also with specifying my query using SQL, i have changed the view to SQL but am unsure as to what i should add...it is only a simple query, one field-The email addresses from one table. Thanks again for your help, i really appreciate it.

Firstly whats EOF? Secondly how to I open the query as a recordset (im a novice). Thanks so much for your help

Within my DB I have a form which has a field for the students email address. I have a button within this form which runs an embedded macro and opens MS outlook (new message) with the current email as the recipient. I would like a button on the switchboard that can send to ALL email addresses...

Ahhh, i see. How would I implement this within my DB?

sorry for the late reply, i was at school and did not have a copy with me. The search function was operational however, after adding the option frames, it is now not. Basically I wish to search for an "employer", or student first and last name, ID, and subject. I would like the "course" and...

Yes i have used that code within the criteria and have used the on click event for the option frame. Thats why im so puzzled! Thanks

Hi, i am using the code created by "John Big Booty" to search a list box. I would like to add some option frames which will further filter the list box. I am using this code 'Create a string (text) variable Dim vSearchString As String 'Populate the string variable with the text entered in...