Search results
-
R
From Main Form, Click Open Switchboard Macro - Stop Saving Default Data as a record!
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... -
R
Display Desired Format in Field, Clears on Focus (Easy question, I hope)
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"... -
R
Report to Include Calculated Values from Several Tables
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... -
R
Assign Numeric Value to Options in a Combo Group
//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... -
R
Queries with Multiple Criteria
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... -
R
Compile Error - Please verify my code
Hey all, I have a problem with a query. I'm trying to generate a kind of report. The database is for a warehouse of sorts. What is supposed to happen is someone Pulls up a Form (Pull_Sheet_Helper). They copy / paste a list of IDs into an unbound field called "isnlist". From the list, it... -
R
Save Button - Saves both Main Form and Subform
Hey all. I am looking for a way to save both the form and subform with the click of a single command button located on the main form. I'm aware that the fields auto update when you go from parent to child, but that's not what I want. For this form, it's important that the forms do not auto... -
R
Subform problem - Data in Row 2 auto. changes data in Row 1
Hi all. I have been tasked with building a database from scratch. I know little about Access, and almost nothing about vb. The database is for a warehouse of sorts. So far, Most everything is going just fine. I have a question about subforms. My main form has an ID assigned to a... -
R
Question Copy and paste a list of IDs -> Generate a spreadsheet with relative data
Hey all. Sorry if this is a newbie request, but this is the first time I have created a database for a warehouse from scratch. I have my data tables set up so that each "Customer" has an ID, and each ID has a list of relative data - including the location of their property in the warehouse... -
R
Subform - Link info to Main Form
I'm trying to use a form for a Warehouse. I have an ID number for each "Customer" on the main form, and a property list on a Subform. How do I link the two forms so that every time I bring up an ID number on the main form, It loads the property list for that ID on the subform? I apologize...