Recent content by dbertanjoli

Many thanks, I will try it right now. Deb

Thank you very much, tomorrow would be fine, I hope you get better soon. Simon: Our members can have research, adacemic and teaching roles at the same time and under each of these categories they can for example teach several courses, have several research fields and so on. Everything works...

Re: referencing forms - one more problem My main form has a list box with names. By selecting the name I then click on the resecarchcategories subform to enter data for that person. After entering a first record and want to add another one by using 'add another' button breaks into debugging...

Bob, Sorry to bug you again, but the frmResearchCategory doesn't let me save more than 1 or two records under the same person. usually after the first/second record is saved it breaks into debugging mode. Many thanks, Debbie

I just made a few changes to table relationships and it seems to be working. So if I select a name and go to the reseachcategories form, enter data it associates it to that person's id. Please let me know if these table relationships make sense and won't give me some troubles later on? Please...

Bob, Now we are going backward :( By clicking on somebody's name and opening the 'researchcategories' form I should be able to enter/or see all records related to that individual. With this change we have just made regardles who I select I see the same data in the 'reseachcategories' form for...

Many thanks Bob, I haven't seen any attachment. Was it suppose to be one? Debbie

Hi Bob, Thank you very much. It is almost working. The problem I am having is that data entered through the researchcategories form is not associating with names. I build a query called results and it shows 0 records. The tblResearchCategoires has around 12 records. I am doing something...

Hi Bob, Thank you for your reply, How would you do it? I have a list of name and each name might have several reseach interests, several academic roles and so on. Deb

I hope someone will be available to help me (please see attached zipped database). I posted the same question under the table section but they told me the problem is in the form design. My simplified database is attached I exported a list of names from excel file to my tblNames. On my 'main'...

I hope someone will be available to help me (please see attached image). I am not sure if I laid this out properly. My main form has a listbox with names (which I exported from excel spreadsheet into tblNames) and by clicking on individual name I can select from (so far) 3 forms ( custom...

many thanks, but how to used datediff to calucate days and months of wait based on date booked? Deb

Hello, in my form I have two fields: date booked (surgery) and wait time. I would like my wait time field to caculate days someone is waiting for surgery based on date booked and today? Many thanks, Debbie

I have a webform (it is designed the way that administrator can add questions on line), but this form doesn't have any setting for date (date validation). So, in my access database I added a new question category called OPEN4 which I would like to use for dates. I am attaching the whole page...

I have a make-table query and I was thinking if there is a way to update this table when changes occur automatically? Many thanks, Debbie