Search results for query: *

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])

I'm not quite clear on where I would identify what words are to be abbreviated, and what their abbreviations would be. Examples being: Advanced = Advd Illustrated = Illus Cookbook = Ckbk Where would this fit into the code? Sorry if I'm being a bit dense... I am self taught in VBA, as well as...

Can anybody help me with a function to perform a search and replace for a string within a string (Access 97)? I am working with tables containing book titles. For reporting purposes, I need to search within the title for certain words and abbreviate them. For example, if there were a book titled...

I cannot remember the specifics, but I have run into problems where I exceeded the number of fields permitted on a report. I had to work around this by getting fancy with subreports. Also there is some limitation on the number of fields containing expressions which can be contained within a...

Go into the Page Setup for the report in question. Click on the Page tab. You will see an option to Use Specific Printer. Perhaps this is where your problem lies?

...just a little refinement on the previous response = [Field1] & [Field2] will result in combining the two as one string without spaces. For example MainSt. = [Field1] & " " & [Field2] will add a space in between to give you Main St