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 10 of 11
  1. arnelgp
    07-25-2018 09:41 AM
    Sorry for late response.
    You can send a sample db to agpuzon@gmail.com and I'll make a sample form for you to look at.
  2. jai kushwaha
    07-21-2018 09:04 PM
    jai kushwaha
    hello friends, I have two tables in my database with name "Invoice" and "Supplier" now I want to make a "Invoice form". And on this Invoice form I am having a combo box of supplier Name which is taking source data from supplier table. All the other fields on invoice form changes on change event of combo box. Now what i want is that, this data will automatically save into INVOICE Table.

    in simple words form will use Supplier table as record source and save this data into Invoice table on change event of combo box.
  3. 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
  4. jai kushwaha
    03-08-2016 02:16 AM
    jai kushwaha
    this is the screenshot image link of the problem


    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
  5. arnelgp
    02-29-2016 03:02 AM
    can't see you image there.
  6. jai kushwaha
    02-28-2016 09:30 PM
    jai kushwaha
    well i don't know that how to attach my database here??
  7. arnelgp
    02-28-2016 02:59 AM
    if you are able to upload your db, then i can have a look at it.
    i have never encountered such problem so far.
  8. arnelgp
    02-27-2016 05:01 AM
    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)
    End Sub

    then on your form's close event:

    Private Sub Form_Close()
    End Sub
  9. 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
  10. 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....


Total Posts
Visitor Messages
Total Thanks
General Information
  • Last Activity: 07-22-2018 02:01 AM
  • Join Date: 11-01-2015
  • Referrals: 0


Showing Friends 1 to 1 of 1

All times are GMT -8. The time now is 04:12 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

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