Search results for query: *

this is great!! thanks for the help.

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

Is your client running Office 2000 while you are running Office 2003? If so, then your problem is that you are doing "Early Binding". this menas referencing the object before you know wha the object is. Change your method of opening Outlook. Use the CreateObject metod instead of new object...

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 figured it out. thanks for the help. here is the original code: If ActiveSheet.Range("C3").Value = "Preparer (printed)" Then 'Report Sheet Application.CommandBars.ActiveMenuBar.Controls("IB-input").Controls("Build Report").Enabled = False...

I can't do it that way. the calculations and data gathering are too complicated to be handled with a simple query data pull. the output form Access is the result of a large number of calculations from a large number of tables. all i want in Excel is the final result. I can push the data into...

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

Just wanted to let eveybody know that I figured it out. I was changing the record in a strange place and it wasn't related to anything the error message was telling me. Thnks for the updates and help.

By the way, a new wrinkle in this....When the write conflict screen comes up and I click SAVE CHANGES, it doesn't save them. I come back to the record and it says it again. As soon as I click DROP CHANGES, then I stop getting the message.

What settngs do I look at to determine what the save settings are? I don't see any in the TOOLS...Options menu. Using the Docmd option doesn't seem to have any effect.

the main form (data correction) is open when the add form is open. the main form is updated form the add form and then the add form is closed. What is strange, even after I say SAVE CHANGES or exit the database, when I come back, to just that record, it gives me the write conflict.

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

It is a new recordset created in memory, using the fields.append method. It is based on the combination of about 8 tables, so using a standard query takes about 30 minutes just to select the data. Add the 30 to 45 minutes to do the record by record export so I can get the data sorted the way I...

Thanks for the feedback, but OutputTo does not appear to support Recordset procressing. It can output the Access intrinsics (table, form, module, query, etc.) but not recordsets. If there is a way to use it, please let post an example. I'm not seeing it.

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

This isn't so much a COM issue as a cleanup issue. My app creates and populate an Excel file. The user then wants to view the output and return to my code to do something else that the program does. If he closes Excel, using standard Excel processing before he returns to my code, then I'll...