Search results

Re: need some help totaling a colum on a report figured it out thanks

Re: need some help totaling a colum on a report Sorry, yes the report opens but the data in the textbox reads #ERROR and that is it

I have a field called [Number of Children] on the footer of the report I have a undound box with this in the control source =Sum(Nz([Number of Adults],0)) but I always get an error when the report opens. why? please advise jon

I run a qry to create a report this works fine I get all the correct records but I need to total a few colums. Each record has "Number Adults" Number of Children" and "Number of Bags" at the bottom of the report I would like to total those 3 colums. I just have no idea where to start? jon

got it thank you for the supprt

I have 2 tables both tables have an autonumber field set as no duplicates and the aotunumber is the primary key. Table 1 has the customers and their personal info. Table 2 has the customers visit and purches information. I have a field in table 2 called Customer ID and this Number comes from...

I want to have a command button on a form (Monthly Report) user selects this cmd and a Month Calendar pops up so the user may select a month and then the query would run between the 1st and last day for that month. Has anyone seen something like this? I have been searching and finding alot of...

its close still having trouble. if I put this code in the OnLoad I will get the highest date enter into the table. Me.[tempdate] = DMax("[Dateofvisit]", "[table1]") when I add the customer ID I get a Syntex error (missing operator) in query expression '[customer ID] =' Me.[temp] =...

On a form I want to display the Date of the last time a customer has been in. The Form is bound to a table that has the records for every customer and the dates that they have been in to pick up. I want to have an unbound field that displays the last date. I have the customer ID i just dont...

I have a split database but it does not run like most. I do not have a front end on the users pc and a backend on a server. The users of this data base do not have server access while working at customer sites. So they send out files that get imported into the master database that remains...

This is what I have but it always returns the msg that the part is on the list. If DCount("[PartNumber]", "[Tble-Parts Lookup]", "[Partnumber] = 'Me.pn1'") = 1 Then jon

I have a combo box that is getting its value from a command button. After the value is entered by code I then have code running the AfterUpdate event. Now I also have code in the On Not In List and the property value Limit to list is set to yes. If I enter a value that is not in the list...

Well I thought I had it figured out but as always I have hit another road block. So I have the AfterUpdate code running but now my code of OnNotInList does not work. Infact it will allow the partnumber to be saved to the table even with the limit to list set to yes. So why does the After Update...

Got it That works well thank you jon

What do you mean by boolean? jon

Is there a way to set a command button up so that it can only be used 1 time per record? Kinda set a flag or something ? jon

Bob I think I have it working. Again thank you for the help. Looks like trying all the different things I ended up with this Forms_FrmAddingAllPartsviewer.PartNumber_AfterUpdate and all I need to do was drop the S Form_FrmAddingAllPartsviewer.PartNumber_AfterUpdate and now it...

not a problem Thanks Bob jon

ok I have slimed it down pretty far so alot wont make much sense but you can see where I'm stuck. If you open the dbase and open form Frm-Viewer from here click the command button "Add Process Kit Parts" This should open the form "FrmAddingAllPartsViewer" now click the command button "part1"...

Its pretty huge I will need to slim it down alot. I will see if I can. Also does it matter if the Combo box is a bound field? jon