Search results for query: *

Imagine a remote system where there are a large number of MS Access database apps (a lot created by 'laymen'), many poorly defined / designed / produced. (You may find this easy to do). Some are having problems with exceeding the 2gb max database size, which in turn creates issues of locked...

OK, getting desperate enough to drop this one in (then continue to try to resolve it, until some wit highlights my schoolboy mistake). I have been a member for 17 years though! I have a function that basically returns a list of files found in any directory (folder). It worked fine whilst using...

This is definitely not the absolutely 'correct' forum, however - general knowledge picked-up, whilst using MS Access may well be contained here. I work on a site where 'MOD level' security must be applied. Subsequently, deploying full-featured MS Access applications is a nightmare. Ensuring...

Windows 7 MS Visual Studio Community 2015 MS SQL Server 2014 50 year old bloke - stuck in my old ways. I have lot's of experience with MS Access VBA etc, but have a requirement to learn Visual Studio VB (or C#) connecting to 'local' (SQL Server) .mdf (file based tables). It seems that 'local'...

Hi, After realizing that we can't always imagine all eventualities (and certainly cannot predict management direction) I've produced an application that enables you to: Maintain a list of all applications that you wish to be searched for 'key' VBA words / terms. Search for a key word / term...

Hi, I'm producing an app that searches MS Access code modules (forms, reports, modules) and opens a specific module where the search term / word resides. It works fine if applied to the current database app. I'm trying to make it more generic so that it can also check a list of other...

MS Access 2003 Oracle 10g Windows 7 I am basically running data updates every night into local MS Access tables from source data tables in Oracle. This worked fine, until some change on the network which produced a timeout error for all append queries that used pass-through queries. In order...

Hi, I have a centralised MDE (Access 2003) sat on a virtual server. Most users have MS Access Runtime. Is there any way that I can 'package' the MDE (on that server) so that it includes some specific ActiveX controls (e.g. TreeView) so that these Runtime versions can use it from their client...

MS Project noob here, so please be patient over the next couple of weeks! MS Project 2003. 2 x team members that I want to initially assign to 'general' duties for a full 12 month period, 5 days per week, 48 weeks per year. So; first pass - they both have 1 task apiece for 12 months. This...

Hi, I have a few 'stand-alone' reports, which contain a chart that, use a query that get's it's keys from an associated form (e.g. the queries refer to a key currently displayed on a form). I want to display these reports in one single report so that the user can print one report off - not 10...

This is regarding the return of order line issues per user in a query. tblUser owns many tblLines, some of these order lines will have issues which are stored in tblLine_Issue (via tblLine & tblIssue_Type keys). Line issue types are stored in tblIssue_Type (14 possibilities). So, a user may...

Hi all, I need to refer to form controls (list boxes) dependent upon selection from a combo. E.g. if a particular option (data criteria for a form) is selected from a combo - it makes the selected control (list box) visible, ready for the user to select items (criteria options) from that...

Hi all, I am researching this topic as best I can via Google etc. Microsoft of course doesn't give information away cheaply (10 pages per useful nugget of info.). I'm wondering if anyone here has experience of ADP and SQL Server Express in order that I can decide on whether or not I invest...

Hi, I cannot imagine how Broadbent's FAQ has not attracted a lot more attention. Surely many people have visited or ended-up at this FAQ! He / she has solved masses of my problems on numerous applications. Date/time arithmetic goes 'over my head', and this FAQ really helped me out. Can I...

Hi, I have suggested that a new forum be created here for APEX - maybe it's not too popular just yet. However, I believe that my question is fundamentally 'ORACLE' orientated, that's why I've placed it in this forum. Please feel free to report it - if I'm in the wrong forum. At my...

Hi all, I've no idea how to have a new forum created, but would an Oracle APEX forum not attract a lot of attention? My interest: it's currently being rolled-out at my employer's (a v. large, multinational company). ATB Darrylles Never argue with an idiot, he'll bring you down to his level...

Hi, I'm basically looking for an angle to attack this from - not an immediate solution. This is a greatly simplified example of my problem, but believe that a solution to this will give me a solution to the complicated version. Table: table1 date_field status_field The status_field can be...

Hi, I need to format an MS Access / MS Graph 11 chart correctly - without much success... I have a query that generates total counts of order status' for every month of the 12 months preceding the month entered by the user. Order status' = Early, OnTime, Late and Outstanding. Sometimes...

Hi all, I'm trying to implement a system whereby I can close down an MS Access application across all users via the use of a hidden form with a timer and a table with a 'flag' value. I've got the code working correctly so that it closes the application dependent on the value in the 'flag'...

Hi, I think that the title says it all, and I have searched Google and Tek-Tips (believe me). It seems that developers don't much use menus to control their apps. (I haven't up to now - due to the apparent complexity). In my run-time app, I want to discard all MS Access toolbars and add my...