Recent content by GeorgeDurkee

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