Recent content by bhecht

Does anyone know how i can make a field equal to the same value as in the last record added + 1 within a form?

Second report I also need to create a report for tables: Programmer Mode and CVpersonal details. The report needs to be with personal details at the top, and the headings, and contents in order given. I tried doing this and i could only get rpt_CV which only has the headings, but not the...

Thanks I am basically interested in a report containing the fields in Tables: tbl_step 1 (if q1_employment is ticked then also tbl_q1, AND if q5_land_property is ticked then also table q5) tbl_q10 tbl_q11 The project is meant to demonstrate constraints, so the reason there are so many...

I zipped it, but it's still 7megs I can't upload it as it's too big, and i've already compressed it. I uploaded it online anyway on http://www.btinternet.com/~dodo/boaz/project.zip Thanks Boaz

Thanks I emailed you through the system, i hope it worked. The file is on http://www.btinternet.com/~dodo/boaz/project.zip Thank you very much for your help Boaz

I am not sure how to fix that I have looked at the relationships, and they appear right to me. But i have never done this before so i'm probably wrong. How do i fix it?

Thanks I might try and create a new form and swap them around. But even then, how do i do it?

I have set up a form within a form that allows the user to add records, delete records etc, while on the right there is a subform (in Table View). How do I allow the user to click on the records in the table to bring up the relevant record in the main form?

It says i can't because a related record is required in table ... Thank you for your reply. I tried the refresh answers, but it says "you cannot add or change a record because a related record is required in table tbl_Step1" How do i fix that?

Thank you Thank you very much, i'll try that. Perhaps you can help me with a more significant query I have: it's posted on the Forms forum under my name. I am not familiar with this to direct you, but i would really appreciate it if you could give me some advice.

I have set up a form that allows the user to create a CV with different headings etc, I have managed to set it so it creates a report with the headings and records, but at the top it places the headings as just the field names, without showing the actual data. How do i fix this?

I have set up a system that allows a user to enter MS Access through Forms (Switchboard). Then the user can select to begin filling in their tax return, which is made up of several forms (Step 1 allows the user to go into Q1 & Q5, then continue on to Step 3 which then allows the user to select...

I have set up a system that allows a user to enter MS Access through Forms (Switchboard). Then the user can select to begin filling in their tax return, which is made up of several forms (Step 1 allows the user to go into Q1 & Q5, then continue on to Step 3 which then allows the user to select...