Search results

Hey all. Access initiate here. I have a command button that runs a macro in the Header of a Main Form: OpenForm Switchboard, Form, , , , Normal Close Form, MainForm, Prompt StopMacro It does what I want it to do - a button that closes the Main Form, and opens the Switchboard...

That's brilliant. Thanks, Mr., uhh... Big Booty. :)

Hey all. I'm using a form to enter data. On the form, there's input fields for basic stuff. Last name, first name, middle, etc. Aside from using a label on the field, is there a way to display default data in the input field that is cleared when selected? Intent: The input field for "FName"...

JHB - At a glance, this seems perfect! I'm kinda reverse-engineering what you did. I'm sure to learn a lot about this process. I can't thank you enough, man.

Done. I really appreciate it! I started a report. That's the general layout I'm looking for. I just don't know how to make it reference the data from the multiple tables, and make it relative to the "SM_ID". That, and each line in the report would essentially be a calculated value. //Edit...

Guys, I'm pretty stuck on this. I'm looking into update queries to see if that's a solution. I'm learning here, so feel free to give me a pretty detailed answer on whether I'm on-track or not.

Hey all. I'm rather new to Access. I do have a good understanding of relational databases and such (Took a few college courses), but I need some help with this. Overview: - It's a database for tracking the performance of Soldiers in our unit (US Army, active duty Soldier). - Includes the main...

Seeking clarification on how to assign a numeric value to weapon scores. Please see DB for details. I'm referring to "SM_Form", "OML" Tab (which loads the "OML_Subform"). If you score Expert, you get say 150 points. Sharpshooter = 130, Marksman = 90. (These values are defined on the...

I forgot to re-assign the relationships after I changed some of the tables' data types. Thanks for the info! That solution taught me a lot!

Thanks, Isskint. By combo group, I meant value list. I read somewhere that it's best to use a value list on a form, rather than have the option group on a table. Here's my current dilemma; I'm unable to view data from other subforms on the "OML_Subform". All it shows is "#Name?" in form...

//Edit: I didn't want to clutter and post a new thread. Uploaded current version of my DB as of 2012.12.22) Hey all. Novice here. (I've had several relational database classes, but -online-...) Here's the gist of it. I have a database that keeps track of Soldier performance / training...

//Edit - Disregard this post. Had a problem -but I worked through it. It claimed to have too many fields defined. Just had to repair the DB to make it work.

Sounds good. I redesigned the tables. I have two now - Only because the attributes are different - Pushups and Situps have Reps as attributes, whereas the Two Mile run has times as the attribute. I'll finish the tables as per your advice, then I'll probably come back to get some help...

Thanks for the info, BigHappyDaddy. I knew I would have to make several tables for the APFT score data, I'm just looking for the most efficient way of doing it. I've attached an .mdb format of the database. Here's what I -think- i need to do: - Create APFT Score Tables - - One for each age...

I'm sure that this wouldn't stump you guys. I hope my OP wasn't too confusing. The forms are generated - the only issue I have is with calculating the "raw" scores into into APFT scores. How do I go about entering a person's age, sex, and "raw" scores, and having Access calculate that...

Access ninjas, where are you?

Hey all. Relatively new to Access, but I did take a few undergrad classes on relational databases and the like. I'll get right to the point. I have attached portions of my database to get better feedback. I'm using a subform "APFT_Subform" that I would like to do several things. Task...

Ok. I'll make the changes the next time on the SIPR network. It might be a few days, I have to fly out of Baghdad in the morning. JR, the code was working before - but with a different DB. I'll try the replacement you suggested. Thanks! -J. "Jon" Rogue

Ok - that makes sense - in the first line of code: Dim ID as Long That probably referenced to a field in one of the tables from the other warehouse's database. I changed ID to ISN (Is that right? It needs to reference a field?) Now, I'm getting a new error, same line is highlighted...

There may be some typos in the code. I had to manually re-type it into a NIPR (Unrestricted) computer to post it on this forum.