Search results

Thanks guys for your help. It does seem not worth spending days on one report. It still was worth trying at least.

Example as requested.

Hi guys, I've got a bit of a challenge here and I want to pick your brains on it. I'm looking to create a simple organization chart type layout report, but not sure if it's possible at all. Imagine a school being the highest level, then you have several classes (2nd level) containing several...

I've came across this, however not sure how implement this. Can you help me with this. https://support.microsoft.com/en-us/kb/138901

OK, I believe that code is for 2 labels their associated txt boxes. I'got several instances of that setup. How's that going to work?

Hi, just tried it and I'm getting run-time error 424 Object required - see attached.

Hi, not sure if the word scaling is the correct term. I'm not sure if this is even possible. What I want to achieve is when you change the size of the form (make it wider than the default size) all txt boxes will also get wider to fill any blank space. This is easy to achieve with one txt box...

I've got to controls horizontally, a lebel + txt box and a label + txt box. I've been playing with it now for several hours, but with no luck. Is it possible have both txt boxes to equally re-size when you re-size the form, however I need the labels associated with the txt boxes to move along...

I will need all fields from the source table for the form to display correctly, however not all records need to show, as some of the records on the form have their associated subform information blank and that is what I'm trying to eliminate. I hope it makes sense. Thanks

Thanks for expiaining, however it is showing all fields. Any ideas?

Thanks CJ_London for reply. I'm a bit of a novice here so could you explain a bit more where do I put that code please?

I've got a hopefully an easy question - how to create a form filter? I've got a form with a subform. Form is showing all records from a table, but some records on the subform are blank. I want to create a filter which will eliminate any record from the form where there is nothing to show in the...

Thanks for your suggestion. It does work on the print preview only. Once printed the footer is not showing at all. HELP

Hi guys, I know that question was asked before, but the answers I've seen didn't worked for me. I've used the following code on the footer on print procedure: Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer) Me.PageFooterSection.Visible = (Me.[Page] = 1) End Sub...

Hi, I've got a form with a subform. The form has always 78 records. The link field is a system field. I want to create a filter which will only show records on the form where an associated system appears on the subform. Any ideas? Thanks Adrian

Thanks, will add. Any ideas my the form don't show the changes and I have to click twice?

Moved the thread to VBA section.

Hi, it is probably very simple but I can work it out what is wrong. I've got a query initiated by a button on a form. That query should update fields based on what you choose from another field. For some reason I have to click twice on that button to see the changes on the form. The code is...

Ok guys, I've get rid of the macro and put some code for it. Private Sub Equip_Data_Upd_Click() DoCmd.SetWarnings False DoCmd.OpenQuery "equipment_update_qry", acViewNormal DoCmd.Save Forms![comp_statement_fm].Refresh End Sub The code works, but I need to click the button twice to see the...

if there is however a better way I can drop the macro and use VBA, but I'm an novice with VBA.