Search results

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?

I am using a combo box to list the names of customers to be used as a selection for a report. I am using a simple query to create the data source for the combo box. I want to be able to add the word "All" to the data source, so all customers can be selected and I can't figure out how. I tried...

Sorry, I guess I missed the original gist of the thread. I guess there is no easy way to get it done. If only users were more like us!!! ha ha

Why not just format the report as you need it in the spreadsheet? I do this all the time. I just leave the data on the report with basically no formatting, or space between your controls on the report. If you also need a formatted report, just make two, one with the formats for printing, and...

Sorry if I am misunderstanding what you guys are trying to do, but there is an export button from the access report preview screen that will dump the report into excel. I am assuming you guys must know that, and you are trying to do something else. Hope this helps...

I am not sure if this is what is happening to you, but occasionally I lose all but my restore button, and am missing the minimize and close button. If I click the restore button they come back. I am maximizing OnOpen, but do not have the pop up property set to Yes. I am using win98 and...