Search results

How do you feel about databases being broken down into separate frontend files for different real world department's? Also being able to load them from within the database? Obviously access to these separate frontends would be controlled by login privileges.

That is the question that perplexes us. Well, maybe not us, but certainly me. I have two separate main forms with the identical subform. One of them is updateable the other is not. all the setting on both are the same. Any ideas? Thank All

Here is a question I asked the Chat GPT. It did not have a solution, just a few possible causes. User Why does this hyperlink not work with this type of address? It works great with most hyperlinks but not this one. Non functional hyperlink, but works when pasted into browser. Call...

I've never been able to get D Lookups, or D Counts, or pretty much any of those D Words. I never had the patience, so i just use queries. This DCount works in a click action in a button not as a control source in a textbox. Sorry for such a basic question. How do I make this work as the...

This is the error message. If you have a link to a place where i can relearn all of the outlook automation, including selecting which calendar to update and pretty much all of it. I will be thanking you all very much.

What is the best way to do something like this?

I've had a few conversations with Chat GPT where I was talking it through writing a function or part of a query. Is anyone interested in sharing some of those conversations?

I thought I would start a thread on art and ergonomics. I imagine a thread of this nature could generate broad discussions, I'm going to start it with one topic, Form Density. Do we start with a question, or a statement? How about a question. How do you determine the balance between too much...

I had this problem years ago, all of a sudden it's back. Is it because have too many subforms?

Large Language Models and The End of Programming - CS50 Tech Talk with Dr. Matt Welsh

This is super basic, but worth asking. I've slowed down on development in the last years and rust has taken over the development portion of my brain. The following is a query that needs to return all of the Contact Records when the getContactTypeSearch() Function is set to "*". The problem is...

Years ago, a friend of mine was building a SQL database in a time before most people had even heard of SQL. Early to mid 80s or so. He maintained that a list of companies (table) should include all companies you do business with and should include all organizations that are stake holders. This...

I'm hoping to start the 12 millionth conversation on SQL, the Web, and of course, MS Access. Here are the conditions, we have an Access Database that runs on SQL. We use if to management construction projects, it's pretty fully developed with a couple of hundred tables several thousand queries...

Is anyone interested in having a planning session on how to set up a scalable project management system on the internet? I did something like this years ago on a design for movie making camera controls. We had a lot of fun and we all learned something. So, without any further ado. I have an...

Is there some undocumented way to control the Phone Link in Win 11 from Ms Access? Or to create live SQL or even Excel data from the phone?

How do yo make a mouseover highlight a specific record in a Subform? Thanks

The GPT gave me this code to get a criteria from a Multi-Select List box. Me: "Write the code for a multiselect list box in Access VBA that will be the criteria for a query" GPT: "Here's an example code for creating a multiselect list box in Access VBA that will be used as a criteria for a...

Did Microsoft make that possible? This could be a source for controlling vital business information.

I've been using Popup Dialog Boxes or unbound controls in the Form, with some insert code, for years to display Combo boxes filtered by other Combo Boxes. If you have better ways, how would that work?

Does anyone use Split Forms, and if so, what is the, how, when ,what, or why?