Search results for query: *

you da man, thanks, Ron

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 removed the declaration of the text box and all is well, thanks anyway, ron

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 =...

you can also use the forms on timer event, set the timer for 5 secs, then docmd. close

cmd button, new record

I'm pretty sure there is a faq with code to solve this, ron

wow carr, pretty cool stuff,, star ron

WORKSHEET change event will do it. Run it with a now function.

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] & "'&quot...

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

Interesting observation, I just noticed that when I try to copy the formula down the column, it copies it exactly, like it is an absolute reference

=VLOOKUP(B2,'NEWEST DUMP2-26'!A:C,3,FALSE) yup,,,

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