Search results

the table that this Update Query is supposed to modify ("Automobile_Info") contains the three fields "Suite", "FirstName_1", and "LastName" (among others). there is a linked table ("tblautoinfo") which the Update Query is getting it's modifying data from, which also contains those fields. i...

so, i was just reviewing some of the most recent changes i've made to my DB here at work, and when i reached this piece of code, i started wondering if there's an easier, more compact way to do this. don't get me wrong, the code definitely works, and works well enough, i'm just curious for...

i've entered some code in the 'On Load' portion of my main form, designed to pop up a confirmation dialog asking the user if they want to run a macro to update the DB's tables with current data from some linked tables. when loading the form, however, i get this message: in addition, the "Show...

the database i'm working on at work involves a "switchboard" form that i've put together. i'm quite proud of the work i've done so far, so i've decided to add a small 'watermark' if you will in the bottom right corner of the switchboard form, and for kicks i want to insert a message box or...

DateSerial Function - Avoid #Error? in one of the databases i'm rebuilding, i'm also creating (from scratch) some queries and reports that need to exist, but never did in the old version of the database. one of these is a query that calculates a resident's next birthday date based on their...

hey everybody, i'm eric. i'm the I.T. Admin / "General Tech Guy" at a retirement community in Massachusetts, USA. i do a LOT of different things here, and the projects i enjoy the most involve working on our databases. they are atrocious, so i've taken it upon myself to rebuild them and clean...