Search results

Hi Mark, thanks for your reply, the work as I mentioned is mainly Queries and VBA, however the database has been in development for the past several months, and when I open the database none of the VBA works, and if I press "OK" on the error message box, all the code in the entire system is...

Hello, I hope that you can help me (God I hope you Can), my master database had a slight hiccup today and it appears that now the VBA code is corrupt. I have checked my backups that are taken every day and every backup from Wednesday shows the same error, which I find curious, as I created a...

Hello all, I have had a quick search regarding my question but I cant find something that is what i'm after. Anyway I am creating a database for my department in access 2010, and we send suppliers non conformances for NG parts, but we require the suppier to reply within 30 days of receipt of...

Hello All, I am currently working on a database that will record and plot an SPC chart, in access 2010. So far I have been able to calculate the X-Bar, Sigma, Min, Max, CP, CPK and Kurtosis in my queries. i am now compiling the final report, which would be used to present the capability of a...

Hi Anzacks, did you manage to complete this SPC database, im attempting to do the same, i.e. create a SPC chart which shows CP and CPK over a range of results but im struggling to acomplish this??

Thanks for the info guys, I will try those methods, for now I have imported the file into excel 2010, then deleted the first column with the * field, then saved that as a txt document and imported that, and that seemed to work. Thanks again. Tom

Hi people, I am having difficulty importing a large txt file into my database, due to the first column containing a * prefix. normally i would just go through the document and delete it, but this file is quite large at over 100k records. Is there anyway of importing this file in access 2010...

Hello all, I am quite stuck at the moment in access 2010, I have a database where I have disabled the File tab using the below HTML code in a USysRibbons table, which works as intended (stolen from a post on here), But I would still like access to show the Add-Ins tab on the ribbon. How would...

Hi Im Tom from the north east of England, quite a novice at Access upto now, but this will hopefully be changing in the next few months, I'm currently running Access 2003 but I will soon be migrating to office 2010. Im sure you will be getting many questions by me over the coming months, so...