Thank you Yar and mshmyob. I apreciate teh help and candidness.
Yar you are right I know little VBA, thank you for teh tutorial link.
mshmyob, thank you for the link to normalization, I will be reading it promptly. Thank you both for the help and suggestions.
Please have a great day.
Brian
Bsorensen
Last Activity: Apr 12 '10, 08:00 PM
Joined: Mar 5 '10
Location:
-
I do not have any current code to offer.
My last attempts were starting from FrmProject, entering design view, right clicking on Associate name selcting properties then in the Control Source field selecting the Elipsis which brought up the Expression Builder.
This populates with AssociateName below are three sets of boxes/windows, I start in the first and select Forms/All Forms/frmthebutton.
The next...Leave a comment:
-
Thank you Yar, Not quite what I am looking to do.
I have attached screen shots showing the components of my database, the screen shots also have notes on them trying better to explain the flow of what I want to do.
Start with FrmTheButton Start Here.jpg, then go to frmProject and build screens associated.JPG then proceed to: frmProject and build screens associated2 Tables.JPG so you can see my 2 tables.
...Leave a comment:
-
Take data from 1 table and place it in a new table
I have created a table: TblDVAssociate with 2 fields:
Field 1 Name
Field 2 Pin <--This is also the Primay Key as I do not want duplicate Pin Numbers
I have another table: TblMaster with 6 fields:
Field 1 ID (Auto Number)<-- This is the Primary key
Field 2 AssociateName
Field 3 ProjectName
Field 4 Totals
Field 5 TimeStart
Field 6 TimeStop
I have a table:TblProjec ts with... -
What is the difference/benefits or evils of using a (.) versus a (!) in the coding?
Smiley Noted in his to use a (.) after ME:
Me.tb_TimeStart = Now()
I was able to get it to work using a (!):
Me!TimeStart = Now()
I went back later in my tinkering and it also works with the period as Smiley had used.
So which is better to use and why?
Thank you...Leave a comment:
-
After a few hours of blindly testing this is the coding I came up with which works:
Private Sub CmdTimeStart_Cl ick()
Me!TimeStart = Now()
End Sub
Do you see any potential issues using this?
Thanks
BrianLeave a comment:
-
Thank you, though I still cannot make this work, I have attached shots of the VB Code For the button.
I even created a new dbase with the sole purpose to test and figure out this button, as I thought maybe something I had done in my blind blundering had "borked" up my other dbase.
However, In either case I am not able to make it work, I insert the code you provided changed it to fit my field names/textboxes...Leave a comment:
-
Thank you,
Now I have a new and "Dumber" question: Which type of button is best for this type action? Sorry I know this is a dumb question, but I have now tried using a Command Button, Toggle Button, and options button.
I was able to get the Toggle Button to work for 2 clicks then it stopped working.
Sorry I do not typically use buttons like this in my databases, all the button work I have...Leave a comment:
-
Need to add a button to an Access form to place the time in a table.
I have created a Table to track a Name, a project worked on, the amount completed, and the time the project began and ended.
My input Form to update the above fields allows the user to put their input their name, select their project from a drop down, and enter the amount of work done. I would like to know how I can place 2 buttons on this form which will place a date/time stamp on the current record. One button will go to a "Time...
No activity results to display
Leave a comment: