Go Back   Access World Forums > Members List

 
jai kushwaha is on a distinguished road

jai kushwaha jai kushwaha is offline

Newly Registered User

Visitor Messages

Showing Visitor Messages 1 to 9 of 9
  1. jai kushwaha
    12-24-2016 08:27 PM
    jai kushwaha
    Hello friends I have a field name vehicle in time which has data type like 12-11-16 11:15:12 and another field vehicle out time which is also have same data type 13-11-16 23:11:15 now I want to calculate the time between them in hh: mm: ss formate? What to do
  2. jai kushwaha
    03-08-2016 02:16 AM
    jai kushwaha
    this is the screenshot image link of the problem


    http://fud.community.services.suppor...7-1f5bed22de8d


    can you please tell me what is it and how i can solve it. it is happening since i used the "clear clipboard" code given by you it is working fine but now i am facing this problem. my form is based on copy and paste append method. and when i choose any of the msg option like "Yes", "No" it paste append (i+2) record at the place of (i+1) record
  3. arnelgp
    02-29-2016 03:02 AM
    arnelgp
    can't see you image there.
  4. jai kushwaha
    02-28-2016 09:30 PM
    jai kushwaha
    well i don't know that how to attach my database here??
  5. arnelgp
    02-28-2016 02:59 AM
    arnelgp
    if you are able to upload your db, then i can have a look at it.
    i have never encountered such problem so far.
  6. arnelgp
    02-27-2016 05:01 AM
    arnelgp
    i have not tried this, but no hurt trying. copy the code in a module:

    #If Win64 = 1 Then
    Private Declare PtrSafe Function OpenClipboard Lib "user32" (ByVal hwnd As LongPtr) As Long
    Private Declare PtrSafe Function CloseClipboard Lib "user32" () As Long
    Private Declare PtrSafe Function EmptyClipboard Lib "user32" () As Long
    #ElseIf Win32 = 1 Then
    Private Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long
    Private Declare Function EmptyClipboard Lib "user32" () As Long
    Private Declare Function CloseClipboard Lib "user32" () As Long
    #End If


    Public Sub ClearClipboard(Optional windowHandle As Variant = 0)
    #If Win64 = 1 Then
    Dim hHandle As LongPtr
    hHandle = CLngPtr(windowHandle)
    #ElseIf Win32 = 1 Then
    Dim hHandle As Long
    hHandle = CLng(windowHandle)
    #End If
    OpenClipboard (hHandle)
    EmptyClipboard
    CloseClipboard
    End Sub


    then on your form's close event:

    Private Sub Form_Close()
    ClearClipboard
    End Sub
  7. jai kushwaha
    01-08-2016 10:51 PM
    jai kushwaha
    can someone give me advice that how to distribute the database to other computer to work in real time ?? will it also work for different cities and Countries???

    please help
  8. jai kushwaha
    12-07-2015 12:47 AM
    jai kushwaha
    can anyone tell me what this code mean is??

    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70

    how I can know the number 8 mean in this code??

    I want full explanation of this code if anyone knows please tell me.


    thanks in advance....
  9. jai kushwaha
    11-22-2015 09:40 PM
    jai kushwaha
    can anyone give me the northwind sample database??

Statistics

Total Posts
Visitor Messages
Total Thanks
General Information
  • Last Activity: 04-23-2017 08:10 AM
  • Join Date: 11-01-2015
  • Referrals: 0

Friends

Showing Friends 1 to 1 of 1



All times are GMT -8. The time now is 08:47 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World