Search results

Hi, I'm trying to create a report which when run loads a filter which is passed in through the docmd.openreport command. it works fine if the filter has only one criteria. IE Date Between ## and ## BUT if i enlarge the filter to contain two criterias IE Date Between ## and ## AND Date2...

Hey, thanks for the info. I checked and all fields are exactly the same. yet it still won't work. I'll try playing around with it some more to see if i can get the fields separated at all?? ----- I created two tables separatly and just put in some junk text info. ran an unmatched query and...

Hey, for whatever reason the find unmatched wizard will not work for me when trying to setup a query. i have two tables - one table gets updated all the time so i have to use another table with all the part#s in it. when the 1st table gets updated i want to search for part#s which are not in...

Pat - I can't use the footer b/c i need the information to show up in a listbox - i want it all together. Rich - yes they do have a sequential id field - i think i tried making a query that didnt use that field but then i still get the wrong information somewhere. its bin awhile though ...

Hey HeatherE, The only way i could figure this one out was to record the total - which is annoying and not the most reliable. but its the only way i could get it to work the way i wanted. no one ever posted a way to fix this nor could i find anything else on the net. it sounds though you...

Not a dumb question at all - but a dumb answer = no i didnt even think of that option! just tried it and i got the results i wanted! =) but i still have a problem with the next page. when it goes to the next page it will show the duplicate information just at the top of the page. i can...

Hi there, I have a report which lists a lot of redundant information. In order to have all the information on the same line I cannot use any grouping with different headers, in the report, but I also don't want to show that redundant information. So I wrote some code in the detail section of...

just a total at any given time. so if the form is reloaded or an item added/received etc... it will be totaled and displayed to the user - without the need to store the # have u any ideas?? Topher

hi there, i have been trying to create a query that will give me a running total for purchase order quantities. i am using two tables. one which has the item on the purchase order and one table which has the recieve info for that item. each item can be received multiple times thus multiple...

Hey there, im not if this helps but i know if access 97 there are some options for referencing files and addins. maybe the required dll u need is not referenced to the access db u are you using therefore resulting in the error?? in acc97 u get to the references by opening up a vba code screen...

Yep your right it wasn't workin b/c of the end sub. but it still wasnt workin even when i put in exit sub. after i put the colon in it worked fine..... Thanks for the explanation though - Topher

That Seems to have worked! Thanks! funny thing is though, in other programs i've never used the colon on the On Error portion and it works fine...... - Topher

Would anyone know why the code for error handling does not work?? ie: Private Sub Command1() On Error GoTo Err_Command1 DO CODE Exit_Command1: End Sub Err_Command1: Msgbox err.description Resume Exit_Command1 End Sub I've used this code before and it worked fine but now it will not...

I have a question for you (or anyone) the code you suggested above - it works for me in other programs. But one that i am workin on now, none of the [On Error Goto ...] statments work. I keep getting errors that they are not defined, or are not the same name as the event and yet they are...

have u tried using recordsets and a for..next loop?? i've done something similar using code something like this with rst 'where rst are the checked records you want to compare .movefirst do until rst.eof varCompare = ![CheckedField] with rst2 - where rst2 are the...

Have you tried setting up the Child and Master Link fields on the subform properties?? if you link them together with the ID field whatever Order you are on in the main form will bring up all rec's associated to that ID in the subform. does that help?

Hey there, I'm trying to do something similar. I've been tinkering with some code which works in one program but not the one im working on. It loads the data associated with what item a user selects from a ListBox It is as follows: Dim varSelectedItem As Variant Dim frmItem As Form Dim...

Thanks Guys - this helps alot!

Hey there, does anyone know how the tabcontrol onclick event works?? i've set up some code in the even but when i click the tab i want the code doesnt run - i dont even think its looking at the code at all. - Topher

Hi! Im using the Treeview ActiveX control in order to display a hierarchy scheme. Im using a loop to go thru a record set and display the part descriptions. it works fine until i get to a certain point and i get a "Index Out of Bounds" runtime error 36500 i think its because i have too many...