Here is a great starting point.
https://support.office.com/en-us/art...0-e4a769f3592f...
phillikl
Last Activity: Nov 6 '17, 02:28 AM
Joined: Mar 11 '09
Location:
-
-
GC,
Wow - the possibilities are literally endless...
First thing I would check - does it compile? If so, I would make sure your security settings are relaxed enough to at a minimum show the Enable bar... read up on trust settings...
Those are the absolute basic checks. Without seeing or knowing any other info; if these don't work, it will be next to impossible to assist.
Best of Luck,
Ke...Leave a comment:
-
Thanks Neo! Will definitely add this to my toolbox of goodies!
KendallLeave a comment:
-
I have to second Neo's reccomendation of pulling the logged in user. With all the passwords we are required to remember in today's realm - it's easier to use the measures in place already. Another positive aspect is you don't have to worry about lockouts and it takes a more "savy" explorer to figure out how to change permissions.Leave a comment:
-
Dums,
Not sure the reasoning behind VBA, however if you would like to use a query to drive the form...
Create query to drive "frm_beneficiry " with the elements you would like to see.
Create an unbound text box control [filterText] on your search form.
Create a cmd_button to requery results ()(after user puts information in the box they can launch the query).Code:DoCmd.Requery
...Leave a comment:
-
Thanks Neo!
Forgot all about driving public functions from the properties. It's the easiest things that always get me - and being the only programmer, makes it hard to bounce ideas.
For anyone else requiring a solution similar:
create unbound text box of form (txtStatus)
set the properties to:
On Got Focus: =setStatusBarTe xt()
On Lost Focus: =clearStatusBar Text()
...Leave a comment:
-
unbound textbox to display Status Bar Text when control has focus
Good day,
I have racked my head against the wall so much over this I believe I have a flat spot....
Customer desires a form with a larger font for the Status Bar Text and located elsewhere on the screen - make shift instructions when a user clicks on a field.
While the simple answer is to utilize on.gotFocus and on.lostFocus the form has around 100 controls and not only a pain to code, but clutter is horrible.... -
Thanks TSC! That was the road I was thinking, just needed a reality check.
Understand all on the naming convention; just wanted to make the example as simple as possible.
Thanks again for your help,
Happy Holidays,
KendallLeave a comment:
-
ACCESS 2007: Updating Multiple tables
Good day,
Having a total brain fart on this and need some help.
Access 2007
2 Tables
Table1: Director (200 records)
Field1: Name
Field2: phone
Table2: Order_Summary (414,000 records)
Field1: Name
Field2: orders
Director!name to Order_summary!N ame Relatioship
Desire:
Enter Company Name to Change (user enters name)VAR1.... -
Tree View / Heiarchial View (Access 2007/2010)
Good day,
First would like to say I use this site to find more trivial stuff than anyplace else.. THANKS!!!
Been looking for a few hours on this and seem to be not asking the correct question.
I am attempting to build some "Strategic Planning" software and my boss would like to see a tree or heiarchial structure:
Example:
1. Pet Products (category)
..1.1 Food... -
Thanks Fish, and Thank you Neo!!
I'm pretty good at figuring things out; just need a small push in the right direction at times :)
I have setup the Many-to-Many relationship; I understand the concept, still doing some research on the limitations. Thats one thing I have noticed about all these expensive books... They are always more then happy to tell how to do something, but never the why and ramification....Leave a comment:
-
The *animal* field is where I have speed bumps.
I have been working with each animal having its own field in the tbluser
example:
tbluser
cat - yes/no
dog - yes/no
gerbil - yes/no
hedgehog - yes/no
etc..... (you can see now the redunancy issues)
or
new table:
tblAnimal
animal - text - linked to the tbluser!animal for list capabilities...Leave a comment:
-
Table Architecture to Host super-multi query
First off would like to say thanks for helping out with my last question! You guys are the bestest!!
OK now for the fun stuff. I am making a template "KISS" (keep it simple stupid) database. What my goal is to have a User create a login and profile of which animals they like. The database would then take thier selection of animals and ask specific questions for that type of animal. Then store the results into the Results... -
Trixx,
I am in the same boat as you. Not sure how "large" your company is, but for the Navy this is how I have mine setup.
Send the database to command. They share the database to all users with modify permissions.
End user creates own unique login/password.
Survey is complete; admin returns survey via (email, cd, sneaker net, or txt output).
...Leave a comment:
-
Thanks for the help, do to company policy and information I am working with; I am going to have to put this differently from the orginal. Once I get my architecture rebuilt, I will back for questions For Sure!!
Thanks again,
KendallLeave a comment:
-
Another set of eyes.....
Good day,
I have inhereted an Access DB that is used to ask people questions about network maintance. I have been tasked with ripping this thing apart and creating a new version. I have most of everything figured out, but need some advice on the actually query of the questions.
*DB Operation* When the user first uses the db, they create a user profile; login name, password, phone, etc..... They also define...
No activity results to display
Leave a comment: