Search results

I am probably guilty of being a newbie who is probably driving you crazy however I think two points need to be made: 1. I usually have come here after days of trying to work it out myself. 2. Everything is a learning experience :) Once we know how to do it we can teach it someone else 3. We...

Its a long story but i have designed a form where there are four check boxes per question - there are two columns (Left and Right) with two boxes in each - L1, L2, R1, R2. There are a 8 questions (each with 4 boxes) but it I get the first one down I should be fine These represent the...

Hi Adam Thanks for replying. However I am having trouble making it work. I get an error message about compile error/syntax error. Here are the details: My pop-up search form is called frmSearchForm The text box where I want to enter the Participant ID (which is the primary key of the table...

Hi I wanted to create a input/pop-uo form (frmSearchForm) that would open when I click on a button from the switchboard form. This formSearchForm would give me the opportunity to enter a 3 digit ParticipantID and a button that I could click to "search/filter" another form called...

It really does make more sense to normalise which is what I did. I now no longer need the function and creates records in each form either. I had just used a combo box to filter the form to the record I want when I open the questionnaire. It looks good so far. It had taken me a while to get...

Do you think I should still do it? I have only made one questionnaire so far so it would be easier enough to fix? As a medical researcher and not a computer science major Ive always used access to meet my needs not really thinking about normaliation etc :) I should really think about it more...

I used the advice above. But each participant needs to fill out each of the 5 participants.

Thanks Uncle. Okay I do not have the database with me since its night in Aus but I really need an answer so I tried to replicate it as best I could without all the other questions etc. Please find attached.

Okay I created a database that I am going to use to collect data about a study we are doing. When a participant is added to the database on the main (Participation Details form), it automatically generates an ID and creates a record in a second table/form - a questionnaire (i.e. Athens...

Thank you Wazz. What is the role of the look-up--> combo box etc? When is this used?

I know this is probably a basic question but I just need to clarify something. I created a combo box using a wizard in a form that relies on its options by looking up data from a spefic table (Y) i.e. such as employee role. So far so good. However when I create the field in the table in which...

I found instructions that said in order to prefix an autonumber i.e. AAA000 you would have to write "AAA"000 in the format section under the general tab in the table design view of the field you are interested in. I did this however even though the number now appears as AAA000, AAA001 etc in...

THere are 5 tables because there are five different questionnaires that I need participants to fill out. Thanks everyone for your help.

I dont really want to use sub-forms but I found this code somewhere else and wonder if its appropriate: Okay I did this and I think it works: Using the After Insert I created an event procedure that said: Private Sub Form_AfterInsert() DBEngine(0)(0).Execute "INSERT INTO tblAthens...

Sorry Can you walk me through this a little more? If the Participants are in the main form and the questionnaires are in the sub-form. Do I select the question 1 belonging to participant 1 for example by using a combp bpx in the top of the form to select the participant I am interested in?

Okay I had an idea and I thought I might get ffedback as I am relatively new to this. I went through a period a couple of years ago when I used access alot and was becoming familiar with VBA etc but I havent touched it in 2 years so Im pretty rusty. I am running a study and need to have to...

Hi I jus got this email. THe person trying to log in wasn't me. What should do about this? ============== Dear ahuvas, Your account on Access World Forums has been locked because someone has tried to log into the account with the wrong password more than 5 times. You will be able to...

Can someone point me in the right direction? I have added a popup menu to my form to reduce the number of buttons needed. I would some of the options only available in the add or edit mode. Because its not a traditional button i dont think conditional formatting applies. Can someone give me a...

Thank you for your help - I have now solved the problem!

I have a code for a free text search form which will return records in another window when the search button is clicked. CODE Private Sub cmdSearch_Click() If Len(cboSearchField) = 0 Or IsNull(cboSearchField) = True Then MsgBox "You must select a field to search."...