Automatic Entries On A Form
I'm trying to build a Form that will allow one field to be automatically populated when data is entered in another field. I have a table that contains two Fields: Course Name and Course Code. When I enter the Course Name in a Form, I would like the corresponding Course Code to appear in the relevant box on the Form.
Can anybody point me in the right direction as to how this can be achieved
Thanks
DD
View Complete Forum Thread with Replies
Related Forum Messages:
Entries To A Form
I have two forms "Enter_details" and "sendemail" on typing txt in "enter_details" forms txt field " checksum" i want it to be updated in "BODY" field of "Sendemail" "SendEmail" form may be open or may not be open. I put this code on "Sendemail" but its not working plz help Private Sub txtBody_BeforeUpdate(Cancel As Integer) [txtBody] = Forms!Enter_Release_details.[Checksum] End Sub
View Replies !
Automatic Population Of Fields On A Form
Hello, we are creating an input form to update a file in access. We would like to enter an order number and use that number to retrieve extra data from, a non access database. The extra data would be used to populate the fields in the access file.
View Replies !
Trying To Create An Automatic Payroll Form
Hello, I am basically doing FORM to automatically figure out my stylists commission pay, based on 5 levels of sales and 3 different pay levels, that I will cut and paste in a table from my POS system. 3 Total Tables. tbl_Employees, with the headers ID, Name, Payroll ID, Comm_Level. tbl-Current Year with the headers ID, Payroll ID, Name, Service Sales. tbl_Comm with the headers ID, CommLow, CommHigh, Level1, Level2, Level3 In a query, Qry_Years, I have Payroll ID, linked between the tbl_Employees and tbl-Current Year. I am close in a FORM to getting this to work, unless DLookup is the wrong why to go about this. This is not correct, but gives you an idea of what I am trying to do. In a FORM text box (called framePayrollIDLookup) I have =DLookUp("Level1","tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]"). This pulls up the correct pay percent for level1 employees, but i need to change out Level1 to something variable. This also doesn't work, but gives you an idea of my though process. =DLookUp(" " = framePayrollIDLookup,"tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]"), but this doesn't work. I might be way off base on how to do this, but I am trying. Thanks for any help. Chris
View Replies !
All Entries To Show Up In Form
I have table with different companies and related info. Another table with contacts for each of the companies, each company might have different number of contacts. I want the form to show all the contacts for each of the company, if there are two contacts in the company then show two, if five then show five. Just to make sure I am doing it the right way, what is the best way to build a form that is based on multiple tables. Thanks in advance, John
View Replies !
Help With Entries On A Form Disappearing
hi, i have tables called JobRecords and Customer, JobRecords contains 10,000 invoices (jobnumber 1-10000, but all are blank) these 2 tables are related by ContactRef. the idea is to select the ContactRef when entering an invoice and it will automatically fill in the address, phone number fields etc from the Customer table. now since i need a VAT and Total values, i used a JobRecords Query, when creating the entries i had the default value for ContactRef set to (select) which in the Customer table has N/A values for all fields. my form shows all invoices with data from the jobRecords Query and Customer table, so when i added some new contacts into the Customer table, and then changed some of the invoices to show these addresses instead of (select) and N/A, they disappear. i know that if some of the fields are null then it wont show the entire entry but even making sure all fields have data in it, it still doesnt appear in form view. it doesnt dissapear in the JobRecords Query either only the form. my form is based on this SELECT [JobRecords Query].JobReference, [JobRecords Query].InvoiceDate, [JobRecords Query].ContactRef, [JobRecords Query].JobDescription, [JobRecords Query].AuthNo, [JobRecords Query].AuthName, [JobRecords Query].OrderDate, [JobRecords Query].CompletionDate, [JobRecords Query].NettPayment, [JobRecords Query].VAT, [JobRecords Query].Total, [JobRecords Query].Invoiced, [JobRecords Query].Paid, [JobRecords Query].IncomeRef, Customer.DrawerRef, Customer.CustomerName, Customer.CustomerAddress, Customer.[CustomerPhone 1], Customer.[CustomerFax 1] FROM Customer INNER JOIN [JobRecords Query] ON Customer.ContactRef=[JobRecords Query].ContactRef; can anyone help? thanks Barrie
View Replies !
Refreshing The Form And Automatic Saving Question
Dear all My inquiries is 2 fold 1) The first relates to refreshing of the data. What I have now is a main form and a combo box control that generates the list of values based on the current data shown on the main form. In more elaborate terms, I have a Main Client Form, and a Fee tracking subform. Each Client can have more than one account, so in the Fee tracking subform, I have a account combo box that provides the value that correspond to the client on the main form based on a query i generated. >> My question is everytime i scroll through the clients, I still get the same drop down values for the previous client. I installed a refresh command button and upon clicking that, it gives me the new account numbers that correspond to the current client upon. What I would like to ask is if there is any simpler or automatic way of refreshing? 2) I am not that familiar with how Access records the data in the underlying tables, but right now, all the changes I make is recorded. Is there anyway to do so such that changes will be saved only upon the user confirmation and not automatically? Thanks a lot in advance on any advice Regards TK
View Replies !
Edit Previous Entries Using Form - Odd...
I'm working on a pre-existing form. When I open the form, I am able to enter new data and this data gets stored in the database fine. If I close that form and reopen it, I cannot view past entries or edit them. I know of a property (Allow Additions, Allow Edits, Allow Delete) which can change this behaviour, but these seem to do nothing for this form. I have them all set on yes and it behaves as I've described. Ideally, I would like to allow edits of previous data. I thought maybe the SQL query controlling the data wasn't returning any entries, therefore no entries would be displayed. So I saved the query and opened it up to see how many entries it did find. And it found all that it should have, so I know that the SQL statement controlling the form is what I want it to be. So my question is this: are there anymore properties or values that I don't know about, that would control the mentioned behaviour of the form? Maybe something somewhere that I'm missing, that would make the form add only? Thanks in advance for any help. Kevygee
View Replies !
Updating Form Entries To Another Table
Hi all I'd be very thankful if someone can please help me with this problem. I have 1 Table. This Table is imported and contains data from Excel. It also contains fields I added manually. There is about 20 imported fields (full of data) and about 100 manually added fields. Then I made a Query of this table. I made some calculations in this Query. I then created a Form based on the Query. I then made a Combo Box. This Combo Box selects a customer, and then updates the other fields (the ones I imported from Excel) depending on the customer I selected. So now what I want to do is this: I want the fields (updated from the query) and newly entered data to save to another newly-created table. Can someone please help me with this? Any ideas? Thanks a lot. All input greatly appreciated. kruger101
View Replies !
Predictive Address Form Entries
i have an address memo field on the form.. is there a way to display entries already present in certain address fields eg.. the following address is in the 'pickup address' field and the 'destination address' field 23 High Street, South Kensington so... i put a rule on my pickupaddress memo field on my form.. if they type 23.. the rest of the above address appears and offers itself to the field as a sign of good will.. of course the user can just type over it if it happens to be a different address starting with 23.. is this hard to do?
View Replies !
How To Make Automatic Refresh / Realtime Form Datasheet
fyi : database use SQL Server 2000 ,frond end use Ms.Access 2000 and allready use with multi user the problem is : I want to automatic refresh / realtime form datasheet, if the data allready changed, deleted or add new. I try to solve it with 1. timer event + requery but i thing it's not a good idea because if data not changes, the form will be allways requery. 2.I use winsock so every user change the data, the will be send an event and i use arrived event to refresh form datasheet. And it's not solve the problem again because prosedure save/add data is more slow than event send data with winsock. so guys , plx help me to solve the problem. thx Esugiawan
View Replies !
How To Choose The 10 Latests Entries In A Table (from A Form)
I'll start by saying that I'm not sure which sub-forum to choose, as my question(s) covers several areas, so I have tried with this one first. I'm currently making a database, which among other things contains a 'Port of Call list' table. I have a form, where I can add data to this table, meaning, that whenever a vessel has left its port, user can update following: Port name, security level, arrival date and departure date. What I need is two things (it might be more or less the same): 1. When user click a "Generate" button on a form, the 10 latest port calls from the table, should be shown. I'm not sure what kind of control is the best to should the list on the form. Code is also needed. 2. I would also need to be able to print the list. It should be part of a report. Again which controls/which code to be used is needed. I hope that someone are able to assist, as I have no clue what to do. Thanks.
View Replies !
Show Total Entries From A Table On A Form
hi i am trying to show the total number of records that are in a table. there are currently 8 entries in the table 'applications' now i would like to show this on a tabcontrol in a form. I have been told to use Dcount. I have read about this and tried this on my form but unfortunately its not working. Can anyone show me an example of how i would do this.
View Replies !
Form Entries Leaving Entry Boxes Blank
I have a form that allows users to search the database for records based on there criteria. The form allows the user to search, through combo boxes, by variables. The first is MAT, the second is Relocation Area. The search works fine when the user selects options form the combo boxes. However sometimes it is neccesary to leave the location field blank and only search by MAT. When the location combo box is left blank no records are found. Is there anyway around this. The SQL code for the query is below: SELECT [Extract Data].[ID], [Extract Data].AREA, [Extract Data].[MAT], [Extract Data].[Relocation Area 1], [Extract Data].[Relocation Area 2], [Extract Data].[Relocation Area 3], [Extract Data].[Grade Score] FROM [Extract Data] WHERE ((([Extract Data].[MAT])>forms![Data Search]!SearchMAT) And (([Extract Data].[Relocation Area 1])=Forms![Data Search]!SearchArea)) Or ((([Extract Data].[MAT])>Forms![Data Search]!SearchMAT) And (([Extract Data].[Relocation Area 2])=Forms![Data Search]!SearchArea)) Or ((([Extract Data].[MAT])>>Forms![Data Search]!SearchMAT) And (([Extract Data].[Relocation Area 3])=Forms![Data Search]!SearchArea)); Any help would be much appreciated Nick
View Replies !
Table Record Entries Exists But 0 Shown In Form
Hi, In the current db there are some tables and queries, forms designed around them With one table Test http://members.optusnet.com.au/~lukechang/access/table_d.JPG That has 3 records in them http://members.optusnet.com.au/~lukechang/access/table.JPG Just won't show in form anymore, at this stage http://members.optusnet.com.au/~lukechang/access/form.JPG The Form was working previously. This is the second time this problem has came up, I thought it would go away if I made a new form and pasted all the controls and codes. It indeed went away for a while until this problem hit me again... This db is in Access 2000 format and designed using Access 2003 I would appreciate if anyone is willing to point me to the right directions, many many thanks in advance
View Replies !
Automatic Splitter!
I am tying to create a setup application in access. The setup forms are incorporated in the database application.It has to split my database into a FE and BE so that the corresponding files can be placed in thier corresponding files folders automatically. Iam doing this because the database has to be exported to a number of remote locations every after two weeks. Apart from using the Database Splitter, Could there be any Ideas on how i can split and link my database through code.
View Replies !
Automatic Sending
Hi , I have one question. Can MS Access 2002 version do automatic send the record by E-mail without click the button? I just want to know that. I know how to create the button, and then using docmd.sendobject command to send, but I wonder whether or not MS Access can do automatic sending by e-mail without click the button. Please let me know. Thanks.
View Replies !
Automatic AutoNumbering
I am using DMax function for my custom autonumber I just realized that when using this in a multi user environment, I am getting duplications. This field is not the primary key, and I am using this as a group ID and cannot set it to “no duplications” My form also has a sub form, and when entering the sub form, the main record gets saved automatically. First I added the following procedure Private Sub Form_AfterInsert() If IsNull(Me.OrderNo) Then Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1 End If Private Sub cmdSave_Click() If IsNull(Me.OrderNo) Then Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1 End If However, I then realized the after insert function will add the new autonumber to the form. However, it will not saved it to the table until the main record is saved again (which may not happen) “DoCmd.RunCommand acCmdSaveRecord” doesn’t seems to be working after the “Form_AfterInsert” Now I moved the code to the “Form_BeforeUpdate” (still testing) Does anyone have any experience on this problem? Thank you Joe
View Replies !
Set Up Automatic Hyperlink
All Do anyone know if it is possible to make a automatic hyperlink in one field by combinding other fields. Eg. one field : 257_ second field: 601-01-001 Third field: A Fourth field: c:drawings Make hyperlink field c:drawings257_601-01-001_A
View Replies !
Automatic Updates
Hi there,I know very little about Access but been asked to find out if this is possible:On a database we have a date field for when subscription is due, is there any way that if a DirectDebit method of payment has been chosen, when the date of renewal is, access will automatically update the year to the next one?Thank you very muchCathy
View Replies !
Automatic Renumbering
Our small newspaper needs to create a database of subscribers from which we can print labels in what the post office calls "Walk Sort" order, the order in which the mail carrier hand delivers the mail on his route. The number associated with a particular subscriber is not fixed because if another subscriber is added on that mail carriers route, it may fall between two existing entries. So the Walk Sort field needs to automatically renumber up or down when an entry is added or deleted. I will use that field to sort chronologically and print form feed labels. I've figured out a way to do this in Excel, but I think Access might be a better program to use for this database. My question is, can Access automatically renumber a Walk Sort field if I add or remove entries? If so, how do I set it up to do that? P.S. I haven't used Access for quite some time, and I wasn't very proficient with it then. :o
View Replies !
Automatic Refresh
Hello everybody, I have many front end's (using ACCESS 2007 runtime version) in different terminals. Suppose that from 'terminalA', I am assigning a task to an employee who's using 'terminalB'. The user is already looged on to the program by this time, so I want that 'task' to appear on his terminal without him having to press the 'Refresh' button (that I placed on the form) every time I give him a new task when he's logged on so he could see it. How would I do this? Thank you very much.
View Replies !
Automatic Backups
Quick question about backing up a database: Is there a way I can have Access automatically save to a different path/filename dependant on date/time? I used to have my database backed up every hour automatically through Windows Task Scheduler. My IT section has removed that capability from all PCs here! (Something about allowing viruses in??? doesn't make sense to me). So I'm stuck trying to find out a way to back up my database automatically. I seem to remember reading through one of my access books that this was possible, but I never could figure it out. So, thought I would turn here for help. THX! AC
View Replies !
|
TRACKER
