I have 2 tables a project table and a project additions table, they have a relationship of 1 to many. When I run the query using both tables it only gives me the results of the project numbers that match in both fields. I need to have all information from both fields.
I am trying to build a query that allows me to enter data over two tables that are related. I'm using MS Access 97 if that makes a difference. For example
I have two tables like the following
Class Class Id (auto number, primary key) Class Name (text) Class Teacher (text) Class Room (text)
Student Student ID (auto number. primary key) Student Name (text) Student Course (text) Class Id (number, secondary key)
I tried creating a query that allowed data entry for the following fields
Student Name Class Name
It first has the following error when trying to enter data in both the feilds; The Microsoft Jet database engine can't find a record in the table 'Class' with key matching field(s)".
So i tried adding the record in the table class, but now i cant even see it in the query.
I've got some tables I pulled off GeoNames.org that I need to extract data from. One table has everything I need except the counties listed in it. Instead of that, it gives a county code. The other table has the actual county names associated with those codes.In the main table, country and state are listed similar to "US" and "WA", representing U.S.A. and Washington state, with the city name ("Seattle") also displayed in a separate field. A county may be displayed as a county code of 003 or 101, or any such 3-digit number. The thing is, multiple counties can have the same county code, since each state's counties start their numbering over at 001, 003, 005, etc.In the county table, one column has the country, state, and county code in one field similar to US.WA.003, and the county name ("King County") in another field.What I need to do with this info is create a new table that will have only the country, state, county, and city names (omitting the text "County", if possible). So, my final result would be: US, WA, King, SeattleI just don't know how to pull the data from each table while merging the county information.The reason I haven't included the examples of the tables I'm using is because I'm hoping to be able to put together the query myself, with the help you all can provide me with. Alot of times, there are well-intentioned people who are kind enough to layout everything exactly as you need it to come up with finished results, and I'd just like to get the opportunity to take a shot at it myself first. If I can't get it from there, believe me, I'll be back for more help.Thanks in advance.
i have a small school with number of teachers, every teacher has a specific number of observations in the semester, i need a small project that when i query a bout a teacher, a form appearing with his name and the remaining hours of observation
what i did is i made two tables teacher (id, name, total number of observations in semester) observation( Oid, name of teacher, date and time of observation, remaining observations) -- i dont know if i have to make a counter or what !!--
Now what i need to do is a form when i enter the id of the teacher, it shows automatically the name of the teacher, and the number of remaining observations
How can i join the two tables and show the results ?
I've created a table (Films). One of the fields is linked to another table (People). The table 'People' is a list of people with a categorization next to them (e.g. actor, director etc)
Is there a way that I can create a field called 'Actors' in the table 'Films' and for the drop down only to display those people who have been categorized as an actor?
I have a small school with number of teachers, every teacher has a specific number of observations in the semester, i need a small project that when i query a bout a teacher, a form appearing with his name and the remaining hours of observation
what i did is i made two tables
teacher (id, name, total number of observations in semester) observation( Oid, name of teacher, date and time of observation, remaining observations)
I dont know if i have to make a counter or what !!-- Now what i need to do is a form when i enter the id of the teacher, it shows automatically the name of the teacher, and the number of remaining observations
How can i join the two tables and show the results ?
I have a table with a field 'FName'. I have run a query to count the number of each Name in this field. However, as well as having a blank field with 9129 results (which was expected) but another with 24 results that appears to be completely blank as well. There are another couple of incidences were results in 'FName' are appearing twice.
I am putting together a database for work, I have a table that is used to refer to (this table is part of our production system) in this table it lists products run, dates run and who has run.
I have the training records data table, this lists; who, machine and status: "trained" "refresh required" " not trained"
I want to build a query so that it searches the production table for the last 6 months worth of records & if an operator that is in the training table (WHO) as status (trained) is not in the production table it outputs a "to be refreshed" report or amends the records from trained to "refresh required" ...
There is a 1 to many relationship between MyForms and MyControls There is a one to many relationship between MyControls and MyLanguage
I have a function that populates these tables. For each form in the system I store 1 record on the MyForms table. I then store 1 record for each control in the form on MyControls. For each control I store N (currently 2) records on MyLanguage.
This all works fine up to a point. I noticed that after a time records were no longer getting stored on MyControls and MyLanguage.
The only way around this was to delete all records on all files (I have cascade delete so only need to delete MyForms) and the Compat and Repair the database. The compact and repair doesn't work unless I delete the records first. It seems to go astray when the MyControls table hits 14-1500 records (MyLanguage 28-3000).
I've stepped through the code line by line and the store of the records appears to go through fine.
Hi All, I'm looking for a simple way to clear a all of a specific field in a table (check box). I've put a control on the form but I'm not sure what/how to make it work. Any ideas/suggestions welcome. Thanks, Tim
I'm developing a database with a field call tag. Users are tagging records by puting specific numbers into that field. It works well, but I need to clear them. I need a button on a form that once I press it will automaticly clear tag field for all the records. Any ideas?
Im not sure what is the best way to go about this.
I have a table with 8000 records and on one of the fields the department name is wrong. eg should be "Marketing", but some records have the name "Marke" or "Marketi"
Is there an easy way to update this field to add on the missing characters ?
On a form I have 2 search unbound fields called keysearchword and guestsearchword. Each has an On Exit event that performs their respective searches.
If IsNull([Keysearchword]) Then strLinkCriteria = "[Keywords] Like '*'" Else strLinkCriteria = "[Keywords] Like '*" & Me!Keysearchword & "*'" End If
DoCmd.OpenForm strDocName, , , strLinkCriteria
However, after the first find, I see a "(filtered)" next to the correctly displayed records. At this point however, I can't even get the cursor into the second guestsearchword field.
I am creating a table that is a master list of all of my company's product. Each "customer" that we have will always be ordering the same items, but not all of the items that we have available. I need a way to go through the master list and click a yes or no and have that item added to the "customer's list of items on a new table.
I need to create a sublist for each "customer" like individual shopping cats for each customer. These individual lists need to link back to the master list in case of product changes, description changes, and cost changes.
I would like to create a form where the end user can type in a product number, description, or manufacturer number and have that item added to the "customer's" list.
A search form, to search into those tables (It searches by "User")
The search form contains a listbox that shows results (listPC)
And the following code:
Option Compare Database Dim strUserPC As String, strUserTel As String Dim db As DAO.Database, rsUserPC As DAO.Recordset ', rsUserTel As DAO.Recordset Private Sub txtSearch_LostFocus() strUserPC = "" strUserTel = ""
[Code] .....
It works, but I have one problem. It only shows telephones or desktop, not both. It deppends on which line inside UpdateList is first.
That example searches into 2 tables:
-Telephones -Desktops
And searches by "user".
I want to list all telephones and desktops that a user has assigned.
Running Office 365 (Access 2013). Recent problem occurrence. When I do an 'External Data' command, either from another Access database or an Excel file, the import completes, but I don't see the new table immediately in the navigator section. If I import from another Access database, the new imported tables appear as '~TMPCLP....' tables. If it's from an Excel workbook, the new table doesn't appear at all. It's only after I exit the database and reopen it do I see the new tables correctly named.
I have been tweaking my friend's database for him. I included some sample data in the main table (ficticious names and addresses etc.) and in a linked table.
I want to leave the sample data in so my friend understands how the database works. However, once he has tested it, he will want to blank those tables (not all tables, though), and reset the primary keys to start from 1 again.
Can I have a button on a form that will do this? Obviously with an OK/cancel message box. If so, how?
I have a query parameter that I'm running from a form and it works fine the first time. Pops up and asks me for the parameter with no problem and the query runs fine. However, if I run the same query again it doesn't ask me for the parameter - it just takes whatever I entered the first time. How do I clear this so it always asks me for the parameter?
Hi I have set up a simple password system to allow someone to have access to some forms within my database that I don't want others to see. I have created a pop up form for the password based on using the Input Mask Password. The password log in works fine but the password stays in the input box so if another user clicks on the button that brings up the password pop up form, all they have to do is press enter or click the command button and they are through. How can I get the password input box to clear itself - probably on closing the password form? I'm sure it's a simple piece of code but my knowledge of VB is limited and everything I have tried brings up an error of one sort or another. Thanks for any help.
I have a one page form set up into 4 different sections. Each section has its own command. First section is Radio buttons with a drop down list. The next three are text boxes. I have a rather simple question, next to my OK command button I want a to create a button that will say "Clear" and I want it to clear the text inside the text field but if possible to clear the radio buttons and the drop down list too. Its not a main concern about radio buttons because you can just unclick it. But I was not sure what the VB is for clearing text inside a text box. Thank you.
I have a command button on a form which i would like to click on to clear all the textbox on a form. Witihn the event procedure of the command button i have tried cylindernumber = "". This does clear the text box however it deletes the information from the table to, which i do not want to happen. I just wnat the text box to be clear once the button is clicked on without deleting the information from the table.
I'm looking for a way to clear the fields from a form after I finish entering data into all the fields (enter button or something). The form only displays one record at a time. My problem is that after a distraction (phone call, etc) I sometimes wind up coming back and entering data in the last displayed record which messes up that record. Or is there a way to automatically advance to a blank form when finished with a record?......
I have created an email message to be sent via a closing button on a form, using the DoCmd.SendObject command. It all works fine except that MS Outlook then puts a message box on the screen with a countdown bar saying that MS Access is trying to access Outlook and to press Yes if this is to be allowed.
Is there any way that I can disable this message box please. I appreciate that this is more an Outlook problem than an Access one, but some database programmer has probably come across the same problem before.
I have a one page form set up into 4 different sections. Each section has its own command. First section is Radio buttons with a drop down list. The next three are text boxes. I have a rather simple question, next to my OK command button I want a to create a button that will say "Clear" and I want it to clear the text inside the text field but if possible to clear the radio buttons and the drop down list too. Its not a main concern about radio buttons because you can just unclick it. But I was not sure what the VB is for clearing text inside a text box. Thank you.
