Recent content by MayoRR5

To be honest, I'm probably leaving the company as we got a new Director and he's trying to claim ownership of it

Noted CJ. That was step 1 in a dummies guide haha

Cheers Ranman. That was my thinking anyway. I'll totally redesigning the front end as it's going to be more visually driven, rather than filling out forms constantly. Shaun

Hi guys, I've been doing some research into this and the possibility of turning it into a business and I'm looking for a second opinion. Quick backdrop. I developed a database for the company I'm working over 10 years in MS Access and with cloud now becoming a better alternative for growth, it...

Sorry for the delay guys. Yeah I was able to find the data but it does ask for the owner administrator and password. I haven't had a chance to ask the guys for it yet but they'll probably say no anyway. I will let you know how I get on. Yeah I know it's ridiculous but we had a COO come in and...

Hi guys, I'm an absolutely noob when it comes to SQL but I'll tell you my predicament. We are using a piece of software linked with Sage Accounts to run our Job Costing reports in the company. It all works perfectly but the directors are "dinosaurs" and want a report with 3 lines of info...

Update guys. I was able to hyperlink them easily enough after a little tinkering. In hindsight it was pretty obvious. All I had to do was create a hyperlink with the folder address and then add the document names (which are based on fields in the table) and add as a new field to my table...

Paul, I will have about 100,00 documents to start with and then continuing on from there. Unless you want to hyperlink them for me, then be my guest :P haha

Hi guys, I have a database in use at the moment for Document Control but I want to add the ability to click a link for a document and open it from a specific location (one folder with all files) on our server. I was just hoping for some general advice, do's and don'ts, before I get...

Update guys. I ended removing the cell bookmarks and adding table bookmarks only and then referencing the cell reference each time (PVTableB A2, etc.) and it worked. Couple of notes I've made once I completed the exercise are as follows:- 1. When a formula was working and I wanted to...

Hi guys, I have a couple of queries.... shocking I know. I have bookmarked some tables and I'm getting a !Syntax Error, ( on this formula below { =(PVTableB(B2))*(PVTableD(B2)) \# "0.00" } Also, I have bookmarked some cells on another table and get a zero when trying to...

SUM!!!!! I knew there was another way to do that simply. Thanks namliam!!!!

Hi namliam, sorry I wasn't clearer. I have a worksheet that lists around 30,000 line items and some of these are considered to be unusual. I have a header section at the top of the worksheet and I would like a message to appear here if a quantity were to be assigned to the items. (see...

Hi guys, scoured the web but can't see the reason for getting the VALUE error for this. Could be something simple but I am really not seeing it :banghead...

Just to follow up I created a form to act like a message box displaying the error message. I then added an uncontrolled textbox on the mainform to mirror the control in the subform and it recognises when no entry is made against this new textbox.