Search results

First, copy the VBA Code given below into VBA Standard Module. Press ALT+F11 to display VBA Window. Select Module from Insert Menu. Copy and Paste the following Code into the Module and save the Code. Public Function Test(ByVal getval As Double) As Integer Select Case getval Case 1 To...

Call this Function with the value as parameter and get the new number: Public Function Test(ByVal getval As Integer) As Integer Select Case getval Case 1 To 18 Test = 1 Case 19 To 36 Test = 2 Case Is > 36 Test = 3 End Select End Function x = Test(25) Result: 2

Hyperlink Information is coded in different segments. To know more details on Hyperlinks and how to edit them visit this page: Editing hyperlink address manually

When password is set for the Admin User of Admins Group Ms-Access starts prompting for UserID & Password. If this password is removed it will not prompt for password, but Admin User will be the default User. The User must be a member of the Admins Group to remove Admin User's password. In a...

I used this method in one of Projects, may be it is useful as a reference. The link is given below: Filtering Data for Different Users

LAN Administrators takes a daily,weekly,monthly back-up of Server Drives and keeps them safely. You can ask them to restore the database from the latest backup. Linking to two databases in different locations is not a good idea, because you need to update tables of both copies every time to...

You may go through the following link, explaining several simple ways to submit multiple parameters (including IN(SELECT Field FROM ParamQuery)) in Criteria Row of the Main Query: Multiple Parameters for Query

Besides implementing the above suggestions, remove the Docmd.RefreshRecord command from the code. There is no such command in Access2007, not sure about later versions. If it works with newer versions of Access then there is a chance that the record pointer will reset to the first record, every...

Search for 'Database Design Basics' in the Help Documents of Microsoft Access and go through the topics, you will know what to do.

Date() - WeekDay(date())+7

Use the formula below to find Week-end Date: y = #01/01/2017# x = Date() ? y+DatePart("ww",x)*7-1

Few things to know about Union queries:http://msaccess-tips.blogspot.com/2008/02/union-query.html

To create System.mdw file do the following: Open Microsoft Access (the following procedure assumes that you are using Access2007). Select Visual Basic from Database Tools. Display Debug Window (Ctrl+G). Copy and paste the following Command and press Enter Key: DoCmd.RunCommand...

I am very sorry about something I overlooked before posting my suggestions for a step by step procedure for you to try out. There are few common functions which I have introduced in an earlier post and they are being used in all subsequent 2D, 3D title creations. I introduced the second post...

Read the Article carefully and try to understand the details explained there. 1.You should paste the code into a VBA Global module and save it. 2. Run the function Border2D() with necessary parameters (explained there) from the VBA Debug window by typing the command directly. Note: A new Form...

I think this will help you to get things done, link:Border 2D Heding Text You will find the necessary VBA code to do it quickly and effectively with the choice of your own Font selection. You may find the following links interesting as well: Create 3D Headings on Form/Report Shadow 3D Heading...

Are you sure you set the Bound Column Property value to 2? Set the first column width value to 0 to display the second column value in the combobox. Please post a screen shot of the combobox displaying the list of values.

Sorry, for one moment I thought of VBA and indexing of column values. That doesm't come into picture here. Yes, your bound column is 2 and list width property value is total of all column width values. You may give the column values in cm.

Assign some values for each column separated by semi-colon like: 0.5";1";1.5;0.5". The value is expressed in inches. You may use suitable value of your region, depending on the Regional Setting of your computer. You may modify the values to display the combobox contents properly. Your bound...

Few simple examples for creating Graph Charts in MS-Access: http://msaccess-tips.blogspot.com/2007/08/ms-access-and-graph-charts.html http://msaccess-tips.blogspot.com/2007/09/ms-access-and-graph-charts2.html Yes, you can add trend lines in Access too. If you are a VBA Programmer you can do...