Recent content by KellyNewUser

The purpose of the database is for all the employees of a pharmacuetical company to be able to search through all the drugs we produce that have similiar characteristics. I use the ndc number and productname as example fields. But there will also be characteristics such as shape of the pill...

Okay, I have gotten each of the NDC_Number and the ProductName to produce the correct results if they are run individually in a new query.(ie NDC_Number has a value but ProductName is blank) The problem is when they both have values in their fields. Nothing is produced for the results. Also the...

When both of the fields were left blank it returned all possible results, as it should. When both fields were filled in it returned nothing and when only NDC_Number was filled in it returned nothing. Kelly

That was great. I no longer get an error message. Now the only problem is that nothing shows up in the resulting browse_products form. Any idea why? You have been awesome with all this. Thanks, Kelly

SELECT products.* FROM Products WHERE (1=1) AND (1=1) SELECT products.* FROM Products WHERE (((Products.NDC_Number)= 005915430)) AND (1=1) SELECT products.* FROM Products WHERE (((Products.NDC_Number)= 005915430)) AND (((Products.ProductName)= 'Allopurinol')) I hope this is what you...

I altered the code like you told me to. Now the browse_products form opens but it is empty. Also if there is anything in the NDC_Number field I get an error that says "You canceled the previous operation". Let me know what you think. I really appreciate all the help you have given me with this...

I inserted the code you gave me and ran it again. This is what showed up in the Ctrl-G window. SELECT products.* FROM Products WHERE (1=1) AND (1=1) SELECT products.* FROM Products WHERE What are your thoughts? Kelly

Okay. This is the code as it stands. It seems to be having a problems with the Forms![browse_products].Form.RecordSource = sSQL line of code. Also when did the print sql screen it returned the code SELECT products.* FROM Products WHERE let me know what you think. Kelly Private Sub...

Thanks! That got rid of the error. Now I am not getting any results. The "browse_products" form is opening with nothing in it. Any ideas why? Kelly

Hi, I am trying to create a form with multiple criteria. I am adapting the code below from a tutorial. I am getting an error for "Syntax error in From Clause". Can anyone see a reason for this. Kelly Private Sub Command19_Click() Dim sSQL As String, sLen As Integer sSQL = "SELECT products.*...

I am new to access and I am trying to create a form to identify a medication by the color, shape, active ingredients, etc. I can create a query for the color and shape individually, but I want them to be all on one form. I want all queries that are answered to combine their information to create...