Data Entry Question: Sign Reversal

Mar 23, 2005

Is there a way to reverse the sign of a numerical field at data entry time and store the negative results...i.e. a quantity field (shipments) keyed as +100 to be stored as -100? I have tried several input mask solutions but none worked.
Thanks for any help or suggestions from an Access novice.

View Replies


ADVERTISEMENT

Forms :: Make A Multiple Item Form / Sign In Sign Out

Jan 8, 2015

My teacher instructs me to make a 'multiple item form' in regards to signing in and signing out of a dentist ( my scenario)...The fields i have are : Appointment ID, dentistID, Appointment time, Appointment Date and customerID..i have created have the multiple item form and i am now displayed with the fields.

View 6 Replies View Related

Relationship Reversal

Apr 15, 2005

Hi, i have a problem that takes a bit of explaining and i'm not sure that what i want to do is possible so please bear with me

i have a table, in it is peoples names, e.g

names table

names
john
jack
alan
bob
dave

etc


this then relates to another table where there are two fields, both relating back to the same row in the first table

so

names1 names2
John Jack
Bob Dave
John Bob


and so on


i need to stop this second table from allowing the same relationship to be reversed

i.e.


names1 names2
John Jack
Jack John


obviously this will cause quite a few problems later on


anyone able to help with this???

View 2 Replies View Related

Data Entry - Auto Fill Data For Exisitng Accounts In Records

Mar 9, 2006

First I would like to give thanks to all the knowledgeable folks here who have helped me with my DB to date. It is working and every one is very happy and I have learned a lot.

So now I would like to add some more functionality to this existing project.

My DB is for data input of customers for a drawing. It has the following fields: Id, account number, first name, last name, date/time, score1, score2.

I t is taking a great deal of time for the users to enter in hundreds of entries a day. Most of the entries are customers who are already in the DB. I would like to get the fields to auto fill the data for existing customers say after the account number is entered. So after you put in the account the name and any other pertinent data would shows up saving users from typing it in again.

The first problem I am having is that this is still a data entry form and I can’t figure out how to be able to see the account information and still add new data to the record? The new data is a daily score they get.

Second I haven’t figured out how to call up the customers information from just the account field.

I’ve googled this and haven’t found anything terribly helpful.

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

General :: Updating Table Data With Data From Preceding Entry?

Jan 5, 2013

My question is this: I have a table where I'm entering employees' hours worked. Basically, it's something like this:

ID WorkerNumberDateworkedTimeStartTimeEnded
121/2/201310:00:00 AM3:00:00 PM
221/3/20132:00:00 AM11:00:00 AM
321/4/201312:15:00 AM11:30:00 AM
421/5/201310:25:00 PM11:00:00 AM
531/2/201311:00:00 AM3:30:00 PM
631/3/201312:00:00 PM10:00:00 PM
731/10/20137:00:00 AM4:00:00 PM

I have a query that (easily) determines how many hours an employee has worked on any given day. What I can't figure out at all, is how to write a query that can figure out how much time an employee had off in between shifts.

Thus far I'm able to run a query that separates this main table into individual workers by their id numbers, but can't figure out how to determine time off between shifts - as the last hour worked one day, and the first hour worked the next day are on two different lines (they are two different table entries).

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

Multiple Data Entry Clerks Inputting Data

Mar 5, 2008

I have a shared db where there is a requirement for more than 1 user to enter data in the same form and hence the same table. Up till now there has only been 1 data entry clerk so there has not been a problem.

Would accessing the same form by different users cause a problem, assumming they are inputting different records?

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

Can The % Sign Be Used In An Access Db??

Oct 6, 2005

Can anyone tell me if the % sign can be used, and if it cant is there any other way around this?

View 6 Replies View Related

Displaying The & Sign

Aug 23, 2006

Hi I would like to know if it is possible to display the & sign. I need to beable to use this both in form titles and on command buttons. When ik type it in as a caption it is displayed but as soon as I come out of edit mode I am left with a _ in place of the &

any help would be great. Thanks Paul Evans

View 2 Replies View Related

Sign Problem Using Time

Jan 8, 2007

I have the following in a select query

TimeLeft: CDate([FinishingTime]-Time())

If FinishingTime is LESS than Time() I want it to show a negative sign to show that the time has past. How do I do this?

View 3 Replies View Related

Small Question About The '&' Sign

Jan 10, 2005

Hey all,

just have a small question...

Normally in a form if you use the '&' in front of a objectname or something like that it will underline the first following letter meaning you can use the 'ALT + letter' combination to use it.

Now I want to use the '&' sign in a label, without having it do anything like that. I just want it to display the sign, anyone have any ideas on how to do this?

Cheers,

Thomas

View 3 Replies View Related

Adding New Columns Of Sign

Oct 14, 2013

I have table with one of the columns with number (amount) that can be positive or negative.

I want to add new column of sign - 'H' for positive or 'S' for negative.

View 1 Replies View Related

Problems Getting The Currency Sign To Display Using The Nz

Nov 15, 2006

Hi,

I have a problem displaying the £ sign in my query. Instead of the query displaying £448.87 it displays 448.87.

You can see from the below image that the value of AllCost is £448.87 and I don't understand why its displaying 448.87 when I run the other query called All Cost 2. The Nz function is used to display £0.00 if the AllCost field is null.

http://img01.picoodle.com/img/img01/6/11/15/f_82932abff5f8.jpg


The below image is when I run the "All Cost 2" query

http://img01.picoodle.com/img/img01/6/11/15/f_489aad3dce48.jpg

Thanks!
Chris

View 11 Replies View Related

Change Plus Sign Relationship From One Table To Another

Sep 11, 2012

I have a table that is joined to two tables. When I view it in Access 2010 the plus sign is set to one table. How can I make it view the other relationship?

View 1 Replies View Related

Sign In To Access Using Username And Password

Oct 19, 2014

I want to create a user name and password in to access my data base

View 3 Replies View Related

General :: Package And Sign ACCDB - Digital Signature

Jan 29, 2014

I have an accdb built using Access 2013 that will run with in 2010 Runtime. I am about ready to distribute the application, and am starting to do some research.

When I attempt to package and sign the db using the feature in Access 2013 it asks for me to "Confirm Certificate".

Before I go buy one I want to 1) try to create on myself and 2) learn about some good places to buy them.

1) I created a "Self-Signed" certificate using IIS, but the certificate doesn't show up on the list of certs when I attempt to package and sign the accdb. Is there a way to use a "Self-Signed" certificate to package my accdb?

2) If purchasing a SSL is the only option. Where is the best place to buy a SSL that I can use to package and sign accdbs from Access 2013?

View 3 Replies View Related

Queries :: Button To Display Current Time (Sign In And Out)

Jan 27, 2015

I have created a button to display the current time ( sign in and out).

It works fine with this code Me.field = time$

However i need a code beneath it to run the actual query that will display this time onto the table...

I have attached an image of one of the query, I need it to run.

View 5 Replies View Related

Forms :: Add Percentage Sign To A Text Field Without Changing Value

Apr 7, 2014

I am trying to add a percentage sign (%) after a number I get from a table, thus the number 1,5 should display 1,5% and NOT 150%.

I am using the Format Property of the text field.

I tried #,##% which converted the value to a percentage (1,5 became 150%) Then I tried #,##"%" and #,##\% Access ignored both and changed the value in the property field to #,##% Using the Format function is not an option because it is a bound field which should be editable.

View 3 Replies View Related

Data Entry Req

Apr 19, 2006

How do I make data entry required, I've sent it to be in the table but it doesnt seem to work in the formI've tried the below with no luck Private Sub Command14_Click() If tbName = Null Or tbTelephone = Null Or tbAddress = Null Then MsgBox "Please complete all details.", vbExclamation Else DoCmd.Close DoCmd.OpenForm "frmInvoice" DoCmd.MoveSize , , 5100End IfEnd SubCheers

View 1 Replies View Related

Data Entry -- Many To Many

Jul 18, 2006

Hello,

I'm looking for opinions on how people like to enter information into a many to many relationship.I understand how a many to many works as well as a Main Form/Sub Form.

Subforms is what I currently use. Would you do anything different? Below is a sample of fields I currently have. Any advice? I keep wondering if there is a better way. I'm not a huge fan of sub forms. I also build lookups from the Junction. Is this correct?

tblProjects

ProjectID PK
Project
Date
Budget

tblProjectsandManagers

ProjectID PK FK
ManagerID PK FK

tblManagers

ManagerID PK
FirstName
LastName
Phone#

Thanks

View 1 Replies View Related

Visual Sign To Show User Details Have Or Havent Been Entered

Nov 23, 2006

hi.. i have one table with fields 1-8

2 forms are used to fill in the details for each record using the primary key on each form.

eg

FORM1
jobid
date
day
time
price

FORM2
jobid
pickup
dropoff
vehicle

is there a way that on FORM1, i can indicate to my user whether or not any details have been entered into FORM2

maybe a colour system.. eg

if table.pickup and table.dropoff and table.vehicle are empty
form indicator on FORM1 is red (to show that none of the details on FORM2 have been entered)

else if table.pickup or table.dropoff or table.vehicle are not empty
form indicator on FORM1 is green (to show that atleast one of the fields on FORM2 has been entered)

it doesnt have to be a colour scheme, it can be wording.. eg

Form2 Empty, or Form2 Completed...

just some kind of sign to my user..

anyone ever tried or used something like this before?

View 3 Replies View Related







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