Recent content by cmac2210

I am navigating through a few unbound forms using a global variable to get set the recordset. That in its self was difficult for me to grasp at the begining, but now I realize that you can use Querydef to do much thesam thing. In your opionon, which is the best or most efficient way to do...

This is what I am unsure of. I have never built a public function, so I am a bit unsure of how to proceed. Would it be something as easy as this? Option Compare Database Public Function acc() acc As String End Function If the above is correct, how would I get this to work accros the...

I need to declare a global variable so it can be used by several forms. The forms will open another form, tied to the record. I was using something like the following to put the data into the sql query, but now that the project has grown and additional functions need to be added, this form...

Yes, that is exactly what I meant! Thanks.

I ended up getting it to do exactly what I wanted to with this little gem. I dont know why its different then the one you guys suggested, but like I said its working. DoCmd.RunSQL "INSERT INTO tblremove SELECT jonesy.* FROM jonesy WHERE (((jonesy.remove)=True));"

I know that this is more than likely very easy, but I can not seem to get the language right. I am trying to append all records from table 1 where the feild closed in table 2 is checked. I can get the append to work using the query generator in access, but I am trying to minimize the use of...

Is it possible to pass a number from a textbox into a TOP clause query?

Thanks for the help! I was able to figure it out. I guess the query saw the textbox as literal. I got it to work by changing the chr(34) to ' on either side of the items and then passed it to the query as a string, not the textbox. Its working a treat now!

That is working great for setting a the list into the textbox! Now for the second part... is it possible to pass this list ("Item1", "Item2", "Item3") to a query to create a table populated with only the values from the list? I have been trying to get that to work with no luck. Any thoughts?

Thanks... Private Sub Command28_Click() If Not Me.Text26.Value = vbNullString Then Me.Text26.Value = Text26.Value + Chr(34) & "OR" & Chr(34) & Me.Combo22.Value Else Me.Text26.Value = Me.Combo22.Value End If End Sub Private Sub Command4_Click() DoCmd.RunSQL "SELECT *...

All I have a textbox that contains values seperated by a comma (exampel: tree, boat, house). I am trying to do an sql query that builds a table from another table only if the record has either of the items listed in the field. If I have only 1 item in the text box (boat), the table is built...

Experts Here is what I have currently going on. On my form there is a list box (multiselect) that creates a criteria that is passed to a query. The problem is that I dont like the way the form looks with this huge list box. I would like to replace the listbox with a combobox and allow...