Search results for query: *

Duane, Found the answer to my question by searching past post. Here's your star for helping me. Wes

Here is the code. The first time I enter the database I can run the code to attach to either one of the sources/tables above without any problems. However, if I try to run it again for the second source, I get an error (above). Exiting the database and attaching to the second source works...

If a column of values that could be several hundred lines long. I need a list of all unique values in the column. Example A C B A D A B I want to see at list that is only one occurence of each: A B C D They do not have to be sorted but would be nice. I would like to do this without Vb...

PHV, Can you help me a little more? I don't understand what you mean by 2 different database objects. Thanks.

Roy, Been really busy and just now getting back to this issue. Your suggestion about decompiling helped me discover some variable errors that were probably causing my problems. Here's a star for you. Thanks Again!

I’m using Access 2002. I have a form / subform combination. Everytime that I try to open the main form I get the error message: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. The database thens shuts down. I have opened Access then tried...

I get the error message: You can't use a pass-through query or a non-fixed-column crosstab as a record source for a subform. Since the column names change every week (current week plus the next 9 weeks). I don't know how to 'fix' the columnheadings property.

I have created a cross tab query to sum orders from current week forward. Also, not every week will be represented in the crosstab since it is possible that there would be no orders for that week. I then use a make table query since you can't use a crosstab on a subform. My problem is that...

I use some code that I found on this site to establish and refresh an ODBC connection to Oracle. And it works great. The problem I have is that I need to connect to two different sources. I use the following information to feed the code. UID = myId PWD = myPwd ODBCtable = apps_Ap_table...

I have this problem also. I have determined for me that it is function of time. After some amount of time the ODBC connection is lost. Closing the database and reopening fixes the problem. Right?

You say: Fields include Qty, Unit Price, Tax Rate You have a space in "Unit Pricae" and "Tax Rate" Then in your formula you are using "Unit Price" and "TaxRate" withno space. TaxAmt: CCur([Qty]*[Unit Price]*[TaxRate]) However, if this was the case I would expect and error or the...

PH, Thanks for your quick response. I am sorry that I was unclear on what I wanted. After the update I would expect the table to look like: F1 F2 F3 A B .5 B C .5 B D .5 B E .5 AA BB .62 BB CC .62 CC DD .62 CC EE .62 CC FF .62 I don't know...

I have a data like F1 F2 F3 A B B C B D B E .5 AA BB BB CC CC DD CC EE CC FF .62 I need to update the value of F3 based on a value that is alrady in F3. In the sample above I would like all records, A-B, B-C, B-D, be set to the value in the record B-E. CAn...

Thanks Paul... Many things occur in the night process, sometimes it errors out and needs to be run manually the next morning. I would like a solution that works whenever I envoke the macro "night" macro. If I can't get one then I'll use the time.

I have an add-in to my main database that houses some code and functions that I have developed Example: I have a report that has the following code in the OnNoData. If the user can runs this report manually and there is nodata then I want to display a message box. However, I also want to...

Yes.. Go to the passthru query that requires the password. Open in design view. Then open the queires properties. May have to right-click in the blue header bar of the query. Then in the ODBC Connect string field enter password, something like...

I agree on the inefficency but I 'inherited' this database and was asked to write a 'quick' report for someone. I do need to rewrite/change several things in this database but do not have the time right now since this table is already used in many queries. I was just lookng for a quick way to...

I want to write a query that will return a record if any field in that record is negative. The table looks sorta like this: Item Bal1 Bal2 Bal3 Bal4...Bal24 How can I do this?

Thanks.... I wil try the sendobject. I was aware that I could create a report but was trying to avoid it since the existing from is very busy/complicated with info that is not actally data.

I have inherited a database were the developer created a form to simulate an existing printed form the company used. The form was developed with all the stagnate information keyed in as labels on the form. The form also has shading and lines. The form is displayed with some information filled...