Thank You
That worked wonderfully. This has been a fun project of learning. Most of your comments on the previous post were right on as I had learned most of this the hard way. The zip file I sent was just quick example of what I was working with. It took me forever to figure out the CarID problem.
Here is a screen shot of where I am now.
thanks again
Steve...
SteveShelton
Last Activity: Jan 9 '09, 04:51 AM
Joined: Mar 10 '07
Location:
-
Excellent. I have already implemented most of what you stated and I working on the rest. I will give an update tomorrow.
SteveLeave a comment:
-
Here is a sample of the form and table
Steve...Leave a comment:
-
I am not sure if this the correct lookup. It just gives error when the form opens
SteveLeave a comment:
-
DLookUp
I have tried on the form DLookup
=DLookUp([EndOdometer]","tblMileage", "[CarId]=Forms![frmMileage]![CarId]-1")
I placed this as the source for starting Odometer. I get an error and the form will not open
SteveLeave a comment:
-
Thanks for the responses. Wow. I am on the road and will return this weekend. I will post a zip file when I return.
Thanks again
SteveLeave a comment:
-
Thanks for the reply. I found this a couple of days ago and could not get this to work as well.
I will keep trying
SteveLeave a comment:
-
Recall Value from Field
Being a newbie, I am buildig a mileage db and need some help. I have a mileage table that has starting and ending odometer fields. As I enter the records for the entry I want the starting value of start odometer to prefill with the value of the last end odometer record.
Here is the code I tried.
...Code:Private Sub EndOdometer_AfterUpdate() If Not IsNull(Me.EndOdometer.Value) Then StartOdometer.DefaultValue = Me.EndOdometer.Value
-
Thanks. I will look this evening
SteveLeave a comment:
-
OLE Problems
I know I have read a great deal about pictures in Access and the problems associated with trying to view them, but I want the picture to display on the form. My problem is the pictures display but they are pixelated and the name of the picture is shown. Also some of the pictures are dib or bitmap pictures created in paint show as PACKAGE in the table.
Any help
Steve -
It was late and I had the key on the wrong table.
The child table shows up on the form but in datasheet. Is there a way to change that to single form?Leave a comment:
-
Prefill and Relationship
Ok it is late and I finally have had a chance to get back to this small project.
I have created two tables tblMileage and tblCarInfo. The corresponding field in each table is called CarNumber. I have created the key on tblCarInfo field CarNumber. I have then created relationship between the two tables one two many between the car number from the mileage to the car info.
I...Leave a comment:
-
Man you are fast!! I will try that when I get in this evening. That is so cool
SteveLeave a comment:
-
Thanks that worked.
I am trying to prefill on one form before the calendar to set the vacation up. On the form I have a combo box that list the employees. I have a querry that list the employees from another table. I have been reading and found this code but I can not get it to prefill the the rest of the information about the employee I have tried to adapt it for mine not much luck.
...Code:Public Sub MatchCombo(frmData
Last edited by Stewart Ross; Nov 21 '08, 10:47 AM. Reason: Please use the code tags provided - enhances readability of your postLeave a comment:
-
OK that worked. Thanks so much. The form is looking good. The next question is this; I want to have the code prefill the starting mileage in the mileage subform from the ending mileage of the previous input. I have tried a query and with no luck.
SteveLeave a comment:
-
OK good advise. I found this out when I started with the test form. It is now working like I want the relationship to be working.
I still can not get the subform to reconize anything but datasheet.
Thanks for the help.Leave a comment:
-
Form / subform
I am trying to develop a mileage log for a set of company vehicles. I have created two tables in my testing and set the relationships. I want to have a subform on my mileage log showing the car and a photo of the car.
I have created a test frmMileage form with the subform from the tblCarInfo. I can not get the subform out of datasheet view. I have gone to the properties of the main form and selected single form with no success.... -
That makes since. I have sent you the shell of the database. I have just started on it so some of of it is crude. Took out all the forms except the calendar.
Thanks again.
SteveLeave a comment:
-
OK
I have rebuilt the calendar in my db. What I want the Event table to do is simply display the employee, type of vacation (event) and the range of the employee's vacation.
I have looked at the code on planner calendar but not sure why you put the tblTempEvent in place?
SteveLeave a comment:
-
Thanks for all the help on this. I have vacation planner started and this is going to tie in great with what I started!!
SteveLeave a comment:
No activity results to display
Leave a comment: