Recent content by chris3942

I think that when Access moves the file from the temp folder the db file comes back with the "permissions" that were assigned to it while in the temp folder. The user on the network has privleges to files in the shared folder only. When the user on the network tries to use the just compacted...

Thanks Darrylles, Your answer led me to figure out what was causing the problem. I copied the file from the shared folder it normally resides in to another folder and was able to run it from a peer PC on the network in that other folder. Then I copied it back into the original shared folder...

We have a small network. Several users are able to update the Access 2000 db from their workstations because I've shared the folder in which the db is saved. They have complete access to do changes to the design of the db as well as update data. Because the db size was getting excessive I...

We have a small network. Several users are able to update the db from their workstations because I've shared the folder in which the db is saved. They have complete access to do changes to the design of the db as well as update data. Because the db size was getting excessive I compacted the...

We have a table with a column labeled "Model". In many of the records the "Model" contains a "-" (ie: -345). I need to change every model that is proceeded with a dash to that model followed with "-REPAIR". In other words if the record shows the data as "-345" I'd like to update it to show as...

Thanks for the tip Tom. The code worked well.

I run reports based on a table. I use a query to present the appropriate data when the user chooses to run the report. The report has a column titled "Manufacturer" which corresponds to a column in the table the report data is based on. In the query the criteria for the Manufacturer column...

PH, Thanks for the quick tip. Didn't quite understand exactly what you wanted me to do but I played around with your suggestion and finally came up with the following code which works. I removed the two references to [DATE] from within the parenthesis and placed your suggested line down with...

I have a table with the following fields: [date], [first name], [last name], [address], [city], [state] and [zip]. I want to select only records that have data in the [first name] and [last name] fields, to eliminate duplicates based only on the [address] field and also eliminate any records...

In the old flat data base we were using (Q & A) we had a screen in which we could input the "retrieve" specs to specify the data we wanted to retrieve. Then we could select an additional screen into which we could enter sorting order on multiple fields. In the first "sort&quot...

Error Message When You Start Windows Explorer: Explorer.exe Has Generated Errors and Will Be Closed by Windows The problem seems to be caused by Internet Explorer 6. Check out the link below. 100% cure for me. http://support.microsoft.com/default.aspx?scid=kb;en-us;319124

Hi Dan, Thanks for your help.Here's the "On Click" [Event Procedure] code I use to open the "SEW-UP PARTS" form: Private Sub CB_Open_Sew_Up_Parts_Form_Click() On Error GoTo Err_CB_Open_Sew_Up_Parts_Form_Click Dim stDocName As String Dim stLinkCriteria As String...

When choosing "Filter by Form" you are presented with a blank form (ala "grid") into which you can enter "search specs". I would like to open a form, have it automatically enter a "Filter by Form" mode with a 'cleared grid' ready for the user to input the...

I've created a custom tool bar that contains "A-Z sort", "Z-A sort", "Filter by Form" and "Apply Filter" buttons. When I click the "Filter by Form" button the form/sort tool bar comes up and I've eliminated all buttons except the...

Thanks to cqhoqa for the help. I may have been misleading in my question as I only wanted to output certain data to the label. Another tip referred me to http://support.microsoft.com/default.aspx?scid=kb;EN-US;210271 where I found code I was able to modify and send to "bookmarks" in...