Search results

NVBC: Ignore previous poster wasa spammer who has now been banned. He was just trying to buildup his post count before posting url's

Here is a function that will calculate the financial year of the date entered based on 1st April to 31st March Public Function FinancialYear(AnyDate As Date) As String If Month(AnyDate) < 4 Then FinancialYear = Year(DateAdd("yyyy", -1, AnyDate)) & "/" & Year(AnyDate) Else...

Have you installed the OutputToPDF Addin?

"Where [YourDate] Between #06/04/2011# And #05/04/2012#"

A2003 version

Take a look at this revision I have added a text box to the form FrmSessions call TxtWhoAmI Look at the On Load event to see how I populated it Also look a the after upate event of the combo box on the login screen to see how I passed the users name to the public variable StrWhoAmI

If You have a textbox on your form called Me.WhoAmI then On the form OnLoad event Me.WhoAmI = strLoginName

Question is How big is it? Have a Compact and Repair ever been performed on it? Can you post a copy for testing?

Yoiu dont need to refer to the form jut refer to the StrUser variable

Autotab only works with input masks and the mask has to be complete so entering one digit will not fire the autotab unless they used 01,02,03

Extract form FrmLogin Private Sub CboUser_AfterUpdate() '/Enable the login button If Trim(Me.CboUser & "") <> "" Then Me.CmdLogin.Enabled = True '/Get the users permissions for RBAC StrUserName = FindUserName() StrLoginName = Me.CboUser StrComputerName =...

I am going to point you to another Sample database that uses puplic variables, this may give you more insight into what I am referring to.

You can use the keypress/keydown event of the control to test for which key was pressed and if matches your condition use the DoCmd.SetFocus method to move the cursor to the next field on the form. Will the user always step through every field on the form sequentially or will they need to skip...

Create a standard module and define a public variable called StrUserName Module Name:ModPublics Public StrUserName As String When the user logs in via the login form store the user name from the combo box and pass it to the variable CboUser AfterUpdate StrUserName = Me.CboUser Then on...

Why? What benefit are you going to get from this apart from a keypress. You are not giving the user the option of correction of data. Takes more keystrokes to get back to the field to edit the record to revise the data. What happens if you increase you options to 25?

What method was used to get the files in to blob in the first place?

There are different types of users to consider 1. Windows user - Who is logged into the machine 2. Application user - Who is logged in to the application (Delilah) 3. Access user - Always admin if User Defined Security is not employed. There is a API function Called GetCurrentUser() This is...

Which bit of the demo is frightening you?

Can you post a couple of records with different ole types to test

First question. Are you using A2007/A2011?