Search results

Hi I'm working on an application that will export and translate an Access database into a web-based (PHP/MySQL/Javascript) application. Small tests are going well, but when I try it on the 'production' scale database that is the true source for conversion, I repeatedly get the following error...

I'm getting waaaay to deep into Access' internals, but I have a nagging question - how does Access relate a label to a control? We can delete the label, and then re-'attach' it, but there seems to be no visible property that retains this information - in either the label or the control (only...

I have a need to scan and analyze form properties - including controls - for an arbitrary form in an arbitrary database. Getting to the database is fine, and I then scan MsysObjects, to locate and identify the forms. This is where the trouble begins - if the form were being loaded from within...

Hi I have a form with several objects: Projects -> which have Sources -> which have SourceTypes The underlying DB has tables for Projects, Sources and SourceTypes: Table Projects; Fields: ProjectID : AutoNumber; etc, etc Table: Sources; Fields: ID : Autonumber...

Hi! I have a tab control on a form, and I want to use "Hotkeys' to get from one page to another (or more specifically, to toggle the visibility of the pages). So, I set up the tab control with the pages I want hidden set with visible=No. Then I enable the Form.KeyPreview, so that the form will...

Vacation can get ruined fast when you don't have the right manuals available! I have this project that I'm working on which needs to process a whole load of Outlook message items into an Access database (some metadata - not the actual MailItems themselves). The top level procedure...

I have a form with a tab control and an option group (frame). When I built the layout of the contents of the first tab, the frame responded properly to click events. Now that I have copied them onto the tab control, the events seem to disappear. (When I check the events for the controls, they...

Hi I'm building a lab environment into one of my projects. I'm testing the distribution of values over a largish number of attempts to create a unique value. I have a table called LAB_UniqueIDTest, with two fields: LAB_ID - the string value being tested, and LAB_UsageCount - the number of times...

Hi there I have a need to enumerate all the Tables/Forms/Modules/Classes etc in an Access Database. At present I'm scanning MSysObjects, but I was wondering if there were an easier way. Using Tables as an example the (pseudo-)code looks like this: Get all MSysObjects where Type = <Tabletype>...

I have a need to 'prevent' an event from completing under certain circumstances, and it is not clear how I can accomplish this. I have an app that is browsing a survey. When the survey is in simple 'browse' mode, I want to be able to emulate the effect of a SkipResponse. (A SkipResponse is when...

I have a situation where the processing for a particular object class is dependent on: i) Does the class have instance level security, or only class level security and ii) The name of the field where the class keeps its instance level security. Let's explain a little further Imagine two...

I'm not certain quite how to express this, but let's take a stab. All forms and controls are unbound. (See below) I have a situation with two object classes (let's call them Studies and Surveys). Each class has an independent existence, but surveys 'belong' to a study. I need to be able to...

I'm learning by example (and by failure - who ever learned anything from success?) about an Access 2010 combobox. This is an unbound control on an unbound form. and I'm using it to display an increasingly refined set of entries from a table. Just like the thing that Google does when you're...

Hi there I'm building a lab db to brush up my SQL. One of the exercises I'm setting myself is to create a SELECT clause that will find all the elements in a table that match a pattern. Here's the SQL command towards which I'm aiming: SELECT ID, LastName, FirstName FROM SampleData WHERE...

Say it isn't so! I'm trying to select an option for naming a file (Excel spreadsheet) that will contain data exported from my Access database. I'm using Microsoft Office 14.0 Object Library references, but when I try to create a FileDialog, it tells me that: (Actually this showed up when I...

I have a database where I have a need to extract data into an Excel spreadsheet. I am building the spreadsheet but need to construct some range values, using a numeric variable. For example: const IndexCol="A" dim IndexRow as long dim RangeAddress as string for IndexRow =3 to 8...

I have a most curious situation. My application is using a Navigation Form (Top buttons = Major Area, Left Hand buttons = minor area), and all of a sudden it has stopped working! All of the forms used as sub-forms in the Navigation Form are also 'available' as independent forms, and they are...

I'm trying to create a navigation control on the fly. When a user logs in to my application they have the possibility of accessing several parts of the application at several levels. Specifically there are seven main areas each of which has up to 10 sub-areas. Depending on the capabilities of...

I have a code snippet that I am expecting to return a valid recordcount from an ADODB.Recordset: Private Sub cmdGoToPrevious_Click() Dim FindCriteria As String Dim SQLCommand As String Dim SegmentedBrowse As Boolean #If TraceLevel > 1 Then Debug.Print Time(), "STUDYDESIGN", "GoToPrev"...

I'm learning to use the new Navigation Form control in Access 2010. I think I like it. I have, however, run into a small problem. I'm using the options/sub-options capabilities, with major options lined up across the top, and sub-options down the left-hand side. At one point I need to be able...