Search results

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

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 problem comes when there are no questions left, the code still tries to move onto...

haha oooops, i didnt really explain what i was asking! well the problem is that I can get the code to go to one form, but it will always be the same, no matter who logs in admin or student. I want them to go to different forms. If Me.txtPassword.Value = DLookup("Password", "Users"...

Hi there, I have adapted a piece of code to allow users to login into the database. I have two types of users, that of student and that of admin. If the admin logs in I want them to be taken to a different form than ordinary users. Here is the code i have so far Private Sub Login_Click()...

Thanks for that, I realised what the problem was, i was pointing to the wrong form :-)

Hi guys, Ive been trying to add search form to my database, and used an example provided in these forums. I am not too upto scratching with programming so maybe I have missed something simple. Basically I took the code provided in the example database and changed the relevant form names, text...