Search results

Apologies Pat. However, the old thread went cold about a week ago and I am getting quite desperate to resolve the issue. I'll try to be more patient in future. Sorry. But, if you do have any suggestions, it would be appreciated.

I have a form with two subforms. The second subform is really a subform of the first subform - confused? Ok. MainForm has many records in SubForm1. SubForm2 has many records in SubForm2. I know I can have two levels of sub forms in a main form. However, the problem with this is that I want...

Hi This is kind've a re-visit to a thread I posted a few weeks back. I have stored a number of work and rest periods by position for each activity in each session. What I now need to do is summarise the contained information by position for each session. I want the following information in...

I'm sorry. I still can't get it to work. All I get when I run the query is the field headings with no information i.e. it's blank. Any suggestions?

Can't say I have. How would I apply it to my current scenario?

I've had a look on the site but can't find an answer to this question - then again, I may not be searching the correct terms!! I have a sub form that contains periods of work and rest for various groups in a session (mainform). I want to be able to calculate the percentage of the work that was...

Sorry. The original post was titled "auto update ratio calculation". The gist of it is that I have 3 bound controls on a form: variable1, variable2 and the ratio of the two of them. What I want to do is be able to insert values into two of the three variables and have the third one calculate...

I recently posted a question concerning calculating ratios on a form, and was sent some code to try out. Unfortunately, I cannot get it to work. I don't think it is a problem with the code itself, rather where and how I am attaching it to the form. I'm sorry not to be giving more...

I have a table that contains 4 pieces of info: Session Position Work Rest What I want to do is calculate the % of work that was less than 10 for each position in each session. Any ideas??

Sorry, perhaps I should have been more clear. I knew to build it in the modules section, and that I could call it from a form or query, or control. It's the how to call it that I'm having hassle with, both in a form and query. It would be great if you could show me how. Thanks

Thanks for the reply, but at the risk of sounding ridiculously stupid, where do I attach the module - the form itself, control box, or not to anything? Like I say - cobwebs!!!

It's been a while since I built an access application and so this could be relatively simple - might just need the cobwebs cleared out of the old noggin! I have a table that contains two variables (var1 and var2) and the ratio of one to the other i.e. ratio = var1 / var2 Now I know I can...

I have created a report with two subreports. These are all linked by a CustomerID. The subreports contain subtotals that are needed for the calculation of the grand total (an unbound text box using an expression for the calculation) on the main report. In general the grand total calulation...

How do you use the Nz function?

sub-reports ar linked via the CustomerID which appears on both the main and sub reports. Also, they are contained in the detail section.

I've tried to calculate the total sum of key controls contained in sub reports on a form. I have used this method several times before, but now something weird is happening. The calculation is contained in an unbound control on the main form and is as follows...

I have been using the following code to update information populating a combo box, e.g. if I enter "eggs" and it is not a stored term, I get asked if I want to add it, and then the combo box is updated accordingly. 'In the data entry form ... Private Sub JournalID_NotInList(NewData As String...

I'm in the closing stages of creating my database, and as a tidy-up I want to control the visibility of forms that open other forms. for example If form "A" opened form "B", when "B" opens "A" becomes invisible, and when "B" closes "A" becomes visible again. As this happens numerous times...

Good News Rob. I got it working... All I needed to do was put an X in front of the = when calling the procedure. That said... The close form isn't working. It doesn't recognise the frm.Visible = false. I get a message saying "Run time error '424': Object required" I think I need to refer...

I keep getting a vbExclamation message saying ... Compile Error: Expected: line number or label or statement or end of statement