Oh, if I only knew VBA....
I'm so frustrated and at a standstill at what I thought would be a simple operation to extract desired data.
I am working on a real estate database and trying to create a query of three tables that I can then use to create a report based on the criteria I provide. Basically, the tables are tblAllProps, tblClientOffers, tblNotes.
The tblNotes is used as a subform in the frmClientOffers and frmClientOffers is inserted into frmAllProps in datasheet view. I did it that way so that the Notes info shows when the subdatasheet is expanded. This is perfect and works exactly how I need it to.
However, now I need to be able to have several reports -- one is a report on all the offers made from one single client, so I put the Client Name in the Client Name field in order to extract only the data from THAT client. That's when I get the data mismatch error.
I have a great suspicion that it has to do with the Client Name field being a lookup field. The Client name is a lookup field from the tblClients that has only two fields -- ClientID an Client Name. I lookup the Client Name from the tblClient in the tblClientOffers and have no problem with that. It does what I need it to do, and this field needs to be a lookup field for the database so that when users are entering data onto the frmAllProps they can use the dropdown to choose the correct client.
tblOfferNotes is tied to tblClient Offers via subdatasheet like I mentioned.
I know no VBA whatsoever. I have tried to find solutions to this problem by searching the net, but every answer I find requires knowledge of VB. That leaves me totally out.
Is there anything I can do from within Access to get the results I need? Do I need to just give up and hire a VB programmer? The database is almost completely finished except for a few small tweaks, this being one of them. Sigh.
Any help is appreciated!
I'm so frustrated and at a standstill at what I thought would be a simple operation to extract desired data.
I am working on a real estate database and trying to create a query of three tables that I can then use to create a report based on the criteria I provide. Basically, the tables are tblAllProps, tblClientOffers, tblNotes.
The tblNotes is used as a subform in the frmClientOffers and frmClientOffers is inserted into frmAllProps in datasheet view. I did it that way so that the Notes info shows when the subdatasheet is expanded. This is perfect and works exactly how I need it to.
However, now I need to be able to have several reports -- one is a report on all the offers made from one single client, so I put the Client Name in the Client Name field in order to extract only the data from THAT client. That's when I get the data mismatch error.
I have a great suspicion that it has to do with the Client Name field being a lookup field. The Client name is a lookup field from the tblClients that has only two fields -- ClientID an Client Name. I lookup the Client Name from the tblClient in the tblClientOffers and have no problem with that. It does what I need it to do, and this field needs to be a lookup field for the database so that when users are entering data onto the frmAllProps they can use the dropdown to choose the correct client.
tblOfferNotes is tied to tblClient Offers via subdatasheet like I mentioned.
I know no VBA whatsoever. I have tried to find solutions to this problem by searching the net, but every answer I find requires knowledge of VB. That leaves me totally out.
Is there anything I can do from within Access to get the results I need? Do I need to just give up and hire a VB programmer? The database is almost completely finished except for a few small tweaks, this being one of them. Sigh.
Any help is appreciated!
