Recent content by JaneJohnstone

Sorry, I'm always doing this - posting a question and then answering it myself - but in case anyone else has the same problem I found this link http://kb.jetreports.com/article/AA-00801/0/Setting-up-an-Azure-SQL-data-source-in-Jet-Essentials.html and installed the right driver using the links...

Has anyone had problems trying to create reports from an Access 2013 web app? When I try to create the client only database I get the following error "Microsoft Access can't connect you to the database right now. This might be a result of missing drivers or a general problem contacting the...

Sorry - ignore the question - I should have read on a bit further - seems I can do this with subviews.....

Jeff, Is it possible to set up a view within an access app to show a number of different "grand totals", related to one or more tables. For example, I'd like to display the total value of all orders, the total number of orders and the total number of items ordered, on a single view. In this...

Jeff, Many thanks for this. (I didn't direct the question specifically to you as I didn't want to assume that you would be the one answering all questions posted here, but I'm delighted you've picked it up...) As ever, I've been sidetracked on other things but hope to turn my attention to this...

Hi, I'm creating my first web app with Access 2013 and I'd like to allow users to run a query after supplying a parameter to be used in the query.Simple example might be to display a list of all records that contain a date older than "x" in a particular field - with the user supplying the value...

Jeff, Thanks for your update. It's good to know that I won't have to start from scratch again when I'm ready to go live. I guess I will have to practice the steps involved in copying across the data (otherwise it may take me so long to work out what I'm doing that the data is out of date again...

Jeff, (Now I've had the opportunity to spend a bit of time on this, the questions are coming thick and fast. I'm not sure that to keep bombarding you endlessly is the proper way to get support on this, but if I haven't already tested your patience to the extreme, I have another one....) As I...

Jeff, I do have one quick (I hope!) question. I'm trying to set up a calculated field that returns the number of days that a job posting has been active. This is basically todays date minus the posting date. I've tried to research this and came up with DateDiff("d", [Posting Date],Date()), but...

Jeff, Please ignore my earlier mail. I can see that you just add another tab to do this!! A case of RTFM!!!!! Jane

Jeff, Thanks. I have set up Total Cost as a calculated field. Just one question on the Related Items Control. I can see how it works in my app, showing me orders associated with Customers, when I'm in the Customers List. Very Nice. Do you know whether it should also show me Postings associated...

Jeff, Feeling a bit smug now as I have made some progress - creating three more tables - Employees (just one field - Employee Name), Contacts (Two fields - Customer name and Contact Name) and Postings (Fields are Date, Customer Name, Position, Contact Name, Employee Name) - This is to track job...

Jeff, Sorry for the delay in responding - I've been busier than I was expecting on the recruitment side - good for business bit bad for application development!! I have done the tidying up. Thanks. In answer to your questions, no I'm not familiar with the controls you mention. To be honest...

Jeff, You're a genius!. All worked perfectly and I have no blanks in the table. (I couldn't open the screen print you sent for some reason, - I do have internet explorer set up to show pictures - but I didn't need to see it as following your instructions everything worked as it should). I now...

Jeff, Thanks so much for all your help. I'm going to be out today and most of tomorrow, so I'm going to try this over the weekend. I will report back on Monday. Thanks again. Jane