Search results

Greetings, My issue is simple. I am making a query interface for my database - so end users can easily extract what they want. I have several controls that may or may not be null when I run the query. I am using the following as my Criteria (which may be flawed)...

I am automating a task from an Access database. I am automating excel and word using vba. I am experiencing "unqualified method calls" - where I'm making a hidden reference to the old instance of the application. http://support.microsoft.com/kb/319832 Microsoft says to make all unqualified...

Here is a quick general question. I may be creating a new database that will be used on Macintosh computers with the MAC OS - is there anything I should be concerned about only having experience in windows? I have heard rumors of VBA being disabled on MAC OS? Is this true? Am I crazy to...

Greetings, I need to create a report that displays a few pages worth of scatterplots (4 pages with 2 plots per page). I'll be honest, the pivotchart view really gets on my nerves (same with the "insert chart"). I'm hoping it is do to my own incompetence. All I want to do is display x,y...

Need help with proper event trigger, and potentially proper refresh. Data entry form with subform in datasheet view. The lab results are entered on the subform in the field "result". The result field is text, in order to accommodate characters like "<0.002". I want to guard against entries...

Is it possible to disable the user from hiding columns in datasheet view of a subform? More specifically, what I am referring to is when the user right clicks the header bar at the top of the datasheet and can access the hide columns option. Thanks in advance, I have had nothing but very...

I have read posts about similar issues and am still unsure what to do about my situation. I'm using Access 2007 with 2007 file format. I was working on this database last night, everything seemed normal. The first time I opened it this morning - a message appeared "Cannot load...

Scenario: Need a dynamic data entry form. The user generates this form by specifying which parameters (field names) will be on it. In one case it may be only 1 field, in another case it could be 25 fields. The parent form is static, these fields are only found on the subforms. I have been...

Greetings, Well this sure is a simple question and I'm embarrassed I haven't gotten it right yet, but a few minutes of your time will certainly solve my issue. All i need is the following pseudo code translated into actual working VBA code. For each value in a public array(1), I am attempting...

Greetings, I need to know how to add an event procedure to a form programmatically. I have a routine where a user generates a custom form & subforms for data input. I need to add event procedures to some of the subforms on the form that have been created with the code. This all must be done...

This form is a utility to help the user import time series data to the database. The only thing I'm stuck on is how to make a nice graphic for the user that will help them quickly know if they have time series overlaps. Table1 Preexisting time series data from several different sites. Already...

I wish to use a date time stamp as the join between 2 tables in order to perform various queries. My issue is this: Table1 - this is a time series table, has date time stamps that may be in any interval (every 15 minutes, every 30 minutes, or no consistent interval at all). This table has...