RTaylor1853
Last Activity: Oct 2 '10, 07:40 AM
Joined: Nov 9 '08
Location:
-
Well then, that's out of the quetsion.... -
If that's done though, would you still be able to add stats for the current month? All stats are in the same table, use the same form.Leave a comment:
-
Is it possible to lock portions of a table?
I have a form that stats are put into. I was wondering if it was possible to lock portions of that table attached to the form to prevent changes to previous months stats but still be able to view them and still be able to add/edit "this months" stats? I've almost debated on just separating the stats info into different tables if that would be easier. Any thoughts? -
Yep. Again, thanks sooo much for all the help!!Leave a comment:
-
To your post:
While I'm looking at the code (references to external form controls is the trickiest part generally - See Referring to Items on a Sub-Form).Leave a comment:
-
Whew, thanks everyone for all the help. Really couldn't have done it without you. So anytime you're adding a form within a form and you're wanting to control one to another you have to establish a SubForm control?Leave a comment:
-
No problem, I was at work when I typed all that so it gave me a chance to ignore anything else that needed to be done :D.
The item I want set is the Location - text field on the [EMS RUN INFO] form to the corrosponding number clicked on the [county] form.
so like commandbutton1 = region one on map - when clicked it will default 1 into the location field on EMS RUN INFO form
commandbutton2; when clicked...Leave a comment:
-
Well, let's hope this thing doesn't have a text limit:
FORM 1 - EMS RUN INFO
Account Number - Text - Account Number of patient
Patient Name - Text - Name of patient
Medical Record Number - Text - medical record number of patient
EMS Run Number - Text (Primary Key) - EMS Run Number
Unit Nmber - Text - Ambulance Number
Incident Address - Text - Incident Address
Caller - Text -...Leave a comment:
-
Ok, so to do list, change rectangles to command buttons, but I guess I'm lost on what more information need to be given. Sorry. I just jumped into this feet first and I'm hopeing to land on my feet, but if not oh well. Ummm. it's microsoft access 2003Leave a comment:
-
I have the boxes drawn on the map on Form 2. The map is divided up into 5 regions. If the incident happened in the 1 region, it would be nice to click anywhere in that region and the 1 would be inputted into the Location field of Form 1. Or if it happened in region 5 then click on 5 and it's inputted into Form 1 Location as 5. Does that help?Leave a comment:
-
Box to Default Info
I have two forms. The first form is Stats and the second form is just an image of a map. I have drawn boxes and set them as transparent over the map and I want to be able to click on the image and have a number associated with that region of the map to be insert into another field on the Stats form. I know no coding and was just trying to see if this is possible? Any ideas? Thanks! -
ISSUE RESOLVED. Thanks for all the help.Leave a comment:
-
Sorry, I'm not that advanced..where would I add the .Caption? I removed the text box and changed it to a label and then played around it with every way that I could but could not get anything to come up.Leave a comment:
-
THANKS!!!!! I got that to work, but I still have a little problem. When I open the database it automatically goes to a record. Then it will store that persons name in the table and then when i scroll to another record it erases that name that is displayed and won't store anymore names. Any thoughts? Again thanks for the help and the welcome.Leave a comment:
-
Storing Windows Name In Table
I've got a textbox that when in form view it displays the users name just fine. but when i go to set the control source to the LoginName so it saves it to the table I get this error:
Run-time error '-2147352567 (80020009)' You can't assign a value to this object.
I click on Debug and it brings up the code at the very bottom and highlights this:
Me.LoginName = GetCurrentUserN ame()
This is...
No activity results to display
Leave a comment: