Search results

I am working on a database that tracks things for a welding shop. Because of this I am using heights in millimeters and decimal points are necessary. The page I am using is an input form with a subform tied to a specific record. I can under no circumstance get my decimals to stay put in the...

Hello all, first off, this forum was a huge help for me this summer during my internship, and now it seems the access skills I have gained are boiling over to my jobs at my university! Any help would be appreciated, also feel free to ask questions if something is not understood. I am currently...

I am trying to create a form that updates numerous tables. I would like to be able to input a name and list sports that the person plays (this is purely an exercise for me to learn access) so it would update two tables one like this ID Name 1 Riley 2 Jeff the other that it is...

Just fooling around, I need to make a shell of my Database because I will be ending my internship soon and I can't control the information in my database for legal reasons, but I still want to have the database shell to show my skills of using access (recently required and not extensive :) ) so...

Is it possible to use a combo box to select a value and change where a form updates a table based on which value is chosen? My thought is to have 1 form to input data, but there are 4 different tables I would want to update and which table is updated is based on what value the combo box is...

I am fiddling with a DB right now just to try to work out some table relationships. I have a PK, Name, it is accompanied by a year in school. I then want to relate the year in school in a different table with the requirements for that year. such as Year Requirement1 requirement2...

I was hoping to get pointed in the direction of some relationship theory. I am new at this and was wondering when, where and how to implement relationships into a DB. I am sure this has a lot of good uses, but I am failing to understand it completely. Any and all help is appreciated. thanks Riley

As I continue my pursuit of MS access knowledge, I am moving to table relationships and would love if someone could point me to a good source to explain in detail when, where and why to use table relationships as well as how to implement this. Thank you much! Riley

I have a search form, and it has 2 combo boxes, and 3 textboxes. I would like one of the textboxes to search 10 different fields for the inputted data. Along with that search all of the others must be able to be used to narrow down the criteria. How can I do this with SQL? Right now I have a...

I have a form that searches a table using a query based on 3 text boxes and two combo boxes. I want to add a button that will clear all of the boxes and rerun the query so that it includes everything. What would the code be for this, or where might I be able to find it. Thanks Riley

I have a database with a couple of search forms to use for my company. My boss wants me to place this on the intranet so anyone can use it not only those with MS Access, which many people do not have on their computers. Please let me know if there is a way to do this and still make it...

I have a SQL that enables the user to search the form from different combo boxes to narrow down the data. I can get this to work but it only finds the fields that exactly match their input data. I want them to be able to type something in the combo box and then it pull up anything with that...

I have been using the forums for the past month and a half, and they have been extremely beneficial to me. I am working on a database that cross references my companies Steel standards to American standards. I am trying to make it searchable in a couple of different ways. I have borrowed code...