New to Access programing and need help please. I have a main form that requires the input of a building #, this takes the primary key spot for all records. On the main form is a monitors field which calls up a form titled Resource Monitors and allows me to input primary and mutiple alternates information. My questions is, how do I get the Resource Monitors form to automatically look at what record (building) is currently open in the main form and automatically adjust the Resource Monitors (building) field to match. I have created a 1-to-1 releationship between the building field in both forms, and created a subdatasheet in Resource Monitors that correlates the entries from both forms. What is my next logical step to make this work?
I need to make my form prompt me for an account number and have the fields in the form populate with any data that the tables contain for that account number.
If there is no account number in the table like that, I need it to make a new record.
So I read through about 50 posts trying to find one that resembled mine, but unfortunately I couldn't.
What I am trying to accomplish is this:
I would like to set up a database for reservations of meeting rooms at my place of employment. My experience with Access is very limited, and I find myself getting stuck. What is making things difficult for me is the fact that I would like to set up the interface so that people with absolutely no Access background could still use it. This means I am using the calendar tool for people to input the date of their reservation and giving them a command button to submit. That part works just fine, however, I am having difficulty in making a query that works through a form so that people can use the same calendar set up to inquire what reservations have already been made. I also am having a hard time with figuring out how to limit people from double booking rooms (i.e. i don't know how to limit just the time, and not the date or room). I would appreciate any advice on how to get this project started, so that I can move further along and be back on here to ask more questions when I get stuck again. Thanks in advance for your help.
Hi! I just found this forum and is exactly what i was looking for!:D
Anyway, i am a new access developer and i am currently starting to get around. I have a question. I been working on this database for a few weeks and when i created any subforms, fields or buttons some sort of wizard would pop-up and and walk me through setting all the properties and so on. For some reason thats not happening any longer. It just creates the field or button and thats it. So i have to right click, properties and so on but the wizard thing(or whatever is called) was easier. The harder stuff that i dont know how to do was easy. Does anyone know what i am talking about?
I have designed the database i wanted but now i want to link the fields from a access form to a pre designed template i designed in both microsoft word and pdf. When a user types the information in and clicks preview the information typed in access field will match the field in the template any ideas or software programs that do this.
I'd like to display several rows of data (records) on a Form. Each row has 4 fields. One of the fields (field name is Description) could contain up to 150 characters. So I would like to be able to display the first 40 characters of that field and have a "scroll bar" for that field so the user can scroll thru the remaining Description for that row (record) .
Hi all. I am fairly new to access and am trying to do something that shouldn't be that hard. I have a simple form with one text box and a command button on it. I have the command button set to run an update query.
My problem is that when I enter data and press the button, I don't know how to get the entered data into the query?
I know this is simple to do, but since I am new to access, I can't figure it out. Does anyone have a simple example or step by step details that they can share with me?
I am a newbie to Access or any database for that matter. So please be gentle. I'm in the process of writing an automotive invoicing database and have gotten stuck early in the game. On my form I have Qty1 - Mat1 - and Amt1 fields placed from my database. In Amt1 I would like to typein an amount and have it multiplied by 15% (.015). I fiddled with the "On Enter" in the Amt1 property box but got nowhere. Can someone help???
Hello. I have a mdb access file. When I open it, I can see lots of tables. How on earth do I open a form? Do I need another file, if so, what extension should I look for on my computer?? I really dont want to create a new form, since a person who did it has told me that its all have been already done. I just need to open the form and enter the data in. Thanks for any help!!!:)
Here goes my problem, and how I am attempting to solve it, but I am open to advice.
I have a table that contains all of the bird species in the US; (fields: common name, scientific name, species ID) I want to be able to update another table, (birds to chase) with particular bird species that I have not yet seen, (fields: species ID, common name, scientific name) and link that to a sub form that links to another table (chase birds locations) which shows geographic location data as to where I might be able to see new/unseen birds; (fields: species ID, date, other geographic data).
My problem is this. I created a form for the unseen birds table that allows me to only select a bird using a combo box of birds from the larger table of US birds. I want to select a bird using the common name in this box, and have it automatically populate the scientific name and the species ID into the birds to chase table. I link this tables to the location table using species ID.
A workaround that I have used is to close the form, run two update queries that populate the proper fields for scientific name and species ID and to re-open the forms. Although this works, when I return to the form it does not return me to the proper record, so that I can enter data into the sub-form.
Obviously this is a workaround and will work for me in the short run, but I want to learn how to do it properly within Access 2003.
I'm not a programmer and hence do not have access to the .NET tools or Visual Basic. Any hints for me out there?
Okay I've looked around but haven't found an answer to this, if there is one in the forum please forgive me. I've created a database to help track employee passwords for differnt system I placed and Audit Trail on the form (the example from Microsoft) however it updates only the form and not the table and I need it to do both. Please Help!
Hi! I'm a newbie and have very very basic understanding of Access...I'm running a small group of about 19 members that is expected to grow within the next two months to 11 more members...
I haven't been able to find a freeware club/membership database so having the fun of creating my own.
I used the "membership database" that microsoft offers and I figure out (very easily) how to do the page breaks, but I tried to add an option on the top of the form to goto page 3 and have access take my viewer to "page 3" of the form...
I've looked at the coding for page 1 and 2 that is already in place for the form where member info is enter, but it's just over my head and hoping someone can help me figure out how to build an event that when someone clicks on page 3, it will take the viewer to the "third page" of the form for additional information I hope to add.
I am creating a customer database for an independent insurance agency. Within that customer database, we have a lookup field that references another table "Carriers". This is where we select the insurance carrier we have placed the clients insurance with (ex. Geico, progressive, etc). This field allows multiple entries since clients can have policies with different companies.
We also have contact detail forms for each of our insurance carriers where we store information like web logins, contact phone numbers, and other notes. These forms are based on the same table as the lookup field.
I would like to create a hyperlink so, if we are looking at a clients form with all of their contact info we can click the insurance company in the carrier field and it will bring us to the contact details form of that carrier.
I have a 'main' table with a Project_Number that links all the data in my db together. I have another table that uses that Project_Number as a lookup field to connect that tables data to the main data. I created a 'main' form that has the ability to enter data for the 'main' table. I want to be able to press a button and have the second tables form pop up and add that that specific Project_Number. I added the button and went through the wizard process. I then added the linking info through the builder. It works fine if there is already data entered for the project_number in that specific field. but if the field is empty, the popup window doesn't recognize a project_number and doesn't add it to that record. below is what I am using. The project_number in the 'main' table is text and the Project_Number in the 2nd table in a number since it is a lookup field.
Private Sub CongressionalDistrictCmd_Click() On Error GoTo Err_CongressionalDistrictCmd_Click Dim stDocName As String
I am having 4 tables where i enter all the data required. The tables are Project Details, Process Detail, Installation Detail & Cable Details. Project Detail Table contains:Project Number,Project Code,wBS Code etc... Process Detail Table Contains : Tag Number, Description, Service, Process values etc... INstallation Details Table contains : Installaion Item, (nearly 40 items which are commonly used) Cable Details Table Contains : Cable Number, Type of Cable, Size of Cable and so on Now I need the form: Process detail containing the information which had been entered in Project detail also. Such as the Project Number, Code etc to appear in the form ( Just to display it) In Cable Detail and INstallation forms I need some specific fields which are in Project details (project Number, Code..), Process Details ( The tag numbers, Description etc..) to appear as display. The tag number shall be the primary key which shall be used in all forms except Project detail form. The information in Project details is just to appear in the report. I could very well do it when all this information was in one table. As a beginer i am unable to solve this. So please guide me.
Hey guys, I have a question for you. I have a query that gives me a list of names with info on each person. From the query I want to be able to click on the name of an individual and in turn have the form open up on that individuals page. Allowing me to enter more data and/or see more data on the individual. Thanks for any help you might give!!
I just added a new field to a table but i now need to add the field into a form so the table can be update. However when i open the field list to assign/bind the control the new cloumn is not present on the field list.
How do i add a new field which i have entered in the table to the field list?
Hi, i'm trying to get a field to only allow data to be entered that is in a table e.g. i have a table which has a list of country dialling codes in it. In my form i want to only allow valid country codes to be entered-i.e. the ones which are in the table? Ive tried coming up with different validation rules but cant seem to do it Can anyone help?
I am creating a Risk Management Database at work. I have created a tab with options to choose, as to log the risk relevant.
i.e. I have a catagory, subcatagory and then Risk boxes
When saving the record it will save the risk but it will not save the catagory, and the subcatagory options choosen? I have a seperate table for this information to appear, Does anyone know how I can make this happen without stopping it from shortening the catagories down.
I hope this make sense. I am sorry I am a little rusty in Access 2003.
Firstly, apologies if any of the following seems to denote bad database design or a lack of forward planning. It does, but I've inherited it, so I'm stuck with it (for the time being).
I have a Subform (Training_Records_Sub) linked to a Form (Employee_Training). Both forms get their data from tables of the same name. Up to now, these have been linked on the field Employee_ID. This has been working fine, as all information stored related to permanent employees, so everyone had an Employee_ID value.
Now, however, I've been informed that the system also needs to store information on temporary and contract staff, neither of whom have an Employee_ID number. In fact - for reasons I fail to understand but which I'm sure make sense to management - there is no unique indentifier stored for any of these people.
The best I can come up with is as follows:
Permanent Personnel - Can be uniquely identifed by Employee_ID and Cost_Center.
Temporary Personnel - Can be uniquely dentified by Last_Name, First_Name and Requisition_Number (this last number can apply to many people). I realise that two people of the same name COULD be hired under the same requisition number, but I've been assured that this won't be allowed.
My problem is in working out how to now link the Form and Subform.
Is there some way to use an 'If...Then..Else' statement? Even in VBA? I've sort of got an idea of what I need, but a day of playing with the code hasn't worked, so I thought I'd try posting.
Having a little problem, have searched the forums but have not been able to find an answer.
I have a single db with 3 tables, artist, gallery and arts.
The main form should show the work details for each artist, i.e. each piece of art they have done. The problem I have is I think I have a link or relationship problem as when I try to create a new record in the arts table, I have a combo box which populates the artist name and gallery name and it should then store these details in the arts table along with the rest of the details I enter but it doesn't.
Each table has an autonumber and there is a one-to-one relationship from arts to artist and arts to gallery.
I would like to link 2 fields in a form. If I select data within one field with drop down list it should automatically bring up a name within the 2nd field. How would I be able to do this?
I've managed to lind the subforms to this drop down list which works brilliantly but this is a field within a form that I don't know how to link.
Ok. I have used access before to hold data but have always accessed and used it via asp. I have never actually tried to use the access forms and queries! But for a current project i am having to use it.
So far its been fairly simple but im stuck on one point. I have one table that holds user info and has a foreign key from another table. On my form i want the user to be able to lookup the foreign keyes available. Only i want the lookup to show the description field in the other table not the unique id (primary key) but when they slect the relevant row its obviously need to record the primary key of the other table in the foreign key field in my user info table.
How can this be done? Im not sure if i explained this very well. If anyones unsure what i mean please ask my to clarify.
i am having a problem linking my subform data to my form data on more that one fitler.
that is, i have a form that contains Last_Name and First_Name and a subform that pull a different set of info form anther table as i scroll through the main form.
on the properties of the subform i have Filter set to "Me.FilterOn="Last_Name".
BUT i need to bring in the filter on Last_Name AND First_Name because of different entries that have the same last name.
