Recent content by colkas

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

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...

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...

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...

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...

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...

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...

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

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

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...

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

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

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

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...

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...