Search results

Good Morning I have been working on a Sales Database for my boss now for well, way to long! I think I am finally getting to the stages where it is ready to be used (YEY!) I would really appreciate some tips / advice on how to successfully deploy my database across our network so it can be...

I dont know too much about importing into excel at the moment, its something I have been looking into myself... I was given advice to record a macro in excel for the formatting aspects and then use the code from the VB window in excel to shape your code in access. I dont know if it helps but I...

Then I think you may have to loop through the recordset to tick each checkbox - its difficult to say without seeing how it works. Perhaps you could look into looping through recordsets and see if that gets you closer...

It looks as though from the pictures you are using a Continuous form is that correct?

I'm hoping that has done the trick - I'm not getting the message now, or so it would seem. A little hard to tell 100% at the moment as it was sporadic to begin with but I'm keeping my fingers crossed. Thanks for that! :-D

I'm hoping that has done the trick - I'm not getting the message now, or so it would seem. A little hard to tell 100% at the moment as it was sporadic to begin with but I'm keeping my fingers crossed. Thanks for that! :-D

The datatype Yes/No is a checkbox. If you take a look at the form in design view then you will be able to check what the names of the checkboxes are on the form... how many checkboxes are there? If there are quite a lot then I would suggest looping through an array (sounds scary but I can try...

Good Morning I am hoping someone may be able to help with the following... I have a requery on a subform that in certain situations is trying to run after the form has been closed. Giving me the error that 'Access cannot find the referenced form'. I have attempted to solve this by adding...

Thanks! I have added this to the query and then changed the code to look at the query rather than the table - not sure why I didnt do that to begin with to be honest, much simplier and it means I dont need to filter in the SQL statement as the query does it all for me :-) I think I was confused...

Good Morning :) I am hoping for some advice on exporting data into Excel (2010). I have written the following VBA which is working really well. The only issue I have is that two of the fields (LTD and PAYE) are yes / no fields and the data is exported as True / False into the spreadsheet. This...

lsSQL = "" lsSQL = " SELECT [Company],[ContractRenewal] FROM tbl_Company " lsSQL = lsSQL & " Where ContractRenewal <= (Date()+90) " lsSQL = lsSQL & " AND CompanyType = 1" lsSQL = lsSQL & " AND Archived = False" This is working :-)

Thank you for your advice, I definately should be using Date() rather than now()... I have made the amendments suggested but it is giving me an error on the line lsSQL = lsSQL & " Where ContractRenewal <= DateAdd("d",90,Date()) " I will try and work out why that may be but if you have...

Hello I am hoping someone can help identify where I am going wrong ... I am having some trouble with the where clause - i think it is the ContractRenewal that is wrong - I need to show all companies whose contract is up for renewal in 3 months time... lsSQL = "" lsSQL = lsSQL & "...

Thanks for the link, some excellent code on there! Reading it also made me realise that I can use the following' If Len(sFrom) > 0 And sFrom <> sTo Then Thanks :-)

I have tried building a query and putting 'Is Not Null' into the criteria however this does not appear to be working...

Hello I have the following function which checks certain fields on a form for any changes. It then stores these changes and puts them on a form for the user to be able to keep track of old / new data. The problem I have is that I didnt allow for 'new data'... I only want the SQL statement...

Good Morning All, I am having some issues with Autonumber working with a global variable that I set... My database stores information for Companys - each company has its own unique reference (currently Autonumber). I have a global variable 'ICompanyRef' which uses this autonumber - I use...

Thank you again for the suggestion, it is something I was unaware of so I thank you for bringing it to my attention. Will be useful for me. As for the wesbite field for my users I really am looking for a way that they can press the Edit button and then click straight into the website field...

Yes but I think you have to have 'clicked in' or selected the field to begin with - which is when it then follows the hyperlink... appologies if I am getting this wrong? I appreciate the help :-)

It would when I'm in the table but I am looking for a solution for the user (who only see / have access to the forms). Thanks