Search results for query: *

I HAVE JOINED THE MANAGER TABLE TO ORDERS AND THE SUPPLIERS TABLE TO ORDERS ON A 1 TO MANY JOIN-THE FORM IS NOT BASED ON A QUERY

I have 3 tables-1 which i want to record manager details in, another which i want to record the account detail on and the other which will record the order details and another that will record the supplier details on-I also have 2 other table which provide the manager's name and the other which...

I have made a form through the wizard but when i come to input it states my Orders table is not in the recordset. Any Clues whats gone wrong Kaz[bigcheeks]

I have 3 tables has follows TABLE1 orders id(PK) kiv:Req No/PO no/Inv No Req No are the same no. Req Date Req Amt Date to Procurment Planned Delivery Date Purchase Order No PO DATE PO Amt Month To Acct All Po(s) recd & Inpt(Y/n) Cleared(y/n)...

How can I hide then unhide my combo box named All paymts rep by Invoices . If the user selects a Yes in combo box Cleared and Combo box Order Paid Status is marked with a Yes then i want the All paymts box to appear on the form. If the cleared and order paid status boxes are null or no then All...

I have an Orders form with 3 Yes/NO boxes box1-called-PO Recd & Impt box2-called-Cleared box3-called-OrderPaidStatus If box 1&2 marked "no"-report to show Req No If box 1 marked No and box 2 marked "Yes"-report shows Purchase Order Amount If box 2&3 marked Yes then hidden...

I have a form which as two yes/no boxes.1 is called Cleared and the other called Order Paid Status(OPS). If the cleared box and OPS box is marked yes I need another text box to become visible on the form for the user to complete Any ideas on how i set about this Thanks in anticipation Kaz...

i NEED TO PRODUCE A ORDERS REPORT THAT ASKS THE USER FOR BEGINNING AND END DATES,THE MANAGER AND THE ACCOUNT.i THEN NEED IT TO PRODUCE ALL FIGS'S DEPENDANT ON which YES/No box on a form has been completed. I am a Novice-So any help greatly appreciated Please Help if you can Bye for Now

I have inpt the following code in order to get a conbo box selection to complet two other textboxes on my form Privat Sub First_NameTxtbox_Afterupdate SurnameTxtbox=DLookup("[LastName]","ManagerTable","First_Name = "&First_NameTxtbox) DoCmd.Close...

In anticipation-A big thanks-First i have no idea about VB. I have 1 combo box and 2 unbound fields-the combo on drop-down shows 3 columns showing 1st and last name and a account number. On selection i need it to place the last name and account no into the other 2 unbound text fields to save the...

Complete Novice-I need a report where the user will select say a manager name and his/her costing no and account code and dependant on what the selects a report showing these details between a start and end date(input by user) is produced? The report figure produced is dependant on either of 3...

Should I set this up on a Button on a blank version of the form or can the button be added to the input form and users just type their criteria into the text boxes. PS-New to Access and vb NOVICE. Sorry to be a bleb!!!

Hi PShpt, any chance you can send me a copy of the sample My address is Malta393@Hotmail.com Appreciate any help offered cheers

I,m not sure I have explained myself correctly. I have a form with the fields first name,surname,dept on a Orders form. I want the user to select the first name from a combo box and the surname and dept automatically be filled in so the user does not have to type in these details on the order...

I need a search tool so users can search any field on a form for whatever they have typed. The Result x amount of records shown that match Or Is there a way the Find/Replace tool can be applied to a field on a form Help Please

FORM:I need a Combo box that when selected fills in another field on the form e.g First Name(combo) Selected First Name :Bob Fills in Surname Field Automatically Any Ideas Cheers

My users want the facility to do a search on each field on their input forms bt typing in text,numbers etc and it answering with the records that match and telling them how many records meet their input Any Clues on how this can be setup on a form?? I am at a loss Will someone save me---please

Can anyone tell me how to set-up a combo box which when the field is selected automatically completes 3 other fields related to that selection. e.g Combo box:First name when 1st name selected Surname and Dept is completed automatically-so the user doen't have to type it in? Any Help very much...