Recent content by PlumDingo

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...

DOes anyone have any ideas on how to accomplish the above? Thanks France Just trying to get by.

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...

Thanks. I was forgetting to put the space before the underscore symbol. France Just trying to get by.

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...

Does anyone have an idea how to make the above work. I could really use some help. France Just trying to get by.

Thanks that works perfectly!! France Just trying to get by.

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.