Search results for query: *

What I want to do is select values from a table based on up to six sets of criteria. For each criteria, I want to display an X in a VB datagrid for the records that match the given criteria, so the result looks like this: Identifier criteria1 critereia2 criteria 3 ABC X...

I have a form that displays a subset of data from the main table. When I try to filter the data using the filter by form functionality, I first must apply a filter that selects all the records (key < 99999), then I can use the apply filter by form functionality. if I don't use the first set of...

I am creating a series of worksheets using VBA. based on the worksheet, I turn on and off action buttons and menu items. I am using access to populate the first worksheet, then using excel vba to manipulate the remaining sheets. My problem is that as long as Access has control of the...

I have a form that is used to edit data. From this form, I open another form to add new data. After adding data, I return to the main form. Everything seems to be fine. I move to the next record on the main form and I get a write conflict error. I am the only user and I haven't changed...

I want to use VB to sort an Escel spreadsheet I just populated. When I use this command xlSheet.Cells.Sort key1:=Range(&quot;A2&quot;), Order1:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal I get an error 1004, Method...

I have created a recordset in Access and exported it to Excel using the Excel CopyRecordset command. Now I want to sort the data. the first time I run the module, it works fine. The second time, with no changes in anything, I get an error - Method sort of global worksheet fails. If I quit...

I have a recordset with about 6000 records in it. Each record has 47 columns. I want to export it to Excel sorted on 7 fields. Using the record by record export allows me to sort the data [smile], then export it, but that takes about 15 minutes [evil]. Using the Excel range.copyfromrecordset...

When I start my computer, it launches a Windows Explorer window that I didn't tell it to start. [evil] How do I find out where this command is coming from and how do i turn it off? [ponder] I have looked in the registry (I think) and each of the startup folders and can't find the comand to...

I have a datagrid that has number of rows. The columns are all numbers and I want to generate a total for each column as well as each row... like this Column1 column 2 column 3 total 1 1 1 3 2 1...

I am using VB to create and write to an Excel file. The user sometimes wants to remain in excel and sometimes not. How can I tell if he has closed Esxcel using the Excel close and still have the ability to close it myself if I need to?

I am using a datagrid to navigate through a recordset contained in an ADODC Recordset. How can I tell which row I've clicked in in the datagrid so I can navigate through the recordset to that record? The area I am having a problem is when the datagrid scrolls so that the displayed records are...

I am using a data grid to contain a subset of data from an adodc recordset using the Parent/Child relationship to populate the datagrid. Here is the sql statement that populates the recordset: strsql = SHAPE {select PROJTITLE,PROCONTTYPE,PROJBILLMOC,PROJBILLRC,PROSTARTDATE,PROJKEY from PROJECTS...

I am trying to dynamically add a check box to my form and can't seem to get the controls.add function to work right. I've found a number of references to the corect code, like this: Set Control = object.Add( ProgID [, Name [, Visible]]) Here is my code: Dim Mycmd As Control Private Sub...

I have an MS Access program that reads data based on months and exports it to Excel. Since I need three months at a time, I run thru the routine three times. The first time works fine. However, the second time, the same line that worked fine stops working, with a property not supported error...

I am trying to export a series of crosstab queries from Access 2000 to Excel. The final excel spredsheet data does not match the query results....data has changed, columns have been added, data moved from one column to another, etc. this is not consistent. I'll run it on time and all of the...

I have a system used by 3 people. Each of them has a log-on ID for Windows. Under Outlook Express, each of the people has their own E-Mail processing. I have set up Identities for each of the users. Here's are the problems: 1. Outlook Express allows each person to read everybody else's...

I need to be LINK to a given worksheet in a given workbook of an Excel spreadsheet. I can do this in VBA if I know the name of the worksheet and the name of the spreadsheet and the directory it is contained in. However, I don't know any of these things or it may change every time I want to...

I need to be LINK to a given worksheet in a given workbook of an Excel spreadsheet. >(::O> I can do this in VBA if I know the name of the worksheet and the name of the spreadsheet and the directory it is contained in. However, I don't know any of these things or it may change every time I...

How can I stop a user from moving the columns in the datasheet view? I am creating a multiuser database and use both form and datasheet views for viewing data. In the datasheet view, the users are mving the columns around to meet their individual needs and when another leaves the application...

I am trying to import data from a dBase II clone and, when I link or import the date, I lose almost half of the number of records that are out there. Access is not reading or importing it. I am telling Access that the file is dBase IV, the oldest it supports, but how do I tell it that the data...