Recent content by Nevets

We don't use AD, so that doesn't apply here. Good thought, though...

All are on Access 2000 SR-1 Professional.

Yes. All of the users have the same permissions. Also there was nobody else in the database at the time, so it doesn't appear to be another user locking it. I know I'm missing something simple, but I seem to have exhausted the obvious answers. Oh, how easy it would be if I could just go and see...

I have an Access 2000 application that I developed. I recently put a prototype onto a shared network drive for a group of users to test/give their feedback. The app is split into front end/back end. The problem is that one of the users out of a group of three or four can only open in read-only...

I have an Access 2000 application that I developed. I recently put a prototype onto a shared network drive for a group of users to test/give their feedback. The app is split into front end/back end. The problem is that one of the users out of a group of three or four can only open in read-only...

If you're on a LAN, just download it once, then istall it to the users' PCs. Or, you could download it once and burn it onto a CD ROM. Install from that. Those are just two suggestions of a number of ways to go about it. But essentially you needn't do a separate download for every single user.

I have used two options to do this myself. One is to use the SendObject method via either macro or module in VBA as a .rtf (rich text format) attachment. This format opens in MS Word. It is a little bit tricky and finicky to get the initial formatting and layout just right. You have to play...

In an Access 97 application I am developing, I have a parent form, "Maintenance". From this form the user can open another for "Financial Scenarios". The idea is that the user can play around with the numbers for a given product in the database to see the results of negotiating better financial...

Below I have pasted some code from a module I created. In this case I am selecting records, and appending them into a table based upon a date range. The user selects the date range from calendar controls on a form. While this is not exactly what you are trying to acheive, you can utilize the the...

Thanks. I had the feeling I was missing something fairly simple.

I am trying to build an interface to allow users to select which fields from a specific table they wish to include in a query. For some reason I am stumped on trying to figure out how to get the field names of a table, rather than it's records to populate the list box. Can anyone help? The next...

If I understand correctly, you simply don't want zeros to display on the report?... By which I mean that you want the records to show, but not the zero values attached to them? If this is the case, you can probably make that particular text box on the report handle the zeros with an 'IIF'...

I generally set up my users with system DSNs. That way the DSN can be used by anyone who logs onto that PC, as long as they have permissions assigned on the SQL server. I also recommend that you come up with standardized DSNs. i.e: the description of a given DSN should be the same on each...

I have used the calendar control in a number of my apps. So far, I have always used it in conjunction with a command button. I declare a variable(s) for the date, then set their values by what the user has selected on the calendar controls: Dim StartDate As Date Dim EndDate As Date...

Try this: DateDiff("d",[DateField1],[DateField2])