Search results

Hi there, I have some code for generating reports that involve an IsNull Statement. I have 2 comboboxes that are in a if statement. The code should execute if Combo1 is not null and Combo2 is Null.But the wierd part is the code fluctuates. Sometimes it works when I have If (IsNull(Me!Combo1)...

Hey there, can someone perhaps explain this little problem to me? It regards an IsNull statement within an If statement. sometimes when I go... if (isnull(forms!formname!nameoffield) = true) then.... the statement works at other times, when I go if (isnull(forms!formname!nameoffield) =...

Hey guys, Can anyone tell me what is wrong with this statement? I keep getting a syntax error when the Record Create Identifiers are equal to 'johnsmith' and i get another syntax error when the record create identifiers are equal to something to something like 'John.D'Souza'. Your help would...

Hi there...just a quick question...I have about 20 fields in this form that I need cleared on the push of a button. Is there an easier way to doing this than to go Me.text1 = null Me.text2= Null . . . . . . etc.... Is there a Vb command that selects all the fields in...

Hi there..i just got a quick question....Normally Access saves all the fields on a form when you exit the form...Is there a way to make Access pick specific fields to save and not the rest? Any help would be appreciated!

hey there...this might be a newbie question, but can you build a form that links two tables without having the user enter a foreign key?

Hi there, I have got a form where I have three foreign keys in them. when I try to save a record, it gives me this error message. "The Microsoft Jet Database Engine cannot find a record in the table [name of table where the foreign key is being linked from] with key matching field(s) [name of...

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

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

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

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

Hi there, The code below takes an option from a combobox and puts it in a criteria for a query in order to filter it to whatever option the user clicks on. Could someone please help me to add on to the code so that if the option the user clicks is not in the query/table a message box pops up...