Search results

I have an excel linked to my database to auto-populate several fields. This excel is dynamic and gets auto-updated from our navision system. This excel has around 31.500 rows and we have experienced that the visibility for ALL records is intermittent; I could see some records that my...

I got it now. Apologies. I can see noe that I wasn't linking to the SubType PK. My bad. Thank you so much!

Thanks anyways. If I change the datatype in tblService and tblServiceSubtype to Number, the fields get deleted and I can't retype them since it only allows numbers. If I change the datatype in the main table to "short text" all the existing records fields get deleted and I believe that the...

Thanks. Yes, it does. How are the data types for the 3 tables?

How should it be? In the main table ClaimDataSheet, both ServiceType and ServiceSubtype should be as Number data type since it's their PK's being saved, is that correct? Should I change the field datetype in the actual tables Service and ServiceSubType to "number" or is it the fields in the CDS...

access 2016

Dear all, I have striped down the DB as much as possible. I hope that it still make sense. I have a problem getting results for this query. As far as I've read, it might be a problem with the relationships. I would like to know why I can't enforce data integrity on the "Service Subtype"...

Thanks! I finally got it working with the last option of the link. :)

Thanks both I am trying with: Kill "G:\Audit 2017\TEMP\*.*" But I get the error "File not found".. the subfolder and PDF are there though..

Hi All, I have a button to email a PDF report. As you can see the VBA saves the PDF on a TEMP folder, in order to attach it on an email afterwards. I thought that the last line of the code "Kill FilePath" would delete the folder inside the TEMP folder, but it only deletes the PDF file. This...

Hi all, I'm not sure that this is the right sub-forum but the thing is that I need to export a report to a very specific excel template. Is it possible to determine the cell position in excel for each field on the report? Thanks in advance

It works now. Thank you very much to both of you!

Thanks for this, actually the 4 "Currency" tables are the same one and same for "tblOut3rdPartyServices". The thing is that I need returned in the query the values for 1#, 2# and 3# invoice currency and 3rdPartyServicesID1, 2 and 3. But I need the values and not the Keys Can I still get that in...

This is it. Thanks for looking into it. The problem is when any of the tblOut3rdPartyServices or the currencies are empty

Dear all, I have a query in which based on the CaseID on the active form, it should return several values from that form. One of the values is ServiceType but when there's no data (it can be), the query is returned empty for all values. There is a relationship on the query so it should...

I found it and removing the "0" made it work. Thank you so much, sir!

Thanks for your answer. Pardon my ignorance but how do I do this? I coudn't find any option in the table properties. Thanks but this didn't work in my case.

Dear all, I have seen this question posted in several forums but I can't simply understand the answers and I'm sure that it's very simple. I have a form filling the table "cases" where a combo box in a form picks the options from a table called "services". There is a relationship enforcing...

*slow clap* Thank you so much, Sir.

Thanks a lot for your help, but I still must have something wrong. Still Error 58. I deleted the PDF file, but not the folder and I still get the same error, so I believe that it is the already created folder that's not bypassed. The debug marked the line in red..