Search results

Hello All, I have a combo box that display three columns but I want the middle column to be the value that displays on the combo box after the selection not the first column. How do I achieve this ? Project Name Project Number Project Description I want the Project number to be displayed...

Hello All! I have a sum box on my form but not sure why it shows up so far down my form I want it to show right underneath the last record. Its basically and sum of Mondays charges so its just sum'n up one field ... Is there a way to move it up without putting in my detail ? I don't...

Thank you Missinglinq! My mistake I thought by it moving to the new record it was saving a blank record with just my auto name and week ending but u are right it just sets u up for a new record. Thank u for your time! and I will keep in mind the cycle property. I made a lot of progress today on...

Oh nice!! just checked and ur right not adding a new record!! thanks Geotch ur great help! much appreciated.

Still didn't work!!!

Nope no code!! I shall try again!

Thanks spikepl I did try that still adding new record. :(

Hello All, How do you prevent access from adding a new record when u input data in the current record or tab to the next field? My database is set up to open with a form where the user picks his name and then a week ending date once that is complete u open a new form where the name and date...

@GEOTCH Thanks for the example! I got it to work on my database with the same concept as yours. One major thing on my timesheet detail form when I input data in any of my fields it automatically creates a new record with the same name and date but what if that person is only inputting one record...

@geotch. Thank you for your response. I like ur idea of having them pick name and week ending on another form. Is it possible to see an example?? How form1 and form 2 are linked. Did u use vba to reference back to the first form?

I'm trying to create a timesheet database to keep track of employee hours worked. I have my tables set up as follows... Employee_T PK -EmployeeID PositionTitle Last Name First Name Employer Projects_T PK-ProjectID ProjectNumber ProjectName WBS Timesheet_T PK-TimesheetID FK - EmployeeID FK...

Glad to finally register to the site and become a member ive gotten a lot of help from the different threads on here! thanks to everyone for sharing their knowledge!! I'm 35 yrs old , from los angeles ca. Ive been using access for about 2yrs now so I guess im a newbie still ... but looking...