Search results

Hi, we are running a pretty extensive DB, evolved out of 10 years of incremental development, today consisting of accdb frontend with MySQL backend (linked tables). I am increasingly facing corruption while editing forms / reports, and am trying to find out why corruption occurs at all. I...

UNION ALL query works fine - but "too complex" for a report's record source? Hi there, have been using the following SQL as record source for a report while still in Access 2003. Since moving to Access 2010 the report won't accept the SQL as a record source anymore - even though the SQL works...

Hi there I am using the following function to check if the ODBC-connection is available each time the user runs the application. A few weeks it started to give wrong results: when i run the function right after starting the application it sometimes (not always) faces an odbc-connection error...

Hi there, I would like to include a file search engine in my Access front end, allowing for an indexed search of all relevant files (doc, pdf, xls, txt) in our network, particularly our server. I have come across dtsearch (http://www.dtsearch.com/PLF_engine_2.html). What they offer is a fully...

I am flipping column headings (editable text boxes) vertical to save width. While this works fine on most PCs in our network, some PCs refuse to display any vertical fields on a form or report. Any idea, hint? Thanks a lot in advance! Btw: all are using Access 2003, FE is Access 2000. qqq

Hi there, (Am using Access frontend with MySQL backend via MySQL Connector 3.5.1) When I press the delete key on a number of records on a subform, the usual prompt appears: "Your are about to delete 2 record(s)". Now, if I click the NO button, the records are deleted nonetheless! Anyone a...

hello there, i'm looking for an easy way to copy any file from one location to an other one, thereby renaming it: when clicking an "import" button on a form i would like a file dialog to open, the file i select should be then be copied, appending the current date to the file name; the...