Search results

@ UncleGizmo thank you for all your little tutorial videos. Everything seems to be working fine (in terms of linking the tables). I was actually able to cut down the number of tables to just 3. Just one last issue I've numbered all the pages on the tab control as 1,2,3, etc Now when someone...

Alright... turns out that I can add all my subforms in a tab control. Here's an attached DB (in 2003) format. Look at "form1" My only question now is: If you take a look at bottom of each subform, there is a button which opens the form (in its own window). Is there a way by which I can make...

Because I'm dealing with impoverished patients in a very rough neighborhood. Some of them are 70+ and do not even know how to use a computer. We are going to have a student volunteer with us who will help them with entering the data but there will be 20 patients at a time and only one volunteer. :(

I did try that once, The only problem was navigating b/w subforms on diff tabs for eg: Main form has tab1,tab2,tab3, etc Each tab has just one subform. Like tab1 with subform1, tab2 with subform2, etc When a user clicks on next button on subform1 (tab1), how can I direct access to go to...

I can understand that. Could you give me some pointers in the right direction?

There is no way to go back. With help of some forum members here, I created a code which checks if all the required fields are answered before proceeding to the next form [button_click() property]. It is going to be a study with patients who will be required to sit down for an hour on the...

Yes. Exactly. This is what I want.

The way the forms are designed is like this Form1 auto-starts when opening the DB Form1 - Introduction text. Click next which opens form2 and closes form 1. Fill up information. Click next which opens form3 and closes form 2. Fill up information... ..... Click next which opens last form and...

Yes you are absolutely correct. That is exactly what I want. The only difference is that I have not setup "ID" as an autonumber. Not sure why. Thought I'd set it up manually.

unfortunately access 2010 is not allowing me to save it as 2003 file format. I don't know why :confused:

I really appreciate your input guys but as I said, I am a total beginner and do not understand most of the terminologies used in the forums. It's like a physician trying to explain the neural pathways to a stroke patient. :) Essentially I am not planning to run any queries, reports, etc on the...

The DB is in access 2007 format. I couldn't open the link cause its asking me to sign up on the website. I didn't quite get what you meant by transposing into an entity. Can you elaborate a little?

I'm a medical resident trying to begin a small research study at my clinic. All I know about access is from a class I took in med school. @GrahamMandeno on this forum has helped me a lot with the coding part of the attached database but I'm stuck at a point. Thought I'd throw it out here in the...

This is what I had wanted. You're a genius!!! :o One last thing. Do I have to paste the public function in the VB code for all forms or can I call the function in from1 from form2. I tried calling it but got an error. I didn't think much about it, just pasted the public function in all forms...

I kinda found a workaround for the limitation of the code but its too lengthy. I'm pretty sure there might be other easier ways and would welcome an alternative but in the meanwhile this piece of code works Dim aRequired1 As Variant If Me.fbda1 = 0 And Me.fbda5 = 0 Then aRequired1 =...

That was my first thought but there are patient privacy issues. Cannot post anything online as the information collected is very personal like name, address, medical history, etc :o Our IRB did not approve of online tools

I get the general idea just a technical snag. The form that I'm designing has multiple such "skip to" questions. for e.g. if fbda1 is 0, skip to fbda5. If fbda1 <> 0 then answer fbda2, 3 and 4 Again on fbda5, if value = 0 skip to next form. If fbda5 <> 0 then answer fbda6 & 7. going by...

@ GrahamMandeno Hi again. I'm stuck at a point further down in my database design and wanted to see if you would be able to give your input I'm now at a point where there are boolean questions. i.e. if Answer to question 4 is "no", then skip to question 8. and likewise. If they click on any...

Never mind... I figured it out burning the midnight oil. It was the comboboxes. They were named as combo123, etc rather than gender, race, etc. I corrected those names and now everything is running smooth I really appreciate your time and would like to add credit to you at the end of the code...

@ GrahamMandeno Even when I use the corrected code, I get the following error (see screen shot attached) and upon entering the debug mode, I see the following code highlighted Set c = f.Controls(FieldList(i)) I am not sure what's going on