Recent content by JimAhl

Thanks, but none of those causes fit. It isn't a read only problem. I can write to this table normally, just not with this update query.

I am having trouble doing a simple update query and not sure why it isn't working. I am trying to do an update query to update a field in a table with the results of another query. I have a select query that sums all cost items from an estimate times the markup multiplier to come up with what...

Any help with this would be greatly appreciated. I am trying to create a report for construction projects schedule. The format of the report the date of work as columns and resources(i.e. Carpenter name, Plumber name, Electrician name) as columns. The data to be displayed is the job name...

I actually found the work around from Microsoft, and it was very simple. DoCmd.Echo False DoCmd.Close DoCmd.Echo True I did confirm that this is something that only happens when using Access 2000 with Windows XP. Thanks for the help though.

Thanks for the response, but the link you posted is incomplete. Could you please repost. Thanks so much, Jim

Has no one else seen this problem?

Any help would be greatly appreciated. I use Access 2000. I have a new form I just created that has a few list boxes on it. The list boxes are used for parameters for subforms within the same form. Everything works fine, but when I close the form I get a Enter Parameter Value for 2 of the...

Thanks for the response. It is really a simple screen. And I have others like it that work just fine. However, I have just discovered something. I am running Access 2000 I was testing it on an XP machine. I ran it on a 98 machine, and the error didn't happen. I tested on a few machines...

Enter Parameter Value error I have a problem on one of my forms that is used for maintaining subcontractor info. I use a list box as record selector, and the data source is a query based on which sub is selected from the list box. The list box itself is populated by a query, which uses an...

__________________________ Private Sub HURtrntoMainCmd6_Click() On Error GoTo Err_HURtrntoMainCmd6_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "HUMainFrm" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_HURtrntoMainCmd6_Click: DoCmd.Close...

Where is the combo box that has the parameter? Once the form with the query is loaded, can you still see the combo box? Not sure what you are trying to accomplish. If you put the requery command on the the after update event of the combo box. Be aware the requery has to reference the form...

This may be a silly response, but did you check the system dates on the 2 machines. If you are using the current day to calculate your average, maybe one machine has a different date. That would explain the 2 different results.

Sorry for being so dense!! I didn't see the link in your reply until now. Again, thanks for the help

Thanks so much. I found it, and it worked perfectly.

I have searched, to no avail. Any tips on my search criterior?