Rio Liaden
Last Activity: Nov 13 '06, 10:07 PM
Joined: Sep 6 '06
Location:
-
You know, MSeda, you are a credit to this forum. I needed a memory jog and you gave it to me. I have been so frustrated with other aspects of my job that I could not think. I have built many databases from scratch but unfortunately, I inherited this one. I did not go back to basics and therefore, sounded like an idiot on this forum. Forgive me. I did as you instructed, put in a WorkDate field (duh!) bound it and my form is doing exactly what... -
What is the WorkDate control source? I sort of understand, but I need to bind the text box to the control source and I'm not sure what the control source is. It is the calendar but I'm a bit confused....Leave a comment:
-
Thanks! I actually tried that but my shots were too large even after I zipped them. Is that common?...Leave a comment:
-
Hopefully you have received the screen shots. Ignore the comment box that says the calendar is informational. I want it to be functional....Leave a comment:
-
Here it is......Leave a comment:
-
Yes. Each line will enter that day's date, and as I said in the last post, I changed it from tblDay, tblMonth, and tblYear to a calendar on the form. A text box on each of the lines will populate with the date when you click on the calendar date. The problem is, that particular date will populate on each line, and as the date for each new line is inserted, the new, changed date then populates each line, i.e. click on the calendar for Monday, Nov....Leave a comment:
-
Is that because I'm being a pain? My life's work and I'm good at my job! ;)Anyway, WorkDate is a text box, the receptacle for the date from Calendar1. There is no code associated except:
Private Sub WorkDate_Click( )
End Sub
Private Sub WorkDate_GotFoc us()
End Sub
Rio...Leave a comment:
-
This is the code:
Private Sub Calendar1_Click ()
WorkDate = Calendar1.Value
End SubLeave a comment:
-
When I click on the calendar on the date I need, it puts it in every line. When I change it for the next line, all lines are populated by the new date and so on. I can send a screen shot if necessary....Leave a comment:
-
Adding a date field to db
Strange things happened when I tried the aforementioned solution, so I'm trying another, more logical way. If I put a calendar (MSCAL.Calendar .7) on the sheet so that if the employee clicks on the date it will populate a field. What is the code to connect it to a text box? This is the solution that was suggested.
RioLeave a comment:
-
Well, here it is, everything found in the editor...
Private Sub cboMonth_Before Update(Cancel As Integer)
End Sub
Private Sub Form_Load()
Me.Calendar1.Va lue = [Forms]![frmTimesheet]![Date1]
End Sub
'Private Sub Label27_Click()
'DoCmd.OpenRepo rt "rptTimesheetAA RDEXNew", acPreview, "qryTimesheetSi ngleScreen"
'End Sub
...Leave a comment:
-
I did not write code, merely built from wizard. Sorry.
RioLeave a comment:
-
Adding a date field to db
Hi all!
My database allows all employees to enter their time and get a report at any time. The first screen has a calendar which is locked to the last day of the pay period and that date is the only one currently in place. The user selects his/her name from a dropdown, clicks the calendar, then "Next" to get to the time input screen. There are combo boxes to select the cost code, project, and company name. Separate boxes... -
Well, I don't know what the initial cause of this problem was, but I finally found a work around. Upon further examination, I found that the problem was not only effecting Excel but in addition, every other application in his system. I decided that it had to be in the profile, so to test that the problem was unique, I logged on with another employee's profile and found that the problem was only on the profile of the owner of the computer.
...Leave a comment:
-
Excel problem
This is quite odd, and I hope someone can help me. I wasn't sure where to go to ask and Microsoft as bad as a rubber crutch.
Here is the problem: I open a new Excel workbook, type a 1 anywhere on the sheet and instead of a 1, it prints the number 360. Hit 1 and get 360! Doesn't matter if it is the first cell, middle of the page or anywhere. 1 always is 360.
Help!!
Rio -
I got the answer from another source. I was told to use:
Private Sub Form_Load()
Me.NameOfSecond Calendar.Value = [Forms]![NameOfFirstForm]![NameOfControlWi thDate]
End Sub
Slick as can be! Works perfect!
RioLeave a comment:
-
Linking one calendar to another
Hello!
I have two calendars on two different forms. How do I link them so that if the user selects a date on the first calendar, it will automatically make the calendar go to that date on the second screen.
For instance, user selects June 3, 2006 on the first screen and when he/she opens the second screen, the calendar is on June 3, 2006. This is the Microsoft Calendar control 11.0 that I am talking about, if that... -
This is fabulous! The database is just what I needed and I hope that I will be able to show my appreciation for all of the help I was given by helping someone else. I may not be an Access whiz, but there are a number of other programs on which I am SMOKIN'!
Thanks so much once again!
RioLeave a comment:
-
Now, I'm getting a compile error. May I send you a copy of this database? It is very small, containing only one table, a query and a report.
Rio...Leave a comment:
-
Do I need to put a field on my report to reflect this function?
Rio...Leave a comment:
No activity results to display
Leave a comment: