Search results

  1. C

    Code to stop Module running

    Hiya is there a code that will stop a module from running so it can be deleted? ________ Children prilosec
  2. C

    Code to Delete Module

    ok m8 sounds good You got an example of this working? I need to somehow turn the Dbase into a demo but still have a disable button to make it fully functional Can you help? ________ HTTP://WWW.VAPORIZER.ORG/
  3. C

    Limit Add records

    Hiya I had the code from someone here before, but how do you limit he number of records? I don't want the customer to add any more than 15 records.. Sort of like a Demo file, but I would like to be able to disable this action if a "serial number" is entered or password protect the button...
  4. C

    Code to Delete Module

    Sorry m8 didn't even realise you had responded ok I see what you mean but don't know how to do that My current setup is flag the date, the Module I have (basRunFirst) stops the Database on any system date change so you couldn't manually change the computer date. I managed to get the code...
  5. C

    Code to Delete Module

    Hiya guys I have a table in my database called tblDateFlagged which will flag 14 dates, after that the Dbase stops working.. This works perfect I have added a button to the spalsh screen to (Unlock) the database THe basis of this button is If UCase(strInput) =...
  6. C

    Button to Delete Table

    Hiya guys I have a table which flags the date for use as a demo db. Its currently set to 14 days trial then after that the db is useless. Now, some ppl may have stored alot of records in that 14 days so rather than having to send out a full copy (unrestricted) on purchase, is there a way, I...
  7. C

    Add tabs to custom ribbon

    Hiya I have a custom ribbon that I've been working on with all the icons etc but having issues with adding more tabs I cirrently have this <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab idMso="TabHomeAccess"...
  8. C

    Custom Ribbon Errors

    Thanks bob Had to give it the ID Name "Test1" (or something) restarted, still got error For the OnAction "NameofMacro" Got it working tho, THanks ________ Maryjane
  9. C

    Custom Ribbon Errors

    Hiya I downloaded the wizard for Custom Ribbons - http://www.ribboncustomizer.clatonh.com/ Follwed the instructions and if I use Access built in commands, things work fine, but I'm trying to use it with macro Basic stuff like Openform Heres the code from the USysRibbon <customUI...
  10. C

    IF STatement

    Ah rgt ok So there is no way of having this box ticked if the Amount Due is £0.00 apart from doing it manually? ________ Balloon assembly vapor tower
  11. C

    IF STatement

    Well its not the resuilt of the calculation. The calculation is the Amount Due field.. All the paid box is, is a yes . no If the Amount due is ?0 then True / Yes Then I can show this on the customer form and filter out l8r on the Paid box ________ DICK S
  12. C

    IF STatement

    Me.Paid is a checkbox on the table If the Amount Due is ?0.00 then place a tick in the Paid box then when I run a report, I can filter on the YEs/No for unpaid accounts ________ MILF XXX
  13. C

    IF STatement

    Ah ok I got one on here which worked but not on calclated fields tho and the other one came from a guy I phoned lol sorry So what would it need to be? I went for the Greater Than to see if it would work.. but it didn't So the correct version would need to be like this Private Sub...
  14. C

    IF STatement

    The names are like this Private Sub Payments_AfterUpdate() If Me.Total_Payments.Value >= 0 Then (Greater than 0) Me.Paid.Value = -1 End If End Sub ________ The cigar boss
  15. C

    IF STatement

    Hiya, cheers for the reply I managed to get it working on a practice form wth the same names, so I'm thinking that it could be because the field its applied is calculated? ________ FREE WORDPRESS THEMES
  16. C

    IF STatement

    Hiya guys I was given this code before - If Me.Amount Due.Value = 0 Then Me.Paid.Value = -1 End If but it doesn't seem to function.. Any help? ________ Beautyxdoll
  17. C

    Automatic Data Entry

    Hiya I have 2 forms - Workorders by Customers and Payments The workorder by customer is a brief summery of previous workorders, contains current account balance etc The payment form is as it is.. Contains the Amount to be paid, payment method and WorkorderID (Related) I have a field on...
  18. C

    Onclose command

    Any ideas? ________ The Cigar Boss
  19. C

    Onclose command

    Heres the code for the Payment Form Option Compare Database Option Explicit Private Sub Form_Open(Cancel As Integer) If Not IsLoaded("Workorders by Customer") Then MsgBox "Open the Payments form using the Payments button on the Workorders by Customer form." Cancel = True...
  20. C

    Onclose command

    Hiya The form I'm working on is Workorders, the related form is Payments I have the following fields (basic) in the Workorder form Subtotal Sales Tax Payments Amount Due If I fill out a new Workorder and refresh the page everything looks good Lets say it looks like this Subtotal...
Back
Top Bottom