Search results
-
A
Auto pop textbox on 2nd form with same value as 1st form
This is nice ! .... so ...currently I'm using a DataSheet as a subform .... and this is a list box.... -
A
Auto pop textbox on 2nd form with same value as 1st form
Okay ... So with the assistance of your example from yesterday.... I was able to create the EmployeeWklySchdfrm with bound fields ... and they auto fill! Thank you! Second ... I was able to create the subform as well and it onlys the data specific to the person logged in ! ... The only... -
A
Auto pop textbox on 2nd form with same value as 1st form
Yes, with the ability to click on the RecID field to edit/ update that task.... -
A
Auto pop textbox on 2nd form with same value as 1st form
Just wondering ....would you like me to scrap the forms that I have created and from new? -
A
Auto pop textbox on 2nd form with same value as 1st form
that's the only way I could get the loginfrm to auto fill those fields..... My goal was to have the employeewklyschdfrm auto fill fields and the sub form to query records specific to the employee logged. Sorry :o -
A
Auto pop textbox on 2nd form with same value as 1st form
I'm trying ...:) I know there are a few that I haven't and I'm sorry .... I just got frustrated with adding a new task ..... -
A
Auto pop textbox on 2nd form with same value as 1st form
Just an FYI .... When I try to Add a new entry ... i keep on getting this error "The Mircrosoft Jet database engine cannot find a records in the table "Employeestbl" with key matching field(s) 'fkEmpID' ..... i'm stumped -
A
Auto pop textbox on 2nd form with same value as 1st form
Oh yeah :) Here is the latest update ..... 2 - EmployeeWklySchdfrm this is linked to the employeetbl and also has a subform based on a query of the WeeklyScheduletbl the subform is called WeeklySchedule subform This is working now :) 3 - WeeklyScheduleDetailsfrm This form opens the... -
A
Auto pop textbox on 2nd form with same value as 1st form
UPDATE :) 1 - Loginfrm I created a login form that auto fills fields on the EmployeeWklySchdfrm and it WORKS ! ! ! ! well at least i think it does :) 2 - EmployeeWklySchdfrm this is linked to the employeetbl and also has a subform based on a query of the WeeklyScheduletbl the subform is... -
A
Auto pop textbox on 2nd form with same value as 1st form
LMAO ! ! ! you too ?!?! ...same here :) I swear ..if another person asks me to write another SQL query today ...I'm gonna snap ! No worries ..whenever you can look at it is fine... I started to work on the login screen and other ...simple :) forms Thank you in advance Arv -
A
Auto pop textbox on 2nd form with same value as 1st form
Okay ...I know i'm doing something wrong ... I just can't figure it out ... I have created 4 forms 1 - EmployeeWklySchdfrm this is linked to the employeetbl and also has a subform based on a query of the WeeklyScheduletbl 2 - WeeklyScheduleEntryfrm this is to enter new "tasks" into the... -
A
Auto pop textbox on 2nd form with same value as 1st form
Good morning .... Here is the latest version of the db .... I have create some forms ... however..when Try i create a test entry I receive an error stating that I related record is required in the employeetbl ..... Also ... I copied the the forms from your example over to my version and I... -
A
Auto pop textbox on 2nd form with same value as 1st form
True ... I will start creating the employee forms as your example illustrates.. Thank you again for your help -
A
Auto pop textbox on 2nd form with same value as 1st form
Nevermind ..I'm an idiot ... everything exactly like yours .... sorry for the confusion I'll just shut up and wait for you ..... Arvin -
A
Auto pop textbox on 2nd form with same value as 1st form
Nice! .... I obviously need to change my relationships to match yours ....For example ... i haven't linked the Junction table to any other table .... -
A
Auto pop textbox on 2nd form with same value as 1st form
Just wondering .... Can I go ahead and start creating the forms for the drop down tables? For example ... Frequency, Hours, Status.... and etc .... I won't touch the other tables ...such as Employeestbl, WeeklyScheduletbl...etc or ... should I just shut up and wait .. :) sorry ....I'm in... -
A
Auto pop textbox on 2nd form with same value as 1st form
As requested.... here it is thank you -
A
Auto pop textbox on 2nd form with same value as 1st form
K ... thank you ... I created the new table.... also.... I don't know looked at one of my previous attachments that included a spreadsheet.... on that spreadsheet there is a tab called "KPI" which provides monthly totals .... in Access I would just create a query (date range based) that... -
A
Auto pop textbox on 2nd form with same value as 1st form
Update ..... Over the weekend I did some further analysis ..to ensure that I had captured everything and there is one thing that I originally thought that couldn't get incorporated but after investigating it might fit in. I would like to create another table called "Monthly Score Card". In... -
A
Auto pop textbox on 2nd form with same value as 1st form
Done ... I changed them all to date/time and I'm using the input mask of short date....