Entering Values From A Form To A Table
Feb 27, 2005
Hi Guyz!! How u doing???!!!
I am new to VBA, and i need some help in my system..... basically i am creating a appointments Form, and in this i have some txt fields and a listbox which contains the available times ... What i want my form to do is that as the user enters the values in the form and the time selected, as clicking the "set Appointment" button it should add the values to the table.
I have included a word document of my form: Just as some help... Could you guyz help me with the coding... I am not at all good at coding! Thanx alot guys.. I really appreciate your help!!
View Replies
ADVERTISEMENT
Sep 1, 2005
Hey there, Im currently making a form so users can enter project information. For this particular project, the user must choose from a variety of options, and each option has a number value assigned to it for a rating. Now at the end of this form, I want a sum of the ratings, and then entered into the table. I am using a text box for the sum of ratings, and can get the sum of ratings to work on the form, but this data is entered as a 0 in the table. If anyone could help me find a way to put the actual sum in the table, that would be excellent.. thx a lot.
If it would be any help, here are the names of text boxes that I'm adding:
Health and Safety Rating, Maintenance Rating, Equipment Rating, School Size Rating, Student Enrollment Rating, SD Priority Rating, Project Requested Previously Rating
Those ratings must be added into "Total Rating"
Thankyou!
View 4 Replies
View Related
Jul 14, 2014
I have a form for entering Retirement Plan information (frmRRSP) that has tblRRSP as its recordsource. The RRSP Rate is a field with a Number datatype (in the table) and a Percent format on the form. When I enter a value on the form it originally displays the value I enter, until I press the Enter key, then it changes to "####" an enters a value of 0 in the table field.I tried entering a value directly in the table and it changes to 0 when I press Enter.I have an almost identical form and table for Vacation and it does the same thing.
View 3 Replies
View Related
Jan 31, 2015
I need to enter workload counts for 10 people, and it is done on a monthly basis. So I have a table of Months (Jan-Dec), a table of names, and a joined table with the months, names and a field for the workload counts.
I would like to make a form where I could select the month and all the names show up so I could go and enter the counts for everyone at the same time. I've attached a diagram to show what it would look like
View 3 Replies
View Related
Dec 1, 2013
I have made a table and I enter data in that table through a form. The form also include two sybchronized comboboxes. When I select a category in one combo box, corresponding items are selected in second combo box. The problem is that when I select the category in the form (with ID+Category Name), it stores only the ID in the table. How can I see the Category Name in the table (which is the control source of the form) instead of ID?
View 4 Replies
View Related
Dec 24, 2007
Hi!,
I am trying to make something to make my job easier. To be honest I am a beginer in this field. I am having a field, when I enter one value ( let that be 10) it should pop up one form and if another value ( let that value be 20) it should pop up another form.
or else I can explain in this way
If data field value = 10 then it should run macro 1
& if data field value = 20 then it should run macro 2
thanks
Pillai
View 1 Replies
View Related
Apr 17, 2014
I have a 1 row table as a result of 2 queries that give me the 'MaxYear' AS 'DefaultYear' and 'MaxWeek' AS 'DefaultWeek' in that year for a selected retailer and stores, from a master table.I want the default Year and Default Week text boxes to display the values of these
I have tried pointing to a table holds the results and pointing to the queries for each box...I have used Form.Refresh and Forms.Requery but nothing picks up my values.
View 2 Replies
View Related
Sep 14, 2012
Some days ago I made it by using "query", but now I forget it how I make the relation on this situation. Here is my problem.I have 3 Table on mdb file, named Table: A, B, Status.Table Status have One Filed with 1 Data: Dishonor
Table A have three fields
Sl Number: (Auto Number)
Status: Lookup wizard-data of (Table-Status)-Default Value is "Honor"
Amount:Number
Table B have two Fileds
Sl Number: Number
Status: Lookup wizard-data of (Table-Status)
After Entering Some data on Table A it's Look like as:
Asl numberstatusamount
1Honor5222
2Honor855
3Honor988
4Honor7777
5Honor777
6Honor9999
[code]...
Now I want to change the Status of SL Number Honor to Dishonor so I fillup data on Table B is as like following
sl numberstatus
5Dishonor
Now how I can get the result as following by using query:sl numberstatusamount
1Honor5222
2Honor855
3Honor988
4Honor7777
5Dishonor777
6Honor9999
7Honor6666
8Honor7777
9Honor666
View 1 Replies
View Related
Sep 14, 2012
I made it by using "query", but now I forget it how I make the relation on this situation. The Sample file is attached.Here is my problem.
I have 3 Table on mdb file, named Table: A, B, Status
Table Status have One Filed with 1 Data: Dishonor
Table A have three fields
Sl Number: (Auto Number)
Status: Lookup wizard-data of (Table-Status)-Default Value is "Honor"
Amount:Number
Table B have two Fileds
Sl Number: Number
Status: Lookup wizard-data of (Table-Status)
After Entering Some data on Table A it's Look like as:
Asl number
status
amount
1
Honor
5222
2
Honor
855
3
Honor
988
[code]...
View 3 Replies
View Related
Feb 15, 2006
Could someone check the following code. i've set up a form for creating regular bookings, and have a field, for which you type in the frequency in days you want the bookings for. (ie, 7 days for every week on that day, 14 for every two weeks etc...) and it seems to work, however it just alters the one record, instead of creating entirely new ones. Could someone please help:
Private Sub cmdCreate_Click()
Dim date2 As Date
Dim period As String
Dim cost2 As Currency
Dim frequency2 As Integer
Do While year = actual_year
date2 = Date_For
period = Time_Period
cost2 = Cost
frequency2 = Frequency
DoCmd.OpenTable "tblRegularBookings"
DoCmd.GoToRecord acDataTable, "tblRegularBookings", acNext
Date_For = date2 + frequency2
Time_Period = period
Cost = cost2
Frequency = frequency2
DoCmd.Close acTable, "tblRegularBookings"
Loop
End Sub
Also, one of the other problems i'm trying to solve is for those who want to create a regular booking but on say every third monday of the month for example.
Thanks very much
View 2 Replies
View Related
Dec 9, 2012
is there any way for a table to refresh on its own after entering a new record?
i tried me.requery but it doesn't seems to work.
View 1 Replies
View Related
May 24, 2005
I apologize if this has probably been asked countless times; however, in my search of this forum I could not find something that seemed to work for something so simple.
**************************************************
Scenerio:
I have 2 forms. The first form is my main form and the second form is my "popup" form. Both of these forms access the same table. In my main form I have it so people can not enter in a ID so it reduces accidental data entry. Therefore, I created a "popup" box that allows ID entry.
Everything works great except when I close out of the popup form, the newly entered data is not available unless I close the main form and reopen.
Million Dollar Question:
How do I refresh or requery (dunno the correct term usage here) the main form to reflect the addition I made in my popup form. I would like the refresh event to happen when I click the close button on my popup form.
**************************************************
Again, I know this is probably simple, but I cannot find it anywhere or most likely I am blind :cool:
Thank You
View 1 Replies
View Related
Jan 19, 2015
I am creating a log in form, it checks the user name which is unique. if the user has entered a password, it shows only one password text box, they enter the password, if it is correct they enter the database, otherwise they return to the text box.
But if they have not entered a password before the form opens with two text boxes, one for the password and one to confirm the password is typed correct, if the are different a message box shows telling them that they are different, now is where i having problems, when they have typed the two passwords and they are correct i want them to save this password in the same record "Password" as the selected "username" record, I can find the "username" record by doing a Dlookup, easy, but i am stuck how to then save the password from the text box where the selected username record is.
My table "staff" has fields of "IDStaff", "FirstName", "Surname", "Password", "Username".
View 3 Replies
View Related
Dec 9, 2012
Is there any way for a table to refresh on its own after entering a new record?
I tried me.requery but it doesn't seems to work...
View 2 Replies
View Related
Jan 24, 2005
I have a form with a sub-form
eg
Purchase Order with main details on (Po Number, Supplier etc)
with a sub form carrying the line items to be ordered.
Table PO
Form PO
Table POSUB
Form POSUB
When entering main order details into Form PO, why do the fields in the related table(Table PO) immediately get populated when the the focus gets transfered to the sub-form (Form POSUB). with users quiting the database illegally (not by the cancel records button) the result is unwanted records in the Table PO.
What I want to do is complete the input fields in the main and sub forms without any records being commited to the tables until the "Save Record" button is pressed.
Thankyou
View 2 Replies
View Related
Jul 4, 2005
I've been working on a database (attached) for a health trust. I think the relationships are right but I'm having a problem entering data. The subform shows the correct data but I can't figure out how to enter data using a form.
Can someone point me to a tutorial - I have searched the forums - honest!!
View 8 Replies
View Related
Mar 17, 2006
I have couple of forms where...The users enters a name of the river where he/she was fishing in, I also have an option where the user can browse for previous entered rivers.I am wondering how this works, how do I let the information entered go automatically into the browse section and how can I prevent from duplicates will appear in the browse for previous entered rivers. thanxp.s is this something that I will work with in the table it self or can I change this in the form ???
View 1 Replies
View Related
Nov 7, 2014
Basically I am inputting stock into my database so I can have a record of what I have left and who it's gone too. Where I'm stuck though is when I want to add an item that I have more than one off but only enter it once and have it assigned a unique stock ID number (this is in the form of an autonumber) for however much quantity I choose to enter. So for example I have 5 keyboards, I type in 'Keyboard' into my item field (named txtItem) and then type '5' into my quantity field (named txtQuantity). When I then press Add Stock (named btnAddStock) I should then see in the table, 5 separate Keyboards listed each with a different Stock ID number.
View 14 Replies
View Related
Feb 13, 2007
Help. I know just enough about Access to get myself into trouble.
What I want to do is have a form where I enter a low work order # and a high work order # with a series of yes/no questions and then have that autofill a table with work order #s incrementally from the low value to the high value and attach all of the yes/no answers to each work order #.
How do I get the table to autofill from low to high work order #?
Thanks for any help in advance and type slowly. I'm not very bright.
View 2 Replies
View Related
Nov 8, 2007
I am stuck on a problem!
I have a table containing line items which are appended to another table using Append Query. But in the table being appended to I have a field 'QuoteRef' and i need to append a value from a form into this field but am stuck how to do this.
View 3 Replies
View Related
Mar 14, 2013
I have a data input form with multiple combo boxes. The combo boxes are related to their own separate tables. The Row Source on some of the combo boxes are from queries with concatenated fields.
Not sure the best way to be able to quickly/simply input new values into the appropriate tables from here.
I've attached a screenshot of my form.
View 2 Replies
View Related
Aug 8, 2006
I've designed a form to enter several items at the same time, eg, I want to enter aeveral company names on one form. The trouble is that when I enter data into one box, it appears in all the other boxes with the same field names, not allowing multiple data, is there a way around this?
View 2 Replies
View Related
Apr 9, 2005
Hey,
basically, i have an invoice form, and on this I need to add InvoiceDate to it. Now, on the form, I have =Date(), but this changes every time i open the form, so it dosnt actually record the date. I have to manually type the date in to the form, which is not very good usibility practice. Can anyone help? Ive tried searchin, but I couldnt fin much relevent stuff. CHeers
Alex
View 1 Replies
View Related
Jan 23, 2006
I have a form with two fields, EMPLNO and SURNAME.
By entering the employee number in EMPLNO or by entering the name in SURNAME I wish to get the correct record onto the form.
This is probably covered in the archive, but I'm not sure what to look for.
Any suggestions.
View 1 Replies
View Related
Mar 17, 2006
Hello! :rolleyes:
Just need a little extra help :(
I have set up a form for the user to fill in a new record and used a command button for it to save. This all works ok.
The problem I have is when the form is opened, a record is shown in each of the fields as opposed to a blank one. The user can still enter data but they need to delete the stuff that is already in the box.
The user then, will have to press the little star at the bottom.
I have tried going into to design view, and typing in "Unbound" but it came up with #name? ...
can anyone help me ?
Shellie x
View 4 Replies
View Related
Apr 27, 2006
After informations is entered and a button is clicked to submit the information I can use the back/up arrows and page up to see what was entered even though the form is cleared. Is there something in the properties of the button that is clicked to submit that will make it impossible to see the prior users data.
It is personal information that people do not want others to see but is a public sign in computer.
Thanks
Tricia
View 3 Replies
View Related
