Search results

#42: Jackie Robinson

you could use Ctrl-F4

Have you considered using the Pop Up or Modal settings, might that work?

Local temp tables starting with # are dropped when the proc ends, but global temp tables starting with ## persist afterwards.

that made me think of the Kip Addotta song "Wet Dream" "They said I'd blown a seal ~ I said, "Fix the damn thing ~ And leave my private life out of it ~ Okay, pal?" song: Wet Dream

Yeah, they're saying that they can't ship the product after March 28. I had started shopping online bc my local store kept running out of my coils, then when the pandemic hit I simply continued online. But now I've moved to a different state, so I need to find a local merchant.

I've been vaping for 6 years, after previously smoking for 50 years (really). In the states, possibly elsewhere, the postal service / UPS / FedEx will no longer ship vaping products due to a rule buried in the covid bill from December. Bummer.

Please take a look at this change-tracking code, taken from a production system: Change Tracking in Access there are a few differences that should be incorporated.

Have you considered using Remote Desktop Services? You could host the app on an office PC and then your remote users would log in and make their entries & updates in real time. They could even use wifi because the actual program is running on the host.

Office programs can be sensitive to the installed fonts on the printer - any changes in the default printer setting?

Just like to add a few comments... both versions of this should test for a current record e.g. in the first version, after the FindFirst we should use something like If Not rst.NoMatch Then ... End If and in the second version, after opening the recordset we should use something like If Not...

A query goes into a bar, walks up to two tables and says "may I join you?"

Hey Doc, my very first "database" was a Lotus 1-2-3 worksheet (remember those?) but then I discovered dBASE and worked with that for many years. My first impression of Access was that it was "a toy" compared to dBASE but the more I worked with it, the better it looked. Especially since Borland...

You could run the built-in Access documenter, turn on every possible option, and then search the output.

Days until the election 42

Look at the replies from me and arnelgp - the sql statement needs to provide the value, not the name of the column. this is incorrect: "exec Update_UserPermissions Username, Department" this is correct: "exec Update_UserPermissions 'SomeUserName', 'SomeDepartmentName' " Also, what was the...

You could create a new Access pass-thru query "qryUpdate_UserPermissions" with the following sql: EXEC Update_UserPermissions '', '' and then when you click the button, you run this VBA code to set up your parameters: CurrentDb.QueryDefs("qryUpdate_UserPermissions").SQL = "EXEC...

Yes that's me

In my experience there is no real performance difference. I had a setup where each user had their own copy of the FE, so we just used the default Shared mode; however this was running on a terminal server - a few users would minimize to their own desktop, forgot they had the app open, and then...