Search results

  1. C

    Calendar - Allow multiple

    Hiya I found the Calendar2000 Dbase and was wondering if there is a way to allow for multiple entrys on the same day, Looking for at least 3. The calendar has the time schedule on it and it works by time slots, so if I :start a job @ 7:30 till 8:30 it won't allow me to enter a new job for...
  2. C

    Data Entry Calendars

    Hiya Anyone know of any free calendars / appointment booking Im building my database for use by builders, slaters etc all trades, so the use of the calendar is a must. Some ppl with have 2 or more men on different jobs, so I would like sumthing like - Use a basic form to add location of...
  3. C

    Filter on form when dblclicked

    Hiya I have a data entry form calendar in my Dbase, Adding an appointment is done via a subform with the following fields: ID DateA TimeFrom TimeTo Location Employee once this has been saved, its stored.. The main form to it is the calendar. 31 days with little textboxes.. If aan...
  4. C

    Filter on Report

    Hiya I have a form with 2 buttons on it.. Preview Report and Print Report whichever one I click, it shows all the reports, not the record the form is currently on. What would the filter be and where do I put it lol? The keyfield would be LetterID which is place on both the Form and Report...
  5. C

    Required field Message

    Hiya On my form I have a "EndDate" field and the prop typre is set to Required, for use in other records.. If I don't enter a value, I get the basic message box appearing - "You must enter a value in the Workorders.EndDate field" How can I change this message to something of my own? Cheers...
  6. C

    Auto Save command

    Hiya Is there a code or anything that will allow a form to be automatically saved? On my form there is a few bits of info the user should enter before moving to the next section, but for the data to flow correctly, a save is required.. Rather than having an annoying msgbox saying please save...
  7. C

    WorkorderID problem

    Ah seems to be fine now guys.. Didn't think of having a refresh command onChange lol simple little things ________ Healthy Relationship Advice Forum
  8. C

    WorkorderID problem

    Hi guys Sorry for the lack of imformation The workorderID comes from another table The way I bring it into the current form is - Default Value =[Forms]!
  9. C

    WorkorderID problem

    Hiya I have a form which has a subform for products The sub is linked to other forms as well.. I've included a pic to show the problem Cheers guys ________ EFFECTS OF ZOLOFT
  10. C

    Problem with Field

    Hiya cheers for the reply Added your code and it worked no probs, however, I apologise as I didn't explain the full problem, STAGE ONE I create a workorder, blah blah and fill out all the fields, I add the materials needed for the job and the labour. Everything adds up correct in the...
  11. C

    Problem with Field

    Hiya Access 07 I have this invoice form, with some info on like Order Total, Payments, Sales Tax etc just what youd expect on an invoice, In the Payments (Unbound) I have this code =IIf(IsNull([WorkorderID]),0,DSum("[PaymentAmount]","Payments","[WorkorderID]=" & [WorkorderID])) Default...
  12. C

    Drop down menu selecte

    Hiya I have on my form a drop down menu that is linked to my Products table. The menu is part of the invoice I have on the basic form, the following Product Quantity Unit Price (Drop Menu) (Number) (currency) When I select something from the Products, it adds the price...
  13. C

    Multiply Date field

    Cool Thanks So it would be like this dateadd("y",Garantee Term,Date of Work) ________ Babe blonde
  14. C

    Multiply Date field

    Cheers for the reply Would this still allow the Garantee term to change? Not all jobs would be 5 years some can be as much as 10? ________ KID AVANDIA
  15. C

    Multiply Date field

    Hiya I'm trying to multiply my Date field but its spitting out the wrong date. I have the form like this Date of Work Completed - Short Date - Data is 5 May 2009 Job Garanteed - Yes / No Garentee Term - 5 (5 Years) Garantee Expires - Blah So far its at 23/9/2446 (more than 5 years)...
  16. C

    Problem with Amount Field

    Hiya I'm trying to add an Amount Field into my customers form, so I can sum all off the workorders in the customers name and have the total displayed in the customer form. Have tried all sorts of things but to no avail. Can someone take a look at this? The main should open itself...
  17. C

    Report Printing 6 copies

    Hiya I have a report Called Working Schedule The basis off the report is - a report detailing what my men have done at the job, IE a Diary of work done. Layout is in a datasheet view When I click print report its printing out every entry for this diary, however, each entry is showing the...
  18. C

    Selection from Drop Down Menu

    Hiya I have a drop down menu with my Customers Name in, is there a way I can also have it select the address? The form is like this :- Appointment Date: Appointment Time: Customer: (Drop Down) Location: The Customer Name and Location would be pulled from another table, Customers...
  19. C

    Automatic Popup

    Hiya I have a form called Employees with all my employees information, I have a subform attached called SickDays Employees Info EmployeeID, Name, Address, DOB, Warnings (Memo) etc Sickdays has - AbsentDate, AbsentReason, AbsentNotes And, Informed (Yes/No). Would it be possable to create...
  20. C

    Call up Module Function

    Hiya m8 The calculation is already done is general. I just need to be able to show the sum on the customer page The current AmountDue that is being calculated per workorder is control source - =Forms![Workorders by Customer]![Workorders by Customer Subform].Form![Workorder Total]-nz([Total...
Back
Top Bottom