Hope someone can help with this one - I have searched the Forum and cannot find any reference to this problem. I have a form which was originally based on a query linking 2 tables - data entry into the form worked fine. I then needed to add another field to the form from another table so I added the 3 table to my query, linked the table and then added the required field to my form and now the form will not allow me to enter or change data in any of the fields. I have checked relationships and they all seem to be OK. I have also tried creating a new query based on the original query and added the new table to that in case there was an issue with the first join, added my new table to this query and then based the form on this new query but the problem stills persists. Is there a limit to how many tables/queries a form can be linked to? Any help would be appresicated.
I am doing my internship now and am new to vba and excel. I need help with the following.
I need to create a form which allows the user to enter records into a table. The fields for this table is [product type], [Reasons] and [Breaks]. However for each [product type] there is a specific list of [reasons] and [breaks]. I need to reflect this onto the form using drop down lists or list box. That is if the user selects [product 1], the associated [reasons] and [breaks] will populate the other 2 list box. And then the user will click the update button to insert a new record into the table.
Can somebody help me out here? Thanks so much in advance.
I was able to enter data into my form but I made a few design tweaks and added another table into the form and now, in form view, I''m unable to enter data into any field.
I have a make couple of Forms and couple of tables.
My problem is how to I connect the form to the table, so it will store entered data from the form to the table. There are about 2-4 places where the user can enter data into the Form and it should be stored to a table. I made 5 forms and 5 tables, where the user fills out the first form and clicks next and next form opens and so on.
If possibly I would like to skip all the coding that can be used.
it is zip file unable to get the size lower yet minimal amount in database I have 2 tables and one form when I create an query on the form the form then becomes that I cannot enter data in it or edit etc
I created a form that allows users to enter data into the fields and populates the table.But can I have it do that and populate instead of one table, two tables?
I have been having problems with opening a form to add new records only. I have gone through all possible solutions but somehow the problem persists.I want to add new records only and not view any of the existing records. I have set the form properties to Date Entry Yes, Allow additions to Yes, Allow Edits to No. The form opens through a command button on another form and the vba code is the following.
I'm creating a Dating Database on MS access, Now I've been given the attributes for all the tables. They are five (Client, Hobby, Meeting, ClientHobby, ClientMeeting)
Now I'm needed to create a form which allows me to enter the client data + at least two interests and their age calculated from their DOB. Seeing as I was only asked to put DOB in the actual Client table, I thought I'd create an Age query and then make that form out of the Age Query. (I already successfully managed to get the Age out of DOB in that query in a field of its own)
However, how can I add the hobbies field to that age query so I can finally create the form that I am required to do?
Second, I am to create a query which will be used for ‘matching’ clients. The criteria that you will use are: gender, age (using a range e.g. 20-25), interests/hobbies and city/town, this query ill be used to create a report which lists all the clients who match the entered criteria. How am I to do that?
So, I've got a frmCustomer and want to link the form to frmNewWorkOrder using a button.
More precisely when I choose/scroll to a customer and click the button "New work order" to autofill data from selected client from frmCustomerto frmNewWorkOrder (First and Last name, telephone number and client ID).
I have a database I made to store a list of users and information about each user.
I have a UserDetail table, languages table, previous experience table, current experience table.
UserDetail table as follows: UserID (PK) First Name Last Name Full Name (calculated) Department (using a multi select combo box. There are 3 departments and some people are in both).
I need to do the same thing on each table and each table is very similar so I'll just list one. This is the Previous Experience table:
I have three junction tables. One for each Previous Experience, current experience and language table. The Previous experience junction table has:
ID (PK) UserID PreviousXPID
I created a relationship between the userdetail table and the junction table then the junction table to the Previous Experience table.
Now what I'd like to be able to do is edit people to add previous experience, current experience and languages to each. I already have a form that lets me add a new user to the database. It's just based on the UserDetails table. If I could have a way (perhaps using 3 multi select list boxes. One box for previous experience, one for current experience and one for languages) on that form to add the other details to that person, that would be ideal. I'd like to create a new user. E.g. Joe Bloggs in department 1 who speaks Dutch, used to have Marketing, Chemistry and aeronautical experience and now works in IT.
I can create the new user by putting last first/last name and selecting the department. But to add experience or languages, I have to go into that junction table and add the numbers myself. e.g. user 1, has experience 1,3,4 and 5. I'd like to see the name that relates to the ID and be able to select it from the list in the table I have.
I use filter Combo boxes in a lot of places so that users can filter records easily. (Not combo boxes for input).I have them labeled as filters but nonetheless users keep trying to input into them for some reason.How would I add a message box to it so that it states that 'this box is not for data entry etc'.
I have a form that has number entries. I changed the Default Value for these numbers to Null because I dont want 0s (they aren't being used for numeric calculations, they just hold a number). I want there to be nothing in the input field until I put it there.
My problem is, when I start to enter info into my form, access automatically places 0s into all my number entries! Is there a way to avoid this? Or should I just make the fields text instead?
I have a list of incidents in my Incidents Management Database. It comes up as a grid view when users open the database.
This is what it looks loke (paste the following into address bar of your browser. lh5.google.com.au/snehal.dabhi/R8oc22J_RfI/AAAAAAAABz0/bbIkCzg5whk/image001.png
I want particular incident to open in a form when users double click on any particular incident from the list above. For example double clicking on the first incident (dated 1/03/2008 in the list above) should open the form below with THAT PERTICULAR incident. And double clicking on 22nd incident should open the following form with 22nd incident loaded, so users can edit that incident
please Paste the following into your browser to see the image. lh6.google.com.au/snehal.dabhi/R8oc3GJ_RgI/AAAAAAAABz8/vGSjfr5rZ10/image003.png?imgmax=640
Any detailed help is much appreciated. – I am too new to understand macros and vba. Thanks!
I had an existing database with 2329 records entered into it. All of the fields (220ish) were all in one table. Myself and my co-workers wanted to rebuild the database without losing the data. We wrote queries to transfer the data from the original database to the new database and split the data from the original 1 giant table to 9 smaller tables.
The transfer of data worked so I went to start making forms. When I went to add fields from different tables I had to built a relationship, which I did. All of the data that transferred over from the new database is in the form (now multiple forms linked by button) but I can't add new information. I get an error stating, "You cannot add or change a record because a related record is required in table ..." and the table referenced keeps changing.
Any way (VBA script, etc) to make it mandatory for a user to enter data in a textboxes in a form before proceeding to the next record on a form? I know I am able to do this in the table by selecting the value "Yes" in the Required area in the General Tab but I was wondering if there is a VBA script you can enter it in a form instead.
On attachment is an Access Database in winzip. In the __Property form, I want to make it madatory for users to enter data in the County Shapefile Gross Acres, Township, Mineral Severance Tract, and Unit name fields before proceeding to a new record. If data is not entered in these textboxes for these field, then a person will not be allowed to go to the next record.
I am trying to set up some data access pages as data entry into a table with access 2000. I can see the records in both the data access forms and the HTML forms, but cannot create new records into the table. I have tried to change the property to DataEntry etc... but nothing seems to work.
I have built a database which has been running OK for 3 or 4 years. Something happened the other day (error - rebuild d/base) and now there are certain fields that I cannot enter any data into. Others are fine and I can see what is already there. Any suggestions very welcome.
Hi, I am not entirely sure where to look in the forum to answer this question, maybe someone can help me. I am just trying to create a simple code that would open a form if a user enter in a field a value that never has been entered before and open a other different form if the user enter a value already recorded. I can't find a 'not in recordset event', but there must be a way as when the form is set to Data entry with no duplicates an event occurs depending on the data being already recorded or not.
I am relatively new to this. I am trying to design a database and need to store data in three dimensions. I have a list of faculty members at our university and need to record data about their salaries and the courses they teach. However, I also need to keep a record for each semester as well. I would like to have the faculty + salaries + courses laid out in a "Fall 2012 Semester" table, for example, and then stack the "Spring 2013" semester table on top of it, etc to make one three-dimensional table.
Otherwise, it appears that I will have to create a separate table for each semester and repeat the list of faculty members.
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?
I created a Query to calculate an over all rateing useing other data that was already in the database. The Query worked out perfectly, and I then wanted to put the one field that gave me the overall rateing that I just calculated and put it into a form. So I added the Query with the rateing into the one that made up the other form and added the field to the Query. The problem was that when i went into that form and added the field, it made it so that i could no longer change any of the data on that forum. I thought that it might have something to do with the fact that there were no fields with math in them in that form untill i added the over all rateing one, could that have messed it up? Please send me some seggestions because I havent a clue at what could be worng. Thank you, Ben
Hi all, firstly please forgive me if i'm a little slow, i haven't done any access work for a year or so and i'm a bit rusty :o
Basically i have a customer database which holds customer details and orders. It's been created and working fine for a couple of years, but i recently found something that i'm having trouble with. tblCustomers holds most of the data and links to other tables such as tblCustomerPostCode/tblCustomerEmail with the primay key CustomerNumber. I put certain data such as these in other tables because i was taught to not include fields with lots of blanks and these wouldn't necessarily always have data. The relationships table is attached - relationships.jpg
I also have a main table for customer orders - tblCustomerPurchases which holds data such as date of purchase and purchase cost. This has a primary key field called PurchaseNumber, and links to tblCustomers with a CustomerNumber field. This meant i could have many purchases for one customer, etc.
Everything has worked great as i said and i have many forms, reports etc with no problems, and the problem i have hasn't shown itself until now.
If i have a query with tblCustomers and all the relevant other tables linked to it, all fields work perfectly and i can add, edit etc whatever data i need to. See qselcustdetails.jpg attached.
The moment i add the tblCustomerPurchases or anything that uses it to the query however, i can no longer add data to some of the fields such as tblCustomerPostcode, tblCustomerArea, tblCustomerEmail etc. If there is data in the field already then i can change it, but not add new data. See qselcustdet&purchase.jpg attached.
I believe it must be to do with the fact that tblCustomerPurchases uses the CustomerNumber field as well? And it then doesn't allow tables such as tblCustomerPostcode to create new data? But i can't understand why. Like i said i'm a little rusty and i can't figure it out at the mo :confused::rolleyes:
Also, can anyone tell me any suggestions for the easiest way of fixing it? The database already has 5000 customers and plenty of forms, reports etc.
I am trying to build a query that would be pulled by indaviduals name entered by the user of the DB. I can't remember the santax to use in the critera field.
I am new to databases. I have set up a simple database but when I enter say 14.75 as a number the database converts it to 15.00. I am not aware of having set any rounding conditions.
