Creating Offline Data Entry Form

Sep 19, 2015

We have a client who is using an Access 2013 DB (Office 2013 Pro Plus) with the Windows 10 operating system. They are working on implementing the infrastructure for using Office 2013 under the Office 365 subscription. The Access DB they are using is setup as 2 .accdb files, one that contains the back end data, and the other the objects for the UI.

They will soon be using MS Surface Pro tablets for their field personnel, and want a form that can be used for data entry while in the field.

We talked about creating a form that could be used offline (basically a new FE and BE) and routine that would do data synchronization back to the network database when submitted by the field personnel.

From online research, it looks like this may be better solved with the use of Office 365, SharePoint, and Access Services. Unfortunately, since they haven't yet migrated to Office 365, we have no way to test it and need to determine if it is a viable option, or if we will need to do the "custom routine" option. Since they are planning to migrate to 365 anyway, if it works, it would obviously be a more cost effective solution for them.

Here are a few questions we have when considering this solution:

1) The Internet is not always available in the field, so the solution must be one that can run offline. Is this possible with 365?
2) They are working to get Sharepoint Services working soon. It looks like we will also need them to implement Access Services. What do SPS and Access Services look like, how do they interact, and what features do they offer and how can we leverage them?
3) What does the web-based Access application look like? What is the path to convert/migrate an Access 2013 DB to a web app? Does all development need to be done (or redone) in a new dev environment for 2013 web apps?
4) The "hydration" of an offline copy of the form is what we would need to distribute to an offline tablet device. What does this involve? Is a small footprint .accdw created? What happens after that when first accessed by the user? Is there a hydrated .accdb for the Front End and/or Back End?
5) If we must hydrate the entire application, we may need to implement security at that time. From our research, it appears that once the Access web app is published to SPS, the objects (lists, etc.) in SPS are lockable at the SPS level, and we may have to use that security layer instead of Access security, correct?

View Replies


ADVERTISEMENT

Forms :: Creating Data Entry Form With Hierarchy

Dec 6, 2013

I am tasked with creating a scientific database of fish catches at various different sampling stations. I envisage the entry form having a hierarchy, ie year, season, date, sample station, species caught, and then the specific associated data with each species (weight, abundance, length etc) will be a distinct record.

As fas as data entry is concerned, I would like the user to not have to re-enter the same information over and over when entering multiple species entries at the same sampling station, on the same date and so on up the hierarchy.

View 2 Replies View Related

Forms :: Creating Form For Data Entry On Three Tables?

Nov 19, 2013

How do I create a form that will allow me to enter data into three different tables?

I have a rather simple database for tracking students. When I get a new student I need to take information off their paper application and enter it into three separate tables, Student, Families, and Demographics. Each of these tables contains the fields StudentID, StudentFirst, and StudentLast.There is a relationship between the StudentID field on each table, with Student being the main table and Families and Demographics coming off of it. All relationships are one to many. StudentID is the key for the table Student.

I want to create a form to add a new record to each of these tables. I want my data to be displayed in the Columnar style. I only want to enter StudentID, StudentFirst and Studentlast once and have it populate to all three tables.

I can create a form and a query that displays existing entries exactly like how I want to enter them, but of course I can not edit or add to them. I have tried using subforms, but they don't seem to link up. Once I enter the Name, I want it to be on all the forms. I don't want to have type it three times. I also tried creating three separate forms and connect them with the Navigation Form. The issue again is that once I enter the name in one form, it is not automatically on the next form.

View 3 Replies View Related

General :: Creating A Form For Data Entry Into Main Table

Oct 21, 2014

I am creating a form for data entry into my main table. It shows all the fields including a name, date, id number etc.

I am trying to put a subform on the form containing a query. The query has two filter parameters fed from two unbound boxes on the main form (date and name). Their purpose is to filter records on the query to just show those for one person on one day. It also calculates a duration based on a start and end time. The query results are ok.

I can't get the query to display properly in the subform.

Subform Properties/data/source object is set to the query name. I'm told i have to link the master fields and child fields but when I try I get the error 'can't build a link between unbound forms'. I thought all that was necessary to bind forms was for there to be a common field between the form and query? Both contain fields from the main table including date, name, start time and end time etc.

View 4 Replies View Related

Creating Dynamic Hyperlinks - Open Data Entry Form And Navigate To Specific Record

Nov 28, 2011

I have a form that lists records in a table. I would like to have a hyperlink beside each record that will open the data entry form and navigate to that specific record. Right now, the use can only open the form for all records and has to use the record navigation buttons to find the desired record.

View 1 Replies View Related

Modules & VBA :: Data Entry - Subform Creating Orphan Records

Feb 13, 2015

How do I display a more meaningful message instead of the cryptic error about having to enter data into blah blah blah. How can I trap that error and provide them a more meaningful message about entering data. I have tried the following;

Main form name frmPatientRecords
Sub form name DentalRecords Subform
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Nz(tblPatientDetails!recordid, 0) = 0 Then
MsgBox ("sorry. Please complete the main record entry")
Parent.SetFocus
End If
End Sub

View 14 Replies View Related

Query Creating With Form Entry

Apr 10, 2013

I need to create a form, in which would be a query at the bottom.

I have table f.e. "A" in which is all data about cars.
I have table "B" in which is all data about customers.

I would like to create form "B" - which would add new customers, but at the bottom of that form I would like to see tables "A" filtered results.

Something like: In form B I create new customer. When I insert what car they want and how much they can pay, at the bottom generates query which would show all possible results from table "A".

With one customer I know how to do it. But when I insert second customer in the form, that query stops working while it doesn't know from which entry it should take the information. I don't know how to tell, that the query should take the data from the customer ID1 when I'm looking customer ID1, and from customer IDX - when I'm looking customer IDX.

I thought, perhaps it possible to create button with macro - when I press the button it copies all data from the current entry, it pastes in the form where is only one entry and works with query, than generates the query results which will be showed in the same entry that I pressed the button.

View 3 Replies View Related

Forms :: Creating New Rows For Data Entry In Access Forms

Dec 26, 2014

I am creating a simple data entry form wherein the user will enter the product id and on change the product description and retail price must be displayed.

When the order quantity is entered, the total cost need to be calculated. I am able to do this using DLookUp and simple multiplication.

However, after doing the above, I need another row to appear so that I can accomplish the same for another product.

View 2 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

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 12 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







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