Search results

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, 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...

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...

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...

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 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...

Hi, i have a form which shows stock levels. It works by the user entering a value and pressing search, then one query returns the data on the product from the stock table (so that it can be edited), and another query returns a "total of how many have been sold" in the form of...

Hi, i have a form which shows stock levels. It works by the user entering a value and pressing search, then one query returns the data on the product from the stock table (so that it can be edited), and another query returns a "total of how many have been sold" in the form of...

Hi, i have made many access databases which run on standalone machines and perform tasks such as invoicing, stock checking and various other tasks for businesses. My problem is, I have just been asked to allow multi user access to the system with updates performed almost instantaneously. Heres...

hi, when i press a button on my form to close it, i have told it to requery a combo on the form it opens over. the problem is it says i need to save the field before i run the requery command. any know how to solve this? jjames

hi, a user enters a word into a combo. a form opens to add the data of the item and is then closed. the problem is, the item doesnt go straight to the combo and keeps being flagged as a new item. i had it working just now butit has totally stopped so i have no idea. any ideas appreciated...

i have a combo which is set to limit to list. i need it set like this in order to get my code to work to add a new record. all i need to now is how you suppress the "item not in list" message you getif you type in a new value to the combo box. jjames

hi, i have a form which has a combo on it, and if the user enters data that isnt in the form they are given the option to add the item to the list. if they choose yes the addition form is open. is it possible to have the word the user just put into the combo box to display in the text box in...

hi, have tried this in queries but i think i shoudl have put it here: i have a query which when the user selects a value in a combo box it pulls up the other details of the item, such as price. i have noticed though that if i try and enter a new item into the list, through the combo on the...

hi, i have a query which when the user selects a value in a combo box it pulls up the other details of the item, such as price. i have noticed though that if i try and enter a new item into the list, through the combo on the form and then enter a price, it gives me error 3101 (something to do...

hi, i have two subforms on a main form, both have a total field on. i have set a field on the main form called subtotal so that its control source is =[frm_invoice subform].[Form]![Total]+[frm_service final subform].[Form]![Total] the problem is, when i start typing on the main form, the...

hi, i have two three tables linked, tbl_invoices is to linked to tbl_invoice details and tbl_service details as one to many relationships. tbl_services lists the parts and prices for use in tbl_service details. the probem is, when i open the form for invoicing which has tbl_invoice details...

Hi, i have an invoicing form which has two seperate subforms from seperate tables. one from tbl_service details and one from tbl_invoice details. tbl_invoice details is linked to the invoicing table and when delete is pressed, it updates both tables a appropriate. but because i cannot put...