Search results

thanks for the responses Tim K and Wayne Ryan. tim i tried adding a message box in the code and it returned the following: SELECT * FROM [Master Table] WHERE [Master Table].[Unit Description] IN ('4', '6'); where '4' and '6' correspond to the position of the items in the list box instead of...

Hi everyone, i've been trying to create a multi select list box that passes the items selected as parameters to a query. i search the forum and found some posts related to this subject, but i could not understand them. i did some research and found a procedure that uses DAO to perform this...

i've just be searching the archives and found the following code posted by R. Hicks: Dim varItem As Variant Dim strWhere As String For Each varItem In Me![YourListBoxName].ItemsSelected strWhere = strWhere & "YourUniqueIDField =" _ & Chr(39) & Me![YourListBoxName].Column(0, varItem) & Chr(39)...

hi all, i'm trying to set up a parameter query from a form that the user can select multiple choices from a list box. basically, it's a form that the user ctrl+clicks multiple selections from the list box and then clicks on a control button that runs the query using the selections chosen from...

Thanks again for the response. your explanation was very clear.

Thanks pdx_man. that worked perfectly. could you explain to me why i need the "&" symbols. i understand why i needed the asterisks (*) before and after the reference, but i'm confused about the "&" symbols. also i'm not sure why i need the parentheses after the asterisks. for example why...

hello all, i'm trying to set up a parameter query that runs from an input form when you enter a keyword into a text box. basically, i have a field "[composition]" that lists a bunch of components such as C4, C5, C6,....etc. as an example, i'd like to have the user enter "C5" into the text box...

howdy folks, i been searching all over the forum for answers to my question, but i'm still a little fuzzy on setting my dbase up for multi-users so here goes. i would like to have my dbase located on the shared drive on an NT server and have multiple people be able to view the dbase at the...

i tried using the "or" scenario and it didn't return the proper results.

unique ID help hi all, i tried searching the forum using "unique" as my keyword, but i couldn't find an example directly related to this. could someone give me a little tutorial or suggest some sample code (and where to place this code) on how to do this. thanks everyone

hi folks, i have 2 fields [A] and [B] and i want to only display records which have values in either [A] or [B]. so i don't want to display records which are Null for both [A] and [B]. but, if either [A] or [B] contains a value i want to display the record. using a select query, i ran into...

hello all, i'm try to automate the task of assigning an unique ID based on selection criteria from a combo box. for example i have a combo box that list values: Ants, Bats, and Cats. what i would like to do is have the user select one of the values from the combo box and then access...

duuuh, i can't believe i didn't remember that. thanks rich. for some reason i was thinking i needed to build one query with multiple criteria to generate multiple reports, but it's much easier to use a separate query for each report. thanks again, rich.

Hi everyone, i need to build a query that will exclude records if a field within that record is null. basically if the record doesn't contain data for a particular field then i don't want the query (and consequently the report) to display that record. for example, i have 50 records and only...

thank you Tim that worked perfectly and your instructions were EXTREMELY clear. thanks for also explaining the data entry property option. i must be able to edit records in the form view, so using your method was exactly what i needed to do. thanks again

thanks for the replies, but where do I find the On Open Event property on the form, or the Data Entry property. when i go to the design view of the form and right click to display properties it gives me the properties for the nearest control (e.g. text box, label,...etc). so, i'm guessing this...

hello everyone, i was wondering how to get a form to open up to a new record each time the form is opened. right now, every time i open the form it displays the first record in the referenced table, and i have to click a "new record" control button to make a new entry. is there an easy VBA...

hey all, i was wondering if it's possible to create a tabbed input form with each tab populating a different table, however the tables are not related? for example, one tab would be for deposits/withdraws information and the second tab would be for bill payment information. Any comments or...

Thanks for the reply Pat. I suppose I could link the worksheet to an Access table, but I think I would have to do that from Excel. I was hoping to find a solution on the Access end using VBA or some other trick. Again thanks for the input

hello everyone, i'm trying to set up a form in access and have the data automatically populate an excel worksheet. i don't want to have to export data from the table in access to excel each time i update a record. is there an easy way to link this form to my workbook in excel from access...