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:
View RepliesI have this scenerio that I am trying to work through and find a proper solution:
Main table stores a part # and an index (Primary Key) along with a bunch of other data. I want to store with the part # the current active version of firmware (aka software) associated with that particular part# / index. Part # may be a duplicate, so for this reason the PK is the index, so that each index / part # will have which firmware has been used with it.
I would like the ability to retain a history of firmware versions used for a particular part # / index so that if we need to go back to a previous version of software we will know which ones have been used.
I have been able to create the relationship to show all previous versions of the firmware used for a particular part # / index, but cannot figure out how to only have one 'current' and update the others as 'archived'. I would like to either use a boolean or selectable lookup (ie Current vs. Archived). What I want is that when I select one firmware to be ‘current’ all others related to the particular part # / index are updated to ‘archived’ leaving the other records not related to that part # / index alone. Also note that I am trying to make the update of the firmware status in the table view without having to go through a form.
Main Table
ID (PK)
Part No
Product
Firmware History
FirmwareVerIndex (PK)
PartNo
Firmware
ChangeDate
ChangeName
FirmwareStatus
Firmware Table (lookup table)
FirmwareIndex (PK)
Firmware
FirmwareFileName
FirmwareStatus (lookup table)
ID (PK)
FirmwareStatus
I have a table that has multiple records (count >1). I used the find duplicate records and then made it a delete query, however, this resulted in deleting all the records that had count >1. I need to retain distinct record, and delete the extra records. Using select distinct.. I do not want to use VBA to achieve this, but at the same time be able to incorporate the steps in a module that would execute the queries in a sequential order and achieve the same results.
View 6 Replies View RelatedI have a text box in a form. When the value in the text box is changed, a message box appears asking if the user wants to change the value in the text box. If they select "Yes", all is good and it goes on well, but when they select "No" is it possible for the text box to retain its previous value?
For example.
The value in the text box is "1". The user changes this value to "2". A message box pops up asking if the user wants to change the value, the user select "No" and so the value in the text box goes back to "1", the number it started with before it changed.
in a Dbthere are 2 fields which contain 'matching' data. (there are other columns too)
A Genesis
B Exodus
C leviticus
D Numbers
E Deutronomy
I want to shuffle both columns so they are both randomly mixed up
B Numbers
A Exodus
C Detronomy
E Leviticus
D Genesis
How do I do it?
I have explored the random function but that randomises the records but keeps each record intact.
I then want to print these two columns to a report which numbers each line - easy enough once I have the query BUT I want to print an 'answer page ' at the end of the report which will look like this:-
1 B Numbers (5)
2 A Exodus (1)
3 C Detronomy (4)
4 E Leviticus (3)
5 D Genesis (2)
I thought of appending a unique ID string to each pair and only displaying the first part of the string e.g
A@1 Genesis@1
etc and I can do this but maybe there is a simpler way.
Lastly supposing I would want to keep the order of column one and only shuffle column two?
Thanks for any advice!
I am trying to export my Access pivot table to excel because every time I do, the values (which are text and numbers; i.e. some numbers and some <0.05 format) are changed into a sum, product..... I need to rearrange this data not calculate anything.
View 14 Replies View RelatedFirst 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.
Is there a way to do the following?
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 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"
[Code] .....
Dear All
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.
Please help me :)
data not showing where no records
I have 2 tables...
tblEvents
tblFMForEradication
i am trying to run a query to generate the number of events that have happened for each code that appears in the tblFMForEradication table.
however when i run the query i only get 17 records returned wheras there are 30 records in the tblFMForEradication table.
If the code has not occured i need it to display zero,
but i always need all the codes in the tblFMForEradication to be listed in this case there should always be 30 records in the list.
please help
Andy
data not showing where no records
I have 2 tables...
tblEvents
tblFMForEradication
i am trying to run a query to generate the number of events that have happened for each code that appears in the tblFMForEradication table.
however when i run the query i only get 17 records returned wheras there are 30 records in the tblFMForEradication table.
If the code has not occured i need it to display zero,
but i always need all the codes in the tblFMForEradication to be listed in this case there should always be 30 records in the list.
please help
Andy
This is a code I used for a stock control form:
"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?
Hello All
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).
Regards
Adrian
Hi hope you can help me out,
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.
Any ideas?
Many thanks,
Ed
I suppose that´s easy, but I only accomplished one by one by selecting a specific record.
Ty
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.
Thanks.
i have a table
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
HI THERE.
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?
Thanks for your support!
bugleboy
Hi
I have a single form for which I need to create 2 records from in the same table.
On the second record when created I need to change some of data contained in the fields - How do I do this:
I give an example. On my form I have a tick box - if true it enables 2 text boxes and will need to create 2 records within a single table.
I need the first record to include the data contained in the first text box and the second record to contain the data from the second text box.
I have tried to use update queries but have had no luck. Anybody have any ideas?
thanks
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?
View 5 Replies View RelatedI 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?
View 1 Replies View Relateduh.. 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.
Thanks
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.