Stopping Edits And Additions On A Particular Record

Apr 2, 2006

hi,

can anyone tell me how to stop additions and edits on a particular record in a form, plus the subform that the main form contains,
im trying to put the event behind the change of a text box, shipped date, so when its changed you cant add or edit the record which is the order.

cant anyone point me in the right direction?

cheers

View Replies


ADVERTISEMENT

Copied Db Won't Allow Edits Or Additions

Jul 2, 2007

I'm an Access idiot - please be kind :o

I made a little Access app for a friend, to do his invoices. Access wouldn't allow me to copy the db to a CD, but advised me to convert it to a Master. I followed all the instructions (honest!). Afterwards, I could burn his db to a CD and, on his computer, it opened but wouldn't allow edits or new records - not terribly helpful for an invoicing program :eek:

Since then I've tried creating a new admin in his name, re-setting all permissions, blah blah ... Basically, it looks like there is loads of help on securing a database but very little on un-securing it enough to be transferred to another PC!

The dang thing persists in allowing everything except edits & additions :confused:

I can't find out how to convert it back from a Master to ... what, a slave? :p
Even so, that wouldn't be the answer coz I'd be back at square1.

I use a PC running XP and Office 2003. My invoice-less friend has a PC with Win[NT]2000 and Office 2000. I converted the database to Access 2000. I am way out my depth here, but hoping you Access swimmers will be able to advise :cool:

View 1 Replies View Related

Junction Table Record Additions

Dec 5, 2007

I'm trying to add records to a junction table based on additional record added to one table via form in the many to many relationship.
Junction table = ClientAssociation
Main table = ClientMain (qry_NewClientNullAssociation identifies new record added)
Many to many table = Associations

I'm trying to do this upon clicking a command button that then opens ClientAssociation based on Client_ID. Then allows user to select mutliple associations (Asoc_ID) for Client_ID.

Here's what I have - I'm new at this...

Private Sub ClickAssociations_Click()
On Error GoTo Err_ClickAssociations_Click

'Open recordset with new client records
Dim db As Database
Set db = CurrentDb
Dim recClient As DAO.Recordset
Dim strClientID As String


Set recClient = db.OpenRecordset("qry_NewClientNullAssociation", dbOpenDynaset)
'Loop through new client ids
Do While Not recClient.EOF
strClientID = ClientMain.Client_ID

Dim recAsoc As DAO.Recordset
Dim strAsocID As String

Set recAsoc = db.OpenRecordset("Association", dbOpenDynaset)
'Loop through asoc ids
Do While Not recAsoc.EOF
strAsocID = Asoc_ID

'Open junction table and update records
Dim recClientAsoc As DAO.Recordset

Set recClientAsoc = db.OpenRecordset("ClientAssociation", dbOpenDynaset)
With recClientAsoc
.AddNew
!Client_ID = strClientID
!Asoc_ID = strAsocID
!CheckBox = False
.Update
End With

recAsoc.MoveNext
Loop

recClient.MoveNext
Loop

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frm_Associations2"
stLinkCriteria = "[Client_ID]=" & Me![Client_ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_ClickAssociations_Click:
Exit Sub

Err_ClickAssociations_Click:
MsgBox Err.Description
Resume Exit_ClickAssociations_Click

End Sub

View 1 Replies View Related

Forms :: Hitting Next Record Button Creates A New Job Instead Of Stopping?

Dec 28, 2014

I created a basic database in Access 2013 to keep up with jobs, and each job has a job number assigned to make each job unique (Primary Key).

At first I had it where I had to enter the new job number manually for each job. I have updated it and now it takes the last job number and adds 1 to it and then fills in the Job Number field automatically.

The problem is when I clicked the Last Record button, it will go to the last existing record, but if I click the Next Record button while on the last record, it will create a new record. It creates a new job instead of stopping at the last record. I assume it has to do with the auto numbering I have setup for the job numbers, since it didn't do this before, but I am not sure why. I ONLY want to be able to click the New Record (Blank) button to create a new job, NOT by also clicking the Next Record button.

Is there a way to force only the New Record button to add a new record? I still need the Previous and Next Record buttons to maneuver through the existing records. I just don't want to create new jobs accidentally by clicking the Next Record button when I'm at the end of the existing records. It should just stop, or say last record or something similar.

View 3 Replies View Related

Dont Allow Record Edits After A Certain Date

Feb 8, 2005

Hi all,
I have a form that is used to Enter and Edit records. At the end of a record is a "shipped Date". This is blank until the item ships. I want to make the entire record editable up until a date gets placed in this field. Is this possible? and can editing of the record still be done maybe at the table level?

Thanks

View 3 Replies View Related

Forms :: Record Source Not Allowing Edits?

May 17, 2013

i have a form that has a record source

Code:

SELECT tblClientDetails.FirstName, tblClientDetails.Surname,
tblClientDetails.MobileTelephoneNumber, tblClientDetails.SentTextMarketing
FROM (tblCategories INNER JOIN tblItems ON tblCategories.CategoriesID = tblItems.CategoriesID)
INNER JOIN ((tblClientDetails INNER JOIN tblOrders

[Code] .....

this does not allow edits on a continuous form. the edit i am trying to do is the check box. it will allow edits if the grouping is not on but if it is not on then i will get many duplicates of client details.

so how do i set it up to allow edits but still only get one instance of each client detail.

View 7 Replies View Related

Forms :: Record Source Of Query Stopped Allowing Edits

Apr 10, 2013

My form with record source of query has stopped allowing edits.

I have reviewed property setting and do not understand what's going on.

View 2 Replies View Related

Mass Additions

Aug 11, 2005

Hello, All.

I have a table that collects training information for our company. Some training is limited to one or two employees and that is easily entered by using a form linked to the table. However, some training is mandatory, company-wide training that all employees must attend. How can I add a record for each employee reflecting this training most efficiently? Is there a way to do a mass update?

Thanks.

View 3 Replies View Related

Table Additions

Aug 22, 2007

I'm a self confessed newb and need help

Bascially trying to get 2 table entries to add together, now I get the 2 fields to view in the 1 entry I want them into but not as an addition

For instance
strPacket24 might have a value of 1726
strPacket48 might have a value of 1725
Total should equal 3451

Problem is in the total field I get the following displaying

String I have tried using is
=Nz([strPacket24])+Nz([strPacket48])
- this displays 17261725

=Sum(Nz([strPacket24])+Nz([strPacket48]))
- this displays 18592300 ??

Can anyone help me out please?

View 2 Replies View Related

Additions After Splitting Problem....

May 17, 2005

I'm not sure if there is an easy way to do this...... Maybe someone has run into this problem. Have a DB.....Did a split...BE is on the server "F" drive.. fe is on stations. I retained a full copy of the DB NOT split. I still wanted to expand it. So now I have problems by working this way..I have not altered the tables that are on the "F" drive.. But I have added more tables to my unplit version. I need to copy the tables and info from the BE on the server BACK to my full DB. Then split it again. IS there an easier way???????????
Thanks

View 1 Replies View Related

Listbox Runtime Additions

Aug 1, 2006

I want to have a dropdown box in a form but allow additions to be made, but after they are made, instead of them not showing up in the box like usual, I want them to become a part of the list. Plz help! Thanks

View 9 Replies View Related

Form Inserts Due To Allow Additions Property

Nov 18, 2006

Hi All,

I have been searching and can't seem to find how to solve my problem. I have a sub form that allows adding new rows to a database. The detail contains a combobox and a few text fields. When I enter data everything works fine. However when I accidently tab into the next row (new blank row) and then try to get out of the form without adding a new row I get an error about "Index or Primary Key cannot be null" or something like that.

It is very frustrating because I can't exit the form until I add data to the new row and then leave without tabbing to much (thus creating another new row with no data).

How do I trap the new row and only allow the insert if it has data in it?

Thanks.

View 1 Replies View Related

Forms :: Disabling Additions In A Form

Mar 22, 2013

I have a form which acts as a search function for users looking to amend existing records. This is based on a query, where users enter a parameter (PolicyNumber) and this returns only the records which match the PolicyNumber in a form view. I have also added basic navigation buttons to move between all records with the same policy number. I have a problem in that I can't disable the option to add a new record in this form once people navigate to the end of the records.

The user clicks a 'search' button, manually inputs the policy number, and the records are returned in form view. The code for the button is as follows:

Code : DoCmd.OpenForm "frmAdjustmentsEdit", acNormal, "qryPolicyNumberSearchWriteOff", "", acEdit, acNormal

How I can disable the addition of records in this? Also as a sidenote if no records are found I would like it to display a MsgBox, but despite trawling the internet have been unable to find a solution I could get to work.

View 7 Replies View Related

General :: Preventing Changes And Additions Except Through Appropriate Form / Table?

Nov 9, 2012

While I was trying to test one of my forms (which was NOT working and I had to totally redesign it), I somehow created a bunch of stores in my Store Information table...some with no names, some with the first letter of an existing store, and there was even a duplicate of the store which is creating a problem now because some products exist in Store 1A and others exist in Store 1B.

I've created a query to identify the wayward products and am changing those. I'll delete that store then.

My issue is...can I set it so that the ONLY place a new store can be created is in the Store Information Input form? That if someone makes a typo when entering products, it doesn't create a new store?

Access 2010

View 2 Replies View Related

Stopping Pop Up Window Of F12 Key

Jul 20, 2007

In order to prevent inexperienced users corrupting the design of the Forms, Reports etc. of my Access DB, I have unselected the relevant options at Tools – Startup and it doesn’t display the Objects window. However, I find that when I press F12 key, a pop up window appears with ‘Save As’ ‘Save ‘frm……’ To: As …..’ with OK and Cancel buttons. Though a user can save the form with a different name and this does not interfere with the proper functioning of the DB, I find this an irritant pop up window. Is there a way to stop this pop up window?

View 2 Replies View Related

Stopping Email

May 6, 2005

I have a form with a command button which sends a message containing information from fields on the form. This works fine. Problem is, the user can use the "Email Button", when there are fields not filled in. Is there a way to stop the email message from being sent?

View 2 Replies View Related

General :: User To Review Address Register - Auto Alert When Changes / Additions Made

Sep 27, 2012

I've got a database that allows all users to review an address register. If they find errors or mostly get updated information they have another form they can fill out to make the recommended changes. Only I have access to the main DB to make the change permanent.

The question I have is there a way for Access to send me a notification that someone has requested the change?

I know that sending an email is doable - in Access. However, that's not an option for our network here. I was thinking something along the command prompt "Net Send" command. However I've not been able to get that to work by itself - let alone within Access...

I have used VB code in the past to store what PC is using the database, I could modify that to alert me whenever I open the DB up from my PC. But I was trying to get away from having to open this particular DB up every day and check for changes.

View 2 Replies View Related

Stopping Field From Getting Focus

Sep 19, 2005

I have 10 fields on a Form. When I load up my Form, I don't want any of them to have the cursor in it.

How do I do that?

View 5 Replies View Related

Stopping Database Being Copied

Nov 8, 2005

I have a customer who is concerned that their access database may be copied and used by a competitor. I have told him to set up passwrods for all users amd hide the system file which stores the password info so database won't open off site if copied. He doesn't want to do this though. Is there any other way, possibly by encrypting it?

Regards :confused:

View 3 Replies View Related

Stopping Duplicate Numbers

Jun 25, 2007

I've got an incrementing invoice number that is just a +1 of the last invoice number. Had a problem today where one user was creating an invoice and took a while to complete the record. As soon as the record was created the invoice number went in as 123 but the record didn't save until she had filled out all the form. In the meantime someone else started to create another invoice and ended up with 123 as well because the previous record hadn't saved. Does anyone have any suggestins how I can stop this from happening? I can't save the record straight away, which would be the obvious answer as they need to fill out quite a few required fields before the record is saved so that they don't have incomplete records.

Thanks

DBL

View 2 Replies View Related

Stopping Number Rounding Up

Apr 2, 2007

G'day All,

I have a table that allows for data to be automatically imported into it or manually entered. When data is automatically entered into the table the number field shows the number as a decimal, but when I manually entered data into the column it rounds it up or down to the nearest whole number.
I have checked the the decimal place setting on the particular item and it is set to allow for 2 decimal places the format is fixed and the number itself is Long integer

Any help would be a appreciated.

View 1 Replies View Related

Stopping Queries From Rounding Off

Dec 19, 2007

I have two tables. Table1 has two monetary value fields (both set with auto decimal places) and table2 has one monetary field. Then I have an append query which appends all data from table1 to table2, except for the monetary fields which are added up and then appended into table2's single monetary field (which also has decimal places set to auto). The formula I use for this is as follows:

Total Value: [Gross Value]+[Adj'mt Value]

Problem is, the total figure appended to table2 is rounded off to the nearest integer, whilst still displaying decimal places (45.00, 201.00 etc). Is there some sort of variable to set in the query to stop it from rounding off the result of this formula?

Any help would be appreciated.

Thanks.

View 1 Replies View Related

Stopping Duplicate Value Entries

Oct 17, 2006

I have a booking form database
With a date field.
I want users to be warned when they try to enter a date that already exists in the database in order to avoid double booking:confused: .....

all suggestions appreciated:)

View 4 Replies View Related

Stopping Problems When A Field Name Changes

Nov 1, 2004

I have a database that requires new data from an Excel file every month. I have created a linked table, and the the user updates links each month, pointing the table at the new Excel file.

This has been working nicely until today when the Excel file arrived with different column names! The user linked the table as normal and started to run the database, but the queries were looking for different field names so the whole thing crashed. I changed the Excel column names and tried re-linking the table, but all the queries had changed so that the field names were things like "Expr1: [Depreciation_currentmonth]" even though that field name now existed.

Does anyone know of a way of stopping this happening, or restoring the queries without ploughing through each one manually?

Abi

View 2 Replies View Related

Stopping A Dropdown On A Combo Box

Jan 4, 2005

Quick question, (and hopefully a quick and easy answer).

I have a check box and a combo box. If the check box is not checked and a user clicks on the combo box, I have a message box that pop ups and informs the user that he/she must click the check box first. However, after they ok the message box, my combo box shows it's dropdown list.

Is there a way to stop the dropdown from occurring when they click on the combo box?

Thanks in advance.

View 9 Replies View Related

Stopping A Macro At The End Of All Records In A Form

Mar 28, 2006

I have a macro which automatically opens a form. I then want the form
to scroll through all the records by itself until it gets to the last
record.

I've got it scrolling through the records, but it doesn't know when to
stop and throws up an error message.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved