Search results

Thanks StarGrabber, I will have a look at the code and the changes you have made and try to understand it. Brucey54 :)

Hi Folks, Please could someone explain to me if this is correct! I have created the following tables; ·Carer Details ·Rota Details ·Client Details Relationships TblCarer (1 – M) TblRota A Carers can have many rotas TblRota (1 –M) TblClient A rota can have many clients. Now...

Hi StarGrabber, I am having nightmare, I am trying to use Lookup field for Client details & Carer details. On the FrmRota I am unable to select the Client names more than once before I am present with the following error message; this is driving me mad!!! I have also attached the...

Hi StarGrabber, I understand what you are saying. I’m trying to create a database that will hold the Client details and the Carer details. Then I’m trying to create Rota table that will hold the rota details, each carer will receive a New Rota each week. I am trying to make it as easy as...

Thank you, thank you very much. Please could you help me with the following? I would like to pre populate the rota table with the Client Name & TelNo via a Combo box i.e. the Combo box would display the Clients names and depending on what name is select the TelNo field would then be filed...

Thank you StarGrabber, thank you very much. Please could you help me with the following? I would like to pre populate the rota table with the Client Name & TelNo via a Combo box i.e. the Combo box would display the Clients names and depending on what name is select the TelNo field would...

Thank you StarGrabber, thank you very much. Please could you help me with the following? I would like to pre populate the rota table with the Client Name & TelNo via a Combo box i.e. the Combo box would display the Clients names and depending on what name is select the TelNo field would...

Hi folks, Please could someone help me with the following problem? Why is it when I click on the TblCarerdetails and try to open a record with the plus sign I am present with the following error message “Enter Parameter value CarerID” The frmCarerRota seems to be working ok, the...

I was hoping to understand why the tables are not linking correctly, if I click on the TblCarer plus sign. I should see the Rota details and a plus sign. If click on the plus sign, I should see the clients details. Therefore I am assuming that my relationships are not correct, I think I...

Hi folks, Please could you help me with the following? Why is it when I click on the TblCarerdetails and try to open a record with the plus sign I am present with the following error message “Enter Parameter value CarerID” The frmCarerRota seems to be working ok, the relationships seem to...

Converted to 2003, thanks much appreciated. Tom

Hi Plog, thank you for your response; I have updated the database with your suggestions. Please could you help me with the following? Why is it when I click on the TblCarerdetails and try to open a record with the plus sign I am present with the following error message “Enter Parameter...

Hi Folks, My rota table is not linking correctly to my Client table; I have tried a lot of different variations but I always seem to end up with the same problem else where!! Basically I’m trying to create 3 tables i.e. Client Details Carer details Rota details Then from this I was trying to...

I was thinking of running query to identify who was below 60 first, then run another query to identify what names appear more than ones. Not sure how to write a query to show duplication, any help would be much appreciated.

Hi, need some help here, I have been asked to run a query on the following parameters; Run a query to show patients names only if their blood results are below 60 and only if their blood results are still below 60 after 90 days from their first blood test i.e. Name----------------------...