Search results for query: *

Is there any way to determine the number of rows that are about to be appended to a table using an insert query through DoCmd.RunSQL [query] ? If I don't turn warnings off, Access will visually display how many rows are about to be appended, but is there any way to access this in the code...

I have created a database using Access Security. I would like to know what would be the best way to disable options on the main menu form, ie. the Switchboard, that a user does not have access to as opposed to program using a popup to inform the user that they do not have permission to view a...

I have created a class module that has its own events. If I create another class, I can use WithEvents to hook into those events. If I create an instance of the first class inside of the first class, in this case a kind of pointer to the next instance in the linked list, I am not able to use...

I am writing a class that will be used to emulate an option group, but allowing other controls, such as textboxes, whose events affect the other controls in the group. I have a class called cOptionGroup that contains a collection of instances of class cOption. Each cOption class instance...

Is there a way, when iterating through a forms controls collection, to determine if a control has a "Value" property? I am writing a class module to handle default values for controls. In the form's OnOpen event the class is initialized and gets sent the form object. It uses WithEvents to hook...

Using automation I am able to create a graph object in PowerPoint from Access, either from scratch or based upon a graph template, and to fill its datasheet from code. The problem is that I have to update the datasheet one cell at a time. I have 1700 data points that need to be graphed, which...

I often create powerpoint presentations displaying data that is stored in MS Access tables. The data being displayed is usually very short (a serial number and a value for instance) and I would like to be able to create at least two columns of bulleted text to display more per slide. I can do...

One of the users on my system ran into a problem where she was disconnected from the network while working in the database and yet Access allowed her to continuously enter new information. The system is set up with a back-end on a server with a front-end that is copied to any machine it is used...

I have a form that is used to search for information in a table. The form has a textbox for each field in the table and a checkbox next to each of those textboxes to determine if the user wants that field shown in the result of the search. The form builds a query based upon information in the...

I have a table that is used to store default values. It has two rows, one which has the default values and one which has the generic, original defaults. It is set up like so: tblDefaults ----------- ID field1 field2 ... fieldN The current defaults row has an ID of 1 while the generic defaults...

I have a form that is used for data entry and for editting previous data. The form is unbound and all interaction with the underlying tables is done through a class module which keeps track of one line in a table at a time. The point of this is to allow entries and edits that can be moved across...

I would like to know if there is any way to determine if a range of dates overlaps another range of dates. For instance: Events occur over a matter of days. I would like to be able to search for all events that were occuring within a certain time period. Event 1: 03/38/04 - 03/30/04 Event 2...

I am converting a database from Access 2002 back to Access 97 and much of the code is written in ADO. As opposed to having to convert all of the code to DAO I would prefer to just keep the ADO format. In converting I have noticed that Access 97 does not recognize CurrentProject. I have the...

I have a field to store a date for a document. The document, however, may have a period of dates (ie 3/28/04-4/15/04). I like using the date/time format because it allows for all viewing of dates to be converted to a specific format, no matter what format the user enters. The problem is when a...