Recent content by TecnicoAlpha

The query filters ok by itself. I created a one-to-one relationship, the problem remains. Private Sub btn3_Click() If IsNull(txtClientName) Then MsgBox ("Por favor selecione um cliente") Else DoCmd.Close acForm, "Menu Orçamentos" 'This doesn´t open, throws na...

That should be the first place to look at, beacause i left everything as is, i neglected that, and no problems arose until now. I think i should create a one-to-one relationship, because that way i only have one record per customer, right ?

Yes, everything is separate, there's a table for the Patient info, and lots of others with exame results, etc. Main menu -> Patient info Main Menu -> Topics -> SubMenu 2 (Inicial Evaluation) -> Forms 2.1, 2.2... Main Menu -> Topics -> SubMenu 3... -> Forms 3.1, 3.2 ... Main Menu ->...

Hello there, happy to find someone interested. This is my first database, i'm a newbie at Access, and they gave me a big one, paliative pacient care, almost 80 tables. Each table has a form linked to it, separated by topics (menus). Working around this for several months, and it's hard for...

Hello.. Situation : - Created Customer John Smith with CustomerID number 2 on Customer Form (Done) - On main Menu, select Customer on ComboBox to set values to : (Done) TempVars!TempCustomerID TempVars!TempCustomerName - Open all forms available always with the same Customer (Done) - Open all...

Hello everybody :) My name is Ramiro, i'm from Portugal, i'm a newbie to Access, and i'm learning the hard way to build and work with Access databases :banghead: I'm doing a project to help manage and control paliative patients, and possible future ones. Any help is needed, and i...