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.
Does anyone know what command will allow Access to pull Dimensions from Explorer into a Query?
I wish to have a query that will illustrate the exact Dimension of an image file (Jpeg). This will enable me to filter all images which do not meet my internet standard of 100x100 dpi and/or 300x300 dpi.
I'm trying to build a personnal budget application.
I need to build a form that looks like a grid.
On the first column, you will see the different budgets elements
On the top line (headers), you should see the different months of the comming year.
I already managed to build the necessary tables (with 2 keys in the table source for the form).
My questions are the following:
1) how can I build a forms that looks like a spreadsheet, proposing me every cells from the start (not only the cells that i have filled before)?
2) how can I make for this form to be dynamic ? This means that, if I add a budget element in the budget elements table, how can I make the form to be adapted automatically, adding a line under the others, for every months?
I have asked severall other forums, no one could answer me.
Hey guys, I know how to maximize a form when it opens, but I was wondering if there isn't a way to actually shrink down the Access app window to specified dimensions when it opens the form? I'm trying to write a dimension-specific app, so there is no distortion what-so-ever. thanks!
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.
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'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 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 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 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 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.
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 know the way to SELECTDISTECT on a combobox referring to a table so the value will autopopulate in the combobox. But is that doable in a subform?
I have a table with 3 columns. First Name, Last Name, Relationship.
I want to let the user adding data directly to the subform, but when typing RICHARD in the first record of First Name, then on the second record, when they type R, it will suggest RICHARD, a kinda auto fill if desire.
I'm working on a database that tracks students and grades. I have a tblStudents with Personal details, tblStudentsAndClasses which allows me to have a one-to-many to many-to-one relationship, tblClasses with all the class info, plus a tblGPA.
I'm wanting to list all the Student's names listed with their current class and have blanks for data entry for Grade, Grade status, and have a current timestamp in another field. So the teacher can enter the Grades and Grade Status for all students on one day in a single form (think EXCEL). The way I have it now, is that (x number) grades that have already been entered shows up as (x number) copies of the same student. So my relationships are probably set up incorrectly also.
I can't filter out IS NOT NULL because I wouldn't get any students with grades already entered in.
I've found a post on another bytes.com that is REALLY close to what I am looking for, but I don't know anything about VB to be able to adjust it to fit my requirements. I would have tried to do a forum search here, but I'm not sure what terminology I would search for.
My database is tracking Job/Project information. The users must assign the Job Contacts which can be both internal and external (ie: Contracts is a Client Contact, while Engineer is an Internal position)..
tblContactTypes which defines each of the 10 types of job contacts. fldTypeID: fldTitle fldClient fldInternal 1 Contracts True False 2 Engineer False True 3 Other True True
The Job Specific data is stored in tblJob_Contacts
fldJobID (PrimaryKey) fldTypeID (from tblContactTypes) fldEEID for Internal Contacts (from tblEE) fldContactID for External Contacts (from tblClientContacts)
My question is this...How can I force the user to enter the Contact information for Contact Types 1,2,3, and 4 while leaving the remaining contacts types as optional?
I would like a form with combo boxes for the first four Contact Types which must be assigned for every job and then a continuous subform where the user can assign the remaining contact types if needed.
Initially, I planned to store the first four Contact Types as separate fields in the main table (tblJob) - however, distribution lists are needed and it makes more sense for all the contact information to be stored in the same table.
I am trying to set up a password on a for different users to have to enter pins to enter data. When a user selects his/her name from the combo box the next field will be something like pin. When they enter the corresponding pin this will allow them to edit and start or continue (if they left) fill out the rest of this form.
The reason being this way is that if one of them goes back to a previous record done by another user (which I want them to be able to view) they can view it but cannot edit it because they do not have the users pin (or password). Is this able to be done, only allowed to edit or create a new record if you enter your pin every time.
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 have to write a result of the query to the excel, which is a invoice template where i need to enter the data.
Depend on the result the template can grow in size also, here if the size grows there needs to be informatin coming on first page for eg: address in first page should not repeat in second page, second page have purly order details and footer at the end which have signatue and attestation.
Problem is data can be in 1 page, 2 pages, 3 pages ..or more
How can i achieve this task as all pages have water mark as page 1, page 2...sand so on...?
