Search results

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

I am trying to track payments due. I have each account set up with a due date. If they are current i have no problem My problem results when an account is past due. What I would like to do is create a table that shows each month, year, quarter, etc. period that is due and then past due starting...

I am using the following code to make the duedate field on my report invisible if it is greater than firstofmonth field. Can someone tell me what I am doing wrong? Private Sub Report_Open(Cancel As Integer) If Me.[FirstOfMonth] >= "Date()" Then Me.[DueDate].Visible = True Else...

Rich I appreciate all your help, but I cant seem to quite get what I am trying to do just right. The textbox idea worked, but I cant filter the form to show me just the records that I want. The query worked, but it wont respond the way I need it to. I have the [expiration] box then the text box...

that works great. Is there anyway to run that in a query?

I dont know where to put that. I have two textbox. They are both controlled by expiration. One shows the expiration date and I want the other to show the expiration date minus one month. I found a whole bunch of different examples, but I dont know where to put the code in the textbox.