Search results for query: *

Is there a way to sort by a Calculated Field in the Group by Header. When I try this, it keeps telling me you can not sort on aggregate fields? What can I do?

Hi, I just upgraded from excel 2000 to 2007 at work. Many of my macros display this when I run them - "not enough resources to display completely" All macros worked fine before upgrade. Example of a macro experiencing problems: Sub one_page() Workbooks.Open Filename:= _...

I need a field to say Bank 1 if opt 1 is selected or bank 2 if opt 2 is selected. I can not seem to get this to work. Private Sub txtwho2_BeforeUpdate(Cancel As Integer) If optwho = 1 Then txtwho2 = "Bank 1" Else: txtwho2 = "Cardella" End If End Sub Thanks for any help

I have a problem that I having trouble resolving. I need field 1 to be updated based on multiple criterias. If field 2 is null set field 1 to off if field 1 = a hyphen '-' And if field 2 is not null set field 1 = to the value of field 2 that is not null. Is this possible? Thanks, Joe

I need a formula to first look at a cell in column A and to decide if it is greater than today's date to place a null value in the cell right off the bat other wise continue on with the formula. Example which does not work...

How do you schedule an autoscript to print to specific printer? Thanks!

Hi, I'm unable to report time over 24 hours such as 37:20:00. This is an reference to a field that is in seconds. I tried this function ss: 24*Int([SumOfScheduled])+Format(([SumOfScheduled]),"hh") & Format(([SumOfScheduled]),":nn:ss") and it did not work. For ex. I had 134400 in secs and the...

Hello: Does anyone know how to display -120 seconds to -hh:nn:ss format? I used NStart: Format([SUMOFSTART]/3600/24,"h:nn:ss") and this only reports a positive time value (00:02:00). How do I get the - sign in front? Any tricks that anyone knows? Thanks, Joe

Is there a way to have a subtotal formula not include zero or null values? I'm using this basic subtotal formula that is connected to a auto-filter list. SUBTOTAL(1,C5:C366) Thanks for any help. Joe

Hi, I have an Unbound Update/Edit form that Does not allow me to update with null values. I only have two required fields. Any suggestions appreciated. Code: Private Sub cmdSave_Click() '**** Save Changes **** Dim db As DAO.Database Dim strSQL As String Dim dte As Variant...

I have a record input form that includes a combox box that filters for a record for editing. If I select a record from the combo box make my changes and click the save button everythings fine. The problem is when I go to select that same record from the combo find box, I receive an error...

How can you check for Dups with an unbound form. For example, I have a field called File#. I do have the field in the table set as a primary field, but I want the form to alert the user that this entry contains a dup right off the bat. I read on here that Dlookup is the way to go, but I can't...

I want to update data in a field from one table with data from another table. I tried something like this which gave me an error: UPDATE 1stDump SET NewTeam = (SELECT [NewTeam] FROM NewTeamName) WHERE PP_Number in (SELECT [PP_Number] FROM NewTeamName); The field I want to update is NewTeam...

I'm trying to make this IIF function work with no sucess: NewTot: IIf([StatTotal]="",0,[StatTotal]) It gives me blank for the nulls and #Error for what I want StatTotal value to be. Thanks, Joe

Hello, I have an form (which uses unbound fields) I use to Add, Update and edit records in a table. I got the Add and delete buttons to work, however I am having problems with the Edit/Save button. Example: there is a data field which may or may not be left blank. If you are editing another...

I have a form that you can add and edit records. Part of the edit record code keeps returning an error "syntax error on Update" here is a piece of the update code below: strSQL = "UPDATE tbloutbound " strSQL = strSQL & "SET Call_File_No= '" & Me!txtCallFileNum & "'" strSQL = strSQL &...

Hi, I need to import the first sheet in all excel files from 12 separate folders. The range that I will need to import will match all field names on the table except one. The last field name will be a date field that I want to populate with the date on the file located on cell m3. Is there a...

Hi, I keep getting a missing operator error from this query off my add button when I try to populate form data into a table. The error seems to around Vendor Code: DoCmd.RunSQL "INSERT INTO tblInbound_Sales " & _ "VALUES (" & _ "'" & txtCallFileNum.Value &...

Hi, I have about 20 yes/no check box fields that I need for calculating an average for a field called score. If each check box is checked it is assigned 10pts els 0 points. Is there any example out there I can follow. I keep coming up with errors in the score field. Thanks for any help.

Hi, I have a form that is a parameter date form query that lets you pick your start and end date then run the query to receive results. Everything seems fine except the Report footer keeps returning an #Error for several calculated fields. For Example, I have this calculated field...