Search results

Impressive. I set a breakpoint in NW2-Dev.modInventory.ProductAvailable and then added a product to an order. The call stack showed: and your code showed: (testDumpStack is my code that calls your code). There was no crash. A365-32 MEC. I will leave it to others to comment on the legalities...

Never mind, I figured it out: the Field object is a reference to a field in the form's RecordsetClone. Filtering the form changes the RecordsetClone and thus the field is no longer valid. I changed the code to use the field name (as a string) instead, and that works.

Access splitforms have their issues, so I wanted to write my own lookalike. Open mySplitForm, and observe you can navigate using the mainform, or the unbound listbox. To make this a generic module I am using form subclassing. So far so good. Now filter the mainform. You will get an error because...

Rich Text is fine for Comment-like fields where people can type away and use some formatting tools. It is NOT fine for creating a textbox where additional text must be inserted at the caret. In my case it was a physician's patient narrative, with ability to insert standard phrases. RTF is NOT...

Interesting how several developers are working on this same issue at the same time. https://www.experts-exchange.com/articles/40696/Custom-toggle-button-for-Microsoft-Access.html

If your current interface has no sprocs or views, and SQL Server is only used to store the tables, and everything else is in Access with linked tables, then yes, this is not a successful configuration with the BE on Azure. Access is very chatty, and pulling all that data back and forth is...

One thing that hasn't been mentioned yet in this thread is that there are two Properties windows: the one in Access when designing an object, but also the one in VBA. The latter has several new-ish properties such as the Theme-related ones that are not in the former.

Thanks for these answers. We know that this line: strWhere = "[ProjectID] = """ & Me.[ProjectID] & """" is currently not being used, but if you were using it in the future: the Autonumber value should not be wrapped in double-quotes. How you have formatted the field is of no concern: that is...

@ Second: via the CreateProperty mechanism.

> strWhere = "[ProjectID] = """ & Me.[ProjectID] & """" > strWhere = "[DwgNo] = """ & Me.[DwgNo] & """" I'm curious: 1: Is ProjectID indeed alphanumeric? 2: Is DwgNo indeed alphanumeric? 3: Did you not want to filter by ProjectID, but only by DwgNo?

Pretty easy to find information online about this error. It has nothing to do with Access, the topic of this forum.

> error invalid signature Is that the EXACT error message? Please quote any error messages VERBATIM. Do I understand correctly that the error occurs while copying the FE file (presumably using Windows Explorer)? If so, this is not an Access issue but a Windows issue. This error?

As a test I added a few lines just to show that the level of sameness of the two objects is not a factor: Dim dict As Scripting.Dictionary Set dict = StringToDictionary("a=1") Debug.Print GetTableDefProperty(dict, "Name") '<==Why does this compile?

> Of course it would be simpler to access the properties directly. Yes, in this example. The actual code is more complicated, but nevertheless, a querydef object is not a tabledef object. Does not even come close in having the same public interface. At runtime we get the correct Type Mismatch...

I expected this to fail compilation on the indicated line. Decompile did not make a difference. This is A365-32 MEC. I was using a test module in Northwind 2 Dev Edition. Sub test1() Dim db As DAO.Database Dim td As DAO.TableDef Dim qd As DAO.QueryDef Set db = CurrentDb...

> I would only save the first and last name in this table if you have a regulatory reason to. Mark has a good point. I wrote from a technical database design point of view, but you are the SME = Subject Matter Expert so you need to make sure that important business rules are documented and make...

> I genuinely just want to improve this existing database or maybe even create a new one to replace it We are here to help you with that. In your case I would create a new database with correct database design. Correct db design is super important for the longevity of the app. What if you...

You can count records in a report without DLookup if you're counting in its RecordSource. It seems that in your case the main report shows drawings (which you can count using Count), not their revisions, so you cannot count revisions with this recordsource. DCount or DLookup works, as does...

Before we get to your question, we need to understand your database design. Can you please post a screenshot of the Relationships diagram, with the tables laid out neatly for our review and feedback? BTW, the expression to pick up LN and FN in the *subform* needs to refer to the parent form...

Hi Colin, That may work, especially if I can trap that error and tell user to move the BE to a TL. I will try it tomorrow (your Today :-) ).