Search results for query: *

I was explaining what steps I have taken to try to solve this issue, I'm not sure that it is a network problem... Thanks for your suggestion though...

The main problem is that 80% of the time, when you open an excel spreadsheet stored on the file server, it takes about 30 seconds to close the whole application or the spreadsheet, even if you just opened it and not make any changes to it. I would suspect it is a network issue since we...

FYI, I installed Jet 3.5 sp3, and it fixed the problem.. Thanks.

I'm sorry, not a concurrency issue, e.g. three computers will run the report at the same time wthout a problem, and one will display this error. same type of machine, same version of access, etc... Thanks.

This error comes up on a few workstation on our network when trying to run a report in Access 97 shared from our server. Only some not all. So it means the database is not corrupt or anything, and I wonder what it cuold be... Thanks all for your help.

To avoid creating at least 30 different Reports in Access 97, with the big memory (and work) overhead I would like to set the Report' s RecordSource property using VBA code. How can I do this. I have failed miserably using all 'known methods' . Please save me!!!

That's a good way to do it! so I guess there's just no way to format the checkbox itself huh.. Cool, Thanks

Im creating a report with checkboxes on'em, the problem is, it would look nicer if you'll only see a check mark on the column where it has check on it, and without the box itself..It shouldn't show any empty box without a check.. but I can;t seem to remove the border for the checkboxes... any...

Thanks for all your help, but I guess the easiest way to do this, so far, is creating a blank table then, SELECT null FROM blank...

Acces 97, value is from a query statement, vba, list1.rowsource ' "SELECT this FROM that": The problem is, whenever I clear all the fields in the list(using rowsource = ""), there is this column line(gray line) for one empty row, which I want to remove. So I want to...

That actually gave me a bunch of empty rows... but if you create a blank table and use that for this statement.. it works.. but, there's gotta be a much automated way, right?

Sorry, still gives an empty row with spaces...

Im not sure why, but I didn't have the removeitem property, I guess because Its not a value list.. Thanks anyways...

So, I guess nobody can help with this one huh? Well...

I need to empty my listbox.. I tried list1.rowsource = "" but it creates a row with spaces on it... I tried list1.rowsource = null; but is not accepted.. I wanted to totally empty the box, without anything in it.. no empty spaces, nothing... help? Thanks!!

Actually, Im using Access 97... so there's no 'Clear' property for listbox... Thnx though.

Hi, I'm trying to empty a list, so it doesn't display any row if it's empty, coz' if you do.. list1.rowsource = "" it'll display a list with one row with spaces.. I tried list1.rowsource = null, but is not being accepeted... thanks for the help...