Recent content by Kovacs

Ok, I was able to write the following code: Private Sub list3_DblClick(Cancel As Integer) Dim a1 As String Dim a2 As String Dim strSQL As String Dim i As Variant For Each i In Me.list3.ItemsSelected a1 = Forms!Form!unitID a2 = addID &...

I have a many to many relationship database using 3 tables: units - tab1(junction table) - addons A unit can have many addons and each addon can be related to many units. Now, on the form I have 3 listboxes: list1: shows all the units. Selecting a unit form list1 sets the form current record...

Ok I found a better solution: =IIf(IsNull([FieldName]);Null;"Label:") This works with numeric, data and currency fields. But the "Description" issue still remains!! How avoid auto correction in the textbox control source?

In order to shrink blank fields with labels, I converted the labels in textboxes and used as control source the following code: ="Title: "+[Title] (for instance). This worked so far, but also generated two hateful issues I wasn't able to fix: 1. The code won't work if the related...

I really appreciate your help. Obviously I need to improve my skills here :D:D Hope this will help others beginners to understand how to approach some basic stuff. Regards :)

Ok guys of course you were right, the problem was in the query.. but once I've changed it, the query doesn't returns all the records, only the filtered ones. In fact when I open the form, the listbox is empty, then the records appear only if I click on a category button (giving the proper...

Thank you Paul for your fast reply. I've uploded a new database made by scratch just for sample. The issue, as you can see, is exactly the same: Access reads a value "12" as 12, 1 and 2; a value "13" as 13, 1 and 3 and so on. The database is originally made for "antiquities", so I have a lot of...

Hi everybody In order to filter records in the main listbox, I have an option frame which has 16 option buttons. Apparently Access is reading the option button value 11 as both 11 and 1, the value 12 as 12, 1, and 2, the value 13 as 13, 1 and 3, etc..... So when I use the button 11, the records...

OK I'm posting the database, called Inventory Please remember: it's just an example, not the entire database. Don't pay attention to the content, it's just for show. What I need is to filter records by Category. MichealJRyan78: I've tried your solution, it's still in the code. You were right of...

lol AccessBlaster thank you for your concern The database you sent is one of the models I used to build mine. That's awesome and really helped me to figure out how to code a database (thank you to John Big Booty by the way...). told you, I've been searching for a long time on internet to find a...

Thank you again michaeljryan78 for your help! Actually I tried your solution which seemed to be brilliant.. but something is wrong. In fact if you run your database and try to enter new informations in the table and then apply the filter, all the data disappear, except for the typology field...

Thank you michaeljryan78 for your feedback Unfortunately I have some requests for this database to be fulfilled so I can't change the form structure in that way. Besides adding new listboxes will definitively destroy the form layout. I think the solution should be more simple. I'm wandering why...

Hi everybody I've been looking for a long time on internet (and this forum) in order to solve this problem. I am new at coding and it's very difficult to get a result with only partial informations. Hopefully this will help a lot of people having the same issue. I wish to filter the records in...

Hi everybody! I've learned a lot reading this forum.. Now I've decided to join.. I'm building some database in MS Access and I'm pretty new at coding. So thank you for your precious help!