Search results

Ok, I think that explains it. But how do I set to "shared" programatically (help isn't very good at this bit)? I have tried using an autoexec macro but can't get it to work. Can you offer any help or do you have a sample piece of code that I could use?

Thanks for the reply, you've pretty much confirmed what I had thought. The database is set to open as shared already, but can this be overridden by users (if their default is to open as exclusive)?

I have a multiuser database installed on our network with about 30-40 users. At present it is a single shared database (i.e. not split). This is basically a management information system so no data is being updated by the users. I have a couple of questions though: 1. Is it likely that the...

I need to setup security on the backend of a database. Previously I have always relied on network security as Access' own security doesn't seem very good. Whenever I have tried this in the past and changed users permissions etc it seems to have changed their permissions and access rights for...

What a plonker!!! I had the auto resize set to No. That's it for me today....I'm going home!

I've created a form, set up all of the controls, written the code, tested the whole lot and it all works perfect, except for one thing.......I simply cannot get the form to display at the right size!!! I must have done this a thousand times before but I've never had so much aggro trying to...

Top man! this is spot on thanks. Do you know why it doesn't work the other way?

I need some help filtering records in a subform. The subform is based on a table. The parent form is unbound and has a combo list from which the user can select a number. The idea is that when the number is selected from the combo, the subform automatically re-filters to show only the records...

Thanks for the replies, this is all useful stuff.

Yes, the regional settings on my PC are set to UK i.e. dd/mm/yyyy - but may not be on the PCs belonging to the eventual users of this application. So to summarise, when using any kind of filter/function etc on dates I MUST use US format even if I have set input masks, formatting and regional...

I have a form based on a table containing ID, Date, Ref & Description. I want to call the form from another form using a filter to display records relating to a certain date, but no records are being returned. I think this has something to do with the way that dates are being recorded. I have...

Thanks a lot this is great!

This is the problem...I haven't really got any yet as I don't know where to put it! I want to invoke some code which opens another form and passes the date selected when a user clicks on a date. The closest I can get is to use a command button to open the form and pass the date selected (which...

I have inserted a calendar control into a form and want to execute some code based on the date selected by the user. Problem is I can't fathom how to do this. Can anyone help?

Thanks for the replies. This is a load off my mind, I was having nightmares about having to re-code everything.

I'm as confused as everyone else here, but I'll have a go! Is what you are saying that you have a table containing models of cars say: VW Beetle Ford Escort Robin Reliant And you want to select the category "cars" from a combo and have the query return the above list?

I've happily been using Access97 for a few years but am now on the verge of moving to XP. Up until now I've always used the DAO method: Dim DbName as Database Dim TabName as Recordset Set DbName = CurrentDB Set TabName = DbName.Openrecordset("SomeTableName").....etc Is all this still...

I am mid-way through developing a management information system and have been asked to build in functionality to allow users to input notes and summaries that may be up to two full A4 pages of text in length. There may be several dozen of these summaries. I could use memo fields to hold this...

I need help formatting text box numbers! Does anyone know how to format numbers in a text box to show in millions? For example 3,444,222 would show as 3.4.[B]

I take that back, done it! Thanks very much.