Search results

The "A" stands for application and that is what defines the object model. All versions of VBA have a different object model and different ways of accessing those objects. So, VBA code to access Word objects has to be translated when the code is used in Access. You cannot use the reference...

That is the part of the transexual "movement" that I find most disturbing. The men dress up like clowns rather than actual women. Is that really how they see women? How insulting. It's one thing to go to a show to watch drag performers imitate female stars. That is entertainment and...

I also am not interested in paying for top of the line vehicles but even still, my new cars are now costing more than my first house and come with many features I could do without.

No matter what the polls say, there should be enough Jewish voters in NYC to elect someone else, assuming the Jews voted as a block and picked the same one. My preference of course is Curtis Silwa but Adams would be acceptable if they can't bring themselves to vote for a Republican. The point...

@isladogs Do you have a copy of the table I'm talking about that is not an image and can you post it? I was going to make a query that brings in the definition of the codes in the Queries table but I couldn't scrape the web page. All I could get was an image.

Says who? Trump will solve that problem if he has time but it is not a priority. Muslims also practice polygamy and "temporary marriage (AKA prostitution)" and child marriage and no one seems to care about that one either. Mohamad had at least one wife who was only 9 years old and Muslims...

If you want to detect the disconnect when it happens, you need to add a timer event to each form that might be left open. The timer event then checks the connection and displays a popup message that warns the user that restarting might take more than a minute. Timer events are fraught with...

@KitaYama Some crimes are defined in the Federal code. Anything that crosses state lines in particular as well as capital crimes such as murder and attempted murder. Other crimes are prosecuted in state courts. State judges are much more inclined to be lenient. If both codes apply, I think...

The Connect property is used for RDBMS links. The Database property is used for others.

I think I counted 4 or 5 people telling you to add the three "popup" forms as subforms on the unbound form. They will stay where you positioned them and not move around. Popups are the wrong solution, in case that wasn't clear.

Not really. Criteria in the query is what one would expect to control what the query shows. If I want to see billing hours by person/task for each month and I want to see all people as columns, I might not see Suzie in August if she has been on vacation. In order for a column to show for...

Source control is only part of the problem. I don't know how this tool works, it's been years since I last tried a source control addin. At that time, the process was abysmally slow but more important was that you had to remember to "check out" BEFORE you started modifying an object...

The dependency checker is very useful for immediate use if you want to check on a specific object because you want to change that object and assess the impact before you start. I haven't used Colins tool so don't take that as meaning I don't like it. However, I have used the FMS tool and found...

That's pretty obscure. When there is one unusual exception (all column headings are known ahead of time), I would simply just define the parameters for all Crosstabs and leave it at that. PS, Just a reminder, if you specify column headings, then the crosstab will IGNORE any row that doesn't...

Also, don't forget that if you are having to create controls on the fly, there is something very wrong with your design.

Maybe they are both transexuals. Barbie's the boy and Ken is the girl.

I did mention that earlier.

The problem is more that Access is just too good at what it does. It is too easy for non-programmers to "discover" forms and build tables. They generally do a very poor job because they have no concept of good design or database normalization but, they frequently manage to get something just...

They'd think I didn't have much of a life. Bridge and Access and Access and Bridge. But both are actually very engaging so I don't have much time for other stuff.

Shocking doesn't even begin to cover it. I'd met Jack as an MVP and we collaborated on a small project. Very sad.