Search results for query: *

Hi, I have an Access 2003 database that has VBA written to to do a select statement. The code has been running for several years, but all the sudden I am getting the "Run-time error '430': Class does not support Automation or does not support expected interface" The code that seems to be...

Hi All, I am using Access 2003 and I have a query that uses the Like operator. The table I am searching is a vendor table. A "master" vendor can have several sub-vendor. If the master ID is 999 it could have a sub 999-a, 999-b and so on. The master vendor ID's are assigned from an external...

I have a table that is populated with a front end form. The DB is on a network. Operators process batch materials and update the tables with data about the batch process. Each plant location has its own table and front end. The tables have been working fine for months, but now random records...

Hi all, I have a query that dose a calculation with data from a function I call in one of the Expression columns. One of the fields that is being used in the calculation in the query is defined as a long datatype. One of the records being processed has a value of 39520. The call to the...

Hi, Is it possible to have a variable in a reference to a form name? I have a sub-form that I want to use in several main fomrs. It calculates plant processing times. Based on a menu selectin, the different forms will be displayed with the common sub-form. The update process for the...

Hi all, I did a search and could not find anything that matched. Does anyone know how to convert a date to return the week number of the year. Example: Input 1/14/08 and get back week 3. Input 2/26/08 and get back week 9.

I have a module that does a select and returns a resultset with 1 to many records. I loop through the records and do some time calculations. I need to update each of the recrods in the resultset with the correct calculated time. I think I need to set the LockType to adLockOptimistic, but when...

I have a main form with 2 sub-forms that have been added to two of the tab controls on the main form. All three have VB added in the OnOpen event. One of the sub-forms, called MiscResource, has a few triggered on-exit events for a few of the fields when data is entered. The problem I have...

I have a continuous form that has a record source of an existing query. Based on a tag setting in the form, the query can return one to many records for the form to display. How can I loop through the records that are displayed in the continuous form? I need to write out the records that get...

I have tired adding code to send a form to a network printer. The problem I have is the code does not work in Access 2000. This is the basic set-up I tried, but the compiler did not like the "As Printer" or the "Application.Printer". Dim prtDefaultPrinter As Printer Const REPORT_PRINTER As...