Search results

hi plog, when i use your code i get an error Dim BodyParts = "Eye,Uvula,Knee,Coccyx" ' The global BodyParts variable should like like the above--all body parts seperated by commas

Thanks Plog for your quick responce, give me a couple of days i will get back if i can get it to work, plus have alot of trouble with internet, provider has gone on holidays no access.

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 Guys, thanks for your replies, this is the SQL that i entered into the form combo box SELECT DISTINCTROW tblPortfolio.IDPortfolio, tblPortfolio.PortfolioName FROM tblStaff INNER JOIN (tblPortfolio INNER JOIN tblPortfolioAllocation ON tblPortfolio.IDPortfolio =...

Hi Guys, Sorry for the delayed response but had to go out of internet access for a few days. But this is my second combo SQL view SELECT DISTINCT qryStaffPortfolioAllocation.IDPortfolio, qryStaffPortfolioAllocation.PortfolioName FROM qryStaffPortfolioAllocation WHERE...

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, I have found out why I had this problem, In my query fields there were "staffID", "StaffName", "yearID" The Like [Forms]![frmStaffSelection].[cboStaffSelection] & "*" was placed in the "staffID" column and the form combobox referenced the first field which was the "StaffID", so when I...

Guys, Thank you for a quick response, I forgot to bring the database home it is still at work and i will not be back till Friday, I will send the results to you replies then many thanks Peter :)

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

JBH, thank you for your reply, with a bit of research and playing around i got the recordset to work just fine. thanks foryour time and help Peter :o

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

Thanks GinaWhip, That is what i was hoping for, thanks for your time.:)

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

EternalMyrtle Thanks for your help, i will try what you said and will post to the table forum. regards

EternalMyrtle Hi, I have converted the database hope it works.... Below are the details of the main form, subform, and the link fields Hope this helps Thanks for your time

Hi EternalMyrtle, Below is a copy of the data base, I am using Access 2010 with MS vista, if you open the "order" query, it will show you a list of only the products that need to be ordered, that is they are below their reorder level and the qty that needs to be ordered. When I open the purchase...

EternalMyrtle, Thanks for your reply sorry that i have not posted a reply sooner, i now your time is valuable, But i have been away and no internet, i will go through what you have said and will reply ASAP Jaymin

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, In a flash it came to me how to do this, Thanks anyway

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