Search results

d'oh! I feel like such an idiot! Thanks for that JANR, just tested it and it works fine. Another question, can I write a universal function for "on error call "universal_function"" rather then type a "on error goto..." before each sub?

Hi! I'm almost finished coding my database and I wanted to include an error logger in it. So I looked up Allen Browne's error handler, basically it says to include the following in every sub used: [/FONT] Which I did and it works fine. Then it asks to create a table which can log errors...

Thanks Bob! I was afraid you might say something like that lol! And it makes sense, I just thought I'd try doing it the easier way Btw, if anyone else is interested I figured it out finally: Private Sub btnView_Click() Me.Refresh Dim StrDonor As Boolean StrDonor = Me.chkdonor Dim StrNGO As...

Hi again, I've tried everything and nothing I've tried works, has anyone got any ideas?

Hi! I have tried googling this but I am unable to find anything close to what I need. Basically I have a form: frmdirectory, which has a subform frmcontacts2. Now basically the subform displays all the contacts stored in the directory. Each contact has three checkboxes columns: NGO, GOPC and...

Solved! Me.Filter = "Month(EvntDate)=" & Me.cmbMonth & "AND Year(EvntDate)=" & Me.cmbYear The above filter works! Thanks everyone for helping me figure it out, couldn't have done it without your help.

Anyone have any ideas, as I have been smashing my head against this and nothing works! I'm sure theres an easy way around it but my novice experience in Access is slowing me down. Help very much appreciated!

ok, I removed the #'s but its still giving me a Run time error '3075' syntax error (missing operator) in query expression "[EvntDate]=And [EvntDate] =Year(EvntDate)=2011'.

Ok, i've got this so far but its not working, its giving me a syntax error: Dim filtM As String filtM = "Month(EvntDate) =" & Me.cmbMonth Dim filtY As String filtY = "Year(EvntDate) =" & Me.cmbYear Me.Filter = "[EvntDate] =#" & filterM & "And [EvntDate] =#" & filtY Me.FilterOn = True

Thanks guys, and Im sorry to sound ignorant but I don't know much about queries. Is there a way to implement this in vba? I feel i'm more comfortable with that, even though i'm still finding my feet! Thanks!

Hi, I have an EventCalendar form, which has a continuous sub form. Basically, i have one combo box with different months listed and another which has years (2011 til 2030), and a command button. Now the subform has all the records about all the events users have recorded, including date...

Here it is

JJB, or anyone else, any suggestions related to my questions?

JBB! Your a genius! Thats what I was looking for to help me create a search. I will need a bit of help troubleshooting though. Ok, so now adapting your code a little bit to what I required, I put the following code on the command button I mentioned earlier (btnSearch) on its OnClick event...

Sandbox's suggestion is good, however, i would prefer not to have a temptable, reason being if a user needs to make changes to the data that they have searched for, I assume that will not be possible. Is there anyway to filter the table according to the search string entered in the txt box? Or...

Hey, sorry about the late reply. The solution was actually their was an autocorrector, which would only work if you put in an 'i' and it would automatically capitalise it. When it did that, i think it threw off the object focus in the code and produced that error. Once the auto corrector is...

Thanks Mr.B, problem solved!

Hey DCrake thanks but this doesnt help me as there are no forms in your database, which is where my coding is.

Thanks Mr.B, the second problem has been solve. NigelShaw, i dont want passwords to be case sensitive so thats ok. Now for the first issue, which is the most pressing... I am using the code: Private Sub Command10_Click() If IsNull(Me.txtLoginID) Or Me.txtLoginID = "" Then...

Hey, I have a form which I have used for users to login to the database. This form works well, but i also added a "change your password form". This form has a combo box which has the user name and three other text boxs (txtOldPW, txtNewPW, txtNewPW2). It also has a change password button too...