Access Help .... Design .... 1st Class... Should B Easy
Feb 9, 2006
I have a project in which i have to make a database. Its nothing real complex it has to have 3 tables.
heres my idea
An address book database.... "I know how orignal lol"
anyways here is what i have.... Looking to get my primary keys and forign keys established
tblAddress
AddressID "Pri Key"
First
Last
Address
City
State
Postal Code
tblContact
Email
HomePhone
CellPhone
DateLastTalked
DateUpdated
tblPersonal
Nickname
Birthday
College "Yes or No"
If Yes Where
Hobbies
So I need to get 3 FK keys and 2 more primary keys... This isnt jumping out at me as to what i should use.
View Replies
ADVERTISEMENT
May 4, 2005
I am doing a cert. III in business admin that finishes on MOnday 9 May 2005. I have 3 days to do a mammoth business trip assignment, AND pass a test on Access. The school is a little dodgy and didn't make me do that practical assignment - they gave me multiple choice q's and written q's to take home.
PLEASE HELP!!! I need to pass this course - and we never use Access at work.
Q1. What is wrong with this formula?
=Iff([Product]=Home,1,0)
I'm sure there's more wrong with it than the 'Iff' - that's meant to be 'IIf' isn't it? I've only ever used formulas in Excel..
Q2. What result will the 'Is Null' expression return?
Q3. What is the difference between a Combo Box and a List Box?
Q4. Why is the purpose of the Paste Append function?
Q5. Which formula is correct?
a. =[Qty]*[Price]+[Freight]
b. =[(Qty)*(Price)+(Freight)]
c. =([Qty]*[Price])+[Freight]
d. =[(Qty)*(Price)]+(Freight)
???
Q6. A chart can be placed on:
a. Table view only
b. A form or Report view
c. A Query or Table view only
d. A Report view only
Please answer any of these questions you can - the last one I can trial by error later tonight.
Thanks in advance.
View 4 Replies
View Related
Jun 6, 2014
I'm trying to subtotal data in an excel file but I am getting a subtotal method of Range class failed in the red text below. I have been trying to get this to work with no success.
Code:
Public Function SUMMARY()
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
With xlApp
Dim wb As Object
[Code] .....
View 3 Replies
View Related
Dec 3, 2013
I have the following code:
Dim FrmGraphObj As Object
Set FrmGraphObj = Forms![frmE Weekly Efficiency]![gph_WeeklyEfficiency].Object.Application.Chart
FrmGraphObj.Axes(xlValue).TickLabels.NumberFormat = "0%"
I continually receive a runtime error 1004 " unable to get tick labels property of the axis class"
if I remove this code, then I error on the following code:
Dim FrmGraphObj As Object
Set FrmGraphObj = Forms![frmE Weekly Efficiency]![gph_WeeklyEfficiency].Object.Application.Chart
If FrmGraphObj.SeriesCollection(2).HasDataLabels Then
also a runtime 1004: "unable to get the seriescollection property of the chart class" on the last line above
searched this forum and found:
If your chart is in a form (or report), you have to:
1) refer to the form (or report) name (Form_Charts)
2) refer to the name of the object frame holding your chart (.Graph1)
3) refer to the object within the frame (.Object)
4) refer to the application that created the object (.Application)
5) refer to the actual chart itself (.Chart)
6) refer to the axes collection and select the axis you want to reference - in this case the category, or X-axis (.Axes(xlCategory))
I made the assumption, that I would just replace xlCategory with xlValue for the Y-axis. So I'm back to:
Set FrmGraphObj = Forms![frmE Weekly Efficiency]![gph_WeeklyEfficiency].Object.Application.Graph
With FrmGraphObj.Axes(xlValue)
.TickLabels.NumberFormat = "0%"
End With
Same error....
Looked in the Microsoft Graph Visual Basic Reference and it indicated:
"Tick-mark label text for the value axis is calculated based on the MajorUnit, MinimumScale, and MaximumScale properties of the value axis. To change the tick-mark label text for the value axis, you must change the values of these properties."
I reset my code to call these 2 functions prior to changing the number format.....
Public Sub txtMaxPercent_AfterUpdate()
Dim FrmGraphObj As Object
Set FrmGraphObj = Forms![frmE Weekly Efficiency]![gph_WeeklyEfficiency].Object.Application.Chart
FrmGraphObj.Axes(xlValue).MaximumScale = txtMaxPercent
End Sub
Public Sub txtMinPercent_AfterUpdate()
Dim FrmGraphObj As Object
Set FrmGraphObj = Forms![frmE Weekly Efficiency]![gph_WeeklyEfficiency].Object.Application.Chart
FrmGraphObj.Axes(xlValue).MinimumScale = txtMinPercent
End Sub
now I am receiving error 1004 again, this time it states "Unable to set the minimumscale property of the axis class" erroring on this line....
FrmGraphObj.Axes(xlValue).MinimumScale = txtMinPercent
debug.Print me.txtMinPercent
0.51
View 2 Replies
View Related
Nov 6, 2004
ms access
I have a empty table called ...'Table2' with 3 fields 'firstname', 'lastname', 'value'
i have another table called ...'Table1' with 2 fields 'firstname', 'lastname'
i have form with a textbox callled Text0
this is the query that i am having trouble with:
INSERT INTO Table2 SELECT Table1.firstname, Table1.lastname, Forms!Form1!Text0.text FROM Table1;
the query doesnot run, gives an error. The SELECT query works stand alone but not when in above.
P.S someone will ask me if the form was open and had a value and that it was open before the query was run...and the answer is yes
View 2 Replies
View Related
Aug 10, 2005
I have used Excel for many years and used the if formula. I have just started using access and need a little help. I have a table the has 20 fields. I am only concerned with about 8 of these fields for a report. I have a field named completed in this field I put a "x" if the job is complete. I would like to create a report that shows me all active jobs. Everything that does not have an "x" in complete field. Can somebody either direct my to the forums I should be in or possible give me the correct coding. Thanks for your help in advance.
View 8 Replies
View Related
Dec 28, 2006
HI,
I have the next 3 tables,
*************************************************
Table USER: id_user (primary key)
name
Rec: id_user, name
------------------
rec: 1, A
rec: 2, B
rec: 3, C
*************************************************
Table AP : id_ap (primary key)
nr_ap (primary key)
id_user
id_sort
Rec: id_ap, nr_ap, id_user, id_sort
-------------------------------------
rec: 1, 2, 1, 1
rec: 2, 5, 2, 1
rec: 3, 1, 3, 1
rec: 4, 3, 1, 2
rec: 5, 4, 2, 2
rec: 6, 3, 3, 2
NOTE:
SELECT sum(nr_ap) AS Total FROM AP
with id_sort = 1 -> SUM(nr_ap) = 2+5+1 = 8
with id_sort = 2 -> SUM(nr_ap) = 3+4+3 = 10
*************************************************
Table SORT: id_sort (primary key)
value
Rec: id_sort, value
------------------
rec: 1, 80
rec: 2, 200
**********************************************
I need do create a QUERY that for all records in SORT table, it will
show only for user 'A', the rescords as in the result shown below.
NOTE: xxxx = (valueSUM(nr_ap))*nr_ap
RESULT EXPECTED
------------------
id_sort, name, ap, value, xxxx
1 A 2 80 20 (808)*2 = 20
2 A 3 200 60 (20010)*3 = 60
Regards,
Elio
View 3 Replies
View Related
Sep 28, 2004
Hello, this is probably an easy question to most of you but I've only ever designed a couple of simple databases so I've never came accross this problem.
In my database I have several forms viewable using tabs, The main form is tab 1 (client details), tab 2 is marketing information and tab 3 is booking information. Data on tabs 1 and 2 are linked to Client details using the client name. I tested with a sample record and everything was working fine. I have now started inputing all the client details into the client details form (currently entered 200 records) however when I closed the database and re-opened later only one record was showing in the client details form. I though all of the data had been lost but when I looked at the client details table all the data was still there. Why are all of the records not appearing in the form.
I hope you can help and thanks in advance.
Julie
View 1 Replies
View Related
Jan 24, 2008
If you build a DB in Access 2007, can it be operated in earlier versions?
View 3 Replies
View Related
Dec 10, 2004
I have a table in Access that has many columns in it. Two columns are in question, one is social security numbers and another is a image file name column that needs image file names in it. The pictures are named with a social security number of the person Ex. 123456789.jpg. I have about 1000 rows of SSN's and need to place the image file names SSN.jpg in the image column. If I copy and paste the SSN column to the image column it is missing the .jpg, is there a way to do this other than manually? And also set it up so in the future the image column is automatically updated when a SSN is typed in.
thanks
View 1 Replies
View Related
Aug 8, 2006
Im just starting to use access for a small business. Im fluent in visual basic but i cannot seem to get this to work. so im using the wizard for the "Order Entry" and it works great. However, on the Preview Invoice where you can also print it, i would like it to include the credit card number, payment method, experiation date, ect. which all can be found on the payment form for the order. I have a text box but i cannot seem to get the write content source. what would be the content source so it can access the payment details from the other form and print it along with the invoice.
View 1 Replies
View Related
Jun 27, 2005
Hey i need some one that knows Access to help with a work Database, and just make sure everything is working and set properly.
This is for a Construction Managment Company.
Email me at *email removed* for more info, and i can send out the DB to be looked at.
Thanks
Kevin Maguire
President
GOT LOCAL MUSIC
View 1 Replies
View Related
Jul 23, 2014
Can I for instance while my db is open, open it in design mode from my form via code?
View 3 Replies
View Related
Nov 8, 2007
I have been asked to create a certificate for completion of classes given at work. Is there any way to use a report or will the need to be done through word?
View 2 Replies
View Related
Jul 29, 2005
I'm trying to create a validation rule in a microsoft access table that would require the entering of data in a "comments" field is another field's check box has been checked. What is the best way to go about doing this?
View 2 Replies
View Related
May 13, 2006
Hi all Its my first time on this forum so please be gentle with me ! I have a list of numbers stored in a field (wieght). I have another field that is the product field. I also have a list of letters (A-D) Now, the weight can be 1kg (through to 20kg) A-D hence four different values in my product field. I need to have a form that the user can choose a letter then enter the weight to show the correct product. I can get a dllookup function to work fine for the fields involved but i need a control to filter the different letter combinations Anybody point me in the right direction
View 4 Replies
View Related
Aug 30, 2005
Hi,
I have made a table(picks) with fields
PickID(primary AN)
Username
Weeknumber
winninningteam
pointvalue
The data is entered through a web based(asp) form. It is for a football pool. The problem i am having is trying to figure out a way to show the picks that are made for each person. I would like to be able to show a table that has columns
Name
Week1
week2
week3
...
week17
so that people can see the picks they have made all week. I tried creating a query using the wizard but I havent had any luck. I am guessing that this isnt a great way to structure the table but it is the only way I could figure it out. Any ideas on how to get this done?
Thanks for reading.
View 1 Replies
View Related
Jul 23, 2007
Hi,
I've been asked to design a database to hold information from a proforma based on tracheostomy insertions. The information breaks down into two components; patients and tracheostomy details.
From this I have designed two tables:
1) tblPatientDetails
- PatientID (autonumber) - [primary key]
- 12 fields (text / numbers) - relating to demographics
2) tblTracheostomyDetails
- TracheostomyID (autonumber) - [primary key]
- PatientID - [Foreign key]
- 74 fields (checkboxes, text / numbers) - relating to tracheostomy details.
Each patient can have more than one tracheostomy inserted over the course of their care, so there exists a one:many relationship between the tables. The two tables are therefore linked (one:many) from tblPatientDetails:tblTracheostomyDetails based on the PatientID fields in both tables.
OK here's my question; I want to make the inputting of these proformas as easy as possible for the person doing the data entry. Ideally I would like:
a) a single form which collects the data and enters it into the two tables.
b) a method of searching the patient details upon name entry and if they already exist in tblPatientDetails, to autopopulate the rest of their demographic information in the fields, but to leave the tracheostomy details blank (as it would be a new entry for that table).
My attempts at using the following solutions failed miserably:
a) a form based on a query of both tables - this allowed me to put the fields from both tables on the same form and enter information, but when I searched for a patient's details to enter a new proforma - it populated both the patient & tracheostomy details as well (i.e. didn't really let me add a new 'many' to the 'one' record).
b) two separate forms (patient & tracheostomy), with a command button to go from the patient form to the tracheostomy form. This didn't work because I couldn't pass on the PatientID variable between the forms to form a link between the tables - and there ended up being two separate tables of information. :S
c) from looking around at the various forums, I understand that a sub-form is useful in these cases but I can't seem to get the formatting right (I would like the form to appear as similar to the paper proforma as possible), but my recent attempts at a sub-form resulted in a datasheet view of the tblTracheostomyDetails, which isn't very useful as it contains so many fields.
I'm now left at a loss what to do, so any help would be gratefully received.
Many thanks,
Craig.
View 6 Replies
View Related
Oct 6, 2014
I have had to use my first crosstab queries.
I now understand that when opening and saving crosstab queries Access (2010) runs that query to ascertain the column names. Unless you hard-code them. Running the query takes at least 20 minutes.
I have hard-coded where I can, but one report takes arbitrary dates so I can't hard-code them.
I believe that turning off AutoCorrect might make a difference to whether the query runs - but I don't want to turn it off.
View 6 Replies
View Related
Jun 13, 2005
Hello,
I can't quite get my head around this - any help is much appreciated.
I have (amongst others):
tblStudents (containing basic info. name etc)
tblClasses (containing a list of studentIDs with classes they are in, so, for example, there may be 3 entries of studentid "1", each with different classes next to them, to show that studentid 1 is in classes: a b and c for example.
tblGrades (containing studentID and masses of fields with different grades for different subjects in.)
What I would like to do, is select the class name from a list (which I can do, no problem).
Open up a form listing all the students in that class, with all their grades next to them.
This SOUNDS simple - but I don't think it really is! I could just be having a VERY simple moment though too - if so, I apologise!
Thanks in advance!
View 1 Replies
View Related
Feb 6, 2007
After long, long, long hiatus of doing other stuff, I wanted to get around to update the database. One thing I had set up wrong was the attendance rosters.I just need to be able to create a new class, which may have more than one sessions, then make a list of registrants for a particular class, then be able to track their attendance per session for this class.However, my Google-Fu is lacking as every templates I've looked at doesn't really answer my question, which how three entities relate to each other.I know for sure that Class-Attendees is a one many relationship. Same attendee can register for more than one class, so that's no brainer. Likewise, Class-Session should be also be one many relationship for obvious reasons. However, if I relate Session to Attendee, it would create a circular relationship between the three entities. I've toyed with the idea of having a hierarchial tables of Class -> Attendees -> Sessions, but that does not relate the sessions to the class, which is necessary. I wonder if I should create a fourth table to contain attendances and use Session and Attendees as FK, but that still wouldn't fix the possiblity of a circular relationship?Any insights will be greatly appreciated. TIA
View 14 Replies
View Related
Jul 31, 2015
I get the message "The expression On Click you entered as the event property setting produced the following error: Class does not support Automation or does not support expected interface"
I receive the message on a PC running Windows 7 Professional using the Access 2013 Runtime. This pc does not have Access 2013 installed.On my pc, I do not get the error. I have Access 2013 installed and run Windows 7 Professional SP1. The "code" which gives the error is as follows and is invoked by clicking a button on a form
Code:
MsgBox "1"
Dim rst As ADODB.Recordset
MsgBox "2"
Set rst = New ADODB.Recordset
MsgBox "3"
[code]....
The error takes place after Msgbox "2" and before Msgbox "3".The strange thing is that I can run without a problem a sophisticated software package on the pc which gives the error, using Access 2013 Runtime. This package I converted from Access 2003.
View 3 Replies
View Related
Nov 12, 2012
This is the error I'm getting. A little obscure, I know, but this is happening in an executable Access application (2010 accde) when I click the close button on a form.
The code behind the form is checking a lot of stuff (data validation, etc.), but "Object or class does not support the set of events" is the error. Then the application continues as if nothing had happened.
The app was converted not long ago from XP ACC2003 to Win 7 ACC2007-2010.
View 10 Replies
View Related
Apr 14, 2006
Has anyone heard if they have improved the rather dismal graphic design portion of form and report editing in the new Access?
I was hoping for an interface more in keeping with standard graphic design programs.
View 2 Replies
View Related
Jul 12, 2006
Hello, I must say that I am not very experienced with Access.. hence why I most likely have ran into this problem. However I did try to read manuals and tutorials to get me through it. (Failed :) ) Hopefully somebody from these forums can help.
The database that I am trying to create is for a Door-to-Door marketing company. They have many employees(Reps) that are organized in teams(With team leaders). Moreover they sell more than one product. (SKY Television, 3G Contract Phones, 02 Contract Phones, BT Lines etc...) Hence what I tried doing is:
1. Create a common customer database M_Customers (At first I tried to what I think is "normalization", so I had C_Address and C_Bank_Details) but that lead me to some problems. This M_Customers table has all the needed information for all the products. (However some information is not needed for some of the products)
2. Create a common Employees database M_Employees, which lists all employees and their details. (Including Address and Bank Details) Moreover I have created a M_Commission database, to list all the levels of commission for different type of employees (on trial, mid level, top) and for all the different products.
3. Then I went ahead and created Quaries for Q_Phone_Deals and Q_Sky_Deals... but they did not input data into the database. (:mad: "The same record is needed in M_Customers" :mad: ) They linked a M_Customers with C_Phone_Deals and respectively C_Sky_Deals (Those two tables contained information about the phone deal or the sky deal... like "Network" for and "handset type" in C_Phone_Deals and "Install Date" and "Installed - Y/N" in C_Sky_Deals. ) These quaries (I thought) would be the main inputting devices, as they would also have a Employee_ID lookup in order to see who did the sale and then somehow calculate the commision that he or she deserves.
PROBLEM: As you can see I have made something horribly wrong with my relationships and probobly the whole design. As I cant get the common customer database to work, and link it to C_Phone_Deals and C_Sky_Deals and later to more products. Moreover I am not sure how to make the commission system work.
Please help me out, I will be more than grateful!
Best Regards
View 10 Replies
View Related
Jan 19, 2005
We upgraded to ms access 2003. We used to be able to make design changes on just about anything in access 97 IF a user was not in the particular record/form/object. Now it seems we can't do much of anything in access 2003 unless in exclusive mode. (and we have many many users 24 hours a day) so it's even hard to import changes made off-line.
Is there anyway around this in 2003? Any other suggestions? Other than calling all users on the phone to tell them to log off (and some are logged in and not even there), can we 'boot' everyone off (although this really is not a good option for us either). This is a production database.
It would be good if we could just make quick changes as needed when we want as it was in the version 97.
Thanks
View 4 Replies
View Related