Search results

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.

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

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

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

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

I am trying to open up a form depending on the expiration date. I was opening expired record and due date that was [expiration] <date(). What I need to do now is give the expiration a month early. Ex: If the due date is 07/01/04 then I want the record to show on 06/01/04 to prompt payment one...

I have two fields Complete Date and Status. If the status is changed to Complete then the Complete Date will fill in with today's date. Any Solutions?

I have a form for evaluating our cleaning service. If the services total score is below 90% then it only gets that percentage of payment. If it is any where in the 90% range then they get full price. Is there any way to write an if statement saying If <90% then ContPrice * Percent, If >= 90% Normal.

I have searched and did not find an answer. Does anyone know how the switchboard manager works? I would like my switchboard to flow like the one that access makes. My swithboard has passwords and graphics and I cant figure how to incorporate them into the access made swithcboard.

First post so follow me on this one. I am working on my purchase order form. If the employee needs the supplies ASAP I have an "urgentdate" field (date&time). If this field is filled then they have to explain why in the "emergency" (memo) field. What I was attempting to do is when the employee...