Search results
-
A
Auto pop textbox on 2nd form with same value as 1st form
Opps .. i cut myself off there ..... My goal is to create one application that all employees can access..for example ... Employee can Create new enteries for themselves Update existing enteries View reports for them self Mangers can. View all enteries made by only the employees that... -
A
Auto pop textbox on 2nd form with same value as 1st form
Okay ... I did i you suggested and it (normalization) makes waaaaaaaaay more sense now ...thank you Here is my issue ... currently, we use a spreadsheet to track employee time on projects/tasks/activities....each employee has their own spreadsheet...which is linked to a Dept summary workbook... -
A
Auto pop textbox on 2nd form with same value as 1st form
Hmmm ...... interesting point ... you see ... I created the tables based on reportng structure ..... For example ... I report to my manager who reports to the director who then reports to the VP.... Would it be better for the long run and the sustainability of the app to have them ( all... -
A
Auto pop textbox on 2nd form with same value as 1st form
Yes they are ..... I think I'm starting to understand where you're going with this .... -
A
Auto pop textbox on 2nd form with same value as 1st form
it would be Org (One) to Dept (Many) Then Dept (One) to Funcgrp (Many) Then Funcgrp (One) to Emp (Many) ? -
A
Auto pop textbox on 2nd form with same value as 1st form
Hello ... The answer would be Org - Dept - Funcgrp - Emp -
A
Auto pop textbox on 2nd form with same value as 1st form
Here you go ..... and thank you very much :) -
A
Auto pop textbox on 2nd form with same value as 1st form
Yes :) Are you referring to my rant about the form displays the record ID ? :) -
A
Auto pop textbox on 2nd form with same value as 1st form
Hi Kryst51.... 1st.... Cheers to the power of GraySkull! 2nd ...thank you very much .... 3rd ... I done as you have suggested ... and i didn't lose anything ... which is a good thing ..however i do have a few questions... 1. In my second form the txt is autofilled with the record... -
A
Auto pop textbox on 2nd form with same value as 1st form
G'day .... Okay ....so I have tried exactly as you have stated and I keep on getting a Run time error " The expression you entered refers to an object that is closed or doesn't exist" I have uploaded a smaple of my db ...... if someone could look at please I would appreciate it. thank you... -
A
Auto pop textbox on 2nd form with same value as 1st form
Furthermore..... On Form 2 - there is one field that I would like autofill with the same value that is selected from the cbo on form 1 ...... The subform on Form 2 is in a Datasheet view and is designed based on a query. The query will be based on the value that is autofilled.... I hope... -
A
Auto pop textbox on 2nd form with same value as 1st form
Hello, No, both forms are not open at the same time.... Bascially I have 2 forms, form1 - Login form2 - Weekly Schedules this also has a subform Form1 has a 1 cbo and 1 test. The cbo is populated via a query.... and the txt field is for the passsword. both fields are "Unbound"... -
A
Auto pop textbox on 2nd form with same value as 1st form
....Does it matter if the fields on the 1st form are "Unbound" -
A
Auto pop textbox on 2nd form with same value as 1st form
Wow ...thank you the quick response .... However I already have a On Click event for the button on the login form which is ... Private Sub logincmd_Click() 'Check to see if data is entered into the UserName combo box If IsNull(Me.Username) Or Me.Username = "" Then MsgBox "You... -
A
Auto pop textbox on 2nd form with same value as 1st form
Hello, How can I autofill a text field a 2nd form with the same value that was entered on the 1st form? Thank you in advance Arvin -
A
Subform - 2nd Combo box dependant on 1st Combo box error
Okay .... I thought we solved it ....but ...exactly as you stated before ... "Though this technique doesn't work with bound records in a datasheet like that. You'll find when you add a second record, it might wipe out the first. I'll try to find a thread on the subject. " So ...it working... -
A
Subform - 2nd Combo box dependant on 1st Combo box error
Ummmmm... hold that thought Paul ...i think I found something :) ... I will post again in a few mins ..... -
A
Subform - 2nd Combo box dependant on 1st Combo box error
My apologizes ..... that is what I had .....and I still get the error .... so just to refresh .... 1st cbo on the subform has an AfterUpdate event Private Sub CarrierTypeID_AfterUpdate() [CarrierServiceTypeID].Requery End Sub 2nd cbo has the following in the Row Source SELECT... -
A
Subform - 2nd Combo box dependant on 1st Combo box error
G'day..... Thank you, I tried that and got the same error/ msg window. However ...when i entered and tested the following [Forms]![Carrierfrm].[Form]![CarrierTypeID] The error/msg window doesn't appear but the drop down is empty? I think I'm getting there .....i think :) -
A
Subform - 2nd Combo box dependant on 1st Combo box error
Hello, Thank you pbaldy for that link, however I think that confused me even more :) I have tried the following and none of them work .... Me!ControlName Me!Subform2.Form!ControlName Me.RecordSource