Search results for query: *

I have five positions with the same title and other information and the positions are split into two at Location1 and three at Location2. What I am needing the dbase to do is: First: Understand that there are only Five positions (e.g. Five Clerks) Second: How can the dbase know when there are...

I searched the posts and did not find a solution to my problem. Any help would be greatly appreciated. - The form allows the user to Select the Region (North America, Asia, etc) of interest. - Subform 1 lists all countries associated with the selected Region for the user to select. -...

I have three tables: Region, Country, City In TBL_City I have information that I need to perform math functions and represent in a graph (if possible) to compare the information from two separate cities. On the Form I will first select the Region (North America, Europe, Middle East, etc); in...

I have a combo box that will have job names entered. Each job has multiple contractors that require multiple entries for each job. What I am wanting is for each new record to default to the last entered job name with the cursor ready at the first field requiring further information. Your...

I have a typical New Record button on my form and it does create a new record when pressed. What I would like is for the cursor to appear in the first field to enter new data instead of me having to click in the field (after clicking the new record button). Thanks ahead of time. Tony

Hello, I am manually keeping track of my postage stock and reports. I would like to create a dbase file that would do the tracking and allow me to simply enter in the number used and print the report at the end of each month. The next month would simply continue on with the tracking. I would...

I done a search and scanned through the posts and did not find an answer to my problem which I hope to have answered here. I have Column C doing a very basic calculation such as: Cell C3 = +C2-B3. The entire column is doing this and currently I have three sheets being printed because of the...

Here is the equation: Fld1: 8 Fld2: 12 Fld3: 15 I need my calculating field to do two things. FIRST, the simple part: =([Fld3]/12)+[Fld2]+8 SECOND, where I am confused: I need to use an IIF statement to look at Fld3 and do the following: If FLD3 is <49 then add 1-6 points to the above...

My form has six or so fields that require a Random number to be generated. These generated numbers affect other fields deeper into the form and are working correctly (some thanks to this forum already). When the form is open I am wanting to have a button that, when pressed, will cause the...

I have two separate dbases that encompass all of my personnel. All of the data that I want to track is coming from this source, but I don't need the amount of information that the original is tracking. So, I created a dbase with like field names and done a simple Append query to pull in the...

I have TblUnit that stores Unit data with the main field being the UnitUIC (unit identification code). The UnitUIC connects everything from all of the tables as to who and what goes where. The are two UIC's: WPB7AA (the HQs) and WPB7A1 (1st Detachment). I have TblParaLin (Paragraph and Line)...

My dbase provides a field for the user to select where a soldier is Active, or not, in the unit. When the form opens I would like for it NOT to show any file with the Active box not checked. Currently I am scrolling through the records with both Active and Non-Active members coming up for...

I am wanting the user to enter the Date of Birth for each record. The Input Mask that I have is: 99\ >LLL\ 00 For instance, my DOB is 04 AUG 70 - which is how I want the data to be entered and to be shown on the forms and reports. Once the information is entered, as shown above and you go to...

My form has several items that require sizes (located in the combo box pulling from a query) and an associated four digit code (located in an autofill box to the right of it). When I select the combo box the drop down menu shows every item on the list that requires a size selection, i.e. when I...

Same dbase, I have to issue equipment where the stock numbers (NSN) are required on the report. The sizeable items have different NSN's, i.e.: Helmet Small 7526 Medium 7527 Large 7528 I currently have the form set up with the bound...

My form has a yes/no field called Attached, asking whether or not the member is part of my unit but attached to another. If this is marked YES then I want another field to appear underneath it asking &quot;To Whom&quot; the member is attached. Your help is greatly appreciated. Thanks ahead...