Recent content by b_c

yeah, apologies for the little info, i was out the door to dinner and just wanted to post something so i didn't forget. anyway, the update query actually calls another query that has a calculation. the called query takes a value from a form and subtracts that value from a RunQty to equal a...

yeah, apologies for the little info, i was out the door to dinner and just wanted to post something so i didn't forget. anyway, the update query actually calls another query that has a calculation. the called query takes a value from a form and subtracts that value from a RunQty to equal a...

hello all... ...i have an update query that seems sometimes to return a "blank" cell as the result. any idea what would be causing this? (if you need more info, just let me know) cheers, b_c

what about finding a more adept programmer than me for my program? i know it could be more streamline and whatnot, but how do i find an access programmer who's worth two shakes to look at my program (everything: tables, queries, modules, reports, etc) and "fix" it the way it should be or even...

so, i've been working tirelessly on a pos-type system for the last 10-months. i finally have it dialed in...but i'm looking to take it to "the next level". seriously, what are my options? i've heard about sql/mysql - how do these work? is it an "executable" file that's created by using this...

oh, followup q... ...how do you make a form "page setup" so that you have 3 columns instead of one in that continuous form?

think i figured out something...let me know your opinion. have the query created to limit choices in the backend...the form is a "continuous" multi-item form in access2007. i deleted all fields that populated through the except for the "invName" field and the "invID" field of which is...

i'm still interested in hearing anyone's ideas on this. i have the query...just need the logic for the form to populate buttons based on the results of the query...i.e. runqty > 0 anyone wanna help a good guy out? cheers, b_c

#3 ...so would it be better if i had a table per LOT? like i said, i thought i had a grasp on "normalization", but i guess i'm boogering it up somehow. ...and i think you're right glax...i have a feeling this won't be the "last request" lol...:eek: any guidance would be appreciated. if i...

i see what you're saying...i'm willing to learn if you're willing to teach... 1. i'm not against using vba 2. i'm open to another way for maintaining stock qty's 3. normalization? i understand it (or i thought). what's a better way? thanks, glaxiom... regards, b_c

alright... ...by now you probably have guessed (from all my other posts) that i'm building a small pos system for a friend that talked me into it w/ some scooby snacks. anyway...he had one last request: he has the same product set up at 3 different registers w/in his store. for security...

mstefansen, mind if i ask for a sample of your coding you are using to communicate w/ the com port. i have a com port peripheral that i need to send/received information to/from and i'm looking for some sample code to accomplish. the interface is preset to communicate using the following...

alright...here's a variation i just can't wrap my head around... i can pull up a day's records w/ the DateValue(date()) function... ...i can also pull up a specific date that's hard coded into the new datevalue column of the query criteria. but when i ask a user for their input via a...

that post was very useful... :D ...dang DateValue() !!

hello... i have a report that's built on a query. one of the fields in the query happens to be a date that i'd like to use to "filter" the report by... ...everytime i either try to apply a [RegDate] = Date() (...even tried = Now() ), it blanks out the report. if i do not apply the...