Search results for query: *

Thanks RoyVidar, Appreciate the suggestion. But, the problem lies in the FindFirst process. FindFirst is finding a record that is wrong based on the criteria. Testing the criteria value in the record after FindFirst 'finds' it shows that the alpha comparison of the two values is correct...

Using FindFirst and FindNext to build a tree from a wirelist. Build array of possible points to search and use pointer to index thru them adding more points to the array end until the tree is complete. The possible wires with beginning and end points are storeed in a table as text fields. The...

Thanks Roy-Vidar Haven't used an alias before, but, it should work. appreciate the suggestion. ccoindre

The error message returned from executing the me.RecordSource = stringSQL is: "The setting for this property is too long". Run time error 2176. I have two subreports that list the differences (added, deleted, and modified records) between two tables that the user selects. I used the "find...

Thanks to CajunCenturion, Tried suggestion got error message stating control not found. I guess it's trying to assign a property to a control and not to the form itself. ... and to kjv611, I couldn't find info on FormDefine or SubFormDefine, but, I only used MS Access Help. I'm going to...

Thenks kjv1611, I've tried this before. Any string that represents the name of the subform used after the dot connect in the Forms format results in a "cannot find form" error message; it thinks the string name is the subform name. I need to use this capability in a loop where the subform...

It is easy to create a string representing a form name and use it to address a Form using the format Forms("formname"), where a string (e.g. strFormname) can be constructed elsewhere and substituted as Forms(strFormname). However, there is no construct to address a subform in the same manner...

You might try adding DISTINCT or DISTINCTROW to the SELECT portion of the SQL view of the query. See VBA help for example.

Thanks for clarifying how the relationships work. The query in question is straightforward with a main table with several indices and a join to another table to get the 'real' data. In a subform, with a child index that restricts the records displayed, I deleted a record, via the query, in the...

After wiping out data in tables through joins in select queries and using Access 2000 help, I figured out it was a cascade delete. The help info said to not check the "Delete cascaded records" checkbox for the relationship, but, opening the join properties in the query design view...

We are databasing the setup for an aircraft simulator. A PC is used with Hyperterminal over a serial interface as a standard VT100 terminal for general interface with the simulator. When the host computer requests the setup, a manual button is pressed in Access which currently creates a file...

I solved the problem using MS knowledgebase article Q194374 that shows how to refresh references. Thanks for the response.

I was using the "format" function (successfully) to create constant length strings to place in forms. Now Access reports that the "format" function is not recognized. The References under Tools in VBA appear to be what they were before. What Library or Reference contains...

mot98 Appreciate the suggestion. Screen stays blank except for a blinking cursor in upper left corner when the splash screen is not displayed. Somehow managed to load a second copy of the video driver and when I deleted the first driver the normal W98 display returned (after 7 auto reboots by...

Normal boot to W98 splash screen. Disk activity light continues to show continuing normal W98 boot progress. Get start up "music" for W98; everything appears normal except splash screen not replaced by W98 normal background. This is a dual boot system w W2000 which works normally...

In a multi-user database, several users (15-20) like to customize the page setup to suit themselves when they send the report to different printers. Like DougAtAvalon, I would like to set the margins at report open to allow everyone to start with a consistent page setup and allow me to use the...

Ma3x323: Tried creating a frame manually and filled it with options. The options were automatically numbered as i put them in. No cigar. All are greyed out. Setting the frame default to any of the option boxes does nothing, all are still greyed out pflangan: The Control Source is blank...

Access 2000. A simple unbound option group with any number of option boxes inside will not let an option other than the first one be selected. The first option box is highlighted. Setting the frame default to any other number does not change the default when the form is opened. The option...