Recent content by wilko

Doc Man, Just a quick note to acknowledge your thorough reply, I'm going to have a look at this over the weekend. I'll report back any findings, hopefully success Regards Ross

Doc Man, I was a bit slow in understanding where you were comming from, but the penny did drop after i wrote my long winded post! I just acted on your advice, for clarification: - created one table database - split database onto my shared folder (located myshared folder by going through Entire...

Thanks for the replies Moniker and Doc Man, apologies for the late reply. I'm still having a bit of bother trying to split this database. Ive tested this out quickly on a one table database, to ensure that nothing in the larger more complicated db is causing the issues. My procedure: -...

Apologies, just made another finding. I added a new network place \\mylaptop\folderpath in the linked tabled manager i selected this directory to split my database too. However, when i then go and look at the path in the database instead of being "\\mylaptop\folderpath" its...

Moniker, i fully understand where you're comming from, however what I'm not sure on is how to execute pointing the linked tables to the UNC path name rather than the drive on my PC. When in the database splitter function, I'm assuming i go to network places and then select my shared folder. If...

Thanks for the advice, much appreciated

I'm currently having problems with splitting my database. The situation as present it: - I have a shared folder on my laptop, to which i have given full permission rights to a collegue, in this folder is the backend of the db which i split from a database also sat in the shared folder - I can...

Evening Gents. I've created a database which is going to need a fair amount of data uploading into it (a long laborious procedure). My initial plan to cut the work load for one person was to create 2copies of the database and split the upload in half (get two people to do it). However, one...

Hi guys, im looking to incorporate a timer function into my database. Basically at the moment students can takes test in the 'quiz' form - id like a function that starts a timer once its opened, and then display the time taken in a message box when the test is finished. Any ideas on how i...

Hi guys, I appreciate there have been a few of these threads knocking around, and ive spent a morning reading them, and going through my Access Book! :) Essentially what I want to do is allow one type of user to have full access rights to the db, and anothe rtype of user to only have read...

Hi Colin, I have created myself a login screen, I am only going to be having two types of user, which include admin (who have ability to do anythign they want) and the other is 'student' - who I only want to have the ability to read the database. At the moment, depending who logs on, points...

Hi there, I am just contimplating the best way to add word files into my database. I know you can add them as objects, however when they appear on the form they seem a bit 'messy'. Does anyone have anytips how to make this look more professional, perhaps the use of links, or buttons? Many...

Hi Collin Just wondered why you suggest that you should always have a query benhind a form, not a table? I am currently building a database and have a built forms based on one or two tables, however not on queries, should I be?

Hello again... to add further clarification.. Ideally I want to code to stop before it gets to the point of error. Therefore the logic should be something like: If QuestionForm is EOF Then MsgBox "You have completed the test" Therefore the code should look something like If Frame10.Value =...

Wasnt sure what sub-forum to post this in so went for this one and the VBA one! Hi Guys, I am building a db where part of the functionality includes a practice tests. It is currently working well, with the form moving onto the next question when a student gets an answer correct, hoowever the...