Search results

Yea I will probably but I would really like to have a go myself! so just a quick question - I did the above and it says: Run-time error "2450": Microsoft Access can't find the form "Training Done" refered to in a macro expression or visual basic code. I followed what you said but obviously...

Hi, you have been a great help so far, could you please try and figure out the final steps for me on the Splting form thread please? :)

Yea but my manager decided on a redesign and the guy that helped me has practically left - only cut down to one day a week Basically - Everything was in one form - now I want to split it into two: These are my steps so far: I copied the Training Done List Box into a new form and called it...

I have located this and it is named training but I moved this list box into a new form called Training Done, this list box is no longer located in this form. I wanted the new forms joined by a button. From my understanding in the code do I need to change this: Me.? training. requery Is...

That's great thanks a million but yes he was but it's important that it is requered as the list box needs to be updated everytime a new rep is clicked. However at the moment you have to close the new report to update it and then reopen it. Is there anyway that this can be requered? This is...

Yes it is - what will I do abou it?

Ok to address the issues: 1. My job may depend on it! I apologise if it offended anybody. 2. I am recieving errors when I copied it: Option Compare Database Private Sub Combo12_AfterUpdate() Me.Competency = Null Me.Behaviour = Null Me.Competency.Requery End Sub Private Sub Command50_Click()...

Spllting a form Hi there, I had help designing this form with the following code: Option Compare Database Private Sub Combo12_AfterUpdate() Me.Competency = Null Me.Behaviour = Null Me.Competency.Requery End Sub Private Sub Command50_Click() DoCmd.SetWarnings False DoCmd.OpenQuery...

I actually think I fixed this yesterday, I created a query that merged all the other queries together by using joins. I then created a chart from that and the results are fantastic. However, now the only problem I have is that I want to change the name that appears on a legend is this...

I apologise, I'm fairly new to access, I don't understand what you mean. Could you please explain further? I want to compare an average for a class across different modules to the actual result a student got. The chart is calculating an average result for a student across all modules, I...

Hi, I don't want a pivotchart to calculate any autocal in the data field drop area , just show the number without sum, avg, min, max etc Is this possible? Thanks in advance for your help

Hi there, I'm not too sure how to phrase this so I will try to explain as best I can: I have a access db based on a course running - 3 tables: 1. Students,(who belong to a country) 2. Modules and 3. Exam Results I created these queries: 1. Average for the course as a whole per module 2...