Recent content by raward1941uk

I have a database which is split so that several people can have a 'front end' to the database to access one common back end. This works fine on a network but I thought I could load the backend up to my webspace and then with the links manager point to it, but it doesn't work. I get an error...

It works fine! :)

Re: Delay in subform navigation buttons showing total. Adam, Thanks for your interest which I appreciate. I was going to attach a Zip file of the database but I can only get it down to 540K and I see that the limit for Zip attachments is 393K. However you have helped me enormously because at...

When viewed in data sheet view the result is instantanious but when viewed as a single form the delay is quite marked I can assure you.

I noticed that you've used a "Totals" query; wouldn't a simple query have enabled you to gather all the information? I have had the same problem myself and I got round it using a simple query. raward1941uk

I have created a form with 2 nested subforms in it for storing order details. The main form shows the customer, date, and his/her order number. The first subform displays items ordered, one record at a time. The second subform embedded in the first subform shows details of subcontracters and...

Nigel, Thank you very much. I have tried it and it works beautifully; best of all, it's very simple. Roger Ward

Thank you: I said I couldn't see the wood for the trees. raward1941uk

I have created a series of 3 forms for entering order details. the first form records the customer reference, order no. and date. The second form contains details of the order eg., qty, description, and price. The third form contains details of the subcontracters and services they supply...

It's pssible that you haven't given yourself access rights to your SQL 2005 server. Open the Surface Area Configuration tool and click on"Add new administrator." You will see 2 panels and in the left hand panel you should see your user name. Highlight it and then with the arrow between the 2...

The first piece of code checks to see if the field contains nothing. If it does contain nothing it returns "Tue", if it contains something it returns "False". The second piece of code increments your ID field, whatever you want to call it, by 1. If it is the first record then it will place 1 in...

Solved A Problem For Me! I created a database many years ago in a DOS program to keep track of my orders and work from sub contractors and have carried on using it on the basis, "If it's not broken don't mend it." However, Windows doen't like it so I am repeating it using Access. The job number...

Thanks Thanks; I've come to the same conclusion, I've changed link now and the subtable is coming up but looking in the properties menu the sub table is set to auto. I'm on a very steep learning curve but enjoying it! Cheers Roger Ward

Hi I always feel as though I'm asking a stupid question but here goes. I am making a database with sub tables and sub forms, and working from "Access 2003 inside out". When I open table properties and enter a subdata sheet name and fill in child and master links everything seems fine until I...