Search results

This is exactly what I was looking for, but was unable to find. Thank you very much pbaldy!

Hello I am trying to list associated values in one field as filtered by a query, but a little more complicated in the presentation of this information. Here is an example: TBL-1 ID: EMPLOYEE: LOCATION: == ========= ========= 1 Hernandez New York 2 Brown Arizona 3 Valdez California 4 Smith...

I just tried that and what happens now is that I will get the previous record in the link table that I did before. So if I just did transaction 929 and then 930. After doing 930, 929 will appear without me having to restart the db, but still no sign of 930...

Hello all, I have a form that is used as a sort of transaction window. Through this form I am able to connect records in a many-to-many relationship. I do this through a form and use an append query to make the relationship. The append query appends the primary keys of both tables as foreign...

Thank you, but I am still confused about how I would lock the textbox. The code shows me how to create the event, but I am still unsure how to make the textbox 'not enterable.'

Hello all, I have been looking for a while, maybe I am not phrasing this correctly. I am working on a survey and I have a combobox where the user is asked a yes/no question. They choose yes or no. If they choose 'no' then they can explain why they chose 'no' in the following textbox, but if...

Works. Thanks!

I have changed it to: SELECT [StockNumber], [Description], [Group], Table2.StockNumber, Table2.Description FROM Table1 INNER JOIN Table1 ON (Table2.StockNumber=Table1.StockNumber And Table2.Description=Table1.Description) ORDER BY [Description]; This does not work. I get an error on Join.

This is what I have right now: UPDATE Table1 SET Table1.[Group] = "A" WHERE (((Table1.StockNumber)=[Table2]![StockNumber]) AND ((Table1.Description)=[Table2]![Description]));

Right now I have an update query that does not seem to be working. The update query is updated information based on two tables. The query has two fields it looks at: StockNumber and Description. So where [Table1]![StockNumber] = [Table2]![Stocknumber] and [Table1]![Description] =...

Haha nvm - I'll look for it.

How do you make it multiselect?

One more question - if I had a highlighted record in a listbox, could I click a button and cause the same update to occur?

Works great. Thanks again for your help!

Alright great, that works. I just ran into a little problem though - if the user clicks on a part of the list box without a record (just empty space), an error appears asking if the user would like to stop the script because Access cannot find anything for [ItemID]. Is there anything I can add...

I've changed it to the following, but I am still getting an error. Private Sub List5_DblClick(Cancel As Integer) CurrentDb.Execute Update TBL_FFE Set [Group] = "A" Where "[ItemID] = " & Me.List5.Column(0) End Sub

I am getting errors, I have looked for an example for this code, but I have not used this code before. Thanks.

My apologies, I was just trying to show you what I was working on, but if you say that that does not work, let me try to do it your way. I appreciate your help. Here is the code for that: Private Sub List5_DblClick(Cancel As Integer) CurrentDb.Execute SingleMove SingleMove = Update TBL_FFE...

Okay so I have this: Private Sub List5_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "QRY_TRANSACTION_INDA" stLinkCriteria = "[ItemID] = " & Me.List5.Column(0) DoCmd.OpenForm stDocName, , , stLinkCriteria End Sub But what should I put in the...

Hey all, Does anyone know how to run an update query on a specific record in a list box upon double-clicking on that record? Thanks