Hi all
I have made a quick db with one table and its needs to be used to enter records and updates to records from three people at the same time. These people are going to be sitting at three networked terminals and entering data to the same db at the same time. I know about splitting my db but will this allow for these people to add and change data at the same time? Should I save the backend to one computer and have copies of the data entry form on all the computers looking at the backend? Or should I have multiple forms in the same location and then each computer open the differnt forms located on one of the networked puters?
I have researched the 'party' data model but it is a bit too complex for what I'm seeking. For those familiar with it, I don't really need the intermediary relationship from-to tables.
I'm interested in ideas about setting up a data structure that will allow users to search contacts or select contacts in dropdowns regardless if the contact type is a person or an organization.
Obviously the fields needed for both are different and the biggest issue is the name field because the person contacts are
The way I am accomplishing it now is writing the company name, or "first name " & "last name" for a person, to kind of a bridge table when a new record is inserted into the person table or the organization table...kind of inefficient.
Is this a relationship thing or should I just write a function to create a temporary recordset when needed?
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.
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!!!
i have a flag in the back end of my database, which once ticked by me, should chuck them out of their front ends
it runs off the timer of the opening form and looks like thisL
Sub EveryoneGetOut() Const MINUTESLEFT As Integer = 10
If booQuitFlagTicked Then If Now() > dtQuitTime Then AuditTrack "kicked someone out", "main form timer" Application.Quit Else If (dtQuitTime - Now()) * 24 * 60 < MINUTESLEFT Then 'MsgBox "database to close in next " & 1 + Int((dtQuitTime - Now()) * 24 * 60) & " minutes for repairs/upgrades" UpdateStatus "database to close in next " & Int((dtQuitTime - Now()) * 24 * 60) & " minutes for repairs/upgrades" End If End If Else 'Debug.Print "no kicking done " & Now() End If
End Sub
two things are going wrong:-
1) i have one user that it keeps trying to kick out (i see it keep loggin it in the audit tracker) but he never gets kicked out 2) i have another user that doesn't even get a mention as trying to kick out, but they're in it. IT told me so from looking at the network locks (and my audit trail knows they logged in earlier)
i'm a bit puzzled, how can the application.quit line run without making someone quit?
and as for the other user that it doesn't even try to kick out, i'm really really puzzled!
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
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?
I have a form with a textbox and a button. When the user enters in a number range, I need records to show up for only dates that are in-between and/or equal to the numbers typed in the textbox.
For example when the user types in 4-9, and pushes the button, a display of records will be displayed for only 4, 5, 6, 7, 8, 9 (if there are such records). The numbers are contained in a NUMBER field of a larger table.
This seems to be a tough question, and I've done days of research on it and can't find an answer.
I need some help here. I have a table which stores DateOf Birth . I used DateDiff to get the age of persons but what I need is a number of persons within certain age range (0-15, 15-30, 30-50, 50>). How should I get that? :confused:
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?
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.
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?
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
i 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,
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?
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
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.
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...
