I've a database with multiple users and each user should fill in a specific textbox in a one form. there are alsow two textboxes that he needs to fill which the current date and userid.
What i want is that once the user fill in the that textbox, the datebox and userid to filled automatically.
I am creating a database for an annual golf tournament. Part of this is to allocate players to play off together at certain times.
I have a form bound to a table called tblteeofftimes. This form has five fields (continuous form) - four of which are comboboxes whereby user selects each player for the record (who will play together). The other textbox has the tee off time. the first tee off time will be allocated by user eg 7:00 am.
My problem is I need to update each ensuing record with a new time slot at 7 minute intervals. Rather than have the user populate the form themselves I would prefer this be done authomatically as the user moves onto the next record.
I have a table called tblDeliveryOverview and a table called tblPurchaseOverview in the relationship there is no link between each other but i've used a query to link the one field from tblDeliveryOverview to tblPurchaseOverview.
How can i prevent a record update from happening when i update a record in tbleDeliveryOverview and the same gets updated in tblPurchaseOverview, which i don't want to happen.
i want to create a link to access table with excel file when i change any value in excel it update in access automatic
View 1 Replies View RelatedHello,
My access skills aren't as good as my Excel skills. I am trying to convert a large uwieldy set of Excel spreadsheets into a more manageable database.
Part of my Excel sheets use logical arguments - so they interrogate a cell and if there are two of three results another cell reports 'yes', if not a 'no'.
I have set up a matching table in Access but don't know how to, if I can, get Access to evaultae a field result from data entered ito another cell.
In one cell the data entered will either be H, M or L. I want another cell to report Yes if H or M are present in the other field and 'No' if not.
Is this possible, I'm pulling my hair out and I want to get away from using Excel.
Thanks,
Fraser
i need to link my db to my excel.
if i input data to my db then the data will appear also to my excel.
is it possible?
please help. i need it very badly.
thanks
Hello everyone,
I was looking for a great way to link and relink BackEnd to FrontEnd and I sort of found it.
Bob larson build a great extensive tool to autoupdate backend en master frontend. You can find his great post here: http://www.access-programmers.co.uk/forums/showthread.php?t=111132&highlight=back+end
Here is my problem or wish is more appropriate.
I just want to relink the backend and if the backend isnt found I want to select it using the filedialog.
Who can help me...
Perhaps you can Bob???
I included the file
I realy hope that you can help me guys.
I made a report with following crosstab query.
TRANSFORM Workersdetail.workername AS CountOfedate
SELECT Workersdetail.[attendance], Count(Workersdetail.[edate]) AS [Total Of edate]
FROM Workersdetail
GROUP BY Workersdetail.[Workername], Workersdetail.[attendance], Workersdetail.[workerhourenter]
PIVOT site+Cstr([workerhourenter])
I wanted to know that, is there any option through which my report gets autoupdate or refresh incase of addition in SITE field (as mentioned with PIVOT)?
I am trying to link the textboxes on a form so that their values are stored in 2 seperate tables.
Setting the Record Source of the Form to TableA and the various Text boxes etc are set to the Fields in that table works fine, however I want some other text boxes to be linked to another set of table fields, so that when I enter values into those text boxes the data ends up in a different table.
Has anyone any ideas on how text boxes on one form can be linked to different tables.
dave
I have a combobox which has 2 values: "kids" and "adults".
When the user selects item "kids", a textbox should display record from table named kids.And when the user selects item "adults", the textbox should display record from table named adults.
How to update unbound textbox on main form from unbound textbox in subform afterupdate.
that is when amount paid is updated it automatically updates total paid, balance etc.
Hi: There are two textboxs in my main form. One is bound and another is unbound. There is no entry in the unbound textbox as values come into automatically after entering some information in the subform. My question is how to i pass values from unbound textbox to bound textbox every time when the value change in unbound textbox i need to change the value in the bound textbox. When the form load there is already value in the bound textbox which i want to override based on the values from the unbound textbox.
Thank You.
I have a date textbox (Week_Ending) and number textbox (Staff_ID) in a form (frmHourEnter), when both have values I open another form (frmStaffReport) with textboxes (txtDateStart and cmbStaff).
How do I open the second form with the values of the first form pre-entered?
I have a database for billing. In my database, I have a form that consists of a main form "Order" and 2 subforms "OrderDetails" and "Customer" OrderDetails are to enter the products to be connected to the Order. All function super, but I want to have some information from one of the forms "copied" over to on of the others.
Here is what I would like
In the subform "OrderDetails" I have made a textbox that summarize all prices to a total, his tekstbox i called "Tekst31". I would like the amount in this textbox to appear in a field "Bel�b" in the main form "Order".
I have tried some different commands, but nothing has worked, also I have made a query which dose the same ting as the tekstboks, as the information in that tekstbox it not stored anywhere.
I have a text box on 'Forma' & a textbox (named text3) on 'Formb'.
I want to copy the contents of the textbox from 'Formb' to the textbox on 'Forma'. I have used the following code in the textbox on 'Forma'....
=Forms![Formb]![Text3].text
This doesn't seem to be working whether both Forms are open or only 'Forma'. Could somebody please advise as to what I am missing. Your assistance is very much appreciated.
Dear All:
I have created a form using access 2000. So far, this form already has data and dates in a combox in this format: mm/dd/yyyy.
In the AfterUpdate of the date combobox, I did this:
If graduation_date = #2/1/2004# then
Text_Graduation_date = "dated this first day of february two thousand four."
End If
End Sub
In addition, I have defined many other dates as well using the code above. It works well when I choose the date form the combobox, the other textbox populates, but there are so many more dates in the combo!
Is there a way to auto-populate the textbox with the appropriate text as I scroll through the form?
Thanks,
Dion
I currently have two froms, "add record" and "add record cont." The reason I have two seperate forms is because when clients create a new record information needs to be saved to two different tables and when creating one from with fields from both tables I ran into many problems. The two tables are named : tblMain, tblFileLoc Currently there is a textbox on both forms named "fileID" the FileID in the first form is from tblMain and is the primary key for that table, the FileID on the second form "Add Record Cont." is just a normal field. When clients enter in the new FileID in the first form "Add Record" and then move onto the next form "Add Record Cont." i need access to bring the entered FileID from the first form and Fill it in the FileID field in the second form. Currently I have tried making the control source for the textbox on the second form = the textbox on the first form but it brought up an error.
View 1 Replies View RelatedDear All:
I have created a form with various textboxes. In one unbound textbox called Graduation_date, I input information and this is reflected in another bound textbox called text762.
However, as I scroll through the form, the information that is to be reflected in textbox 762 disappears.
Any ideas on how to apply the information entered in Graduation_date textbox to all?
Regards,
Dion
Hello,
I have continous Form with TexBox. In TextBox is "Dsum" calculation.
How can I make Sum of Values TextBox. =Sum (TextBox) Don't work.
Please, help.
Suppose i have one form in which i have one more form pasted.
when i tab off the textboxes of first form, i want the tab to go to the textboxes of another form.
At present, it goes back to the first textbox in a form instead of going to the first textbox in subform.
How can i do this ?
help urgent
This might be really easy to do but I don't know how.
I want to create a textbox that will accept unlimited characters. The highest it can go is 255, I want it as a comment area where the user can type in as much as they want w/o being warned that they've reached their limit.
Does anyone know how to do this?
Thanks
Hello guys
I have a report that bring total training by employee [Sum Of Duration] and is working fine, my dilemma is that I want a new [Text Box] that If employee have from 1 hour to 40 hour total a [text Box] to say "Legible for Bronze" if 41 to 80 "Legible for Silver"
I don't have any idea how to me this source code
any idea please.....;-)
thanks
Carlos
Is it possible to display text as the default value in a textbox which is bound to a field with a numerical data type?
For example, I want to display "N/A" as the default value, so if no one enters a number "N/A" is displayed on my report.
Hi,
I have string SELECT Field from Table:
A1
A2
A3
....
I need to see records in textbox: A1, A2, A3..
Thank You in Advance
Hi All,
I have a small yet important question to ask. I have a text box on a form, that text box accepts a product number that the user wants to modify. I want to be able to do the following:
- If the product number does not exist, prompt with an error message (this part is not a problem).
- If the product number does exist, populate the text boxes on the form with the respective data. ex: Product number 512547. Does exist, hence: (TB = textbox)
Prd. No.TB = 512547
Rec'd Date.TB = 10/10/2006
Comments.TB= blah blah blah, etc.
I am simply trying to pull information from a table into text boxes on a form using a text box.
THANKS A MILLION!
hello,
another problem that I have is as follows:
I have 2 txtBoxes and a button (txtA, txtB, btn). When opening the form I fill in txtA and txtB. Now when clicking on the button "btn" (OnClick event), the program is supposed to compare the values in the 2 txtboxes. If they are equal (txtA=txtB), then I have to do something which is not relevant to my question. In the code I type:
if (Me.txtA.Value = Me.txtB.Value) then
' DO WHATEVER
End if
and it does not even go through the conditional statement if to do whatever I want the program to do inside the if. I would really appreciate anyone's help.
Thank you very much
PS: By the way, thank you boblarson and rainman89 for the past question, both solutions worked, I used boblarson's but I have to click on the form when it's opened in order for the changes in the table to take effect.