Search results

  1. C

    Cannot connect with ODBC

    Hi I have been trying to solve this some more but I am still having problems. 1 person suggested I use an IP which I have done but it still gives same problem. Hope somone can help, its quite urgent and if we cant network the database is no good to anyone... Thanks
  2. C

    Cannot connect with ODBC

    Hi I have Mysql databse running on a windows 7 computer and this works fine. I now want to link to it form another computer using ODBC, I have loaded the ODBC connector for MySQl.... However when I try and connect I am getting and error message saying "Connection Failed (HY000) ODBC 5...
  3. C

    Check boxes and actions

    Hi Rabbie Thanks for the reply. Firslty I certainly dont expect anyone to do any work for me and I have learnt alot form this site alone. All I am looking for was a point in the right direction, then of course I would be giving more specific questions regarding coding or whatever....... I...
  4. C

    Check boxes and actions

    Hi plog Thanks for the reply. I appreciate it wont be easy but also feel access as more than the capability of doing it. I have searched for some examples but cant seem to find any... I think I need examples on check boxes and also example of turning a quote into an order. do you know...
  5. C

    Check boxes and actions

    Hi we have a quotation form which is all working now. the next stage is we want to when we receive a customer Po do this 1. Have a range of check boxes (perhaps in another form) that have to be ticked (based on a quote number) , for example Is customer name correct is customer address...
  6. C

    password between forms

    Hi Thanks for the reply. I think I understand you, so the logical way would be Menu - on click of Invoices 1. Close menu form 2. Open password form thats as pasword text box onit (this is the bit I am not sure on and how to do it) 3. If password is correct then open invoice form 4. If not...
  7. C

    password between forms

    Hi if we have a main menu with 3 buttons Quote Sales Invoice Is it possible to have some way of blocking a user to access a form OR password the form before it opens. I have a login form for tha database, but this purely to gain access to the database and then log who is netering a...
  8. C

    Taking out £0.00 rows

    Hi Bob Sorry about that I must have supplied the incorrect link, the DB is 113mb. heres the correct link I beleive http://www.mediafire.com/file/317n89mgzuzc12w/Access%20test%20-%20Copy.zip Thanks
  9. C

    Sub Report problems

    Hi I dont think my coding in the first instance is good enough to replicate it hence if I change anything it keeps changing the good report in some instances. So looks like I will ahve to re-insert over and over again. Thanks for the suggestion
  10. C

    Sub Report problems

    HI I have a report that as some 20 subreports. I have developed the first report and all layout is perfect. I now need to copy the report including all sub reports but it needs to look at different sub reports, as it is based on a table with 4 different id's which have different text...
  11. C

    Cant see form footer in datasheet view

    Hi Thanks for all the replies, got it all looking nice with total now. Many thanks
  12. C

    Cant see form footer in datasheet view

    Hi Dave That works, but I did the form using a wizard and it show the rows in blocks and alternative colours..... do you know how to get the wizard format off without me having to do the form again. I am using 2010 Thanks for the replies
  13. C

    Cant see form footer in datasheet view

    Hi Rabbie I cannot find the form you mean, I am using 2010 Thanks
  14. C

    Cant see form footer in datasheet view

    Hi I have which I use for quote rows. It is set to datasheet view. In the Form Footer I have a txtbox with a sum oin the control source. this works ok, but when I view the form I cannot see the form footer. Thsi is also in the quote as a sub form so I need to see the total field. If I...
  15. C

    Taking out £0.00 rows

    Hi Bob I dont suppose you managed to get the download of my DB did you from the link I sent. I tried sending it again on here but got same result. Also if oyu manage to get the link, in the quoteform the subform for the prices, there is a totsl price field in the footer of the form. I...
  16. C

    Taking out £0.00 rows

    I did zip it, I ahve no cpmapct and zipped it. It trys loading it and then says (see below) not sure what that means, it is 15.2 MB though. Hopefully you can get it this evening, good luck with the shopping.... Your submission could not be processed because a security token was missing. If...
  17. C

    Taking out £0.00 rows

    Im that confused I didnt fincish my thread. I have attached the test db I have been playing with today. In it is form called formquote and here you will see the subform. I only have the quote working for type combination at the moment. in the last page of the report (use report button) you...
  18. C

    Taking out £0.00 rows

    Hi Bob Not as confused as me ha ha
  19. C

    Taking out £0.00 rows

    Thanks for the replies guys, I think I fonally got a solution but not ideal. I have like you say ID, Descritption and price. int he forms and reports I am just totalling the price. Also I have added in quoteid so it lnks in the quote it is in as a sub form. If I wanted to make the...
  20. C

    Calculate fields

    Hi I have a quote form and a sub form for quote lines within the quote form. On the sub form I have 4 main fields ID Building description Price Report price The quote may have many lines of bulding prices, so I ahve used an Add button for this. On the finla line I also put in the...
Back
Top Bottom