On receiving data from a Json format from the RS 232 COM, I seem to have some a bit of a challenge, I have no problem in sending
(1)      I’m not sure at what point the received data (In Json string) from the gadget will  looped into  or iterated until passed through the table , I cannot see the actual connection here, my maths does not seem to balance. Kindly see if you can spot something here.
Below is the code requiring checking , currently there no errors whatsoever , but the connection on how that data which will be received will looped into the database that is where I’m behind.

Code requiring your attention

Private Sub CmdEmp_Click()
    Dim json As Object
    Dim i As Integer
    Dim db As DAO.Database
    Dim rs As DAO.Recordset
    Dim item As Object
    Dim intPortID As Integer ' Ex. 1, 2, 3, 4 for COM1 - COM4
    Dim lngStatus As Long
    Dim strError  As String
    Dim strData   As String
    Dim lngSize As Integer
    ' Read maximum of 64 bytes from serial port.
    lngStatus = CommRead(intPortID, strData, 64)
    If lngStatus > 0 Then
        ' Process data.
    ElseIf lngStatus < 0 Then
        ' Handle error.
    End If

    ' Reset modem control lines.
    lngStatus = CommSetLine(intPortID, LINE_RTS, False)
    lngStatus = CommSetLine(intPortID, LINE_DTR, False)

    
    Set db = CurrentDb
    Set rs = db.OpenRecordset("Contact")
    
    i = 2
    For Each item In json
        
        With rs
            .AddNew
            ![id] = 

Select all Open in new window

…

A client has sales people out in the field throughout North America and needs to get signatures on electronic contracts.
They are presently using WACOM signature pads and software.
We are looking for a cost effective solution to replace the WACOM pads.
My understanding is that they need to have internet access for the pads to work?
The pads cost over $350 each.
It is one more thing for them to carry
It is one more thing for them to break or lose or forget in their hotel rooms
A lot of the places that they go do not have internet access even with a Verizon JetPack
The reps are presently using HP Elitebook 840 G5 laptops
We have gotten suggestions to use DocuSign, but there are monthly fees associated with those types of services
We are looking for alternatives.
Thanks in advance.

Hello Mate ,

The attached report shows how much inventory is enough based on average sales,
I need a pillar chart similar to the attached chart as an example, with the number of months covered
Safty-Stock.xlsx
safty-stock.png

I would need an idea to set up a vacation calendar for our company.

So, we have 3 branches in 3 different cities and 5 different LoBs (marketing, Sales, finance, business, technology)

I am looking for a solution where I can create a calendar for say people in "Technology" visible for everyone in "Technology".

I know I can create an office 365 group and send an invite to it that will show the blocked dates for my vacation. But I don't want that every member should receive every invite or changes notification in his Inbox. But the members should be able to view their vacation in their calendar as well as in "Technology" calendar as well

Any thoughts or ideas?

Thanks in Advance

How to get live data for a point of sales machine with data in Json format into Ms Access tables ,like below:

(1) tblCustomerInvoice (Primary table)
(2) SalesDetailline (Child table)

Parameters and data type are as below:

Json:  char *TaxCode, char *Productcode, char *number, char *date, char *CustomerID, char * amount, char *SpecialCode, char* intKey

Access: text  TaxCode, Text Productcode, number Number,date Date, Int CustomerId , double Double , text spcialcode , autonumber Primary key

The only sure way is to use VBA , any idea on how to do the following:

(1) VBA function to get the data and insert into the tblcustomerinvoice and tblsaledetailsline

What we want to archive here is when a person is punching data on a POS machine , then simultaneously the same data must be entered in the above two (  tblcustomerinvoice and tblsaledetailsline) this means that we won't need to recapture the same data again.


Regards

Chris

Dear Experts,

I am a part of a team that developed an iPhone/Android game.  We are in a unique position because the sponsor of the game is willing to pay a lot to get this app marketed by an experienced digital game marketing company.

My issue is, I am not familiar with the gaming industry at all, and not sure how to find such marketing company.  The 2 contacts I found through my professional networks did seem qualified, but as soon as we start talking budget, they stop responding.  (I was told to start from 20k, but my sponsor is willing go pay quite a bit.  He wants this game to be popular.)  
Perhaps they are not willing to work with such small team of developers?  I am thoroughly stumped to how I can proceed with this problem.
Please advise.

On our point of sales receipts (Ms Access) form we are using on current event to capture the following automatically:

(1) Date
(2) "Cash receipt"

Now the problem is that when closing the form, its leaving a blank cash receipt which making the serial number having gaps because of the same blank receipts. Is there another event to use other than the current event to archive the same results:


Regards

Chris

Hello

We are to deploy Sales force Cloud to users.  From initial testing 2FA looks to work well using the authenticator app, however we are now proposing to block access by corporate IP ranges i.e. our firewall WAN IPs, rather than 2FA.  This will mean VPN for remote users will be required not only for SF but other current and future apps.  
Unfortunately the subscription/evaluation has expired and SF wont extend the trial, i have to pay a years fee to continue.

We are also looking at SF inbox, marketing cloud, SF inbox and other 3rd party tools to help integrate SF with exchange.

So, if w ego the route of IP blocking can anyone confirm if this can be setup in Sales Cloud globally for Inbox, marketing and sales cloud?  I only see option to white-list SF IPs.

Thanks

I want the Point of sales report to close automatically either after printing or if it failed to print , how do I do it , please do not worry about the the attached action queries they are there to handle the double entry only , below is my VBA code:

Private Sub CmdPos_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "QryRevenueAccount"
DoCmd.OpenQuery "QryCostofSales"
DoCmd.OpenQuery "QryStockAccount"
DoCmd.OpenQuery "QryVatAccount"
DoCmd.OpenQuery "QryReceiptsAcc"
DoCmd.Save
DoCmd.OpenReport "rptPosReceipts", acViewPreview, , "ItemSoldID =" & Me.ItemSoldID
DoCmd.PrintOut , , , , 1
DoCmd.Close acReport, "rptPosReceipts"
Me.Refresh
End Sub


See how the above code can be amended.

Regards

Chris

Hi

My point of sales receipts is compiled from queries that gather the following:
(1)      Taxes
(2)      Quantity sold & prices
(3)      Other calculations
So in short it is not possible to use the current form to act as a receipt report. These queries are the one providing data for the receipt report, that is why currently to print a receipt report you need to close the current input form and open the parameter query form.
Now I’m wondering if there could a better way of binding the parameter query using the input form so that people do not need to close the current input form but can just invoke the printing of a receipt from the same input form.

I Thought MS Access save data into the table immediately after leaving a control, if yes how can I use the current primary key of the current receipt form as part of the parameter query so that the document printed is the current document showing on the input form screen?
I want to maintain the current form parameter query because sometimes the document may fail to print, then with the current parameter form query available I’m able to preview the document and reprint it.

I know it is possible to attach a macro to either print directly to the printer or preview the document by using the built in macro wizard, but the problem is how to the current document I’m not sure here because this macro wizard will only ask for the report to be printed, this means that I will end will all receipts being printed.

Could it be that there is …