Search results for query: *

Thanks all, it looks like I need to decide whether the database I am using will delete the autonumber or not by the sound of what you are saying. I don't think it will but then again you can never rule it out I suppose but one does have back ups. It would be a lot easier if Access had written in...

I never mentioned anything about deleting I'm afraid. I apologise if I worded be mail incorrectly. No records will be deleted. I want basically that when a user goes into the form and asks for a new record they get the next sequential number as you would in the Autonumber sequence. However, you...

Thanks for that. I created a modular page. This is something I have never used before. I entered the text as shown. It looks like this currently; Function GetNextNumber() As Long GetNextNumber = Nz(DMax("Deviation No (DN)", "TBL_FrontEnd_EDIR_505"), 0) + 1 End Function However, how do I...

Hi, I know it is not recommended to use the Autonumber as a numbering system for Access but I am unfamiliar with macros and I know of no other way to think of creating an autonumbering system. Does anyone know which macro I should choose and options if I want a sequential numbering system as...

Assistance required please. Basically, I have a linked shared database where I want to have a read/write form and then a tick box where I can select it and by selecting it, it moves the record from the Form into the read only Form. I have set up two Forms and two queries. One with read/write...

It says so. Could there be something wrong in the relationships here do you think? I can mail you a print screen of the relationships and the form would you be able to see? The fields are Operator Details(This is report submitted by on the form)/Serial No/Asset No. Some of the users appear to...

No the data for those particular fields is not there, but for the other fields is. Just appears to be local to 3 fields.

I have a linked database where I and other users are entering data. Yesterday I entered a record absolutely with no problems into all fields. Into some of the fields, on searching back to the Form the data appears missing but only from 3 fields. It now prohibits me entering the data into it for...

Hi there, I have a Form. On this Form I have a button that allows the user to print the current Form they are viewing but for some reason they always seem to print all the records not just the one. The button/command is a Macro (PrintOut.(Print selected copies = 1)) Can anyone tell me what I am...

Thanks. Although, I have been told to keep the back end data together and not split it off into two. I had it in two before and in that respect it was easy, i.e. ReadOnly copy and set user access of the back end. It seems like I have to play with the user permissions as you suggested. I was...

Hi I don't know code and have no wish to delve into that scary world at present. I have a linked table database(one core, one manipulator). I have one (of many) Form where I wish certain users to have read write access to but the rest not to write/edit. The editable parts of the form I know it's...

Sorry I feel I was not clear. On the form I have a check box. This relates back to the main table. What I want to do is once the form has been checked by one person they then have the authority to tick the box. On doing so they lock the box making it un-editable. However, I wish people to use...

Please can someone help? I have a database where I need to lock the forms once it has been completed and checked. I.e. I don't want it editable after this. I know nothing about code just basic forms, queries, tables etc. Can anyone help me with this please?

I'm going to link two databases together. Database A will become the common front end and database B will have its form imported into it. The linked table manager will link both sets of data together etc. What I need is a way of assessing the risk - ie that the data has not changed due to...