Search results

Thanks for the feedback Pat. Right now I am just trying to get this thing to work. Then I will go back and edit it. These statements are still not working!

hey there...thanks for the reply but I keep getting the following error: Compile Error: ByRef argument type MisMatch Can you help me?

Urgent help needed! Hi there, I am new to VB and Access and I have the following problem. How would you store the results of a qdf as a variable. I need it for a where condition when I am trying to open my report. this is my code for the qdf (I am not sure what the item in quotations on...

How would you store the results of a qdf as a variable. I need it for a where condition when I am trying to open my report. this is my code for the qdf (I am not sure what the item in quotations on the last line does) Dim dbs As Database, qdf As QueryDef, strSQL As String Set dbs =...

Hi Wayne...I tried it but it did not work. I am not sure If I am using this right! I will post some of my code and maybe that will give you a better understanding of what I am trying to do. If (IsNull(Forms!FullCompoundDataElementsReport!Combo69) = False) And...

thanks Wayne...I will give it a shot and let you know how it turns out.

Hi there, I have a form with two comboxes. The first combo-box refines the selection in the second combobox. Now I also have a button that generates a report based on the second combo-box. However, that report only comes up with one of the items in the second box. What I need is for it to come...

how big is your database? if it is pretty small, zip it and post it...then I will get a better understanding of what you are saying

could be... is that unique field on the form retreiving a number or text?

Hey there, I am not a very experienced VB programmer as some of you guys out there and I really need help with this one. I am trying to open a report and this is the code I got. DoCmd.OpenReport stDocName, acPreview, , data_criteria & criteria where data_criteria is one part of the where...

Got it Nevermind...I figured it out. Thanks to anyone who was going to help!

Hi there, I am trying to make a command button only appear when one or more of the checkboxes are clicked. I put this code in the Before-Update property of all the checkboxes but it is not working. Could someone please help. If ((Forms!FullCompoundDataElementsReport![Check59] = False) And...

Richo buddy... You are a genuis! thanks a lot! I spent soooo much time on this stupid thing. I sincerely appreciate this!

the answers to your question are: Yes, you understand what I am trying to say. Yes, that is where my question comes from. Yes, the code does work for one topping Yes, I thought about a multi-select list box, but that is not the way the end user wants the form to look like. Do you have any...

Hi there, Thanks for responding. There is only one value in the field toppings (Ex: pepperoni, onions etc). What I want is for the end-user to use the simple user-interface (form) and develop a report on a particular month of buisness. the user will also be able to create a report based on one...

what i got so far this is what I got so far. however this only works when I click one box at a time, not multiples. Your help would be much appreciated Private Sub gen_report_Click() On Error GoTo Err_gen_report_Click Dim stDocName As String Dim criteria As String If...

Hi there, I am having a lot of trouble with checkboxes. I have a form that will generate a report based on whatever the user selects out of a combobox (this works). However, the user can also select 5 checkboxes that will either select all the records or one of the records or two of the records...

Hi there, I am having a lot of trouble with checkboxes. I have a form that will generate a report based on whatever the user selects out of a combobox (this works). However, the user can also select 5 checkboxes that will either select all the records or one of the records or two of the records...

thanks for your help man. I managed to get it to work! :)

I now get an error saying 'object required' thanks for trying to help out man!