gestsola v0.1 trabalho realizado por: ana rita soares jorge oliveira mafalda oliveira ricardo...
TRANSCRIPT
![Page 1: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/1.jpg)
GESTSOLA v0.1
Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares
![Page 2: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/2.jpg)
2
Formulário Inicial
GE
ST
SO
LA
© -
v0.
1
![Page 3: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/3.jpg)
3
Login
Query UtilizadorFormulário Login
Private Sub Form_Open(Cancel As Integer)If tipo_de_utilizador = 0 ThenDoCmd.CloseDoCmd.OpenForm "F_entrada0"DoCmd.Close acForm, "F_Inicial"ElseIf tipo_de_utilizador = 1 ThenDoCmd.CloseDoCmd.OpenForm "F_entrada1"DoCmd.Close acForm, "F_Inicial"ElseIf tipo_de_utilizador = 2 ThenDoCmd.CloseDoCmd.OpenForm "F_entrada2"DoCmd.Close acForm, "F_Inicial"ElseDoCmd.CloseMsgBox "Nome de utilizador ou Palavra-Passe Incorrectos!", vbExclamationEnd IfEnd Sub
![Page 4: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/4.jpg)
4
Opções para cada tipo de Utilizador
GE
ST
SO
LA
© -
v0.
1
![Page 5: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/5.jpg)
5
Botões da Barra de Ferramentas
NovoEliminarGuardarImprimirCopiar
GE
ST
SO
LA
© -
v0.
1
![Page 6: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/6.jpg)
6
Botões da Barra de Ferramentas
Private Sub copiar_Click() On Error GoTo Errcopy Screen.PreviousControl.SetFocus DoCmd.RunCommand acCmdCopy Exit SubErrcopy: Select Case Err Case 2046 MsgBox "Tem de seleccionar texto pra copiar.", vbInformation, "Informação" Exit Sub Case Else MsgBox Err.Number & ":-" & vbCrLf & Err.Description Exit Sub End SelectEnd Sub
Copiar
GE
ST
SO
LA
© -
v0.
1
![Page 7: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/7.jpg)
7
Botões da Barra de Ferramentas
NovoEliminarGuardarImprimirCopiarColarProcurar Ajuda
GE
ST
SO
LA
© -
v0.
1
![Page 8: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/8.jpg)
8
Formulário de Ajuda
Nome do Formulário
Ajuda
Ajuda
Private Sub ajuda_Click()DoCmd.OpenForm "F_Ajuda", , , "Cod = 1"End Sub
GE
ST
SO
LA
© -
v0.
1
![Page 9: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/9.jpg)
9
Botões da Barra de Ferramentas
NovoEliminarGuardarImprimirCopiarColarProcurar Ajuda AnteriorSeguinte
GE
ST
SO
LA
© -
v0.
1
![Page 10: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/10.jpg)
10
Opções Administrador Abrir Formulário de Utilizadores
GE
ST
SO
LA
© -
v0.
1
![Page 11: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/11.jpg)
11
Formulário de Utilizador
GE
ST
SO
LA
© -
v0.
1
![Page 12: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/12.jpg)
12
Opções AdministradorAbrir Formulário de Clientes
GE
ST
SO
LA
© -
v0.
1
![Page 13: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/13.jpg)
13
Formulário de Clientes
GE
ST
SO
LA
© -
v0.
1
![Page 14: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/14.jpg)
14
Relatório – Lista de Clientes
GE
ST
SO
LA
© -
v0.
1
![Page 15: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/15.jpg)
15
Formulário de Clientes
GE
ST
SO
LA
© -
v0.
1
![Page 16: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/16.jpg)
16
Formulário Nova Encomenda de Cliente
GE
ST
SO
LA
© -
v0.
1
![Page 17: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/17.jpg)
17
Formulário de Clientes
GE
ST
SO
LA
© -
v0.
1
![Page 18: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/18.jpg)
18
Formulário Lista de Encomendas
GE
ST
SO
LA
© -
v0.
1
![Page 19: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/19.jpg)
19
Formulário de Clientes
GE
ST
SO
LA
© -
v0.
1
![Page 20: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/20.jpg)
20
Relatório – Ficha de Cliente
GE
ST
SO
LA
© -
v0.
1
![Page 21: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/21.jpg)
21
Opções Administrador Abrir Formulário de Fornecedores
GE
ST
SO
LA
© -
v0.
1
![Page 22: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/22.jpg)
22
Formulário de Fornecedores
GE
ST
SO
LA
© -
v0.
1
![Page 23: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/23.jpg)
23
Formulário de Matérias-Primas
GE
ST
SO
LA
© -
v0.
1
![Page 24: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/24.jpg)
24
Formulário de Fornecedores
GE
ST
SO
LA
© -
v0.
1
![Page 25: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/25.jpg)
25
Formulário Encomendas de Matérias Primas
GE
ST
SO
LA
© -
v0.
1
![Page 26: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/26.jpg)
26
Formulário de Fornecedores
GE
ST
SO
LA
© -
v0.
1
![Page 27: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/27.jpg)
27
Relatório – Lista de Fornecedores
GE
ST
SO
LA
© -
v0.
1
![Page 28: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/28.jpg)
28
Formulário de Fornecedores
GE
ST
SO
LA
© -
v0.
1
![Page 29: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/29.jpg)
29
Relatório – Ficha de Fornecedor
GE
ST
SO
LA
© -
v0.
1
![Page 30: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/30.jpg)
30
Opções Administrador Abrir Formulário de Stock
GE
ST
SO
LA
© -
v0.
1
![Page 31: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/31.jpg)
31
Formulário de Stock
GE
ST
SO
LA
© -
v0.
1
![Page 32: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/32.jpg)
32
Formulário Encomendas de Matérias Primas
GE
ST
SO
LA
© -
v0.
1
![Page 33: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/33.jpg)
33
Formulário de Stock
GE
ST
SO
LA
© -
v0.
1
![Page 34: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/34.jpg)
34
Formulário Lista de Encomendas
GE
ST
SO
LA
© -
v0.
1
![Page 35: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/35.jpg)
35
Formulário de Stock
GE
ST
SO
LA
© -
v0.
1
![Page 36: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/36.jpg)
36
Formulário de Gastos
GE
ST
SO
LA
© -
v0.
1
![Page 37: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/37.jpg)
37
Impressão do Intervalo de Gastos
GE
ST
SO
LA
© -
v0.
1
![Page 38: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/38.jpg)
38
Relatório – Gastos
GE
ST
SO
LA
© -
v0.
1
![Page 39: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/39.jpg)
39
Formulário de Stock
GE
ST
SO
LA
© -
v0.
1
![Page 40: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/40.jpg)
40
Relatório – Stock
GE
ST
SO
LA
© -
v0.
1
![Page 41: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/41.jpg)
41
Opções Administrador Efectuar Encomendas
GE
ST
SO
LA
© -
v0.
1
![Page 42: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/42.jpg)
42
Opções Administrador Escolha de Encomendas
GE
ST
SO
LA
© -
v0.
1
![Page 43: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/43.jpg)
43
Opções Administrador Encomenda de Clientes
GE
ST
SO
LA
© -
v0.
1
![Page 44: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/44.jpg)
44
Opções Administrador Escolha de Encomendas
GE
ST
SO
LA
© -
v0.
1
![Page 45: GESTSOLA v0.1 Trabalho realizado por: Ana Rita Soares Jorge Oliveira Mafalda Oliveira Ricardo Pedrosa Sérgio Tavares](https://reader036.vdocuments.us/reader036/viewer/2022081516/552fc101497959413d8bd968/html5/thumbnails/45.jpg)
45
Opções Administrador Encomenda de Matérias Primas
GE
ST
SO
LA
© -
v0.
1