I am creating a database for a cadet Corps, and I want to be able to issue kit to a cadet or to an officer, and have the form automatically deduct this kit from the main inventory. I am using the same form for both, and all fields are entered using VBA. There is a subform attached to the main form, and the main form is for general information (Name, Address, etc), and the subform is used to issue the kit to the appropriate person. The subform uses a combo box, to be able to select the kit from a pull down box.
I have 2 tables, which can be seen from the attachment, one for kit issued to a cadet, and one for kit to an officer. The 2 tables are set up exactly the same (except for the word "Officer" in front of some of the fields on the officer one), and the VBA code is the same for both (again, except for the word "Officer" where needed).
The cadet one works great. It shows on the subform whatever kit is issued to whatever cadet (for example, cadet 1 may be issued 5 items, but cadet 2 may only be issued 4 items. It will show which items are issued to each cadet.).
The problem is on the officer side. When I issue kit to one officer, it shows up on all officer subforms. (For example, Officer 1 may have 4 items, and officer 2 may have 5 items. It will show 9 items to both officers.). Even when I go to create a new record for an officer, before any kit is issued to that officer, all items will immediately be displayed in the subform.
Here is the VBA code for both officers and cadets:
Private Sub IssueKittoCadet_Click()
DoCmd.Close
DoCmd.OpenForm ("frmKitIssued"), acNormal
[Forms]![frmKitIssued]![Label17].Caption = "Issue Kit to Cadet"
Forms.Item("frmKitIssued").Properties.Item("Record Source") = "qryCadetsEnrolled"
First I would like to give thanks to all the knowledgeable folks here who have helped me with my DB to date. It is working and every one is very happy and I have learned a lot.
So now I would like to add some more functionality to this existing project.
My DB is for data input of customers for a drawing. It has the following fields: Id, account number, first name, last name, date/time, score1, score2.
I t is taking a great deal of time for the users to enter in hundreds of entries a day. Most of the entries are customers who are already in the DB. I would like to get the fields to auto fill the data for existing customers say after the account number is entered. So after you put in the account the name and any other pertinent data would shows up saving users from typing it in again.
The first problem I am having is that this is still a data entry form and I can’t figure out how to be able to see the account information and still add new data to the record? The new data is a daily score they get.
Second I haven’t figured out how to call up the customers information from just the account field.
I’ve googled this and haven’t found anything terribly helpful.
The scenario: The “Animals” database contains the “AnimalsInfo” table. tblAnimalInfo contains the “AnimalType” field. User1 is always entering data for Cats. User2 is always entering data for Dogs. User3 is always entering data for Fish.
The question: What is the easiest way to automatically fill in the “AnimalType” field based on which user is entering the record?
I really don’t want to use the built in security feature for this because that entails setting up security and permissions for each user, which is not necessary in this application. :)
I want a help in adding data to a table w/o writing the whole word.
e.g. if a word like " Medical " need to be repeated in many records, how can i add it w/ just typing the letter "M" and the whole word will show up? like what’s happening in ms excel.
My database was working fine until I had to make some minor changes in a few of the fields (which I did in the table and the data entry form). Now, all of the combo boxes in all of the records show the same selection. If I change the selection in one of the fields in a record, it changes the selection in that field in all of the records to that selection. :eek:
"Balance" =[QuantityReceived]-[Stock record table Subform].Form!SumQtyIssued
It is just a simple substraction between a record from a field and a sum of records from an another field contained in a subform. The code is working fine apart for the following situation:
If there is no data, yet in the subform;the value for the "Balance" which should be Just equal to [QuantityReceived] appears for 1/2 a sec and disappear!!????
Just now, my knowledge is pretty poor with codes but what i guess is that Access start the calculation fine, then realised that there is no data in the subform and then cancel the calculation. How can you set the value of a field to 0 or cancel that part of the equation if there is no record for that field?
I've posted in general because I really don't know what approach is best for this requirement. I can't even come up with a meaningful, yet succinct title.
Here's the problem. I have tables:
tblApplication - defines an application (name) tblServer - defines a server tblInstance - defines a partition on a server (defined in above table). tblApplicationInstance - defines a specific instance of an application on an instance on a server (i.e. ties the above three tables together)
The tblApplicationInstance table has an autogenerated ID field as primary key, and foreign keys to tblApplication and tblInstance (and thus through this to tblServer).
All well and good. Now the next table
tblApplicationUse - defines that a specific project (a foreign key to another table but I don't think it is an important factor here) is using a specific application instance over a date range.
The question. How to allow entry of new tblApplicationUse records without having to find and enter the ID from tblApplicationInstance. Rather, I want the user to specify the Application, Server and Instance, but be limited to only those that are defined.
I tried a simple query, thinking it may allow me entry, but not so. I've been building some simple forms for query parameter prompting lately but am fairly inexperienced with these. The crudest form of prompting I can think of is to simply apply a drop-down to the ID field (in tblApplicationUse) and use a multi-column format here. But it ends up very wide and is less than ideal.
Can anybody give me ideas on the 'proper' way to do this?
I am creating a production line database for use on a touch screen (no keyboard or mouse) which has to be really easy to use. At the start of the week i got to the point were i thought i would test what i had done to date and have come across a serious issue.
I thought that the data from the forms i am using to input the data to the main table tblProductionDetails would write into individual records but although new records are created at the appropriate point e.g. when the comand button labelled START on frmDetailsCorrect is clicked the data is not writing to the new record that is created. I thought it would be an easy thing to solve but 20 hours later and much mucking about with DoCmd.Goto's etc i am no further forward. I have attached what i have done in the hope it is something obvious and somebody will be able to point me in the right direction.
The way the db is set up is that frmDayStart needs to be opened the command button clicked and then each form opens once the OK comand button in the top right of each opened form is pressed.
It is still a work in progress so a bit rough and ready but i need to get this fundimental problem sorted before moving on.
Any help appreciated (i am not looking for somebody to do the work on the DB just point me in the right direction or point out what the error might be).
I have a query which combines several linked tables, the query has about 10 columns, I need to show only the records which have one or more empty fields.
Some records may only have one missing field others may have several.
Hi I have a table called Users that is populated via a form. Within this form I have listbox that opens up another form. The problem I am having is that I want them to populate the same record, but currently the two forms populate seperate records within the table users.
Is there a way that I can link them to the same record on the table?
Any help would be greatly appreciated, as I've been trying for sometime now without success.
ID - File Type - Source - Delivery - Return 1 - X - LB - ROY - LB via Roy 2 - Y - USA - Smith - USA via Smith 3 - Z - LB - -
my question is how can i make the last column (Return) to fill like the data above..what i mean if (Delivery) not null So the return will be filled like the above if the (Delivery) is null the return will be null too
-the user will fill only the columns (File Type - Source - Delivery) -the column (Return) will be filled automatically if (Delivery) not null
IVE GOT A QUICK QUESTION ABOUT DATA ACCESS PAGES AND THE DATA THAT IS SHOWN. IVE CREATED A DATABASE THAT HAS AROUND 25,000 RECORDS OF LANDUSE PROPERTIES AND HAVE CREATED A DATA ACCESS PAGE TO VIEW THESE RECORDS. THE PROBLEM IM HAVING IS THAT WHEN I LOAD THE FORM ONLY 1000 RECORDS SHOW OUT OF THE 25,000 THAT I HAVE IN MY DATABASE. ARE THERE ANY SETTINGS THAT ALLOW YOU TO CHANGE HOW MANY RECORDS CAN BE SHOWN? IS THIS ONE OF THE SHORT FALLS OF DATA ACCESS PAGES? :confused: ANY COMMENTS MUCH APPRECIATED.
Howdy.....I'd like to know if there is a way to populate the same field in several hundred records with the same text value instead of typing into each field in datasheet or form view. Macro?
I am creating a database to store employee data, its divided among 3 tables, storing :Employment data,Personal data and Payment data, the 3 tables are related using a 1-1 relationship between the common field ID in each. I`ve created a form through which all data needed for the fields in each table is entered,while entering the data its possible to view the records, however, when i close the form and check the tables, the data is going to the respective tables,however,after i open the table and then go back to the form, its not possible to view the records in the form, they`re still in the table but i cant view them through the form, i can still add new records using the form, but i`m not seeing the old records anymore. Anyone, help?
I am creating a database to store employee data, its divided among 3 tables, storing :Employment data,Personal data and Payment data, the 3 tables are related using a 1-1 relationship between the common field ID in each. I`ve created a form through which all data needed for the fields in each table is entered,while entering the data its possible to view the records, however, when i close the form and check the tables, the data is going to the respective tables,however,after i open the table and then go back to the form, its not possible to view the records in the form, they`re still in the table but i cant view them through the form, i can still add new records using the form, but i`m not seeing the old records anymore. Anyone, help?
uh.. I guess the title pretty much sums it up... Is there a way to enter data in a text box or something once, and have it applied to all the filtered records?
I have it set up so that we can sort by project number, and it displays only the invoices that havent been assigned to a bill (we recover the expenses form our parent company). I dont want to have to enter the same bill number to each of the filtered records individually.
My Membership Database includes 3 fields in the main Table which I need to clear prior to the new subscription year, but on a selective basis.The fields are R/N for (Renewal or New), a subscription date and an amount field (Currency).
At the due date I need to clear all 3 fields except where N/R=N AND date >01/01/2014, when data in all 3 fields is to be retained.I have tried several SQL codings to achieve this but have been unsuccessful so far.
I've got a database of club members with names, addresses, contact info etc.
I need to send letters by post to those members that I don't have email addresses for. How to create a query to return a list of people whom I don't have email addresses for.
I know how to mail merge the info with the letter I've written in word, how to group people who's email address cell is empty.
I'm working on a database that tracks students and grades. I have a tblStudents with Personal details, tblStudentsAndClasses which allows me to have a one-to-many to many-to-one relationship, tblClasses with all the class info, plus a tblGPA.
I'm wanting to list all the Student's names listed with their current class and have blanks for data entry for Grade, Grade status, and have a current timestamp in another field. So the teacher can enter the Grades and Grade Status for all students on one day in a single form (think EXCEL). The way I have it now, is that (x number) grades that have already been entered shows up as (x number) copies of the same student. So my relationships are probably set up incorrectly also.
I can't filter out IS NOT NULL because I wouldn't get any students with grades already entered in.
I've found a post on another bytes.com that is REALLY close to what I am looking for, but I don't know anything about VB to be able to adjust it to fit my requirements. I would have tried to do a forum search here, but I'm not sure what terminology I would search for.
I have a student database and I want to update class manually as the students graduate each year. In my form I want to search the name of the student and retrieve records from last update from a query I have created. To find the record, I search from a combo box with a code:
Me.Recordset.FindLast "StudentID = " & Me.SName
The fields i want displayed for that are LUpdate, LClass and LStatus.
I have a database containing 10,000+ trouble tickets identified by a unique field called "Ticket ID". This is the primary key for my table. (It's on just one table.) These tickets came from an excel sheet that was exported out of a different database. (For various reasons, we've moved the tickets to access.)
Among many descriptor fields, I have a field called "SPR Type" that shows what type of ticket each entry is. (Bug, Defect, Enhancement, etc, etc) The problem we have here is... not all of the ticket entries have an SPR Type listed on my access table because not all of the tickets coming out of the original excel sheet had one.
I was given a new excel sheet containing 400 to 500 ish Ticket IDs and the SPR Type that applies to each of those tickets. How can I take that sheet and use it to update my access table? Ie. Use the excel sheet containing Ticket ID and SPR Type to populate the blank SPR Type fields for each of their respective Ticket IDs?
**Update: I'm trying something like this...
UPDATE [SPR Priority] inner join [EB Update of SPR] on [SPR Priority.Ticket ID] = [EB Update of SPR.Ticket ID] SET [SPR Priority.SPR Type] = [EB Update of SPR.SPR Type]
But I am getting an error that says "Invalid Bracketing of name [SPR Priority.Ticket ID] and similar errors. What am I getting wrong here?
I thought about an Update query that would populate the SPR Type fields based on Ticket IDs. I could import the new excel sheet into a separate access table and update from there.
I have a main form which displays data regarding stock takes for a number of locations. The form is bound to a query which is based on a table containing a STOCKTAKE_ID field which is an autonumber field. The STOCKTAKE_ID is present on the main form
I then have a subform which is linked to the mainform via STOCKTAKE_ID.
When I open the form for a particular location the subform displays data, no problem. When I do the same for other locations the form is blank. If I check the table that the subform is based on, there is a record with correct STOCKTAKE_ID but for some reason the form won't display it. There are also no duplicates.