Search results

Hey Guys! I got it! Thanks a bunch! As Always, Justice

Firstly, thank you for your help. What I am attempting to do seems as if it should be REALLY simple. I am trying to link two different forms. 1) My main form 2) A related form (though not a subform) I want, when I click a button on my database, for the secondary form to open... and to have...

That was the syntax I had... Here's the code... Private Sub Form_Current() If IsLoaded("Termination") Then If IsNull([Partner ID]) Then strFilter = "[Partner ID] = 0" Else: Forms!Termination.Filter = "[Partner ID] = " & [Partner ID] End If End Sub In practice,however,it...

Hello All, I am trying to use the IsLoaded function, and although I specify the name of my form "Termination" when the code runs, it insists that it can't find that form, though it sits, quite plainly, in the form list. Shouldn't "Forms!Termination" refer to the form I have named...

Hey Folks, I was asking earlier about how to synchronize records on a form, and someone pointed me to the help file on it. However, the instructions call for me to use the IsLoaded function "from the Northwind Database" Now is this a normal function native to Access or do I somehow have...

Hello, Can anyone help with the above problem? Justice

Hello... I tried the code and I can't seem to get it to work quite properly. Can you give me a breakdown of what the variables in sCount and dCount are? Thank you! As Always, Justice

I will try this and see if it works... Thank you very much for your prompt reply.

Are you planning on having it search internal data (data you guys put into the database) or external data (stuff out there on the internet)?

For clarification... I already have the separate tables linked in a relationship, but when I bring the secondary form up, I can't figure out how to assure that it links to the currently open record on the main form.

You might try uninstalling and re-installing Access... it won't do anything to the current database file, but it might repair something that might have been corrupted.

It sounds like a general bug. Are you running the Access software off of a network or off of your computer's hard drive? If it's the network, there may be a problem with the installation there.

Hello, What I am attempting is to bring up a form from a control on another form. This form is not a subform, but I would like it to contain information that links to records in the main form. I.E. I have a list of Girl Scouts, and I want to pop up a form by pressing a button on the main...

Hello, What I am trying to do is to write code for my form such that if a person enters a name in the "Company" field, the database will automatically check all the records to see if that name (or something similar but not identical) exists. i.e. I put in Barnes & Noble, and the database...