Search results

Hi Guys, :banghead::banghead: if i type into the criteria = "face" or "hands" or "feet" the returns are OK. and if i create a global variable and use only one of the criterias eg Bodyparts = "feet" and enter it in the criteria as Bodyparts() all works OK. but if i give the Bodyparts = ""face"...

Hi All, To me this problem should be easy but its got me at the moment. I have a form with two combo boxes, one has staff names the other has portfolios, the normal action is when you select the staff name the second combo only shows the portfolios that are associated with them. But what I want...

Hi all, Hope someone can explain what is going on. I have a report, that gives a result from a query which is filtered by a combo box. - Like [Forms]![frmStaffSelection].[cboStaffSelection] & "*" what happens is that the combo box has a list of names, when you do not select anything in the...

Hi, Hope i can explain what i want to do ,I might be just having a seniors moment. I am creating a log in form, it checks the user name which is unique. if the user has entered a password, it shows only one password text box, they enter the password, if it is correct they enter the database...

i am using vista and access 2010, what i want is to be able to email a report from access that was created by a form with DoCmd.OpenReport "ReportOrder", acViewReport. I have a button that when i click it it will send the report via email, but the email address has to be a varable so when the...

Hi All, Hope someone give me some help and/or guidance of what to do, as I am new at this. I am trying to create an inventory database for work which needs to track first aid products. I have three main tables:- 1, Products 2, Inventory 3,Purchase. By using a query I have been able to sort the...

Hi All, I am working with Access 2010, on vista. What I have is a query made up of two tables, one product the other inventory. (see below) In the product table i have a field called "minimum reorder level". In the inventory table i have two fields one called "number in stock" and "number on...

Hi all, I need a little help with form design, I have several forms where i enter information eg. a enter staff form, delete staff form. is the best way to have a seperate form to add staff and a seperate form to edit/delete the staff, or should i just have the one form that does the both. or...

Hi can anyone tell me if it is possible to remove an list item from a combo box list after it has been used. What I am trying to do is use a combo box that has a list of questions, after the user selects a question from the combo box list and answers the question when they reselect the combo box...

Hi all, Hope someone can put me straight, i have a form that has three cascading combo boxs, plus a subform. the third combo has a list of questions, and you put your answer in the txt box in the subform. What has to happen is that the combo box has a number of questions and each has to be...

I do not know if this is normal, or there is something wrong. I have a simple form with a subform, the main form has a drop down box which i select a name from the selected list, then i enter the subform it has one txt box which i enter data, i tab, and the focus is on a button on the main form...

Hi all, I have a form with two cascading combo boxes and a subform with a txt box, after you enter data into the cascading combo boxes the focus goes to the txt box in the subform, the data that is entered into the subform comes from serial numbers from two sets of clothing only four numbers, if...

i have a txt box which is a required field, i have a dlookup to check if this data has already been entered, if not it continues on if it has the focus is reset to that txt box, but the entered data is still able to be seen, is there a way of removing this data so the txt box is clear, i cannot...

Hope someone can help me, i want to get access to tell me who has loged onto the computer, i know in excel there is a code GetXLUserName this gives you there login name, Peter :)

Hope you can help,i know this should be simple but it is bugging me, I have a form with a two cacading combo boxes, i have a button to delete the record, filtered by the second combo box. i use DoCmd.RunCommand acCmdDeleteRecord when the button is clicked. it delets a record but not the one...

I have a form with a subform, when i finish entering the data of the last combo box of the subform i would like to have it tab to the exit button on the main form, it sounds easy but i am having alot of trouble doing it, can anyone suggest something for me please. I have looked at the syntax for...

I have a form with three cascading combo boxes and data is entered via a subform, the third combo box will only ever have four entries in it max. i can fill the subform in, them requery the form and select another item from the third combo or exit the form. What i want to do is that every time i...

hope someone can help, I have a form with three cascading combo boxes and a subform, the third combo provides a bound field that joins it to the subform, i use this code on the "on change" event on the third combo box, Private Sub cboPPE_Change() Dim strFilter As String strFilter = "IDPPE = "...

Hope some can help me, i have read many cascading threads and tutorials and videos on the subject and still it does not work, My scenario is that I have a form named “frmMain” on it has three cascading combo boxes, the first named “cboStation”, the second “cboStaff” and the third is “cboPPE”...

I hope someone can help me, I have a form with a combo box and two subforms, the combo box has a list of names, when one of these is selected the first subform is populated with a list of clothing types that is related to the name selected from the form combo box, when one of the clothing types...