Search results

Thank you for your responses. Jack I used yours and it worked but I was wondering why -1 is what works and not true?

I have a check box called FullTime in a form that one checks if an employee is full time. If an employee is not full time then a label and a text box appear with further information. They only are supposed to appear when the check box is not checked. I used this in the form current event...

I have one query and another query that is based on it. Both of these queries have forms that are based on them. The form based on the first query has a button that opens a form based on the second. The second form opens to the current record on the first. I would like to use the find button on...

I have one query and another query that is based on it. Both of these queries have forms that are based on them. The form based on the first query has a button that opens a form based on the second. The second query performs calculations from information from the first. I would like to have the...

I have a module that concatenates names and addresses. I built it on Access 97. When I try to run it on Access 2000 certain objects such as "Table" are not recognized. Same with "index". I was wondering if this has to do with a difference between 97 and 2000 because the module works fine on 97...

The big problem is after entering the number into the text box. If I then scroll to another record and then come back to the non-full time record the days aval text box will default to the number of days for the full time employee that I just scrolled from and not retain the number I put in...

I currently have this code that fills a text box with available days of leave depending on how many years an employee has worked for a company: Private Sub Form_Current() 'Set the cursor to the first name field 'If Full Time check box is checked, this determines _ 'the number of days available...

I have a form with a text box that displays the date an employee started working for a company. Another text box displays the total number of years the employee has wroked for the company. A third displays the number of days off of leave an employee gets based on the years worked, if he worked...

I have a form with a subform. The subform is tabular so when a user scrolls down through it it moves to the right. Every time a user scrolls through the form to a new record the subform stays far to the right and a user must manually scroll the subform to the left. Is there a way to avoid this...

I have button on a form that prints a report with just the record of the current ID number in the form. The report has a subreport in it and although all of the subreport comes up in the printing, a copy of the report prints for each record in the subreport. For example if I had a Customer...

I have a database with two tables. One has employee information the other days of leave an employee takes off. They are related by the employee ID number. An employee gets 20 days off each year, after 5 years they get 25. They can take full days and half days. I have a form that shows the...

I have a form that is based on a table. A text box in the form is used to fill the values for one of the fields in the table. I would like to use a value from a field in a query to fill in the value for the text box and the then field in the table. I have tried various ways but nothing worked...

I was wondering if I could use a crosstab query for a subform? I tried and a message box appeared that said that I had to set the query's ColumnHeadings property. Is it possible to use a crosstab query for a subform?

Thank you, I got it to work after a few times!

I have a database that tracks employee leave days. An employee can take either a full leave day or a half leave day. Each employee has 20 days of leave total that they can use each year starting on the anniversary of the date they were hired. Those that have worked more than five years get 25...

I have an employee leave database. If an employee has been employed more than five years, he or she gets 25 days off per year, less than 5, 20 days off. Part time employees get a variable amount of days off. I want a text box that will default to the number of days off each employee will get...

This is a basic question. I want to know how to create a form that will open maximized every time.

I have a form based on a parameter query. I can run the query once when the form is opened. I want to run the query again but I have to exit and open the form again to do so. Can I program a command button to run the query again? I put an OpenQuery statement in the click event but that opened...