I have created a text box so a user can enter in the number of a project, then click a cmd button that opens a form and displays that project.
I would like to place the same code on the txt box so that the user could alternatively just enter the number and hit the enter key and launch the code...
I am trying to update a textbox on a report with data from a table that is not part of record source for the report.
I am trying to get the sum of the field "admin_amount" from the table "tblAdminAllowance", then pass the result to a text box "txtAdminSum" on the...
Another benefit will be "employee buy-in".
Most people want to be part of a team that is achieving a worthy goal. (success)
Finding value in ones work is an important and crucial element in the morale and productivity of any unit.
Girth, my two cents:
Look with in for solutions.
Get the book and do the best you can while asking here for assistance.
Assess what you section needs are and provide remedies.
Managers usually welcome employees who can resolve problems with little assistance. Take what is given and maximize...
My original purpose in setting this form up this way, was to allow viewing but not changing of previous records, and still allow entry of new records on the same screen.
Assuming the above, why don't you try this,
Dump the subform, set the following properties on the main form.
allow edits =...
Yes Melinda, it does make sense, normally,
I just have a unique situation here. (as usual due to the longggggg story, it never all gets posted for people to consider)
I solved this by doing a runsql command and creating the new record.
Thanks to all who helped.
It's appreciated.
Ron
Private Sub cmdSpecialConsiderations_Click()
On Error GoTo Err_Command19_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "SPECIAL CONSIDERATIONS"
stLinkCriteria = "[SPROJ_NO]=" & "'" & Me![ProjNo] & "'"...
I don't want the user to have to enter the information twice.
I have a header (in the form header of the many form) I have the one side displayed so that when the user opens the form, he can visually confirm that he is adding information to a specfic project.
Let me try to restate:
A user...
I am trying to create a record in a many table from a form.
user creates a new record in the one table via a form, then I want them to be able to open a new form so they can enter the details for that table.
problem is that I need to create a record in the many table before I send them to...
well carr, You were on the right track,,
There was some kind of space or novisible character in front of the equals sign,.
I deleted it and now it work fine,
thanks all, Ron
I am doing a vlook up, but the formula is displayed not the result???
Everything is formatted as text, save the file as a 97/2000/2002 excel file.
I am working in 2002
I have other formulas on the same sheet that work fine.
What's up?
Thanks, Ron
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.