Search results

Thanks a lot both!

Just one more question. Yes Sub-Specialities can only belong to one Speciality. How is it going to get registered the specialities and Sub-Specialities under each Provider when we don't know beforehand how many are there going to be? Same thing with languages. I will have a table with a list...

This was useful. Thanks a lot!

I am building a table with medical providers. Every provider will have one or many specialities and zero or many sub-specialities. Should I build the Provider Table with a column for every single possible speciality and sub-speciality with a checkbox? It is possible that we will have to add...

Thanks! It's crazy but it isn't working and I can't find the problem. I have the same situation with another combo in the form that I have to select manually the result. This one, when the box TotalAmountToPay is updated or changed, it should trigger the query and put it in...

Thanks! I mean b).. Would you please be able to elaborate a bit more on how to save the result as a variable and set the combobox value to that one? Do you mean the "default value"? I tried to set it to the query itself (it produces just one result per form) but nothing shows up if I don't click...

I'm sorry for the newbie question here. I know this is access 1.1 but I can't figure it out. I have a form with a combo box which its row source is a query. I would like the result to show automatically instead of having to click on the combo and select it manually. Is it possible?

That was easy. Thank you!

I have a spreadsheet in excel that I am struggling to translate into access. In the excel I have: P2: Currency (f.ex EUR) R2: Amount to Pay (amount in P2 currency) S2: Amount in GBP I have Sheet 1 with the name of the Currencies in Column L and the conversion of 1 unit to GBP in column M...

Yes, the excel connects to the CRM. I've check that connecting the Access directly with the CRM, it's possible but I would have to involve our IT department and let's say that that's always a bit complicated. I would prefer to get this linked excel to work if possible.

Done and it's the same. If the data is static it works perfectly. I've never made it to work linking dynamic tables :banghead:

Hi all, I have an dynamic excel that I exported from Microsoft CRM. The excel works perfectly, it gets updated and I managed to remove the warning message about the external connections. When I link this table to access, there's no records there... I can see that all the lines are there, but...

Before throwing myself into Ridder's solution, I tried to do a work around with my linked dynamic spreadsheet. One problem that I had with Microsoft CRM was that I was only allowed to export 10.000 records at a time. What I had to do was to export from the selected date 6 months at a time and...

I would actually be more than grateful if you could explain me how to do this. There is no PKs in the dynamic spreadsheet, since this is only used as a lookup to bring a "Case Number" field on a form and auto populate some other fields in the form. Thanks so much!

Yes, that's why linking the dynamic excel sheet sounded like the right thing to do here. I can imagine that setting up a process to append new records to an access table from a spreadsheet that it's continuously updating can be a nightmare.

Thanks a lot for your answer. Could you please point me out to an information source to set this up? This would be great!

I've looked at the TransferSpreadsheet method and I'm willing to try that. The thing is that this big table with >32K rows is now a linked table and the weird thing is that when I open the excel itself, all the records are there, but when I open the linked table from access, there are a bunch...

Thanks a lot for this

Sorry about that. * My main table has 2 country fields related to tblCountries * The ProviderDatabase tbl has 1. If I run the query without the tblCountries I get the PKs in the results. I am having issues when more than 1 field is related to the same table like in this case and I would...

Hi all, How can I make the attached query to work? As you can see I have 3 country fields related to the country table. How can I get the country name for every field on the results?