Search results

Take a look at this site: Microsoft office 97 developer

Put in 2 or 3 or 4 for the criteria Field Name Your Field Table Name Your Table Criteria 2 or 3 or 4 GumbyD

Right - so you need to customize that query and save it multiple times once for each sub-form with the criteria for the specific sub-form. Then you need to change the recordsource for each of the sub-forms to the correct query. GumbyD

You need to create queries with the criteria in place that you want. You will need one query for each sub-form. GumbyD

I hope you followed Rich's lead! If you create an update query that updates the value in all of the checkboxes to 0 that will set all of the checkboxes back to an unchecked state. GumbyD

Take a look at the GRP Keep together property of the report. You should be able to establish columns based on that property along with the width property. GumbyD

I think what I would do is create a seperate table call Emp5DayCompliance. In the table I would put EmployeeID and Completed5Day (as a boolean - yes/no). link the new table to the existing empAbsence table that you have and add the check box field to the query and form. That way if you check...

Sorry - I lose all my indents when I post code. I hope it is still clear. I forgot to mention a couple of things. First, you need create a table for the data to get dumped into. It needs to be called "MaxDays" and have the fields "EmployeeID" (Text)and "MaxDays" (Long). Second, you will...

Try this code. You may have to update the SQL a bit to get the table references correct. Public Function Get5LessEmps() Dim rstEmps As Recordset 'Recordset for All Emps Dim rstAbs As Recordset 'Recordset for absences Dim rstLess As Recordset 'Recordset for the table where we will put the...

Sorry Sam I had left for the day. I played around with this and have a working solution, but it is not pretty. You can build into your ORDER BY clause an iif statement that checks to see if they want to sort and then checks the value in the combo box and sets the value to the field. Here is...

Your ORDER BY clause needs to have tablename.Fieldname. I am guessing that you are just returning the field name. Try this: ORDER BY IIf(FORMS.[CARCASS FILTER].OPTION1=-1,"Tablename." & cstr(FORMS.[CARCASS FILTER].COMBO32),""); GumbyD

Garyj - It looks to me like you are tracking each day seperatly and not blocks of days (I noticed that you are just tracking date and not startdate & enddate). Because this is the case to find out if you have 5 consecutive days you will need to look at the seperate records grouped by empoyee...

You should be able to re-size them just like an excel spreadsheet. Go to the point between the rows or columns and then you should see an expander. Just expand it to the size you want. If you save the form then the size you left it on will stay in place. GumbyD

Odd that you should ask this question as I just created a query like that for one of my clients. You must work at a finanicial institution - What software are you using to track absences? GumbyD

Put it in the the field area ClassYear:CINT([dbo_ALUMNICLASS.CLASS_YEAR]) If this does not work I would bring the data locally. IT jobs in Denver are still pretty tight. I have had a few friends that are now starting to get decent jobs again. It looks like things will get better pretty soon...

One other thought that just occured to me. When I have delt with tables from a SQL database in Access. Sometimes I will make a local table out of the data by utilizing a make table query. Then I will try what I was doing with the linked table on the local table to see if the problem is with...

Sorry - When I copied and pasted I got the wrong field. Try this: Cint([dbo_ALUMNICLASS.CLASS_YEAR]) The cint function will convert the field to an integer value which you should then be able to get the min value of. I think the problem you were having is that Access could not resolve the...

You can try putting the expression: Cint([dbo_GIFTPLEDGE.GIFT_DATE]) instead of just the field that will convert the data to an integer and then you may be able to get the min or first on that data. GumbyD

What is the datatype in SQL of the ClassYear field? It may be that it is a text value and that is causing the problem. Is the data for that field "1999" or is it an actual date or a number? GumbyD

The SQL you posted is just a select query. Does it run as a select query and the problem only exists with the totals query only or does it lock up in both cases? Do you get a timeout message or does it just never come up? GumbyD