Hi
I have a report that selects and shows records where a specified date field is within the range of 2 dates that the
user enters.
I created 2 unbound textboxes on the report with a Shortdate format and InputMask 0000-00-00;0;_.
When user enter correct dates, then everything works fine...
Hi,
I just finished a small Access-2013 database (accdb format).
Now I want to make it available to users.
How do I make an 'executable' (meaning that tables, forms, ... cannot be opened in design mode)?
Thanks.
Hi,
I have this declaration in a module called Global Code
Option Compare Database
Public currentCustomerId As Long
Option Explicit
There is one report that simply prints a the firstname of current customer and the amount of each of his invoices.
The current displayed customer's ID is always...
Thanks Bob,
This looks better but the instruction
Set rs = CurrentDb.OpenRecordset(sqlString)
is still not happy: "too few parameters. Expecting 1"
Yes txtCodeUtilisateur, txtMotDePasse are text strings.
Thanks.
Hi,
Please help with this SELECT command:
Dim sqlString As String
Dim rs As DAO.Recordset
sqlString = "SELECT * FROM tblUtilisateurs WHERE (tblUtilisateurs.CodeUtilisateur = Me.txtCodeUtilisateur AND tblUtilisateurs.MotDePasse = Me.txtMotDePasse);"
Set rs = CurrentDb.OpenRecordset(sqlString)...
Hi pbaldy,
I resarted it from scratch using the hypelink data type and ... now it's working well!
I probably did something wrong the first time.
Thanks a lot.
Hi,
Designing a table of companies.
Need a field containing the website adresse for each company.
MS-Access 2013 does not offer such a field format.
On a form I can create it, click on it and it will open the website.
But that way it opens the same website instead of different websites for...
Hi,
Debugging my VBA code.
I'm trying to track/display the content/value of a couple of variables to make sure they have the right value at a certain point.
What is the VBA code to say "display content of variable Var1" ?
Where exactly will it display the value when instruction is executed?
PS...
Hi,
Access beginner.
I have a form that displays records from a table.
When opened it displays all records (no selection yet).
I put would like to put 2 buttons to filter records (Male/Female).
I'm thinking of 2 possible options:
1-on click run a script that will close current form, then reopen...