Search results

I am creating an Excel file from a query built within the module and need to update a field ("MFR") after the file is created so it changes the manufacturers name to the matching code within our sales system it is being import into. I have a table that I store all my manufacturers in and it...

Unfortunately then with my limited knowledge I don't know how to help. I have never personally seen this particular problem before but I do know if push comes to shove, the people over at the Power BI Reddit page are typically pretty helpful as knowledge on PBI here isn't in as much abundance as...

Sorry to pester, but did you try using the Access specific connector to see if it can see the query rather than OLE DB and the ODBC? I personally have only ever had problems trying any other method to connect to Access from PBI.

Interesting, I have never run into that error before. One more question for you, are the Access files on the same network as the machine you are working in BI from?

I manage several Power BI reports that are connected to both SQL Server and Access but in my case the Access files are accdb not mdb so I am not sure if that would cause the difference. When you select the tables are you doing them one at a time or multiple? And is it Power Query telling you...

I had honestly thought that was what I did, hence me completely forgetting that temp table existed. I have already gone back and begun revising it to remove it as I am in the file doing formatting already, so might as well write the data to the db while I am there.

Yeah, this is the 3rd time in a row the answer to the problem was staring me in the face:confused:

The problem was I had forgotten that the data lands in a temp table prior to being cleaned up and appended to the final table and that tables field was set to Long which is why the numbers were being rounded.

I have an interesting issue that I can figure out why it is happening. In my table tblFixture I have the field UnitCost which is set to the data type Currency, yet when I import data in, this is rounded to the nearest whole number and I thought this datatype would only round to the nearest...

No problem. [OverrideType] is a Short Text field in tblFixture, which is the control source for combo box OverrideCmb with a row source set to value list and "Hide", "Override" as the values.

Thankfully this is still very much in active development, so what data is in it is extremely small (only like 3 full sets of records). I already deleted it all out and did a compact and repair.

OverrideType is the name of the field but the field is populated by a value list combo with only those two options. If OverrideType = Override, I want to "mask" the value with Approved. Also, while mucking around with another expression, I managed to crash Access and when it came back up the...

It is not. It is Short Text and is filled via a combo on a form with a value list of set values (Override, Hide)

In a query for my report, I am testing if a field contains a certain string, then if so, override the value to "Approved". I have tried several different variations, but it never seems to flag true. Mfr: IIf(InStr(1,[OverrideType],"Over",1)>0,"Approved",[Manufacturer]) I have also tried: Mfr...

I am hoping someone with a keener eye can tell me where I need to put the IIF(ISERROR()) in these two expressions to suppress the errors from appearing on the form. The form in question is a continuous form and the last row displays these errors (no record). Does it effect anything? No. Is it...

I don't believe I am. This was just for display on a control on one of my forms to calculate the totals and such, none of which I am storing but just displaying.

I am not. Everything is within Access and the file is not yet split.

After messing around with it and reading up on what makes a query no longer able to be updated (which was a surprisingly long list), I determined it was best to not use a totals query and just use DSum in the control on the form. It is a little slower but I don't know if any other way to handle...

SELECT tblFixture.Type, tblFixture.Qty, tblFixture.Manufacturer, tblFixture.CatalogNo, tblFixture.Note, tblFixture.LampType, tblFixture.Sort, tblFixture.[Select], tblFixture.OverrideType, tblFixture.UnitCost, tblFixture.ID_Job, tblFixture.FixtureID, QryAdderTotals.TotalAdder FROM tblFixture LEFT...

I did try making the total query as a left join on the dataset and unfortunately it was not updateable. I thought about DSum but have had issues with slowness as you describe when doing many of them on a form.