Search results

I've got an Access 97 database which I'd like to convert to 2002 (new NT operating platform). The problem is that the database has workgroup security set up. As a result, I can't get into it from the 2002 version, nor does it give me the option to convert. However, I can't find a way to remove...

Snorrrrre I'd like to nominate this thread for the World's Most Boring Thread award. It's just dull beyond all description. Zzz.

All options are checked. Still no reply from the failed delete. Incidentally, I've noticed a similar occurance when I attempt to enter data into a form control that is incompatible with the datatype of the field to which the control is bound. No error message - it just won't let me leave the...

Hi all. One of the functions in Access 2002 is when, for whatever reason you are unable to delete a record from a table, an error message appears telling you why (for instance ref. integrity). I've accidently suppressed this message function. Anyone know how to get it back on? DaveMere

Eh? This post doesn't make any sense at all now that LushMan has deleted the original messages. What an anti-climax.

Is there a command which I can attach to a command button such that the button opens Internet Explorer at a partiular url address? Thanks. DaveMere

Solution Out of interest, thought I'd publish my solution to this. The problem was that the Msgbox querying whether the user wanted to proceed with creating a new record was contained within the form_current event - but by the time the code reached this event the record was already created...

Hi all. I've written some code in the form_current procedure that is designed to query the user when they try to create a new record, then proceed accordingly. Basically; If msgbox ("Confirm") = vbYes then (Run query to fetch next primary key and create new record) (This bit...

Hi all, I'm trying to adapt a text box in a subform to reference a value on it's parent form. The subform is present on the 2nd tab of a tab control. The value in the parent form is called "JobNo". I've tried inputting the term "=[Parent].[JobNo]" into the subform textbox data source, and this...

I'd suggest that instead of defining your own user/password tables you take a look at Access' inbuilt security features. You can define a set list of users with specific privileges on each table, query or form in the database. You can also define groups to which users belong and apply these...

Hi all. I have a data structure consisting of three cascading one-to-many relationships; Job -< Batch -< Treatment -<Observations. So, a job can have many batches, each batch can have many treatments and each treatment has many observations over time. I attempted to construct a series of nested...

Is it possible to trap the 'New Record' event on a form, ie when the form reaches the end of the current list of records and displays the next avaiable new record (displayed as '>*' on the record selectors) I need to pass in some variables to certain objects in my form on this event. Any...

I've done this recently. First trap the value you would like to pass over in a variable, say, "CurrentValue". In your calling form, under whatever event calls the form to open (say, a command button) include this code; DoCmd.OpenForm <NewFormName>, , , , acFormAdd...

You could set up another table, created by yourself, listing usernames and the countrys to which they belong. The property 'CurrentUser' will give you the username at run-time. Retrieve the users's country from this table, either upon use of the control in question, or early on and store it in a...

Is there any reason why the address details are stored in a different table from the other patient details? Keeping them in the same table would be one solution to this.

Try attaching the subform using the Wizard. It will ask you to define Master and Child values for the subform. Define the Master Value as the process name and the child value as a corresponding foreign key in your subform data table. Presuming the database tables you are using for data are...

You appear to have missed out the exclamation mark following the word "Forms". As well as that, I think this workd should be enclosed in square brackets. [Forms]![formname ]![controlname] The error message "#Name" appearing in a control indicates the data source has not been defined properly

Hello all. I'm working on a database with linked tables and security workgroups set up. The security settings divide the users into groups. One of my users is a member of a group which has full access to a particular table (all boxes ticked). Nevertheless, whilst logged in under her username I...

If by that you mean to limit the permissible values in the field, I'm afraid not; I must leave the field open for new data. The list of unacceptable data is relatively small, so I thought to filter against this. Dave

I don't know about the input mask properties but here's another solution; The KeyPress event "object_KeyPress (KeyAscii as integer)" will trap the ASCII code of all new characters as they are entered into the text box/list box/ label, whatever. Set up an If...else loop checking to see if the...