Search results

i have a command button, and i need it to close not only the form but close the whole application (access)... thanks for your help

i seem to be having problems with a dsum which is in a subform. the layout of my database is as follows: all forms are subforms on the switchboard. each subform is located within a tab. in the order form i have a dsum formula...

can anbody help me with this form... its the order form but looks too complex. how can i make it more simple? i need all of the fields that are present and its causing me a problem as its to complex. thanks!

hi i have a fairly complex problem which probably has a really simple answer, but i cant figure it out. ok..i have a switchboard, in which there is a tab. each page in the tab has a subform. the thing i need to happen is when the user clicks a button on the switchboard, it goes to a new record...

im creating a search form, where the user can search for customers by their ID, first name and last name. i have a option group at the moment, consisting of 3 options..Customer ID, LastName and FirstName. if CustomerID is sleected i want the systsme to search for the ID only...simelar to if the...

hi iv built my form with a tab on it. it has several pages. but i dont know the code to go to a certain page once a button has been clicked. anyone have any ideas? thanks!

hi, i was just wondering how i would go about making a splash screen for a dtabase im making... i have no idea of how to make one...the access help is no good. thanks in advance!

hi, i am adding a search form to my database. i need to be able to search for a customer--by ID or by surname, and also search for the invoice....again by invoice ID, or Customer ID. the thing is i have no idea on how to go about making the form, to make it as easy to use a possible, minimising...

hi im having problems with a subform... i have the subform in an order form for which u can add many products. each product has a stock number which must be changed when an order is added. for example order 1 product id= 1234 quantity = 2 stock = 8 because the subform can contain multiple...

i have a series of combo boxes on a form for which 2 need to be disabled.... combo 1 has to be entered in order for combo 2 to display its contents, which in turn is needed for a list box to display its contents. i need to be able to disable combo 2 until combo 1 is entered, and list 3 until...

=Sum([txtSubtotal]+[txtShippingCost])-[txtDiscount] i have entered this code as the control source of the field "GrandTotal" on my invoice form, for some reason it displays #Error. i have tried everything i can think of but cant get it to work? thanks for your help.

i dont seem to be able to drag fields in a form onto a tab control. usually when you use a tab control it is highlighted, but i cant drag fields onto it. is there any way of doing it?? thanks in advance.

i dont know if u recall, but you helped me with sorting the size of products problem out. but now another problem has arisen... keeping track of stock. i have the 2 tables -- tblproduct productID sizegroupID ect... tblSize SizegroupID sizetype sizegroup how can i keep track of the stock of...

hi i was wondering how i would go about making sure that credit card details can be kept secure in access? i have a credit card table which stores all details of credit cards but i need to secure the data, can this be done and how??? thanks for your help!!

i have a ProductTable which includes various products of different sizes. the only thing is, if one item comes in many sizes (S, M, L, XL) what would be the best way of representing this in the table. at the moment i have each product with each size EG LIV001 - M Owen T-Shirt - Size=M LIV002 -...

Basically i have 2 tables... TeamTable: TeamID, TName, TCountry ProductTable: ProductID, TeamID, Cost ect... what i have so far is a form in which the user can create new products using information in the team table. so what the user has to do is enter the teamID(Producttable) for the TName...

i work for a company which sells sporting goods. these can be ordered online. what i want is a system, which will allow me to put orders submitted from the web into the database>>> Product details, credit card details ect... At the moment we have to manually print out each order which is eating...

hey, how can i refresh a field, containing a DSum expression so that as i change parts of the form which dertermin its value it updates. the thing is it calculates fields in a subform, and i cant get the DSum field to refresh as i change values in the subform. if that makes sence to anybody is...

i was wondering how a database can capture information which is sent from a website. for example, when a person orders something, their details are automatically entered into the database. is there any way of doing this? at the moment the website is using securehosting.com to store the orders...

i have a listbox which contains a large amout of products and i need to be able to show a sample for when each is clicked. so for example, when the item LIV001 is clicked in the listbox, i need a picture to then show the corresponding picture. but then if the item NEW002 is clicked, i need that...