Search results

My apologies to every one I went back and checked my data and found the problem is week #53 in my query I group the records by week number so weeks that have a week #53 get missed and in some cases the data is mixed up. There is a bug in access 2003 with the date difference function as reported...

Hello all I have a report that uses a week number in the query to select the records for the week. My week is always Sunday through Saturday ( seven days ) I have a function that up to now has always worked well until this year. What I need is to have week one with any day of the week falling...

Hi all I have been trying to use one form for many different reports. The basic form "year selection criteria" is used on all of them. I want to change the caption and some labels for each different report. I have opened the form on the open event of the report changed the caption and some...

Hi there I have solved the problem myself. In the properties of the the report footer there is one that said keep together which was set to yes. I think access then starts a new page. I set this to no and it now works fine. vBob PS How do you mark a thread as solved?????

Hello All, I have a printing problem with a report that has a sub report in the footer. The sub report always starts on a new page leaving a large white space in the footer of the main report. It is functional but looks hellish. In the main report I have a list of items in the detail with both...

It worked great thanks for your quick response. Bob

Hello All, I have a report that by making the detail section visible or not changes it from a summary to a detail. I have an option group with two buttons summary value 1 and detail value 2 In the report detail On Format property I have the following code...

I have a main form with several with four subforms. On the main form I have a bound text box [ShiftTotal] I have on each subform a unbound text box that sums a field [ExtTaxIn]. I am working with just one subform till I can get it to work correctly. The code I am using on the after update event...

Hello I have a Main form with several sub forms on it the tables behind each form are related tables. The user enters data on the main form with the exception of one bound control then moves on to enter data on the sub forms On exiting the record or the main form I want to take data from several...

Hello all Thanks for all your help but did manage to solve my problem. I used Now() as the default value which gives time as soon as I used Date() problem solved Silly Me LOL

Hello all I have a query based on a table which has a date field. the field both in the table and the query have the time also in the date value so when I try to query on a date I get nothing if I copy the date and time from the field I will get the result for that record if I just use the date...

Hello thanks for the tip it worked Bob

I have a form with several command buttons to run reports. When I open the form I used the docmd.maximize and when I use the button to run the report it runs but when I close the report it returns to the form which is now sized not maximized. I want to have the form as it was before I opened the...

Hi here is a better description of the problem I open Frm_ShiftMain to a new record Date defaults to today Tab through the following adding data Shift, employee, tax On the main forms after insert event I insert data into the subform table ( it completes this o/k) I set the...

Hi may now be when i change to another record sometimes there are records you cant see unless you scroll to them with four subforms you dont know where the focus is thats the problem also some records may now be hidden giving the user the impression that they are not there. so when I change a...

Hi into thanks for the reply. There are two tables main has date shift employee the second table has products that are catergorized into four types of products. I use four subforms with queries so each subform is used to enter one catergory of product this works very well for user imput. New...

Hi I have a main form with a table as its recordset. I have four subforms with queries as there recordsets all quering the same table but four different groups of data. they are linked to the main form with child master relationship. This all works well in regards to data entry and saving to the...

Hello Bob thanks for the reply I have changed my design and have gone away from continuous forms. Thanks Bob

Hello Bob Thanks for the quick reply. I have tried what you have sugested but did not work for me. I am using continuious forms on all subforms and when I get to last record it stops and will not go any further so not sure where to go next. Thanks Bob

Hello all I have a main form with a tab control with three pages. On the first page I have three subforms each one has table linked to the main form. What I am trying to do is update one field in this table which I have the tab stop set to this field only. When I tab down the table on this...