Search results

> 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 :-) ).

I thought you were my friend 😞

No dice. The user of the app can select which BE to connect to and scan (for purposes of Anonymizing the data), and I'm allowing them to select either Access or SQL Server BEs.

If SQL Server is the back-end (BE), we can link to tables and views. Views are like queries. However, if Access is the BE, we can only link to tables, not queries. My form is listing BE objects and I have a "View Data" button. When clicked, I link to that table, and use DoCmd.OpenTable to view...

I'm expecting DRM: the video is protected and cannot be shown worldwide.

Re Active Directory: here is my blog post. The code includes a test to see if you are using AD or not.

Great to see you here Sean, and best of luck with your project.

One other suggestion: if you had an add-in such as this one you can do a deep "Find" operation for the word "BusinessAddress", and it would list all occurrences, including the query discussed above.

I asked Chatty "where can I download ingredient cost information for bakery goods?" and got a few promising leads.

I think the answers are No, No. Have you tried reviewing the execution plan? And maybe also the Database Engine Tuning Advisor?

> Decimal() Don't use Reserved Words for function names.

I disagree, Colin. While it is true you can write a MsgBox replacement, that is a far cry from having ALL messages having consistent features. Like @DaveMD I have been annoyed that for example ODBC error dialogs do not allow you to copy the text using Ctrl+C, while other messages (including...