Recent content by gi0rg0s

Lots of good comments here, thanks. Since everyone is recommending it, I will see how bound forms behave as well and choose accordingly. Re my comment on better control and performance with unbound forms, I thought that each time they are loaded a recordset opens with the fields that are bound...

Thanks MarkK, but I would rather use unbound forms. Mainly for the following reasons. I am new to both Access and programming and unbound forms are great for learning and developing problem solving skills The database may need to be upgraded to an SQL server in the near future. Having unbound...

Hi all, I am building a customer profile using an unbound form and I just wanted to ask for advice on best practices for doing this. Specifically on the matters listed below: Retrieving the data from the tables To do this I created a one line multiple fields recordset based on selected...

I am very new to Access and programming, so I may be wrong, but I am using one real field tables for the following reasons: Database is smaller as the size of the Long Integer is generally less than the size of the text field. I don't know if this will ever actually scale to anything...

Thanks Wayne, This 13 year-old post, helped an access newbie today :). But I would like to ask the community for some optimization advice. As opposed to zbap my supertype contains three subtypes so optimization is a bit more important I managed to do the merge in 3 possible ways: Merging the...

Hi all, I am very new to Access, which means a lot of googling in the process. More often than not the answer to my questions come from this forum so I decided to join. Keep up the good work, George