Unbound Data Entry Form

Aug 14, 2005

Is anyone there who can show me a db sample of unbound data entry form. I want to control the builtin auto save of Access, because sometimes I don't want to save the data of my form..

Thanks,
cagay

View Replies


ADVERTISEMENT

Data Entry Using Unbound Forms

May 20, 2005

Hi All!

I have written a call log system in Access 97 for a busy customer help desk. Now I never bind any of my forms as I like to use VBA code to verify the entry first before writing it to the table. However, every now and then that million to one shot occasion occurs where 2 help desk operators click "close call" on the form simultaneously and therefore one of them gets a debug error (ie the system is busy).

So to prevent this error I have included a "on error" statement within my code which utilises the "RESUME" command to go back to the top of my procedure (in effect trying again). Now I have coded this on error trap to present the user with a message box along the lines of "system busy click OK to retry" as I was unsure about just leaving the code to continually loop until succesful? Is my uncaertainty justified or can I just leave the code to keep looping until it carries out a successful write to the table? This would be preferable as really I dont want the user to even be aware as if they are presented with this message too many times they might start getting worried!!!

My final question is should I send the code back to a point preceding the "On Error" statement at the top or does the system still remember this and so I can send it to a point after this? This is only a issue as I can envisage a time when by the time the system has re-tried another user is also writing a record and so the "on error" (or system busy) may be triggered again.

Any help most appreciated.

Dalien51

View 2 Replies View Related

Forms :: Allowing Data Entry For Unbound Fields (not In Table)

May 1, 2013

I'm trying to build a form based on a table where the user can also enter data to update the table but with data fields not originally in the table. Below is a summary of what I have and what I need:

1.) A file that will be uploaded daily into a Table (ie name Denials extract table).
2.) A form bound to table Denials extract
3.) Additional fields that will be updated by users that is not included in this table b/c they are not available in the system we are getting the data extract from.
4.) The user will look up a key field that will allow them to review it in our system. Once they "work" the record, there will be multiple fields that they will update with this information that are not in the bound recordsource (table Denials extract).

Do I create another table with these fields even though they will be blank at first and make them a subform that will have a "primary key field" that will link the main form with the subform? Will they need to "update" a whole new table? Not really sure how that would work since they will be updating fields not in the bound table.

View 8 Replies View Related

Forms :: Preventing Duplicate Entry In Unbound Form

Aug 13, 2014

What is the code for displaying warning message when enterenig duplicate information in unbound form in BeforeUpdate event procedure.

View 1 Replies View Related

Forms :: Create Data Entry Form To Input Data For Field

Mar 5, 2015

I an trying to create a data entry form (IndividualsEntryFm) to input data for fields such as (First Name),(Birthdate) etc., these to be saved to the (IndividualsTbl)

I also have another table (NamesTbl) which has family names etc. The two tables are linked by a (MainID) field. I want a combo box on the individualsEntryFm so that I can select the family name. Then I wish the empty fields for the IndividualsTbl to be available to enter data.When I press the save button I then want this data saved, together with the MainID from the combo box to the IndividualsTbl.

I have set the IndividualsTbl with a (PersonID) field as an auto number each individual therefore has a unique PersonID but may well share the MainID. I'm trying to link many people to the same address.

View 1 Replies View Related

Modules & VBA :: Datasheet Mode Form For Both Data Entry And Data Retrieval

Feb 9, 2015

I want to use the same form in datasheet mode for data entry and retrieval. When retrieving, all controls are disabled and locked. I am trying to enable and unlock them for modifying but that isn't working.

<code>
DoCmd.OpenForm "PO_Practice Data", , , , acFormEdit, acHidden

Forms![PO_Practice Data]!PO_Name.Enabled = True
Forms![PO_Practice Data]!PO_Name.Locked = False
Forms![PO_Practice Data]!Practice_Name.Enabled = True
Forms![PO_Practice Data]!Practice_Name.Locked = False

[code]...

View 3 Replies View Related

Forms :: Saving Specific Data From Data Entry Form Depending On User Selection

Dec 18, 2014

I am trying to save specific data from a data entry form to a specific depending on what the user selects from a dropdown/combo box.

So if the user selects "test company from the combo box, that data (from that form) will save to the Test company data table.

View 5 Replies View Related

Forms :: Switching Form From Data Entry Only To Data Editing

Feb 18, 2015

My aim is to have my forms open to a new record, which I have done, but if my users need to then update or edit data in previous entries, they can click a button that allows this.

My thoughts were to add a button, then put in code so that the necessary properties changed the form from displaying a new record or records entered since opening it, to showing all records in the associated table....

As an example there is a table for purchase orders. When clicking on this from the main menu form, it opens up the purchase order form to create a brand new PO. At times though, we will need to revisit an order to attach a copy of an invoice, or update the cost of whatever was purchased.

View 5 Replies View Related

Forms :: Display Existing Data On Data Entry Form

Sep 28, 2014

My db has multiple linked tables. As time passes and work on a project continues data needs to be added to a separate table that is linked to the first table to be populated.

i.e., Initial design data is entered first, when drilling is complete more data is added to a linked table, when drilling is surveyed yet more data is added to the second table.

What I want to be able to do is to query for a particular set of existing design data, display this on a form and on the same line enable data entry to other fields from other tables which are linked to the existing design data.

View 7 Replies View Related

Refreshing A Data Entry Form After Saving Data

Jul 6, 2005

This has most definitely been asked before but I really cant find anything on the forum! Ive created a data entry form which has a save button which the user must click each time to save the record. However how do I refresh the form i.e. empty all data from the previous record without exiting the form. Ive tried to combine the undo macro but that simply deletes the previous record. Any help please!!!

View 3 Replies View Related

Data Entry In Form

Jul 13, 2005

I don't want the form to add the record if I put in a value in a field. I want it to add the record when I press a "Add information to a record"-command button. How can I do this?

My form is in data entry mode.

View 2 Replies View Related

Data Entry From A Form

Dec 19, 2005

I need to design a query using fields from two tables, from which I am creating an autoform for data entry purposes. I have done this before with no problem. Now though, I cannot enter data - the option for new record is greyed out. Is there something simple I am not doing? Please help!

View 1 Replies View Related

How Do I Add A Row Via A Form Without Using Data Entry?

Aug 18, 2006

Say I have a form with three blank textboxes:

Name
Date
Description


And I have a table with those same fields: Name, Date, Description


How can I code a button to add a new row (record) from the form using the textboxes after they have been filled in?

I am familiar with the basic data entry mode, but for my purposes, it'd be best if I could do this without forcing the form to use the table as a Record Source.

Thanks so much in advance.

View 1 Replies View Related

Data Entry Sub-form

Mar 18, 2007

Hi, need some assistance as a access beginner. First I’m not sure if I will need two related tables to do what I want (if so a brief description of how would be appreciated). I would like to create a data entry form (Material Requisition) where the body of the form contains basic information about the request (including a “Next Number” com. button, that will assign the next number using “Dmax” + 1, I think I can figure this out myself) and then have a sub-form where multiple items can be entered (requested) on the same “Requisition Number” as line items (if the line numbers will need to be identified as I’m sure they will, I would like this to happen automatically. I can/ have made basic databases with simple queries, reports and entry forms but this seems a little advanced for me right now. I would then like to generate a report grouped by the requisition number with their associated "line items". Any help or suggestions would be greatly appreciated.
Thanks

View 1 Replies View Related

Clear A Data Entry Form

Mar 2, 2005

My data entry form has a button that allows the record to be saved. However, after saving the record, the form doesn't allow a new record to be added. The new form just sits there with the previously entered information in it. How do I go to a new record?

View 4 Replies View Related

Data Entry Using Blank Form?

Apr 6, 2005

I have searched the forum and asked some of my colleagues about this and I do not seem to be getting anywhere. :(

What I need is to be able to use a (blank, ie showing no current records) form to enter data into a new record.

I have Tables A and B in a 1-to-many relationship and I need to be able to bring up a blank form which has:

1. a combo box, allowing me to select the relevant record from the parent (table A), and ...
2. blank fields (from the child - table B) to fill in with new data.

I can set this up using a standard setup, where all records are shown, but this is confusing to a dumb user, who really only wants to see relevant boxes for them to fill in without the distractions of data in fields they are not concerned with or with other records they do not want to know about.

Can anyone help? :)

View 2 Replies View Related

Sub Form Not Allowing Data Entry

Jul 1, 2005

I have a main form with 2 sub forms built in. my propblem is that i can't enter data into either of the sub forms

pls help

View 2 Replies View Related

Form Not Updating After Data Entry

Dec 20, 2006

Hi
Can any one help me with a quickey. I have a form which shows short details of a building ie name town postcode etc. I have another form with 3 subforms to be able to enter new details of a building, the new client and the new agreement. This works well and is feeding the new data into the correct tables. When I reopen the short detail form it doesnot display the new records. I have a short piece of vba which allows ne to see the full details of a site when I click on the site name.
A quick reply would be much appreciated.
Thanks
ChrisD

View 2 Replies View Related

Data Entry From 1 Form To Many Tables

Sep 10, 2004

Can I use subforms to create ONE form that will do data entry to more than 3 tables at once in a relational db? How can I do this? Do I have to use Javascript, etc?

View 3 Replies View Related

Exit Form Without Data Entry

Jan 26, 2005

HI
How can exit from an "DataEntry=True" and "AllowAdditions=True" Form without add a new record to the table ??

Any help please!!!!!
Thanks
Ps: i only can do that if i press 'esc' in the 'textbox', but that doesn't suits me. the form only have a 'textbox' and a 'commandbutton'

View 2 Replies View Related

Form Data Entry, Add Only No Edit

Jun 29, 2006

Hi guys,

I've got a table (called table1), which a select query (called qryTable1) read it and is referenced in a form (called frmTable1).

So now my form display fields of the query of the table.

On the form, below the text boxs for data entry, there is a subform that displays the entire table - table1.

I've done this so I can see some fields of the old data, that helps me to enter new ones. Hope u follow so far...
---
This where I'm stuck. When I was half way entering data in the top section of the form (ie using text boxes), if I go to the subform below to copy some values from a field, ACCESS then either adds a new or edit the record. I'm wondering if there is a way to stop ACCESS automatically doing this? I want to be able to add a record when THE add record button is depressed, and that's the only way to add record.

Please do help..

View 1 Replies View Related

A 2 Part (Data Entry Form) HELP PLEASE

Oct 3, 2006

Im trying to make a data entry form which will add a new record to a database. My problem is when I associated it with a table. it starts off with a record already populated in the fields. Can someone tell me how to start off with a blank form to add new information.


Part 2

I wish to have a combo box that will drop down with SSN#s and populate the Address field automatically so that a person with additional orders will not have duplicated addresses but just one main address.

Thanking you all in advance!

View 4 Replies View Related

Data Entry Form/SSN Not Updating

Nov 13, 2006

I have an issue, I have a main data entry form that does not allow new SSN# to be entered in that particular form. So I added a button that brings up the form which allows a person to put in the new SSN# and person name. The problem is when that form closes and the other form tries to get the information from the pulldown. It is not shown there. I have to manually close and open the form again so that the new updated information can be on the main data entry form.

Is there a way for the information to be updated when a new SSN# is put into the database so a person don't have to close the main form and open it back up?

View 4 Replies View Related

Multiple Data Entry From One Form

Jun 20, 2007

I have a very simple database that keeps a track of line performance figures, i have attached a part of it as an example:

In my lines table are 8 production lines

in my log table i need to keep a track of the data,

what i would like to happen:

i need a form that when i open it all the production lines i have are displayed and next to each line are 2 data entry fields so i can enter a performance and an output figure for each line in one go, so in this instance i would like 8 lines and 2 entries per line.

at the moment i have to do each line individually.

i would also like this to grow should i add more lines

how can i best sort this please.

Help would be much appreciated

Andy

View 1 Replies View Related

Data Entry Form - Multiple Tables?

Aug 18, 2006

I have been trying to figure this one out for a while and I can't seem to find anything helpful. I'm going to present a simplified version of my problem to help keep it simple.

I have an "Activities" table that contains fields:
ActivityID
ActivityName

I have a table of 7 Risk areas which contains fields:
RiskID
RiskName

What I need to do is to create a form that will allow the user to select an activity and then, for each of the 7 risk areas, input a risk measurement.

This involves the creation of a 3rd table to collect the user input which would contain fields:

MeasurementID
RiskMeasurement
ActivityID
RiskID

I can do a dropdown of the Activities and have a subform that links to it but the problem I'm having is trying to get that subform to list the 7 Risk Areas AND collect the RiskMeasurement information from the user. How can I have a listing of these 7 areas from one table that are tied to inputs that go into another table? This seems so basic and simple yet I have tried numerous things and all have failed.

I hope this was clear. Any help is appreciated.

View 14 Replies View Related

How Do I Lookup Something From A A Different Table On A Data Entry Form?

Aug 23, 2006

Okay, for simplicity's sake, I have a data entry form.

It is bound to tableData.

Inputs are:

ProductID
Customer Name


ProductID is a combo box.

There is another table called tableProduct. In this table, is ProductID and ProductName.

For convenience sake, when a user chooses a ProductID from the combo box, I want it to lookup that ID from tableProduct. However, how can I do this when everything is already bound to tableData?

Thanks in advance.

View 1 Replies View Related







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