Search results

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...

IT WORKED! Thanks a lot.

thanks for your help. For some reason that option 'Create accde' is greyed out.

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.

thanks a lot: it is working!

Thanks a lot. I'll try that and let you know.

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 Guys, I found out: one field was misspelled. Thanks a lot.

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...

Thanks a lot. It is now working well.

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...