We usually put the Back End on the server and the Front End on the local machine.
Is there a problem (maybe performance) in leaving a copy of the FE on the server for each user and just put the link of each on the local machine?
That is, I...
I created a table called Funcionarios where I have at least 2 fields:
ID and caminho_impressao .
Where I put it, for example:
C: \ Users \ user1 \ documents \
C: \ Users \ user2 \ documents \
So I tried to prin...
I have a table with Quant and Preço .
In the form, besides these fields, I have the field Total = [Quant]*[Preço]
Also, in the main form I have the field SomaTotal = Soma([Total])
That is, the classic sum of pric...
It's a stupid question, I know.
I almost had no contact with MS Access. I know it's a database. Does he have anything special? Any feature worthy of note? How does it work? What demands does it meet?
I'm using a vba code that passes some data to an auxiliary table, manipulates it and returns it to the original table.
How do I solve the competition problem? That is, I did not want two users to use at the same time.
Hello, I looked for this answer all over the internet and I did not find:)
I am importing an MDB (Ms Access db) into R Studio (Windows 7 R v32b) using RODBC but when I give the sqlFetch command I am having an error importing a date column that...
I have the following Form with a SubForm:
IneedtoenableCheckin"Approve3" and block the other fields, but I only get "LOCK" all or none, how can I get around? Maybe for vba?
I remember a SubForm inside a Form
Let's say I have an initial date equal to 30/01/2014 10:00 and an end date equal to 02/02/2014 10:00 .
I wonder if it's possible to get a grid containing these results:
If possible, I would like to know how.
How to check if a number is integer in Access VBA?
I've tried
If Int(Me.Numero) Then
Msgbox "É inteiro"
End If
But it did not work.
I wanted it if I type 8,5 it would return "Not integer".
The field is Not Coupled.
I have a table in my database and would like to mark occurrences where certain code repeats itself. Remember that this code field is not a primary key.
Example:
Data Código Repetição Status ...
25/2/2014 138863 ok...