Search results

Yup - backed up both FE and BE files.... ...Lucky is an understatement!

Yes, seems to have done the trick? Still none-the-wiser as to what happened to the original file though?

Not quite the response I was after ;) Have only just started 'building' the database, so didn't have a backup yet - aside from a backup prior the splitting the database - could work from that but was hoping for an easier fix?

SHIFT Key doesn't work, and there's only one FE file at the moment - I'm the only person using the database....

Hi all, I have a database split into FE and BE. Did some VBA work on the FE yesterday, before leaving the office. This morning I go to open the FE and am told that Access has encountered a problem and needs to close without even opening the DB. The BE on the other hand opens fine. I...

It's not actually the check box we're setting to Null, but the corresponding text box where the order quantity goes.

Done! Thanks again missinglinq for the tip. I did this: Private Sub Form_Current() If Me.Ctl504Slider = True Then Ctl504Qty.Enabled = True Else Ctl504Qty.Enabled = False End If End Sub Then I did this: Private Sub Ctl504Slider_AfterUpdate() If Me.Ctl504Slider = True Then...

Ok, point taken......as I've already said, I'm new to this, and may not have found the 'perfect' solution....so I'm glad you've responded. Now that I'm starting to get my head around this VBA stuff, will have another crack at it.

Yup...hehe...I should have known someone would ask that ;) All sorted. This is how I did it: 1. I had a small routine to grey the boxes out by default on opening form: Private Sub Form_Current() Me.Ctl504Qty.Enabled = False End Sub I then added the OnClick Event to the check box...

Thanks Missinglinq I pasted the code in that you provided, only the text box is now greyed out permanently, and checking the box on or off makes no difference - it just stays greyed out.... Apologies for the dumb post, but I really am only learning lol Chero :)

Ok, here's what I have: Private Sub Ctl504Qty_BeforeUpdate(Cancel As Integer) If Me.Ctl504Slider = True Then Me.Ctl504Qty.Enabled = True Else Me.Ctl504Qty.Enabled = False End If End Sub I still can't get the Qty box greyed out like I want? Being a complete newbie here, idiot proof...

I have a table, called tblJobDetail, with the following fields: jobid [primary key, and used to store job card number] product, yes/no format qty, number format which I've created a sub-form from, where users can select a check box beside each product, and the quantity of each product is...

Hey Everyone.... I'm new here, and have messed about with Access for a little while now but am only just dipping my toe into the world of VBA....do any of you have useful references/books for a complete newbie to get going? I'm currently writing an access database to handle production...