Search results

Hi, I am having a problem displaying certain data in my listbox in a form. The listbox displays several fields, one of them is "Part Number" and sometimes that part number is going to be "TBD" depending on the item. When that is the case I want to display the part version(another field that...

Hi, I have a table called "tbl_Design_Change_Item". What I want is for the primary key to concatinate three separted strings into one and also auto increments. An example of what the first record ID should be is "SWCDCR2015_08_31_001". When a new record is created, I would like for the field...

thank you for the response and link. I am having trouble implementing it though. I am not very experienced with data definition queries/create index statements and I dont really know how to assign a compsoite key to the table. Any suggestions on how to approach this?

Hi, I am having an issue with duplicates in my table. I have a table, called "Part Mods", that has about 12 fields in it. the first 2 of them are "Mod" and "Part Number". I have a form where someone can insert data into this table and what i want is for them to NOT be able to insert a record...

Hello again, I am having touble with this code again and I don't know why. I created a new database because I want to clean up what work was done in the other database. In my new form, I am using the same code, but I changed the names of everything accordingly. The issue now is that nothing will...

thanks for your responses; I was able to make it work by creating a dummy unbound text box and before newrec was called I set the dummy textbox = to the bound acb textbox. I then referenced the dummy one in my query. regards

I got it to work, thank you. I am having another issue now, the main purpose of that pop up form is for the user to add a new part number to the database and also to a listbox which is back on the other form. I have the acb id passed over and stored in that textbox, but when the line...

Hi, I have a form and in the subform for that I have a button that opens a pop up form. I want to pass the value [ACB ID] to an unbound text box in the popup form but I am having trouble. My code for the button in the subform is: DoCmd.OpenForm "addPartNumberMod", acNormal, , "ACB = " &...

Hi, I was wondering if it was possible to wrap text in listboxes. some fields are very long at times and i was hoping there would be a way to wrap it so I didnt have to make the width of that column extra long. I am trying to conserve as much space as possible on the form. As always any help...

Thank you guys for the replies. I am having trouble implementing code from both resources though. I think my form would behave a little differently than those. The two listboxes contain different data based on the ACB. the first listbox is filtered based on the selected acb in the main form...

Hello, I have a form where there are 2 list boxes: Part_List and acbPartList. acbPartList has multiselect enabled and what I want to do is be able to select multipler records in that list box and then press a button to add those selected records into the other list box. Here is my code for my...

Thanks for the replies I was able to solve the issue thanks to the itemdata function. If anyone is curious this is what I did: Private Sub removeButton_Click() Dim varItem As Variant Dim strSQL As String With Me.acbModList For Each varItem In .ItemsSelected...

iterating through selections in multiselect list box Hi, I have a form with 2 list boxes, part number and modification. There is a subform containing another list box that is supposed to show the part information (bpn,vendor,status,etc.) that corresponds to the selected part number/modification...

you are a saint!!!! thanks again and god bless

SELECT tbl_Part_Number.[Part Number ID], tbl_Part_Number.[Part Number], tbl_Base_Part_Number.Base_Part_Number_ID, tbl_Vendors.[Vendor ID], tbl_Part_Nomenclature.[Part Nomenclature ID], tbl_Ref_Des.[Ref Des ID] FROM tbl_Ref_Des INNER JOIN ((tbl_Part_Nomenclature INNER JOIN ((tbl_Vendors INNER...

Here is the row source for the listbox. there are 2 more fields after vendors for nomenclature and refrence, they just arent in the picture.

hello, this is my first post so if i leave out information or word this poorly then i apologize. I have a form where I am trying to use 4 combo boxes(nomenclature,BPN,vendor, and reference) to filter a list box containing part numbers. The way I have it set up right now is in the listbox it is...