Search results

If you make your field a date field in the linked table, access 2013 will display a calendar on the form when you hover over the field. Is that what you mean?

Yes you can create an ODBC link that travels with the database. In windows go to : Control Panel - System & Security - Administrative Tools - Data Sources (ODBC) You should see a form with several tabs User DSN (connections made here only work for current user) System DSN (connecons made...

Its like saying "Dont drive that car - you might crash it and cause planes to fall out of the sky!" If you havent caused an infinite loop then you arent trying hard enough. Ctrl - Break keys (the break key might be labelled Pause) works great to interrupt the code. Of the few things...

Short answer is not that Im aware of. If you can always use a form to read/edit the data (either form, continuous form or datasheet will work) then you can add a procedure to run on the Current Record event as shown. Private Sub Form_Current() On Error GoTo ErrorHandler...

Thanks - I do occasionally compact and repair - apparently I need to do it daily! Im curious about the origins of your number 2. Im a big advocate of compact on close - except if its hurting me!

I am regularly getting the error "There is not enough free memory to update your display, close unneeded programs and try again" Access 2013 on a windows 7 machine with 4 processors and 24GB total RAM. Today I have 14 GB free memory (unbelievable! my first laptop had 136 MB total memory!)...

You need a third table with just the ID of the person and the ID of the photo as 2 fields. You could make the 2 fields combo boxes - so for example you display the users name but you save the user ID into the field. Then build a query off this table, add the photo table, join the tables on...

Hi, Im Gerry from Dublin currently living in Portland Oregon. Been using MS Access from version 2. Been lurking here long enough I thought Id contribute!