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...

Thanks traingamer. I don't know why I did not think of changing the like to include the "-". It works fine now. I guess I was thinking of a way to just drop the record rather than filter it out with the criteria. Thanks again...

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...

Yes it is. The back end is access, and only holds the tables. The front end has links to the BE tables. I did a test where I opened a record on a FE on my PC. I had another person open a different FE on their PC and delete the record I had opened. On my pc I saw all the fields go to...

Hi PHV, Yes. If the FE is adding a new record and the primary key (BatchNumber) is not filled in, it triggers the message that it is a required field. If the user attempts to enter a duplicate record, the primary key error is triggered and a message is sent back telling them a duplicate...

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 Golom, Thanks for the note, but I figured it out right after I sent the request. It was in the Cleanoff function. I had defined the returned datatype as Int, instead of Long. I ran the query and put some break points in the functions and after about 20 tests, I saw the error.

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 KenReay, It worked. Thanks. I knew there was a way, but I just could not find the right syntax. Thanks again for the help.

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 HarleyQuinn, It worked. Thanks. I could ot find anything that matched. Simple and short. Just what I was looking for. Thanks again.

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.

Thanks JerryKlmns!! It worked perfectly! I am self tought with VBA so sometimes even though something works, I am not 100% sure why. If I am working in the same database with selects on tables, I don't need to create a new command object each time? I have always used command and result set...

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...

Thanks TheAceMan1. I will try what you suggested. I walked through the code several times and I really could not figure out why it was flowing the way it did. I figured out the sequence of the subforms being opened, but I had no real explanation as to the order after the OnOpen. My fix was...

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...

Thanks. I will see if it has what I need.

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...