Recent content by sandylt

Although it is based on a query, that wont work for me. If I set the query to 25 it only show 25 records throughout. I need 25 records per day. I can do it on a form, but It will not let me do it on a report. I need the first 25 records for each day.

Is there a way to limit the amount of records on a subreport. Sometimes I have more that 25 lines, however the records past 25 might be repeated for duplicate orders. I only want to display the first 25 and anything beyond that not show.

I tried that and it works, except the day doesnt hold. If I go to a new record the date does go to the next day, but when I add records and close. When I come back there are no records under that date. Also the query on the days wont work because it raises the day to a number that doesnt exist.

1. I have a form that runs by the date. I want the next record to default to the next date. For example if today is 03/08/2006 then if a new record is created the next date will be 03/09/2006 and so on. 2. If that is possible I dont want Sundays involved. We do not deliver on Sundays.

I want the query to return the results of all records that are for the next day. Sort of like =Date() +1 Please help

All projects will have a unique ID assigned by the autonumber function. The numbering system I would like to reorder will be a different field manually entered. Does anyone have any solutions? Would this be a table of forms question?

I thought about that. Any project that is been deemed inactive will never be logged again and is tracked by another query. I set this whole db up for them and this is one of the only things they say they need.

I have a list of projects that are broken down by location and status. Every projects that has a status listed as "Active" has a number that is manually entered in. When a project becomes inactive it loses its number. When that happens I end up with gaps in the numbers. Is there a way to reset...

Is there a global solution?

Where would I put that?

I have a score sheet with 43 categories. Each category has a combo box with a range of 0-5 or X. The number would equal face value and X would equal 0. The problem I am having is how to score it. I cant total the combo boxes because they are text boxes due to the use of X. The only thing I can...

I have an inventory subform using barcodes. The barcode is entered into the [Itemlookup]. Upon update [ItemUpdate] runs the following code: Me.ItemNoLookup.SetFocus DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdCut Me.ProductNo.SetFocus DoCmd.RunCommand acCmdPaste Me.QtySold.SetFocus This...

Works great Thanks

Looking for a way to sum visible fields only. Have five fields to total. Depending on code some of these fields are not visible. Is there a way to total the visible fields only?

#1 Need to find a way to make this code work. Can anyone help?? If Me.CurrentDue2 Between FirstofMonth And LastofMonth Me.CurrentDue2.Visible = True Else Me.CurrentDue2.Visible = False End If It keeps highlighting BETWEEN I guess this parameter is wrong does anyone know how to...