Search results

Practice by creating a test report using the report wizard, it would ask you what field to summarize. or check the sample northwind database, most of the reports have total/sum of fields.

If you have more comments or questions on why I try to complete code to the last detail even if I dont have too, please refer to post #4. If you have more nasty, sarcastic comments, really guys, dont you have anything else to do? Or is this a board affected by what's going in on London these...

If txtSearch2.Value = "" Then or If NZ(txtSearch2.Value , "NULL") = "NULL" or txtSearch2.Value = "" then I like using the one with the "NULL".... when I reread the code, its easier for me for me to remember what I was trying to do. I had moments of when I am looking back at my code, I...

I assure you that I know that. I spelled it out so if in the future he would want to use "false", he would have an idea. Thats how you teach, in details so next time they dont come back again for another question that should have been answered in the first response. Instead of correcting...

check datediff function. Calculate number of days from hire date to 1/1/2004 then divide by 365 days multiply by 100 (for the percentage)

if IsNull (txtSearch2.Value ) = true then --------------- Try to dispel spaces in your fieldnames if its not too late. strSQL = "SELECT tblMain.bkg no,tblMain.Surname,tblMain.TempName, tblMain.Department, tblMain.Taken By, tblMain.Reporting_To,tblMain.Start_Date,tblMain.End_Date "...

I need to show two decimal places on a form based on a recordset of a table that has a field - type = double, format = fixed, and decimal number = 2 I need to show 101.00 and 102.00 so if user insert a record, record would have a sequence id of 101.05. How do I create that field by code...

Report: You can based the recordset of the form on a query wherein the userid is linked to the current recordset of the form. Form: Have you tried can grow and can shrink? If that doesnt work, you can create a code, wherein you count the rows iof that recordset first, then set the form...

Thanks y'all. Very much. Will try. :D

got an array myarray(0,4) as variant. I want 0 to be a redimmable so I could go 0, 1 = a 0,2 = b 0,3 = c 0,4 = d redim preserve myarray(0+1, 4) how do you declare this array in the first place? isnt it supposed to be an empty parentheses -- () in declaration.

Thanks Doug. A lot. :), Will report you time later, still working on something else.

You want to pass these data (-1229999914,-9998452) to a query? and they are in a table?

I have a million record of a single field that has combination of funny characters and letters in it. I only want to pick out the Uppercase data. I dont want to turn them into UCASE. For example: {sectl}SECTION I<qa>\nPREFLIGHT (05-20-10)\ I only want 'SECTION I PREFLIGHT" Any ideas...

iif function

Create a crosstab query Video number........Title.........Cost(£) Groupby...............Groupby....SUM

did you hide the menu bar through a code or through the startup which can be access by clicking on TOOLS then startup? The default Switchboard does not contain a code that hides the menu so I am assuming you inherited the switchboard from someone who did the code. What is the name of your...

Northwind database. With the new version, you can choose a template of databases like Event Management, Time and Billing, etc.

Better to point. No big bytes.

why dont you create a new switchboard in another mdb and compare what code is missing?

DoCmd.OpenReport "SalesReps", acViewPreview, , "[salesrep] is null" End If DoCmd.SetWarnings True Me.Refresh ***[this one does not work. ]**** Your present object that has focus on is the report?