Search results for query: *

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

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

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

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?

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

I want to be able to delete all records for a sequence number when all the status for that seq are "Closed, Complete or Cancelled" in any combination. In the data below I would want to delete Seq #2 and #3. Seq Job Status 1 A1 Open 1 B Closed 1 c Closed 2 D Closed 2 E4 Closed 2 B Closed 3...

I want to create a table that will be used in creating a "SnapShot" view of reports during a nightly update process and store them on the server. I want to do this so that users can have access to the reports without distributing paper copies. Also, I do not want everyone that needs the...

I have a hidden form (frmTimer) that I open on startup of the program that has a timerinterval of 1 second. This form keeps track of and writes to a table all the users currently in my database. I do this so that I can force out any users when I want to do maintenance. The problem is that...

I have code that when a users clicks on a menu button it will check for some valid data, ask for an input, then open a frm/subform with the forms tied to queries. The subform then cycles thru the records from 1 to # of records. When I execute this code in single step mode everything works fine...

I have a subform that is a continuous form. The first field is a check box. I want the user to be able to select the box and then enable field on the line (record) only and set focus to that field. When I do this now it enables the field for all records. Also, if the box is checked I want to...

Below is a sample of data (all in one field): OUTSIDE Need by 7/16/04 NEED BY DATE: MAY 17, 2004 NEED BY DATE 5-28-04 DATE 1-30-04 (NEED ASAP) 18005 NEED BY DATE 2-23-04 ASAP! NEED BY: ASAP NEED BY DATE MARCH 1, 2004 NEED BY DATE: FEBRUARY 6, 2004 NEED BY DATE 2/02/04 !!!!!! need to...

I saw the answer to this in another thread awhile back, however, I cannot find it now. I hope someone will help me with the syntax. I have already have a query written to select records. I would like to use the query to define a recordset in my code. I know how to do the following, which is...

I have a user that generates data and then emails the table to vendors. Sometimes they forget to upadte the data before they email. When I look at the table view with details I can see the attributes of modified and created. I want to able to extract the modified attribute and use in in a...

Can I set up a macro or code to import an Excel spreadsheet and have the user be prompted for the Excel file name. The data format will always be the same however the file name will change each week? ie, data041904, data042604, etc. I tried the transferspreedsheet but it requires a file name...

I created a table that has the data similar to below. I need to count the field “group” and replace/update the group to that value of the one that has the highest count. Table Num Desc Group 1 xxxx A 1 yyyy A 1 zzzz B 1 xxxx A 1 yyyy B 2 abcd D 2 bcde D 2 zzzz A etc….. In the first group I...

I want to create a database (db1) that links tables from another database (db2). Then allow users in db1 to write their own queries/reports but without the fear that they can actually change the data in db2. Can I link a table from another database as read-only without using MS Access security...

I use the following code to define a recordset: strSQL = "SELECT Purchase.*, Purchase.COR_NUM FROM Purchase ORDER BY Purchase.COR_NUM;" Set rst = dbs.OpenRecordset(strSQL) I now want to access the field Cor_Num in the code, if I use nNum = rst.fields(0) it works. However, I...