I Thought It Was Simple(subformStuff) But Maybe Im Just Stupid.
Feb 15, 2005
Ive got a form, that has inputs to a table, and it also has 2 subforms that link to another table, the subforms are different forms but they link to the same table, this is bacause I need to be able to enter two different items off the table that may be different items, the reason Ive used subforms is because there is the need to have the part number for the item, as well as the weight, this will be a growing list as the Dbase expands.
now I have the two subforms with a combobox for part number, and the weight field looks up because of the combo,
back on the main form I need a entry that adds up the 2 weight fields, and enters them on the main table that the main form writes data to, can someone help?
Ive been heatbutting my monitor for a week or two now, and my limited know how on Access is beginning to show :-)
Thanks.
View Replies
ADVERTISEMENT
Jan 5, 2006
I have a very simple database for recording data collected from a questionnaire. The database comprises of
table1: QUESTIONNAIRE
fields: QUESTIONNAIRE ID
QUEST_1 ........
up to QUEST_75
table2: VALUE (1 to 6)
ANSWER (strongly agree, agree etc)
All of the 75 question fields in table1 record the same information, and all look up to a table2 which stores the 6 values: agree (1), strongly agree (2), neither (3), disagree (4), strongly disagree (5) and spoilt (6). As the data is being entered into a from using option groups, the database stores the value rather than the text in each QUEST field.
Pretty straightforward I thought, but when I come to query the database I am getting into such a muddle I feel like my head is going to explode!!
The results I need to produce should look like this:
ANSWER QUEST_1 QUEST_2 ....all the way to QUEST_75
agree 34 3 25
strongly agree 45 5 34
neither 3 2 4
disagree 3 4 32
strongly disagree 3 3 5
spoilt 0 1 0
Basically all I want is a count of the number of answers for each question! Given that the answers for all the questions are the same I thought this would be a piece of cake, but alas no.
I thought I would simply be able to crosstab my results from the questionaire into a new table, which would have the six rows (agree, strongly agree etc) and the questions as fields. The values should be the count of "agree" etc. I can quite happly have one field and the counts of each answer but when I try an add any other fields it just duplicates the counts!! I have sat staring at my query and am at a complete blank as to how I resolve this seemly simplistic problem :confused: .
Please if anyone has any ideas why I am in such a muddle over something which seems so simple I would really appreciate their help!
Many thanks
View 13 Replies
View Related
Aug 30, 2004
If I am going to get a Invoice/Statement programme made for me should it be in MS Access or Visual Basic, Thanks for your thoughts, Bob Vance
View 2 Replies
View Related
May 11, 2005
Hi all,
Hope this is the correct forum, and I am not breaking any rules of etiquette. :rolleyes:
I am after some guidance on how to start to tackle a problem, rather than any advice on the details of how to do it. That I want to work out for myself in order to try and improve my mastery of Access.
I have a team responsible for completing a number of scheduled reports.
These reports are scheduled for different frequecies ie :-
some are scheduled Weekly on a particular day,
some are scheduled Monthly on a particular date,
some are scheduled Monthly say on the 1st Monday of the month.
My goal, amongst others, is to be able to, from the switchboard,:-
a. Print a list of reports scheduled to run in the current work week.
b. Print a list of reports scheduled to run between any 2 inputted dates.
This is just part of what I want to acheive from this database, but as we all know Rome wasn't built in a day!! ;)
Grateful for any help / advice / directions,
Cheers,
fos605
View 1 Replies
View Related
Mar 12, 2007
Hi All,
This post is a bit long, but it is actually really simple. I have two tables(DEDPARM1 and DEDETAIL1). I ran a “CREATE TABLE” query using these two tables, to create a NEW table called “Biweekly_Temp_Table.”
DEDPARM1 sample data
SSN |Name |Type |Amount
555-99-8888 |Joe |FAE |2000
555-99-8888 |Joe |FAR |20
DEDETAIL1 sample data
SSN | Name | Type | Amount
555-99-8888 | Joe | FAE | 1000
555-99-8888 | Joe | FAR | 20
BIWEEKLY_TEMP_TABLE results
SSN | Name | Type| faeAmount | farAmount
555-99-8888 | Joe | FAE | 1000 | Null
555-99-8888 | Joe | FAR | Null | 20
This result makes sense, b/c it is what I wanted.
Now here is the problem. I ran another query(qrySingleRecord) against the BIWEEKLY_TEMP_TABLE to combine the TWO records into ONE. It works, BUT the faeAmount will equal 2000 and the farAmount equals 40. Why is Access doing this? I know something called Cartesian Product will occur if I query against both DEDPARM1 and DEDETAIL1. However, in this case I am NOT querying against these two tables; the whole purpose of creating a new table(BIWEEKLY_TEMP_TABLE) is to try to prevent Cartesian Product. Please help.
Thank you!
Joe
View 6 Replies
View Related
Jan 7, 2006
Ladies and Gents
I am wondering if when i run my report is there anyway that the detail of the report can become objects that say i could drag and drop into a Word Doc for example. I am trying to create a tool that will allow me to see all jobs from our maintenance mangement system at work, i have managed to achieve this but i was wanting to be able to view the jobs on a report and then basically just drag them into something else and wahey i have built my plan for the week.
Maybe i am hoping for to much but i though i would ask anyway.
paul
View 1 Replies
View Related
Mar 2, 2006
Evening folks :)
Been trying to find this on google for a while, but am not really sure about how to express my self in few words (being the norwegian that I am) so I turn to you for help! :)
Im having two tables which I want to join into one with a query.
I want to keep all data in table 1 and suplement it with info from table 2. Should be easy enough, at least thats what i thought. Cant get it to work here so if anybody can help me out i would be EXTREMELY grateful :)
Table 1:
artnr
description
minant
Table 2:
artnr
minant
Connected by artnr
Table 1 has approx 1500 lines and Table 2 has approx 2100. I want to keep all lines in table 1 and suplement that one with info from table 2, but I end up with a query with approx 1200 lines.
Table 1 does contain 'artnr' that Table 2 doesn't have and vica versa so I assume that the ay i do it I end up with the query only with the ones that has the same 'artnr' in both tables. Still my question is:
How can I keep all info in Table 1 and only suplement with info from Table 2?
hmm.. I agree, not the best way to put things, but it's the best a tired norwegian could do at the end of the day.. :)
All immediate help would be great!
View 3 Replies
View Related
Mar 29, 2005
right, deleted my last post.. think is is more down to the point!!!
got every table sorted so far, just one stupid relation.. I have to link the results of a horse race to the horse but cannot figure out how!!!
I have a table listing all the horses (names, dob, value colour) but need to create a table to list what place the horses finish during the 6 annual races - I tried to create a table with (date, race name, place name, 1st, 2nd, 3rd etc) so I can type in which horse finishes where for each race and then AaRrGgHh cannot work out how to link it!
I know I probably need more tables but Its starting to annoy me.. any suggestions would be greatly appreciated!!
the db can be found at http://www.pokernuts.co.uk/access/server.mdb (200k) and I have attached a picture of what I have so far (relationship wise)
Please help :(
AaRrGgHh
View 3 Replies
View Related
Aug 11, 2005
hi im stuck and i was wondering if someone could help me.
i am trying to multply values in individual records.
i have three columns in a table, lenght cost per a meter and actual cost. how do i calculate the actual cost for each individual record? thanks
View 2 Replies
View Related
Aug 7, 2006
i probably want to create a upddate querry or maybe some code but...
i have a light bulb and i keep 300 on hand i just ordered 300 more when i check the box that the order is complete i need the "bulb on hand" feild to update to 600....please help
View 1 Replies
View Related
Jun 12, 2007
I have not used queries or Access for a few years. I have a query set up to search for a tag number which the user enters in. How do I incorporate the * function in with it? This is what i have tried:
SELECT * From Bags_Recieved WHERE Tag_No = *" & [Which Tag?] & "*
I am trying to get it so the user just has to enter in a few numbers in case they do not know the whole number.
View 1 Replies
View Related
Jul 5, 2005
Hi guys,
I have a bit of an embarrasing question, as I`m sure that this is so easy to solve, but its just beyond me...
I have searched but dont get exactly what I`m looking for, looked in all my books to no avail !!!!!
I have a form, which had many data in it.
I have a particualr feild "cust_ref" which is sorted A-Z (asscending)
How would I change this to Z-A (descending)
I have done all the changes in my tables, queries etc, but this doesnt effect the form..
I also have the same problem in one of my reports....
Im sure its really simple, but I think i`m over complicating the solution, and its now giving me a really bad headache.
Thanks guys.
View 2 Replies
View Related
Nov 9, 2005
ok a stupid question but i cant figur it out.
I have 2 subforms and 1 mainform
all i want is that subform1 comunicates with subform 2.
subform 1 had a listbox that is filled with a query. When i click a value in the listbox the othersubform must navigate to that record.
View 1 Replies
View Related
Nov 29, 2005
Here's a stupid question... how can u make a field in a form so that the text in it is allways in capitals, it's for adresses and i need the city and the zipcode to be in capitals, any ideas?
Thanks on forehand
SilverBlood
View 4 Replies
View Related
Mar 13, 2006
I'm sure this is a stupid question, but here goes it. I'm working on a survey database. I want the end user to be able to be able to select a checkbox, if they use that service. Down the line I want to do some charting on the answers to the number of checkboxes selected. Is there anyway to change the default value to 0 and 1 verse 0 and -1
Any help would be greatly apprecidated
View 1 Replies
View Related
Dec 11, 2006
hi everyone, i'm new and almost clueless with all things asp, html and access. i know this is a bad start, but i'd really appreciate some help.
i'm doing a project with a group, we're constructing a website and i'm stuck with my part, a 'staff home page'.
basically what i'm stuck with is:
- writing the code to request the latest 5 orders from our database, and put these in a table.
- linking my drop down menus, which are in the same table, to change the status of each order
- linking my update button to the database in order to send this information from the drop down menus, and update customer orders.
apologies if i haven't worded that very well, or if the answers can already be found on the board. any help would be greatly appreciated.
thank you
View 1 Replies
View Related
Nov 21, 2005
i use Ms Access 2000 (home)& 2002 (office)..
can i choose type of relationshp manually..
i mean i can change ony-to-many to many-to-many or some thing like that...
if it possible, how...
plz help me...
View 4 Replies
View Related
Dec 15, 2004
I have done multiple searches with no luck- sorry to ask such a basic question, but I want to know the correct way of inserting a foreign key into a table.....I was told to Insert - Lookup field - in my main table - is that correct?
Thank you :confused:
View 14 Replies
View Related
Feb 21, 2006
I'm currently trying to get a button working that will check the contents of a field for a value, and if nothing is selected I want it to prompt the user to select something. Here's my code:
Private Sub Command47_Click()
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmCustomerInf"
stLinkCriteria = "[CustomerID]=" & Me![CustomerID]
If [CustomerID] = "" Then
MsgBox "Please Select a Company Name", vbInformation, "Warning"
Else
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If
End Sub
For some reason I can't get this working, what am I doing wrong?
The error I'm getting when trying the button is Run-time error 3075: Syntax Error (Missing operator) in query expression '[CustomerID]='
View 4 Replies
View Related
Mar 19, 2006
Right.. I'm a complete noob @ access...
Ok.. I have a yes/no column in my table and I want to build a query on that table so it returns all the records with NO (unticked box).
How do I do that?
Any help appreciated :)
View 1 Replies
View Related
Jul 6, 2006
I've got 20 checkboxes which i need to do the same thing but individually.
If IsNull(DLookup("[question 1]", "qryQuestions")) Then
chkQuestion1.Visible = False
Else
chkQuestion1.Visible = True
End If
I tried this:
Dim loopy As Integer
Dim tmpquest As String
For loopy = 1 To 20
tmpquest = "question " & loopy
tmpCheck = "chkQuestion" & loopy
If IsNull(DLookup(tmpquest, "qryQuestions")) Then
tmpCheck.Visible = False
Else
tmpCheck.Visible = True
End If
Next loopy
tmpquest works.
tmpcheck doesn't.
I tried dimming tmpcheck as lots of things but no luck.
Any help?
View 6 Replies
View Related
Nov 4, 2004
New to Access and learning quickly, but some things just throw me.
I have a database that adds rows to a table as certain command buttons are selected. It frustrates some of the users because every time they click the button, a warning comes up, "You are about to append 1 row(s). Once you click "Yes".... and on and on.
What's the easiest way to remove this notification?
View 3 Replies
View Related
Mar 2, 2005
I've searched these forums, but I haven't found anyone as clueless as I...
All I want to do is put something in the "Control Source" of an empty field in a form to create a date... Specifically, in the following format: MM/DD/YYYY
I know this has got to be easy, but I can't figure it out. I'm an idiot...And so is Mr. Clip-It.
Andrew
View 6 Replies
View Related
Jun 11, 2006
Before I start I just want to say that I know forms are not well suited to printing etc... but I have this stupid issue that is driving me nutzo.
I have a form with a subform on it but for some reason on the main form and the subform insist on printing on seperate pages, i have checked the force new page setting for each section and there are no page breaks that i can see? Don't seem to be able to find references to this issue anywhere...
Losing my mind... :confused:
View 1 Replies
View Related
Dec 2, 2004
I saw that nobody read my first post so I figure I'll post my question here. I am trying to learn VB and am curious about how to make command buttons that will do the next/previous thing in VB and not using a macro. Any advice?
View 4 Replies
View Related
Jan 29, 2008
version: access 2000.
OK, i have what may be a fantastically stupid question. i did a search (http://www.access-programmers.co.uk/forums/search.php?searchid=1806902&pp=25&page=2) on this and didn't find anything that seemd to address it.
my issue: autonumber field, sole primary key. i am adapting a legacy (non-access) db into access. it was originally an autonumber field but during import, the data type was set to number and of course, i cannot convert it back now into autonumber.
i already duped the PK field as an autonumber and tried an update query to "correct" the autonumbering PK field as i believe is suggested here (http://www.access-programmers.co.uk/forums/showthread.php?t=138484) but it won't permit me to do this.
b/c it's legacy data, i want to preserve the original values in the autonumber, but am unclear on what next steps might be available to me.
thoughts, anyone?
ed
View 2 Replies
View Related