Search results

I'm using this code I found online. But I'm not sure how to incorporate it into my project: Private Sub cmdBlurbRequest_Click() Dim rsData as DAO.Recordset Dim strSQL as String strSQL = "Select * from Junction Where Primary Key = " & Me.txtFileNo set rsData =...

Hello all. Ok, I ran into the code above and I think it's what I need. I'm not sure how I would modify it to work on my form. Here's my scenario: tblTransactions TransactionsID - Autonumber ClientFirstName - Text ClientLastName - Text frmDocuments txtClientNo - Number cmdProcess - When...

I've got one last question regarding the module that's used for this listbox - how can I control the alignment of each column that appears in the listbox? I changed the numbers around where the "-" is but not much changes. This is just cosmetic tweaking. Currently, my listbox appears like...

HiTechCoach, OMG! That's genious! I added the piece of code you suggested to a command button and it worked! It worked! Thank you so very much!!

ZigZag, Thank you for those suggestions. I found a few things that were close to what I would like to do. Nothing solid. The thing is - I'd like for the user to enter the folder name in a text box and for Access to populate the contents of the folder name in a listbox. Is this even...

Hello! Thank you for your assistance. I apologize for the long post but I want to make sure it's detailed. On my Documents form, would it be possible to have a text box where the user enters an order #, clicks a command button and displays the directory (which is the order #) in a listbox...

Oh man! In Startup, I unchecked the boxes to hide the shortcut menu's and the toolbars. Now I can't do anything. I shut myself out from going anywhere within my database. How can I get around this? Thank you all for your time!

Pbaldy, Well, everything is working great! Thanks to you, everything is flowing as it should. We're down to the last bit of business for this listbox: If the user needs to unselect an item on the list, what method would you use that would allow the user to remove a certain item from the...

Pbaldy, That's a good point. I didn't think about the query. I was just thinking of the table itself. I'll create a query in the morning to make sure it all works. Thank you greatly!

Pbaldy, Thank you for that example. I was able to implement it in my code correctly. This leads to my next question. How can I append a field other than the bound column? Please see attached file.

OMG!! Pbaldy, it worked! It's inserting the PRDID number. It does not make any sense to me logically but it's working none the less. Yeeeha! Thank you so very much. The only problem now is that when I move on to the next record, the items are still selected. And if the items are still...

Thank you! I will try this out tonight and let you know if it works. I can't post the DB because it already has sensitive information stored in it. The government wouldn’t appreciate that very much. Thank you though for being patient with my screenshots. If the database didn’t have records...

Ok, I did what you suggested but the EventID is not appending to the IsotopeFound table. FYI - I changed the name EventID to PRDID so that the column names match in the main table and the IsotopeFound table. Please see attached file. :confused:

However, the EventID "is" already in the table I am appending to. When the ListBox AfterUpdate event triggers, how does the event add the data from the ListBox and also tie it to the main record table? This is where I am stuck. I can't get my brain to think outside this part. In looking at...

Thank you all for your help so far. If you don't mind, please see the attached PDF for more details of where I am and where I would like to go with this database. I included some screenshots.

Going with your example database Baldy, how would you modify the code assigned to the command button so that it takes the data from the listbox instead of the text box?

pbaldy, I appreciate your response. Thank you for the examples. After reviewing the code and samples you provided, I'm not sure how to put it to use for what I want to do. I'm putting together a database for a government agency so without giving too much information, here is what I need: I...

Hello all! I have not been able to find the answer to my question. Everything I find is opposite of what I want to do. Any who...I have a listbox on my form that will be MultiSelect. Let's say the listbox contains the names of fruits: Apples, Oranges, Grapes, Mango. The user should select...

You have any good places to point me to?

That program you supplied is kewl and all, but I already have all the documents I need and they all contain merge fields already. Now I need a way for Access to open up the documents the user selects and merge in the data to the Word documents depending on which account is selected.