Search results

Add a label where you want the text to appear, I'll call it "lblMyLabel". In the "AfterUpdate" event for each of the check boxes, add the following code: Private Sub chkMyCheckBox1_AfterUpdate() If Me![chkMyCheckBox1].Value = True Then Me![lblMyLabel].Caption = "Text 1"...

Thank you, almost works, and simpler is always better :) Will work on it a bit further and post back if I get it working...

I am tryign to create a query but just cannot even get my head around how to design it, here is what I want. I have the following tables and fields being used for this query: tblMain.COTRound tblMain.DayID tblMain.StateID tblMain.ProgramID tblPrograms.ID tblPrograms.ProgramName...

This is just an idea from someone with little exception, but could the user's version of access perhaps not have the correct references? I think this would bring up a debugging window though and alert you to the problem, but just one thing to check for...

Wayne thank you, this works perfectly. I really do appreciate the help you have given me, this was my one major road block still standing in my database application. Regards, Jordan

Could you perhaps store the field name in a variable? TextField1 OnExit() strFName = Me.Textfield1.Name ~ Refresh Page ~ strFName.SetFocus I have no idea if this would work, or if the syntax is correct, but the method seems like it would work?

OK, did not know about debugging with single stepping, tried it but is only confirming what I already know, when the recordset = 0 the code is jumping to a label named ErrHandler for some reason. The ErrHandler code is for a completely different function. Anyway. Attached is the database. The...

Noone can help with this? Please?

OK, iof this "should" work then I am stumped. I do not get any errors, the code simply stops after not finding any valid rows. Here is the code in entirety for this section. ' Check if Movies required. strsql = "SELECT tblMovies.COTRound, tblMovies.DayID, tblMovies.StateID...

In one of my functions I want to check if a query returns any rows, if so, keep going, but if not, skip a certain piece of code and then continue on. At the moment, I can get it to keep going if the row exists with: ub = rst.RecordCount If ub <> 0 Then ~ Code to be executed ~ End If ~ More...

Edit: Nevermind, I just realised that the object must have focus for this to work, so guess a hgidden field is out of the question, will just keep it visible then. Thanks.

One more quick question. I have a form that contains 1 textbox and two combo boxes. All I need to do is pass the values of those three fields to three hidden text boxes on a second form, which is opened when the first form closes. Now I thought this would be simply a matter of setting all...

Thank you Pat. That works perfectly. :)

Does anyone know how I can set the criteria of a query in design view to a public variable? Cannot find any info in the help documents. Access 97. Thanks guys,

Just a bump back onto the first page. Anyone got any suggestions at all? Also, does anyone know where I can find a reference for MS Word DDEExecute commands that can be used in VBA in Access? Thanks :)

OK thanks for the help so far guys, I appreciate it... Mile-O-Phile: My VBA skills are only meicore at best, but I will try and see if I can figure out your suggestions. Oldsoftboss: Thanks for the code to change the icon, interesting, may employ it at a later date. Also thank you for the...

Hi guys, this is my first post here, hope someone can understand my babbling and offer some advice :D OK, well I am setting up an Access 97 database at work, and have little to no training in the program, so most of my results end up being workarounds at best, so long as the database does as...