Search results

I didn't have this problem when I had used subforms, but there were little bits of thins I had to polish. There are basically 2 tables, and the form is based on the table PKing. It shows the PK and a few irrelevant fields. However, when the recordsource now inner joins the two tables based on...

Right now, I have a a form that shows all of the information about a company, all based on 1 table. I also have a query where it shows all of the people related to a company, based on a tertiary table that shows each relationship. However, I need to enter the PK of the company every time I run...

I'll illustrate my problem with pictures. Basically, within a company, a director can have an alternate. I have done this by linking the relationship between a person and a company (company-personID) with the table "alternates". In a subform for the information about the company itself...

I'll first apologise for the ridiculous title. Anyway, my goal is to use the SQL "Update" function to set the address of a company to the previous addresses when I update something. FOr example, the fields show as Current=A Previous=B Previous 2=C When I input something to...

I used to have a problem where my form would only show 1 record of 7. After changing the record source to a table, however, it no longer shows a particular subform, instead turning up blank. Furthermore, a one-to-one relationship between this table (company) and another(company_address) shows up...

Very suddenly today, when I'd done seemingly nothing, all of the records from my form that I'd built from a blank form disappeared, with the exception of the first record. When I try to just close everything down, nothing changes. When I put in a new record to the form, however, it's saved in...

Right now, I have 4 related tables. There's a table with companies, one with people involved with companies, a table linking the two by having foreign keys of the company number and people names, and a table that indicates directors and their alternates. Since there's a one-to-many relationship...

I apologise in advanced, as there will be some VBA in this, but I figured it would fit better in the query section. I ran a very similar code with near-identical SQL, with only the fields and tables changed, and it had worked before. However, after changing the fields and tables, I repeatedly...

I have a piece of code, and when it's run, the system doesn't detect any syntax errors. However, as far as I can see, it does absolutely nothing. I had a tonne of syntax errors before, but after correcting them all, it does nothing. There are two tables. One is that of the companies, which has...

Right now, I'm working with an SQL code of "UPDATE Individuals SET [ShareholderOf] = " & Me.CompanyNo & " WHERE [Name] = '" & PerName & "';" However, doing so will obviously change the "Shareholder of" field into what the user inputs (Me.CompanyNo). What should I use if I want it to ADD the...

I can't even begin to comprehend where to start with this. There are 6 tables involved, where 4 of them are practically the same. There's the companies, people, and 4 different roles for the people. I've keyed the peoples' names and the company numbers, as well as names in the roles. Apart from...

I made a userform in another module and got it into a subroutine for a form, but it doesn't seem to affect what goes on in the subroutine, The code was Private Sub UpdateI_Click() Dim Popup As Role, Sub4 As String, PerName As String, Sub3 As String, Sub2 As String, Sub1 As String Set Popup =...

Please note that I am a complete beginner in MS Access, and this may be impossible. I made a form(based on what I'll refer to as "Table 1") with a set of command buttons, and a some of them are meant to update existing records in another table (table 2), as well as table 1. The code is as...