Search results

For your info: Excel Cells have some data validation features, which you can enable for required Cells to control data entry. Select a Cell Select Data from the Main Menu. Select 'Data Validation' from the 'Data Tools' Group. A Data Validation dialogbox will open. On the Settings tab...

I am not sure whether the following link will help you to plan your own approach for a solution: Autonumber with Date and Sequence Number

The ROUNDDOWN() Access Function Code: Public Function ROUNDDOWN(ByVal N As Double, ByVal p As Integer) As Double Dim S1 As Integer, S2 As Integer S1 = Sgn(N) S2 = Sgn(p) Select Case S1 Case 1 Select Case S2 Case 1 ROUNDDOWN = (Int(N * (10 ^ p)) / 10 ^ p)...

It depends on what purpose we open the recordset for. If you attempt to take a count of records Immediately after opening the recordset the output will be 1. That means the recordset is not fully populated in memory. To do that an rs.movelast is required before taking a count. On the...

Thanks for the tip Micron. The code was written for demo purposes only. Without some data in the table the demo will not work. The database is provided for download as well in the page: www.msaccesstips.com/2007/12/progress-meter.html Sent from my iPhone using Tapatalk

Here is some sample Code, may be helpful to correct yours: DoCmd.Hourglass True Set db = CurrentDb Set rst = db.OpenRecordset("Order Details", dbOpenDynaset) rst.MoveLast TotalRecords = rst.RecordCount rst.MoveFirst Do While Not rst.EOF With rst Quantity = ![Quantity] UnitRate =...

I have used VNC Viewer Software to connect to the remote Computer Desktop when maintenance requests were received from the Users of my Access Application. This is mainly used within LAN/WAN Network and have VNC Server and Client Versions. Our headquarters is in Oman and the maintenance requests...

AS400 Tables can be dowloaded if allowed to do so, in .dbf format for local customized analysis. We used to ask for the Monthly Report Printout in Spool file form from AS400 inventory system (hundreds of pages) parse the data lines/fields, discarding header/footer/summary lines with a...

If you have access rights to AS400 table then you can link it to Access through ODBC and work with the table. Sent from my iPhone using Tapatalk

It is possible to create Custom Properties on Form and Store and Retrieve Values on Open/Close Events and I use them for different purposes. UserIDs, Passwords or any other value we like to store and retrieve them as and when needed. Few examples here: Saving Data on Forms Not in Table...

Use the lost focus event of the earlier field to display an Inputbox() based menu of two choices 1. Flight Level 2. Altitude. Based on the selection of the User Enable/Disable appropriate field with the required Input Mask.

Try using Input Mask setting, you don't need to use any Code. Try the following: 1. Text Box Input Mask Property setting for 10 digit number: 9999999999 This setting will accept digits 0 to 9 only. 2. Input Mask: ########## This setting will accept 0 to 9, space, plus or minus signs.

Duplex printing is a feature of most Laser Printers. Change the configuration setting of the printer to print pages on both sides of the paper, by flipping the page.

If your machine is a Workstation of Intranet then you can use the NET SEND command to send messages to other workstations, by typing the following command on the DOS Prompt: C:\>NET SEND "workstationID' "Message" This can be automated through VBA based on speccific requirements. Check the...

I have something on this topic here:Saving Report Pages as separate PDFs but, it is VBA based.

Open Access Options - - >Current Database - ->under Document Window Options - - > select Overlapping Windows. put the following code in the Report Module: Private Sub Report_Open(Cancel As Integer) DoCmd.Restore End Sub

Hope you will find this Post and two other posts on it will be useful to you: https://www.msaccesstips.com/2008/01/progress-counter.html

Same thing explained with a different approach:Date and Time Values

Some info about Tab Controls and Events:Set Focus on Tab Page Click

Are you sure you have copied the code into a Standard VBA Module (Global Module). Open the module again and try to Compile all the VBA Code by selecting the option from the top menu. If you have errors in any of the code in your database. It may not work. If you could compile the entire...