Hi i hope that someone can help with this. I am new to Access code writing. I am trying to create a command button that will pop up a search field allowing the user to serach by either employee name or employee id. I do not want them to have replace as an option.
After the employee hits...
I think that we are taking the same thing. WHen I say width, I basically mean height. THe way the code I pased before read to me, for each row, it finds the maximum height of that row of subreports. I want it to make the height of all he subreports the same, that it why I attempted too add...
I just got this posting. With the new baby, somehow I missed the ntification on my email.
Okay Richard, let me see if I understand what you are saying. First I create a table called Vacation Rules that basically has five rows and each row defines the rules for vacation for the five different...
I thought that the whole purpose of the code below was t find the max height and draw a line matching the maximum height of the subreport with the most data. f not that i what it did.
lngMaxHeight = Me.txtDay0.Height 'set the max height to be the minimum height of the txt box
'Go...
Yes Duane, I know but that does not work for me (adding a box at the end of the detail section). I added the code because I was trying to format the calendar so that each box was the same. Your code modifies the width of the box depending on how many entries you have for that day. Is there...
Sorry, I hit the wrong button .
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Dim lngMaxHeight As Long
Dim i As Integer
lngMaxHeight = Me.txtDay0.Height 'set the max height to be the minimum height of the txt box
'Go through and find the max height...
Duane,
I got the calendar to work with the colums, I just have one more question. I am having trouble with the lines printing properly. I really want the square to be the same size regardless of what information is printed out so that it will more look like a uniform calendar. With the...
First, I have given up on trying to automatically calculate the vacation information based on an employee's work history. What I having trouble with is storing the old information so that I can use that information to popoulate this years information. Am I making any sense?
France
Just trying...
Hi,
I am trying to find something that will allow my code to wrap around so that it doesn't go past the window and activate the scroll bar. I sometimes have long code and I would like to set the characteristics of the window so that it word wraps. I am using VBA for Access. Any help would be...
Okay across then down is perfectly fine. Stupid question, I just learned how to manage subreports with your demo. How do I do a multiple column subreport?
France
Just trying to get by.
I have a calendar with subreports. I incorporated the calendar demo that prints the
orders table on a month calendar format. So now I have a month with a list in each box that lists the person(s) on vacation that day.
France
Just trying to get by.
Rick,
I don;t know if you are still monitoring this but I just had a thought about this oart of my program. Is there a way that I can also verify that the person they are scheduling has enough vacation time, i.e. they are not overschuduling, and not allow them to schedule if their remaining...
Thank you so much for this information Fancy. After reading your post, I decided to give it a try. I realize a couple of things. In trying to make my database make sense, I was going to get rid of the idea of the history. I realize that what I really need a history on is not the Employee and...
Thank you guys so much. That demo has really helped me out. I was even able to figure out how to configure the whole thing for a C sized drawing. Here is my final question though, I need to word wrap the information. Otherwise around the holidays when we have a lot of people off, the list...
It is the code that I am having trouble with. I was trying to use a DLookUp to find the records but it stops after the first match which doesn't mean that is the person they are looking for. I need something to search all the records in the table. THen I thought of a SELECT statement that...
Hi,
I am trying to do the following with my database. I have a database with a table named Employees. I also have a form named Employees that I use to enter information on the form. What I want to do is, only allow the user to see one record at a time. In other words, if they need to look up...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.