Search results

Hello Experts, I have an urging issue that I desperately need to solve. I’ll just explain the rational of my database before presenting the issue: I have a projects Database with: Projects_Table, Staff_Table Both tables has forms for data entry or update. Each project has many staff allocated to...

Thank you so much JHB.

Hi JHB, Sorry to be a bit slow but how then users will make more than one choice for that firld? what should I do?

Thank you Mihail ...

I solved it ... Thank you

Hi, In my database I have the following: 1)Projects table: - Project ID - Number field (Primary Key) - Project Name - Location - (other fields) 2)Working details: (this table has a form based on it and it's used to enter data by users) - Project ID (this field has a lookup for the same field...

Hi JHB, I'm thinking of the solution you suggested about using a child table. How can I achieve that? In my database users need to choose (5) different options for each category. I have 5 categories in my form. Thanks

Thanks JHB for the response. I've created my database alreday and can't change the multiple values fields now. Are you saying that there is no way to work around this? Can I create a code to copy records from table in one database to the Master database?

Hi All, I'm designing a database to capture data. I'm going to split my database to front end and back end then put copies of both on CDs to distribute them to my agents (I had to think of using CDs because not all location can access internet). When the CDs are returned I need to collate all...

Hi, I tried it but nothing has changed. The problem is still hapenning. Thanks any way.

Hi John, Steps that I'm doing: 1. choose Officer Number from the first combo box 2. choose EDW Number from the second combo box (this step bring automatically to the form some related details which are linked to EDW Number) 3. Then I can fill normally all the other details in the form. (till...

Sorry John, It's not working neither. :confused::confused: Is there something wrong with me??? Am I cousing something to the database???

Hi John, I'm sorry it's not working, the second list is not changing.

Hi John, I tried the sample that you uploaded and it works perfect for the first time, I mean the first record that I enter when I open the database, but then when I move to new record and choose another "OfficerNumber" the "EDWNumber" does't change from the previous record. I have to click on...

Yes I have done that John. I put also the "Current event" as you said but no change. It's driving me crazy !!

Hi John, I checked them on the database that you have attached , but they are not working. Still when I move to new record the second combo box doesn't change. It still holds the same list for the previous choice.

Hi John, I followed exactly what you said but it didn't work. Now I really don't know what to do. Thanks for your help !!

Here is the file in access 2003

My 2 combo boxes are the first two on top left: Professional Licensing ID Unique EDW Number

Not privacy issue, I think the size was too big but now it's OK