Search results

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

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

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

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

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

Hi guys, (Using MS Office 2007) I have a delimited text file (see attached) (delimiter is semi-colon) and want to create a linked table in a db. This was working without fault until yesterday afternoon. When I link the table now, it duplicates the data horizontally so instead of having 12...

Hi guys, I have 12no. tables containing days for all the months of the year. I know this is against normalization rules but I couldn't get around this format. I needed a timesheet that mirrored the screenshot attached. Now I want to create one report that will pull data from a specified...

Hi all, I'm having a problem with a "calculating text box". In the [Item_Total] box I have the control source "=[SumOfQuantity]*[Unit_Rate]" and [Unit_Rate] is a value that is calculated in the Query controlling the Report. All works fine to this point. Then I have a group header and...

Hi all, I have a text box on a form which I want to be controlled by what is selected in a combo box on the same form without the use of queries and subforms. For example:- Table 1 tblSchedule contains a unique ID(SchID) and a value(SchValue) for that ID. The combo box will show what...