Search results

I had been wondering what had happened ... Glad to hear it's all working out. :)

You're right - it' not pretty! :eek: Yes, I did mean the Record Source of the subform. Yes, you're missing the point with the subform - perhaps I have explained it badly, in which case my apologies. You have the basic structure now (with the continuous view), but it's still inappropriate in...

Would you explain this please? I don't understand what you mean.:confused: The problem speedman_2001 is having is that there is no column(index) property in a list box. If this is present in some other guise, then I can't find it (other than the value list in the RowSource). If you look at my...

Yes, good progress!:) The problem with FRM_customers is that the name does not match the function it is trying to serve, which is causing confusion. If you named this FRM_registrations, then it would make more sense in context. If you look at this from the top down, the purpose is to...

You are very welcome.

I have amended your example report as follows: 1. Changed the Record Source to hold the query directly, rather than pointing to the external query. There is nothing wrong with the way you did it, but my aim was to make the report entirely self-contained. 2. I moved the function from your...

This option causes the statementOption Explicitto be placed at the beginning of modules. With this statement present, it means every variable must be named before it is used (athough it doesn't have to be given a data type). The advantage is to avoid mistakes in typing variable names which can...

I have amended your workbook to include a macro behind sheet INPUTSfixed - no other changes made. I used the double-click event for the worksheet to trigger the macro to run. If you open the workbook and double-click in any cell in INPUTSfixed, you will see the cells in range Y2:AB104 populate...

If the students submit hard-copy worksheets only, then I assume there is a process of data-entry that you follow, to key-in the results? If I have understood this correctly, then what is the starting point for your copy-paste exercise - is it the INPUTSdynamic worksheet? I assume you mean...

No, that is a constant. What was the error you got? I haven't come across this, but I suspect it's a setting in the VBA editor for your copy of Access. You can't declare Public constants in a form module, with or without the type, so I think you had them in the right place (a stand-alone code...

You need to put a dummy value in cell A5 in WeeklySummary, to allow the offset to locate to A6 first time throught the loop. So addSheets("WeeklySummary").Range("A5") = "x"just before the outer loop starts, then addSheets("WeeklySummary").Range("A5").Clearafter the loop ends. This isn't the...

I assume the text boxes are unbound and are populated manually? I have created an example, using text boxes named txtFM, txtFY, txtAM and txtAY (I used more meaningful names than just Textnn, which I suggest you do as well. You can change the names in the controls' property sheet under...

Are you sure this is a good idea? You say you have columns for credits and debits, so I would have thought that would suffice. However, the easiest way to reverse the sign of a number is to subtract it from zero. If you start in an unused column to the right of your data and enter the...

I managed to get my laptop to work, so I have now got your DB open. There isn't a form named frmMeters, nor one named frmMenuSwitchboard? The two forms present are 'Meter Counts' and 'MeterCounts'. Opening these from the sidebar both have the focus on the first field, as would be expected...

Really?:confused: In Access 2007, I have the ability to save to earlier versons - I'd be surprised if that option had been removed. Anyway, if you can't do it, I shall have to crank up my laptop (which takes an age) and see if I can review your DB on it. Alternatively, some other kind person...

I can't open your DB - are you using Access 2010? If you can save in in Access 2007 format, I can have a look. I tried both DBs in the zip file - each come up with unrecognized format in my Access 2007.

You'll need to give more information to get any further suggestions. How about posting your code and provide more details about the form and subform and how they are used?

Aha! I wondered where you'd got to!:) Now how do you know I'm a fan of Winnie Ther Pooh? I grew up having AA Milne books read to me - take care not to encourage me, 'cos I'm likely to start quoting James, James, Morrison, Morrison ... at you. What makes you think I do? Try this: With your DB...

The root of your problem appears to be lack of normalisation. Inserting fields in the customer record for every possible course makes for complexity such as you are experiencing. In essence, you have four elements for this part of your database: 1. Course details (name, description etc.) 2...

Perhaps the form is already loaded, so you don't get the load event triggering? How about putting the SetFocus in the subform's Current event? Depends on how the user interaction works.