Recent content by MaleNurse325

Thank you very much.

Hi guys, I have a report that I woudl like to print four copies of with this code. Where do I put the number of copies please? Function mcrPrintConsignmentNote() On Error GoTo mcrPrintConsignmentNote_Err DoCmd.RefreshRecord DoCmd.OpenReport "rptConsNote_by number", acViewNormal, ""...

Good day, So, I have a form with several fields that I need to carry forward to the next new record, These feilds will only be updated infrequently. I am trying a Before Update code that looks like this: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.Manufacturer.DefaultValue= """"&...

Hello Chaps and Chapesses, On the main menu screen (Switchboard) I have placed a button that initiates a back up of the database. Works fine, but.. Id like a field under the button that tells the user how many days have elapsed cince last they backed up the database. Any thoughts?

Thanks Plog :)

Im not very experinced atthis and 'self taught' so ...

Guys, Im almost embarrased to ask this but it has bugged me for over an hour. On a record I have Item1 to Item8 and corespinding Quantity figures. so Qty1 to Qty8 All I am trying to do is, if for instance the field Item2 is not null then AfterUpdate Qty2 with the value 1 (that is going to be...

Guys, Why is my copy of access graying out Conditional formatting when I am in desing view for reports? Help :)

I have a check box on a form. I'd like, when it is selected to make a field ( A text box ) called [DanGo] visible on the report generated [rptConsignNote] only when the check box is checked. I hope that makes sense.

I could do that but I have 10 colleagues who use the system and they re.. lets say, less that reliable. Currently the font is light grey and can only be viewed from directly in front of the screen.

Actually it is not a drop down but a field on the main form. The medicines are selected from a drop down box and this the updates the rest of the form with the details of that medicine. The prescribing details are in a sub section of the same form. It is not a sub form. The rest of the...

OK ... I have a database with medicines in stock with storage data. There is embedded in this form an area for prescribing medicines and printing a medicine label. On this area there is a field "Patient" which is the name of the guy I'm giving the medication to. Id like an AfterUpdate...

i have a field on the form with the time countdown to tell the user how long they hve before the application shuts him down. We have power issues where I work (on an oil rig) and if the programme is left running it can corrupt the database. Sorry for not beign too clear :(

I have a countdown to close timer on a form. I can only make the countdown in seconds and 20 minutes is a lot of seconds. Can anyone help me convert this to minutes and seconds please? Private Sub Form_Timer() TimeCount = TimeCount + 1 Me.txtCounter = 1200 - TimeCount If...

Call me a looser but I'm calling it quits. I have been fighting with this for a couple of hours and its time to go home . its 5:30pm here Thank you very much for trying for me. This is the second or third time you have helped me. Thank you