Search results

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

Hi I have a form that uses 10 fileds for entry. The fields are Building descritption and building price (from 1 to 10). Not all 10 will be filled in, so in mt report I only want to show the fields that have prices in and I want them all together. Could someone advise how I acheive this...

Hi I ahve a quote screen that as potentially 10 areas to add prices in and each one with free text descritption field. On the report for this quote I Only want to see the fields with a price >0 and not all 10 and I only want to see the description fields if it as a price so for example...

Hi I have a report with a log brought in as an unlinked object. However, I want the users to be able to add in another logo if possible without having to go into report desing etc....... Does anyone know of a way that this can be acheived, for example replace exisitng logo with new...

Hi I have a lable called label93 which as a caption Estimate Date: I also have a txtbox called text93 with control source =Now() When ti shows on the report Estimate Date: 07/05/2011 How can I get them both so they are next to each other so it looks like Estimate Date...

Hi I have created quite a complex report built from over 20 sub reports (due to it having to be a document rather than a report). So I have some questions if someone could kindly advise or point me in the right direction.... 1. How many sub reports can 1 main report handle? 2. Is there a...

Hi We want to have the date, idquote number and page numbers at the top of every sheet of a report. However, we want it to go above our logo rather than below. So for the date etc.. to show on every page I know it as to go in the Page header If I put it above the logo in Report Header I...

Hi I have tried this many times but still having problems. I basically want a user log in screen but then want to be able to oput the user name and job position onto a report front page. Several have tried to help me so my apologies if I seem to be going round in circles. I have used this...

Hi I found an Access database that let you point to a directory (in a form) where you graphic files were kept ad upload them all at once. I lost the file and I cannot find it on the web. So 1. Does anyone know of a sample database out there that does this.. 2. if not any ideas how I can do...

Hi All Does anyone have any ideas on this at all I have tried using the access 2010 manage user and passwords and I cant get this working. I use the Wizard but then when I go into the database it just shows as Admin as current user and does not even list the users I have so I am totally...

Hi I have a table with user id, username and position of users. I want the users (abit like the Northwind Db) to have this screen when they log in (a form which as the user name drop down list and button for Login) When they log in with their user name then I want that to be the...

Hi I want to email a quotation report based on a survey type I have this code..... Private Sub Command103_Click() Dim StDocName As String If MsgBox("This will send Quote to your Client. Continue?", _ vbExclamation + vbYesNoCancel) = vbYes Then StDocName = "quotedem"...

Hi Could someone please help. I simply want to set up 1. Group of users with their own passwords and when opening Access it as a login box. 2. User name display when entering a quote for example (current user) 3. Display Username on reports who as creted a quote for example I am using...

Hi I have a mulitple page report. I need to insert into it PDf or Word documents.... I cannot find a way to import these within the report tools. Does anyone have any ideas how I can do this. Basically we are are wanting to put certificates within the document. Thanks

Hi I ahve a form with 2 combo boxes related to each other Client and Site (1 client can have many sites). In the client combo box I have Notinlist working well and if it is not in the list my message box activates the subclientform where I can add in the new details and also sites at the...