Search results

Assuming that the bound controls are all going to be link to the same fields on both queries this works. Create your two queries as per normal and set the default query as the record source of the form via the properties. Add your button that toggles between the two queries and insert this...

I'm actually trying to avoid typing the name of the control into the code. I'm looking for a key word that will pass the reference of the object actually making the call. I know Java does this with the "This" object, does VBA have an equivelant?

Assuming that you have a Unique Key in your table try this. Create a public sub routine that looks like this (just type "public sub blahblahblah" outside of after any "End Sub" in the VBA section): public sub RetrieveAndTotal(Key as Integer) Dim db as DataBase Dim rst as Recordset Dim SQLStr...

Is there a generic way to pass the reference of a control to a module(Like you use "Me!" for the current form)? What I am doing is calling a sub that executes everytime a user enters or exits a field passing a refence of the current control to the module. I.e private sub my_Control_GotFocus...

You could always just change the form to modual so the user can't click outside of the form. You could always have a try at catching the application close event through the API. I haven't tried this myself... the above usually is enough. [This message has been edited by Emohawk (edited...

Open up the properties of the combo box you wish to add your code to, go to the events tab and click on the field next to "On Change" and select code builder. This will bring up the VBA editor for that combo box. Repeat these steps for your other combo box(s). This should create a new sub...

This is most definately possible but to give you acurate help you'll have to give us a more detailed explanation of what you are trying to do...

In the After Update event of you combo box put this. If My_Combo = "Some_Value" then My_Field.Locked = True My_Field.ForeColor = 0 'Whichever colour for grey else My_Field.Locked = False My_Field.ForeColor = 0 'Whichever colour for black End If HTH

I found code in the Access Knowledge Base that allows you to register if programs are open by applicattion name. Have a search through there incorporate your code and then search for the DUN to see if it is active. Haven't tried it myself but I am sure it is possible.

Argh!!! When the access window is minimized the timer function halts. I getting the feeling that this wont work in access any help/work arounds? The code I found in the microsoft documentation apparently works but if everything in Access halts when will the call to check if the application is...

Looks like I'll have to give myself one. Found the code neccesary to minipulate the windows handle here: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q147214&GSSNB=1 Thanks for your help anyhow! Always good to meet a fellow dwarfer.

The DB itself runs fine, it's already in use. Just was wanting to get some add functionality. I've found some code that responds to the window being minimized however as the application is minimized this event isn't triggered as the app itself still thinks the window is still open. Any ideas...

I dont think Access is capable of this (well I've never seen anything like it in the literature or forums...), the best way would be to write the code in a more suitable language like Java and uses it's JDBC:ODBC link to port the info into the database. I guess this doesn't really help if you...

I've written a smallish chat room program in access 97 for my team at work to "boost productivty". What I need to know is, is there a way to create a pop up message box that appears when the access screen is minimised, ala Microsoft Messenger?

Thanks... I thought the wizard was only over two tables, but was wrong. Finally worked it out though (my server was down so I couldn't check the response) I got the same result from writing a query that joined the table to itself and then searching for indentical loan numbers with differing keys.

Hi, Simple one here. I have a table with loan numbers and the associated loan information stored. What I need to do is pull every record where the loan number has been duplicated. Cheers.

Not really understanding your problem as the picture you posted does not show up at my end. Are you able to give me a bit more info?

Using the module approach, works a treat. As an added benefit I can now pull code out of my forms to improve reuse. Sweet. Thanks

I need to pass a boolean value from one form to a second form (a pop up screen) and then back, this seems like such a simple operation but I can't seem to work this one out. ARGH!!! Sorry, the Topic should read Variables... Not sure what varibales are... [This message has been edited by...