Hi i am a doctor dabbling in ms access and trying to make myself a database of patients. I have 2 forms named new and followup where i would add the data accordingly. I have a primary key named TSCID that is autonumber in the new patient form. I wanted to know how can i program my followup form in such a way that if i put in the TSCID as the foreign key and add that data, some other data such as name, age, gender, address, etc can be auto entered and it can remain modifiable.
thanks
Vinay:)
my main table is Patient Registration details, which includes a universal PK (field is called RGID) that links to all other tables in my db.I'm setting up a query that will add appointments to my appointment table. The PK in tblAppointments is an autonumber, but within the db, tblAppointments is joined to tblRegistration via RGID on a one-to-many relationship (one in tblRegistration, many in tblAppointments). Before you ask, referential integrity is enforced. The query will eventually be the datasource to input appointments via a form.
I'm running into a brick wall, because despite the relationship being set up correctly, I find when I run the query and specify "2" as the criteria in tblAppointments.RGID (one i set up earlier) i can alter the existing appointment record, but the RGID that should automatically insert into the field is not and then the record won't exist correctly as there's no RGID.
I have been messing with this for a while And i am losing my head- I am not very good with access, Never was taught it either, but I can duplicate almost anything just by looking at it and trial and error. but this auto number and adding the tech and labor and parts feild to total up in to the total column. I will try to attach the file so you can take a look at what I have and see where I am screwing up at. or what ever I am missing. or is there a way to duplicate last years (which works fine) but I dont want any of the data. just all the propert fields.
I have a daabase that I am importing via excel. I want the entries to be numbered ex: MT0001 MT0002 etc....
I would like it to promt the user for the last number(or next number in sequence) entered, then fill in the blank records with the next increment number. The prefix will also change to so eventually the user would enter into the prompt RD0001. then autofill the 140 imported records with RD0002, rd0003... etc....
I can't really make seperate fields because the MT0001 number will become a barcode and putting them seperate causes many issues.
can this be done? Any help would be great I am still a beginner but slowly learning! Thanks!
I'm just looking for a way to add an additional column to a select query that will just be autonumbered down all the way to the bottom of the data. How can I accomplish this?
Adding a second auto number field to current table and auto numbering current entries?
I need to combine some records from the same order number that currently have detailed names. I'm trying to simplify them, but I can't because it creates duplicate records.
I have 2 tables Master table (Jobs) containing the primary key ("Job Reference") and 2nd table (Candidates) with the foreign key ("Job Reference")
2 Forms
frmJobs Form to view job details frmCandidates form to view Candates information
I have placed add new candidate button on the frmJobs form which opens the candidate form in the add mode as a blank form. This is fine but I'm looking to add a record where it picks up the "Job Reference" text field value from the main frmJobs and update it in the "Job Refernce" text field on the frmCandidate when I click add new candidate.
How can I achieve this? I'm fairly new to access/vba
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.
I am new to Access and I am trying to update our existing database. Presently our database is used to report incidents that have multiple subjects per incident. Is there a way to have a field recognize the data ie. the last name of an individual, and automatically fill in the remaining fields for that individual without having to fill in each field over and over again?
Hi guys, hows it going?, im hoping that someone can provide me with a solution to my problem i have spent many many hours trying to solve it, just cant seem to do it.Alright guys here it is, I run an entertainment company called Deejays Entertainment, we run over 18 and under 18 events, at these events we collect peoples details to put them on our database so we can keep them informed with new events, happenings etc etc. I currently have 1 database and inside the database is 2 tables, 1 titled "under 18s" the other "over 18s", what i want to do is have it so once a person turns 18 in my "under 18s" table it automatically transfers there data to the "over 18s" table and removes the data from the under 18s one. If someone could help me out i would be greatly appreciative and if you can explain the steps so i 5 year old could understand them that would be great as my knowledge about access is very little.Thanks in Advance.**Sorry forgot to add that i have there date of births in the database**RegardsDanny.
I have a standard Data Entry Form based on a WorkOrder. I am dealing with over 90 offices nation wide with mulitple offices in a state. I have a seperateTable that lists all 90 Offices which I have created a Query to Promt the user to enter the State code for that State.
Is there a way I can Select an Address from the Query and auto populate that information onto my WorkOrder form?
Any help would be greatly Appreciated as I have Exhausted myself trying to figure this out!
Hi, been lurking on here for a while and can find most things im looking for but for some reason cant find any info on auto scrolling of data?
Im chasing something that will scroll a sub form which is displaying data from a query. slowly scrolling down all the data. It wont have anything entered or edited simply displaying the data. It is to be displayed on a monitor/tv and preferably have either a pause button or stop when focus command or something should they want it to pause. I was thinking it might be something like a move next loop or similar but Im terrible at code, can read alot but cant write it if that makes sence.
i will have a refresh/requery command when it gets to the end i think and or on a 1min cycle? to make sure it displays the most appropriate data.
Anyone point me in the right direction?
(sorry its long, just trying to be a good newbie poster :D )
Its been a long time since I did dB work - stopped back in the days of dBase IV.
Still, using Access 2007 is not that difficult - except right now. I have 2 tables; one with customer contacts, the other with project details. Heres what I want - hopefully someone can help:
Within the project table, select from a lookup into customer contacts a name, which then auto fills in the fields for phone and email in the project table. I want to do this in the table or form, but have the data deposited into the table for sure!
I created a database to track a group of records (people). I couldn't figure out how to auto number the primary key to a random unique number that was less than 10 digits so I generated a list of random numbers and just use the next number off the list as I enter the next person which works OK- but I have to put that number on each table as the ID number to relate back to the Primary key and it seems that I should be able to have those auto fill with the entered number. Is it possible to have the number typed in "table 1" (people) primary key auto fill onto each of the other tables as an ID number??
I have been tasked with creating a databse that contains multiple test records. Within a single test record, there is a field named 'bits' in which there are 10 different bits (0 - 9) each with a different value and description. I would like to set up the database such that a user can view a single test record and select a particular bit field from a drop down box and when the bit is selected, the descriptive information for that particular bit is automatically displayed to the user.
For example: - User selects 'test record A'. - Within 'test record A' there is a 'bits' dropdown box. - From the 'bits' dropdown box, the user selects bit '0'. - When bit '0' is selected, another field named 'bit description' automatically fills in the bit description for bit '0'.
His is itpossible to make abutton in access and then assign a equation to it to add the dat in two of the fields together, for example adding the "stock level" and the "re-order level together? ifso could some please tell me how greatly appreciated cheers
I have just devised a simply database but as usual when using it I found that I had left out some information.
To simplify - I could for example, make a drop down menu with the letters a-z but when finished realised that I had left out the letters K, L & R. How do I insert the missing data into the already created list?
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.
I am using a database prepared by someone. But it seems that when i try to add data to a form I am not able to do that. Neither can I edit it. For both these purposes I need to use the table . i.e for adding records and for editing too. Is it possible anyway that I can change the record in form it changes in the table as well. or I will have to work with tables all the time
I have a form, created from a query. The query contains and links about six tables using an AutoNumber ID. The query also has fields from each of these tables.
OK, so when users enter their data into this form, I would like the autoincremented number to increase in each of these tables. The catch is that when the user enters data, he/she does not have to enter data into every field. Therefore, not every table will contain information. But there will be times later on that some of that information will become available and will need to be placed on the appropriate spot (based on the ID number.)
So, some of my tables do not auto-increment and some do. How should I go about resolving this so that when someone enters new data, each table's ID is autoincremented no matter if that table contains information immediately or not? Please Help.:confused:
hi I had a form with TO,DATE,BODY and a button . on click of a button this fileds should get added to a table. I have created a table with same fields. Thanxx
Hi all, I currently have 2 databases: a main current database (Main.mdb), and a secondary database (Working.mdb).
They are identical, except the working database has no data, just the existing tables, forms, etc. from the main database.
When I (or a programmer) makes changes to the forms and some underlying calculations, they are first made in the Working database.
After the changes are made, i delete all the data from the tables in the working database (data from testing, etc.). I will then copy all of the data from the tables in the Main Database over to the Working database, then rename the Working Database to the Main Database.
The only problem I'm having right now is that the primary key in one of the tables (ClientID) is an autonumber. When I paste the data into the Working Database, all the ClientID numbers change. Is there any way to keep the numbers the same as the Main database?
