Search results

Just added in the extra quotations and it works great! Thank you to everyone who helped. It only shows you how worthless I am in access. I should stay in excel, haha. Thank you so much.

Thank you for the code, yet I still get a data type mismatch is criteria expression error which it then points to: DoCmd.OpenReport "Skills Matrix", acViewPreview, , strWhere As for normalizing I'm absolutely horrible at it. Once I get this expression sorted I'll see what I can do. Thanks...

Thank you for all of your help. The main form uses the Part Number field as the index which relates to the Part Number field on the subform though the Subform has an index called ID. Part number is a text field, and ID is an autonumber. Thank you again.

Thank you for the link, but I can't decifer that to save my life. I am very much a novice at Access, and while I have most of the database the way it needs to be this one thing is really stopping me. With most of the VBA I have found it either gives me all of the records or limits it all the...

Sorry I spoke too soon. On Error GoTo Err_cmdPrint_Click DoCmd.OpenReport "Skills Matrix", acPreview Exit_cmdPrint_Click: Exit Sub Err_cmdPrint_Click: MsgBox Err.Description Resume Exit_cmdPrint_Click This gives me the report, but also for all of the records. I'm not sure how to limit it to...

Hi I hope you all can help me. I have created a form with a subform for training. The database works great and I'm close to finishing it. One of the issues I have now come across is printing a single record from the form. The VBA I use is: Dim strWhere As String If Me.Dirty Then...

Thank you for the formula, it work's great. I've tried to normalise in the past, but really can't seem to relate it to my database. I'll keep trying though. I may actually get this running yet. Thanks again for your help.

Well it seems I'm using some new features so it won't allow me to save as a previous version. Lucky for me I have my original database in 2000 which shows the same error. If you open up the Quotation Form for the error, and the formula is still on the query. Apprently in 2010 you can put...

Nice to see I'm breaking new barriers with this error. The Error shows on the "Quotation Form" under the general tab. The formula is located in the Run Time (HRS) field on the query. After you mentioned about the formating of the fields I looked at it again and all fields apart from the...

The [Family Tool] field is a check box, and the other two fields are both numbers. I put all of the formula's into the Query I run for this form using the layout: Run Time (HRS):IIf([FAMILY TOOLING]=Yes,(2*([QTY PER ANNUM]/[PRODUCTION PER HOUR])),([QTY PER ANNUM]/[PRODUCTION PER HOUR])) I'm...

Sorry for what may end up being a fairly simple solution, but I can't seem to get rid of the #Num! error on my formula. Looking at previous posts It seems I may not have the best formula so I hope you can help. I have a query I run that contains all of my formulas. One of them is...

Hi everyone. I've still been trying to figure out this issue I have and have come across another way to do it. Since I can't seem to get the relationships to work like I want I am looking at keeping one table. Now I have been looking at ways to summarise this information on a form and...

At first I thought this was going to be be pretty easy for me to do, but this one issue has really got me stuck. I've attached a very basic database based on just the five fields mentioned above in two tables. The Form I am using only has three fields on it. Two from the first table and one...

Thank you Rabbie, but I can't help to think I am doing something very wrong with my relationships. I created a new database with just the feilds mentioned. On the Table Quotes I created QuoteNumber as a number type field, and customer as text. I then created a new table called Table...

Guess I'll be crying again on Friday when I try to do it. What's worse is I created a whole new database with two tables. It only had two feilds on each. One had Quote number and customer, the other had quote number and revision. I tried to link the Quote number on table 1 to the quote...

This seems a bit above me at the moment. While I think I understand the purpose of normalisation, I can't seem to relate it to my database. From my perspective all my data can remain in the same table. I just need a way to group the data by quote number so I can show all revisions against...

Thanks for your Help Rabbie. Is there a better way to group these on a form then having two tables? I just need to be able to summarise quote numbers with a list that will allow me to jump to another form. I'll try to add anothe autonumber as an index. I guess I would need one on my Quote...

I knew it was too good to be true. I've attached another version of the database with a load of changes I made to it. I tried to normalise it and up till now thought I did. If I go into my Quotation form and create 2 quotes one with Quote number 1 Revision A, and another with Quote number 1...

Thanks Again John, unfortunately that formula change doesn't help, but I think the issue may be related to a Div/0 error. Once I figure out how to return a 0 for that formula I think the others may be OK. The formula is: =(3600/