Search results

Type the following expression in the VBA Debug Window (Immediate window) directly and press enter key to list out the active keyboard code and it's corresponding character: for j=123 to 255:print j,chr(j):next This will display the character codes. Check for the character and the...

You are not saying anything about how the forms are linked each other. It looks like both sub-forms are linked to the main form on some key values. I think the best approach is to link the main-form to the first sub-form. Second sub-form to the first sub-form on a common key value. When you...

Check the following links: Who is Online Who Changed the Data Database Open/Close Event alerts

Take a look at the following links: MS-Access and Graph Charts MS-Access and Graph Charts-2/

Database with Code is attached.

You can prevent running a copy of your database on a different machine by checking the Machine name every time the database is open. If it is run on your own machine it will open normally, if the machine is different the user will not be able to open it. Before you proceed with this I suggest...

Go to Tools Menu, Options, Advanced Tab and check to ensure that the Shared option radio button is in selected state. If I am not mistaken then the Exclusive option is in selected state now.

The LAN machine will have a name (like IBMLAN or whatever name given to the machine) and is addressable with it's name and folder name Like \\IBMLAN\FolderName rather than C:\User\My Documents\Document etc. The folder name part will have several folders like Audit, Accounts, Hrd etc. intended...

Run the following code from the Combobox's NotinList Event Procedure to add a new entry, entered by the user in the combobox, after taking her permission for adding it to the Employee_List table: Private Sub cboInitials_NotInList(NewData As String, Response As Integer) Dim init As String, db...

Get the solution to your query from the following link: Selected List Box items and Dynamic Query You will get details of the method, VBA Code and implementation techniques.

If machine1 and machne2 are client machines of LAN then best option is to install the back-end database on a common folder in LAN, accessible to both parties. If that is not possible then you may try peer-to-peer mapping of the shared folder of machine1 as a network drive on machine2. If...

If I am not mistaken you need two different sub-forms to the main to fill-in data, based on the Group-Code, into their related tables. If it is so then take a look at the following link: Overlaying Sub-Forms in Real-time. You can load either one of two sub-forms, depending on the Group Code...

If the Sub-Form(s) record source Queries' criteria depends on a value of a control on the Main Form, then you may try to refresh, rather than requery, the Main Form to update the underlying queries and reflect the change on the sub-forms automatically. The Me.Refresh action can be executed from...

As far as I know, Report Formatting and Printing is happening page by page from the beginning of the Report. Printing of Sub-Report at the Main Report Footer starts printing only after printing other Sections of the main Report and before finishing the main report footer printing. You can...

If you are using the textbox contents as text type data in the lookup expressin (like =dlookup("fieldname","TableName","Telephone= '" & [Text2] & "'") it should work. If it is in numerical search (if so, why your number starting with a zero (0) in your example shown in your first post) you...

If each event is recorded on separate rows then take a look at the following link for an example with code: Finding Difference between dates in Rows of a Column

The Syntax for setting up a Temporary Variable in VBA is given below: TempVars.Add "VariableName", ValueToStore Examples: TempVars.Add "Age", 25 TempVars.Add "StudentName", "John" To retrieve the value from a temporary variable: x = TempVars![Age] To clear a particular variable from...

Try this: Left([Last Name],InstrRev(RTrim([Last Name]),space(1))-1) The -1 in the Left() Function can run into problems when there is no segmentation in Lastname. I think a Public Function, like the following code, in the Standard Module will be safer and easier to use: Public Function...

Open your Form in Design View. Click on the Unbound Textbox to select it. Display it's Property Sheet (press F4). Find the Name Property Value. Try to change the existing Name property value to Text2. If you have another textbox on the form with the same name Text2 then Ms-Access will not allow...

You may use the following VBA Program in the AfterUpdate() Event Procedure of your Unbound Textbox to scan and remove the space from the pasted data: Private Sub Text2_AfterUpdate() Dim txt2 As String, num2 As String Dim j As Integer, strK As String txt2 = Nz(Me![Text2], "") If Len(txt2) = 0...