Hi
This is how the tables should be related
Hi
This is how the tables should be related
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
thanks i did it the same way
but the forms just won't open on the same record as the main form, they keep adding new records :s
Hi
The only way we would be able to see your problem is for you to upload a zipped copy of the database.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
https://www.mediafire.com/file/d74mn...base4.rar/file
This is just a test, the form Datos de la empresa has a button to open the form Requisitos1 and look for the same data that is on the form Datos de la empresa but instead it just keeps showing a new record
I believe this is crossposted at How to link multiple forms to a single form - Microsoft Q&A.
Am I correct?
yes, that post is mine i posted here afeter that post because i saw the community here is more activeI believe this is crossposted at How to link multiple forms to a single form - Microsoft Q&A.
Am I correct?
It is important you explain when you have crossposted - please read http://www.excelguru.ca/content.php?...-cross-posters
Also, please provide a link to this thread at the other site
i didn't knew, i posted the link already but it's waiting for moderator's revisionIt is important you explain when you have crossposted - please read http://www.excelguru.ca/content.php?...-cross-posters
Also, please provide a link to this thread at the other site
Hi
The Tab Controls should be linked as shown in the example attached
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Here's a quick and dirty form/subform setup of your DB with proper linkages between the forms.
Solyman-davegri-v01.zip
Sorry but those examples that you made weren't what i was looking for
but i finally did it
maybe you will see it as a mess but it works for this DB at least
what i did was creating only one table and put all of the fields there
then i used this code on a button to open the required form based on the combobox and make it write on the same record
and here is the file https://www.mediafire.com/file/pvvtl...coh.accdb/filePrivate Sub Command40_Click()Dim sSQL As String
Dim sFormName As String
If Me.TipodeTramite = "Licencia Nueva" Then
sSQL = "ID_Exp=" & Me.ID_Exp
sFormName = "Req"
If Not Me.NewRecord Then
DoCmd.OpenForm _
FormName:=sFormName, _
DataMode:=acFormEdit, _
WhereCondition:=sSQL
End If
ElseIf Me.TipodeTramite = "Cambio de Propietario y/o Razon Social" Then
sSQL = "ID_Exp=" & Me.ID_Exp
sFormName = "Req1"
If Not Me.NewRecord Then
DoCmd.OpenForm _
FormName:=sFormName, _
DataMode:=acFormEdit, _
WhereCondition:=sSQL
End If
ElseIf Me.TipodeTramite = "Cambio de Domicilio" Then
sSQL = "ID_Exp=" & Me.ID_Exp
sFormName = "Req2"
If Not Me.NewRecord Then
DoCmd.OpenForm _
FormName:=sFormName, _
DataMode:=acFormEdit, _
WhereCondition:=sSQL
End If
ElseIf Me.TipodeTramite = "Cambio de Giro" Then
sSQL = "ID_Exp=" & Me.ID_Exp
sFormName = "Req3"
If Not Me.NewRecord Then
DoCmd.OpenForm _
FormName:=sFormName, _
DataMode:=acFormEdit, _
WhereCondition:=sSQL
End If
ElseIf Me.TipodeTramite = "Suspension Temporal de Actividades" Then
sSQL = "ID_Exp=" & Me.ID_Exp
sFormName = "Req4"
If Not Me.NewRecord Then
DoCmd.OpenForm _
FormName:=sFormName, _
DataMode:=acFormEdit, _
WhereCondition:=sSQL
End If
ElseIf Me.TipodeTramite = "Reanudacion de Actividades" Then
sSQL = "ID_Exp=" & Me.ID_Exp
sFormName = "Req5"
If Not Me.NewRecord Then
DoCmd.OpenForm _
FormName:=sFormName, _
DataMode:=acFormEdit, _
WhereCondition:=sSQL
End If
Else
strForm = "FormC"
End If
End Sub
i'm really thankful with all of you
Hi
If you are putting everything in 1 table why are you using Access?
Access is design to work with Multiple tables that are related.
I would suggest that you have gone the quickest but wrong route to get an answer.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
because
1. this project isn't for me
2. the people that i'm working for aren't even aware of what are tables
3. they specified the use of access despite they don't know how to use it
4. they wanted this project finished for today at 9 a.m.
that's why i choosed that way to make the things
if i had more time i would work with multiple tables, but thats not the case sadly
Hi all!
@Solymandiasbecause
1. this project isn't for me
2. the people that i'm working for aren't even aware of what are tables
3. they specified the use of access despite they don't know how to use it
4. they wanted this project finished for today at 9 a.m.
that's why i choosed that way to make the things
if i had more time i would work with multiple tables, but thats not the case sadly
Take a look in attachment to get some ideas for your next version (using mutiple tables).
You have to put the appropriate fields into the corresponding tables and forms. The popup form (sfrmReqs), while is open, stays synchronized as you make changes in main form (change record or TipodeTramite).
Good luck with your project!