Sales information can be added against a customer record. What I would like to achieve is for users to still be able to record new sales information, but historical sales information (e.g. before 2007) can be viewed but not be able to be edited or changed. Is there a way of achieving this.
Thanks in advance...Paul
In my data input form I have several boxes. In one case i wish to allow data to be input if a certain box is marked. that mark will allow any of six boxes to be checked. This works for me. However, in the event that the certain original box is marked in error, how do I allow the box to be unmarked and make the six other boxes closed to input?
such as: (box) do it
(box) one (box) two (box) three
box do it is marked. It allows any of 1,2,3 to be chosen. Box do it is marked in error and reclicked to blank. Boxes 1,2,3 need to close up so they cannot be marked. How do I get them to close up?
Thanks
How can you block a query from getting new information from a table? but yet keep it's current values.
View 1 Replies View RelatedHow can I get Design View off the toolbar? I have users getting into it and making changes. I need to keep this from happening.
Any ideas?
Thanks
When I open my DB (I use Access 2003), Access flashes a window 'Security warning : This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?'
How do I stop this annoying message so that my DB opens directly?
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.
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.
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]...
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.
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.
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).
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.
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?
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 RelatedHow 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 RelatedHello,
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
I've got two tables, Properties and Valuations. Every six months the properties are revalued. I want to have a datasheet list of all the properties with a blank field for the new valuation so that the user can just go down the list and enter the new amount without having to select every property individually. Can I do this?
View 5 Replies View RelatedHi everyone,
I have a relationship between Market data table and Trade table which is One to Many. Market on the One and Trade on the Many.
However I just found out that I am unable to enter information into the Trade Form without entering information into the Market Form first.
I would like to enter info. into Trade Form/tables independent of whether I enter info. into the Market Form/table, but I still need to have the relationship of One Market data to Many Trade date.
Thanks
dfuas
I want to have my records in my form show the latest entry, not a completely new form. The user will click on the new record button to create a new record but I want the user to be able to see the last record. Anybody know how to do this?
View 14 Replies View Relatedi have a data access page, which as a querry in it.
When i set dataentry true, none of the recrods are visible.
but, when i set dataentry false all the records are visible, here i have to change a value (ex; change a value in drop down ) which should get saved into the data base,
Please help.
I am new to Access and I am trying to update our existing database. Presently our database is used to report incidents that have multiple subjects per incident. Is there a way to have a field recognize the data ie. the last name of an individual, and automatically fill in the remaining fields for that individual without having to fill in each field over and over again?
Your help would be greatly appreciated.
Hi,
Im copying information from Excel to Acces. As I enter the information in fields in Access, this goes just fine. The problem is that sometimes I have to change the information I put in. So for example I first copied 10 record(cells), but now I discover that I have 20 records/cells. But Access refuses to let me enter more than ten. Does anywbody know why it does this and how I can fix it?
Thank u,
Stacey
Hi there,
I have a table called Cars and a table called Rent
In Cars i have Car ID (Autonumber and primary Key) and Price Per Day
In Rent I have Rent ID, Car ID and Price Per day
The Car ID in Rent is a lookup from the Cars table, but is it possible to make it so that when i enter the Car ID in the Rent table, it automatically fills in the Price per day field for me?
Sorry if something like this has already been posted, i didnt know what this is called so didnt know what to look for.
Thanks
Chris
Hello All,
I was hoping someone could tell me the correct method of performing my intented function.
I would like for Access to Auto Input data from another table based on one entry in the current table.
Table 1 consists of Field 1 (Part Number), Field 2 (Serial Number) & Field 3 (Description).
Table 2 has Field 1 (Part Number) & Field 2 (Description).
Based on the info from table 2, how do I get the program to auto input Field 3 from table 2 (when I type in Field 1 in table 1)?
Thanks in advance
Hi, if i have to input a entry that have more than 255 words, but my table could only handle 255 words, so how do i go about it... pls advise, thanks...
View 3 Replies View RelatedWhen a order (identified by orderid) of products reaches a certain status I lock the article numbers (with an orderrule number 1 to many to that order-id) from changing. This works ok, the user can't change the article numbers and quantities. What doesn't work is the fact that they can still add records to that order. How can I get Access that far that they can't add records?
View 3 Replies View Related