Recent content by fredp613

Hello, I'm currently creating the finishing touches a database i've been working on for a while now. I created a search form that I believe is very user friendly thanks to Allen Browne's tutorials. I ran into a small issue however. When searching fields in my form that are foreign keys, it...

Hi Ceinwyn, before I send you the database, I have to let you know that mine is research one and may not be useful to you. But I can assist you with constructing it. Before I do that however, did you ever check for access 2003 templates on the microsoft website? When I first started using...

Re: Creating Listbox into "search form" that generates query - see code - almost ther Hi, I hope you can help me with this again. Everything we spoke about works perfectly, however I still cannot pass the OR criteria using the vb code below. The LIKE AND works perfectly for the data that is...

Re: Creating Listbox into "search form" that generates query - see code - almost ther Thank alot, works great!!

Re: Creating Listbox into "search form" that generates query - see code - almost ther I seen that as well in my research, but lets say I have multiple Listboxes, how would I modify the cmd button code to pass 1 query on all the selections I've made from each listbox?

Re: Creating Listbox into "search form" that generates query - see code - almost ther Thank you! that worked great. Now i'm almost done, I hope you don't mind, I was going to ask you another question. I'm getting other help on this issue but it seems like i'm on the right track with you...

Re: Creating Listbox into "search form" that generates query - see code - almost ther Done, now the only thing I'm having trouble with is the SQL statement: ' Build the new SQL statement incorporating the string strSQL = "SELECT * FROM Master " & _ "WHERE Master.ValueTypes IN(" & strCriteria...

Re: Creating Listbox into "search form" that generates query - see code - almost ther I think i'm close, I'm still getting an error though and I know its because of this line of coding: ' Build the new SQL statement incorporating the string strSQL = "SELECT * FROM Master " & _...

Thanks for letting me know! would you know anything about passing multiple selected listbox values into a query? Currently I have a listbox where the user can select multiple items and a command button that passes those selections into a query however as an IN criteria, im looking for a LIKE...

Hi, the database Is a bit too big to post on this forum, if you want I can send it to you by email (in a zip file).

Creating Listbox into "search form" that generates query - see code - almost there Hello, What I would like to do is create a new form which will listboxes that will allow the user to pass their multiple selections into a query. So far I have the following code however this code generates an IN...

Hi, thank you for your reply. Actually, after some research I managed to find the proper VB code to pass my multiple selected items in my listbox to a table for each ID. Now what I would like to do is create a new form which will have the same listboxes that will allow the user to pass...

Hi, I was hoping someone could guide me on the right direction. I created a database that allows users to enter research data. The users enter the data via a form I created. The form is bound to a master table and each control in the form is bound to either a field inside the master table or...

Thank you, that did the trick!

Hi, I created a similar database. In this example, you would need preset tables that all relate to one big "Master" table, you would also need a "master form", a form for each preset data table, a subform in the master table that displays the activity of the order, and command buttons on the...