Search results

  1. P

    Problem with number seperator in sub form

    Help please, can anyone see a problem with the code below I needed to change the decimal symbol from a dot to comma for use in Europe. On changing the the settings to a comma everything works fine but for the field that I have the code in the AfterUpdate properties Private Sub...
  2. P

    Problem with a Continuous sub form

    Could anyone help please with this problem, I have searched the forum but not found anything to help. I have a system that has a Continuous sub form, (example attached) this is used to calculate various processes. The problem is I would like to have the Labour cost as a single field in the...
  3. P

    Calculation From Combo box

    Hi could any one help with a problem I am having getting a calculation to work from a combo box - The product and cost come from a drop down list, cost comes from colum 2 - calculation works fine until I do the total sum which comes up blank or error. attached is a jpeg of the form in design and...
  4. P

    field order in a report

    Hi, on running my report the data in the detail section comes up in reverse to how it is entered in the form - could any one please give me a simple solution to put this in the correct order :o
  5. P

    subform in report

    Hi Guys I have a problem with a repot, I have inserted a sub form (continuous form)in the detail section of the report - problem is on running the report the form duplicates itself according to the number of records in the form - any idears please i am using 2003
  6. P

    Sum of a Calculated Field

    Could some one please help, just spent some time looking through all the posts regarding this , but still cannot get this simple sum to work I have a continuous form and require a field to give the total sum of the retail cost attached is a Jpeg of the form and code in the control source please...
  7. P

    Calculations in a report

    Could any one help please I have a form with a field that has the total cost of a number of functions [Text407] I am trying to bring this into a report via a query (copy attched) with out any success, as the result comes up blank any one spot whats wrong please?
  8. P

    Inserting Images in report

    Hi could some one please help - I have searched the forum for a solution but not found or understood anything I have seen to resolve my problem I have a database for estimating accident damage on vehicles - the main form as fields for all the costings, plus a field that is hyperlinked to a...
  9. P

    Combo box list

    I have a combo box with 300 customer names in, on selecting the customer it auto fills fields in with address etc. Is it possible instead of scrolling down the list to required customer, I can put the first letter in the box to select customers beginning with that letter Have searched the...
  10. P

    Command button in Excel 2007

    Help please I have been using a form in Excel 2003 with a command button that puts the form dirrectly into outlook (with the added email address) - since changing to 2007 the button just keeps giving the error msg. can any one see the problem with the code - as this still works fine in 2003 but...
  11. P

    Calculated field in form not working

    Can anyone spot what is wrong with my formula for this field, copy of the form enclosed, also a part of my DB system that is giving me some problems would appreciate help as I have spent hours looking for a solution and trying many different ways to get this to calculate
  12. P

    Time Field

    I have a text box that I need to be able to put in available hours - in excess of 24:00 hrs - the text box is formated to short time and will not allow this - how can I achieve this please
  13. P

    Problem with Code

    Please help - Could anyone spot what has gone wrong with this calendar that I down loaded from the forum - I have tried to use it with one of my systems, but found the top two rows will not delete the added data, the bottom two are fine I have checked the the code but canot see anthing...
  14. P

    Update Query Help

    Help please, a simple problem that I am struggling with I have two tables, 1 tblparts and 2 tblproducts when the product table is added to, I require this to automaticaly update the parts table with only the new records
  15. P

    Help Drop down list problem

    Help I have a problem with 2003, in that my information in a combo drop down field has disappeared, the information is still there but is not showing I believe there is a patch repaire that resolves this problem does any one know the location or how I can fix this please
  16. P

    Date Query

    HELP please - I need to run a report from a command button using the attached query - the report needs to show any jobs that have 2 days left before the estimated completion date (a type of early warning system) the report can be run any day to show any jobs with 2 days left to run, I have tried...
  17. P

    Early Warning on Date Field

    I have a form with a estimated job completion Date and I need to create a warning system (2 days prior to completion date) can anyone help with me with any idears or code to do this
  18. P

    Querie using check box

    I have a form with two check boxes 1) BuyingPlatform & 2) WorkingPlatform I am running a report from the attached Querie - showing all the customers in the BuyingPlatform - Question - is it possible to have the paramerter value to choose either the buy or workplatform I have tried different...
  19. P

    export data to Sage

    Hi can any one help with this problem i need to export data from access to a Sage accounting package is it possible?
  20. P

    Transfer data from a calculated field

    I need to export data from a access form into exel - problem is it has a number of calculated fields that come out blank - is it possible to transfer the data into a field in a table? i have searched and know you cant store a calculated field, if there was some way the information was in a table...
Top Bottom