zmbd
I'm by no means adept at Access 2010, so I know what it's like when you need help to take the next step. I was in mitthu1992's shoes with passwords etc a couple of months ago, and I found the best thing to do was to think about the steps to achieve what you want to do, and then figure out the forms and programming to get there.
Simmo160
Last Activity: Mar 11 '14, 09:05 AM
Joined: Oct 18 '13
Location:
-
Thanks for the above. I'm beginning to think I'm in out of my depth!
My problem is that if I want to add extras to a wiring diagram register in a quick and easy manner, it's easier to do it using check boxes. However, if somebody wants a drawing doing where the extra is not included on the form, then I'd have to add it and code in design mode. By using a calculated text box, I can add it to a table and refresh the form putting that addition...Leave a comment:
-
The way I did password on my db was:
Create a user table with
[UserID]-Primary Key Autonumber
Try again.
I created a user table with the fields:
[UserID] PK - Autonumber
[FirstName] - Text
[LastName] - Text
[AccessLevel] - Number
This form would load first, so all others were locked out. Depending upon the AccessLevel, the next form would have...Last edited by zmbd; Nov 3 '13, 03:29 PM.Leave a comment:
-
Which is best? Multi-Value ComboBox or Check Boxes?
I'm doing a drawing register for generator control systems and have a Multi-value combo-box for the extras.
The first register I did had check boxes, but I didn't foresee the amount of extras that would come my way, so I went down the MVF Combo route which allowed me to enter as many extras as possible without the form looking like Swiss Cheese!
However, if I want to create a type of bill of materials, I can't find out how... -
Okay, so I created a sub for the Case Select, and that works as I want it to. I can also see the benefits for a separate table and DLookup if I was entering the sizes from scratch. So thank you both. Happy chappy.Leave a comment:
-
Thank you for the responses. I'll give them a go over the next couple of days.
Sorry if I posted incorrectly. This is my first question, so bit a newb.Leave a comment:
-
I need to return 1 value based on an equation
I'm trying to do a form that returns the size of a circuit breaker when the kVA and voltage are entered, with a calculation behind the form working out the current.
Current = (kVA * 1000) / (Volts * 1.732)
However, I cannot find out how to do this, except by calling consecutive subs.
So, for instance, Current could be 17 Amps, 26 Amps, 45 Amps, anywhere up to 6300 Amps.
Circuit breakers are sized...Last edited by Rabbit; Oct 18 '13, 04:27 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.
No activity results to display
Leave a comment: