Search results

thank you very much, very grateful.

Well of course, but with access 2007 i cannot for the life of me find out how to view the macro code that is created. it uses a macro but you cant view the code. lhowever, that is irrelevant, ike i said though, the macro for that particular button would use access standard messages which i do...

Hi, im looking for a generic delete code to use with my systems. Basically; User presses command button, Access asks whether they want to delete record (with a custom yes/no msgbox as opposed to the built in access one)? then if yes, record is deleted and a message saying "record deleted". or...

hi, yes i have looked at using a query, but i found that until you enter something into the text box and press the button it doesnt show anything in the list (isnull). i havent used the Like function in a query, but would this allow all records to be shown on form load and the user to search...

anything guys? im sure you can do it or something similar?

hi, i have a simple database storing customer information. i currently have a search page with a list box on it which lists all of the customers held within the database. now what i would like, is to have it so that when the form loads, there is a complete list of customers, and then if the...

i remember reading it somewhere, and there was a lot of detail about (this was a few years ago though so not exactly up to scratch). i will have a look through those searches, however i do know they give up pre-big bang. for the record im an aerospace engineer and like i said above, an atheist...

if man has free will to choose whether or not he believes in god or not, then that is a free choice each person makes. however, it isnt a free choice is it? you are told you either believe and submit to god and go to heaven where you live happily, or you dont believe and end up in hell...

hi, sorted now, incase anyone else needs it, it's simply: = date() - (1) jared james

hi, i have a simple form with an unbound text field, which is used to input the date criteria for a query. i want it so that next to the box there would be two buttons for "today" and "yesterday". when you press today, it inputs todays date, and if you press yesterday i want it to input...

hi, i have a query which retrieves data on products. my problem is how to display a specific total i need. there are three fields; [itemprice],[itemlabour],[itemdiscount] the item price and labour columns are in currency format, but the discount column allows the user to select a discount...

isnt there a simpler code that could be used? i dont really want to be doing all that for such a simple operation, particularly when im not that good with coding.

hi, i have a form with three unbound fields, now i want it so that the user enters information into either one, two or all of them and then presses a button and it searches a table and retrieves the relevant data. basically; [invoiceid], [carregistration], [customername] the user can enter...

that code doesnt work, when the query doesnt have a value, the subform fields dont show and so the calculation box shows '#error'.

hi, thanks now im getting it, but where exactly would i put that? in a particular event command or in the part which says where the field gets the data? i really dont know where to put it. jared james

Hi, i know ive asked this in another forum, but i just read a thread on a query function which may be able to deal with this so thought id post it here: the function i just saw:- Expr1: IIf([Sold],="","0",[Sold]) this does nothing to help my problem though so any ideas? i have three fields...

hi, i have three fields; [boughtin], [sold] and [instock]. [boughtin] comes from one query and [sold] from another. [instock] = [boughtin] - [sold] because [sold] only has a value once an invoice has been created for that item, it means that if you try to view an item that hasnt been sold yet...

hi, where exactly would i place that? and what is my variant?

hi i have the following code, how do i 'call' it so that it runs to check the value? '***************** Code Start *************** Function nnz(testvalue As Variant) As Variant 'Not Numeric return zero If Not (IsNumeric(testvalue)) Then nnz = 0 Else nnz = testvalue...

i dont know how to call it