Search results

Hi, My table has a category field and a status field. Each category can have up to four statuses (open/closed/hold/resolved). I have a query that will provides a breakdown of the table by category and within each category, it lists the total count of each type of status. My dilemma is that...

HI, I been trying to figure out how to have three combo boxes update two text boxes with no luck. I'm lookin for suggestions/help I have a table that has fields ID (PK); MAJCOM; baseid; base, unit, state, and country. The majcom, base, state and country fields may have duplicates in each...

All, I have modified the call tracker database template to the suite my needs but one issue has arose that I'm seeking inputs on how to handle. I need to have three copies of the database running on three seperate computers (one being the master), all will be at diffferent locations...

Hi, I have imported an excel table into access succcefully. The records contain the following fields: NIIN, FSC, SD, NET QTY, NRTS QTY, Credits, Net, and Noun. Each record has a very unique NIIN. I have written a query to find all duplicate NIIN records and sum up fields NET QTY, NRTS QTY...

Hi, Is it possible to call/run a macro from a combobox but it is NOT based on the combobox selection? I know you can do it based on the combobox selection but that is not what I want. I have the user make a selection from the combobox and store it as a variable under the afterupdate...

I pulled this code off of the MS knowledge database for using the API windows common dialog box to browse/select a file. It works great but it places the file path into a text box. I would like it to store the filepath as a variable for use later on in the database session. Ideas on how...

Hi, I have been trying to import and excel spreadsheet into access 2007 via a command button with no luck. If I use the external data wizard it imports Ok. Can anyone help me with the code? My source excel file is in the documents folder and is titled 'new wucs'. The destination table...

Hi, I'm trying to determine if a check box is checked when I view a record. What is the best way of doing this? I have tried IsNull, but that doesn't seem to work. My goal is to check the checkbox; if unchecked, remind the user to check the box and then resave the record. The...

Hi, I'm trying to use a command button to run a report and save the results to a word document. I am just beginning to dabble in the reports arena and am unsure as to the best way to tackle this operation! My research appears to lead me to using the docmd.OutputTo action but am unsure on...

HI, I have 10 tables in a DB and one form (based on table 1) so far. I need to take the SSN field info from the form and place it into the other 9 tables. I have created 9 append queries (to update each form individually). I would like to execute all nine queries, via an on click event...

Hello, I've created a query that finds all of the dates for specific types (monthly, quarterly, semiannual, annual) of evaluations. It works great, shows all evaluation dates for each person. What I really need it to do is just show the most recent (i.e. latest) evaluation date for each...

Hi, I haven't dabbled with queries much and am at a standstill. I have a table called Personnel. Another table is called evaluations that is related to personnel via a primary key, SSN. this is where the evaluations date is entered based on the SSn selected. On a form is a combo box to...

Hi, Need help with text box issue. I have a form with a combobox that allows the user to select Monthly, Quarterly, Semi-Annual, or Annual. The resulting selection is stored in a field called timeframe on a table called Personnel; but the stored data is a number (1,3,6,12 respectively)...

Hi, I'm trying to come up with the best way to limit users access to certain areas of my database. For example, I want only training managers to have access to the "training" menu item on a customized menu bar (and everything else on the menubar) and general users access to everything but...

Hi, I'm starting to work with modules and need some help with functions. I have created a custom menubar with menus like File, Admin, Reports, etc. I would like to have my top level Admin form, for example, open when I click on 'Admin' in the menu bar. I think this can be done with a...

Hi, On a Form called "Class Size", the user annotates how many students via a combo box. I would then like a new form or even a subform to be created that contains data entry text boxes for the students name. Once names are entered, I would like to store each row as a record in a table...

Hi, I've have seen an access database in which a field/box ask's for the number of individuals required for an event. The User, through either a list/combo box or direct entry, enters the number. As soon as user tabs out of box, a subform appears with the same number of empty lines ready...

Hi, Is there a way to use the input mask to capitalize the first letter of text typed into a text box? I've used >L<????????? and it works as long as I enter enough letters to fill all of the question marks. I get an error message if I use less. I'm looking to capitalize the first letter...

Hi, I am having trouble trying to get a subform to show a record selected from listbox on the main form. Using the list box, when I click on the desired info, I can get a seperate form (InstructorList) to open and show the complete record using the following code: In the listbox...

Hi, Haven't used the 'ondirty' property before and am having trouble with it. I have a main form (PersAction) with a subform (PersAction_PersData). After Insert button is click, subform appears ready for new data. click save works great. I wish to have an undo button on the main form...