Search results

Hi, Sorry to as this question. Is it possible for a standard A4 page invoice be reduce to print in a small thermal printer with vba code I am asking this because everytime I have to deploy my desktop App to a client, I will have to setup the thermal printer manually and if it's not a thermal...

Hi, I am trying to write a code into my small application but it keeps throwing errors when I compile it (Type Mismatch) Below is the exact code throwing error at .OpenCurrentdb: Set dbs = CurrentDb Set rs = CurrentDb.OpenRecordset("SELECT tblItem.QtyAvail, tblItem.UnitSale...

Hi, I am having a problem update multiple tables that are joined together in a query. I want to update them with recordset in a multi-user environment Please can someone show me the correct synthax to do that? Thanks in advance Moore

Hi, Please a quick one here. I have an app that is shared by 2 user (splitted BE/FE). Everything was working fine until I discovered that it's becoming too slow and so I upgraded the windows from 7 to 10 pro. My puzzle now is that the same access app that was working is now locking up after on...

Hi, I have a solution being used by 2 users on a Lan/Wlan. Initially there wasn't any complain until recently they are complaining of too slow activities I went there to check and you need to wait minutes for one process to perform I change selecting Items from a ComboBox traditionally to using...

Hi, I am just trying out something here. Although I have gone thru various post concerning this question, but I haven't seen the exact one that fits into my criteria. I want RecordSet that Insert The Following Fields from a query (MyQuery) into a new table (MyTable) MyQuery feilds are TransID...

Hi please can someone help me out on this code? Dim Db As Database Dim RS As Recordset Set Db = CurrentDb Set RS = Db.OpenRecordset("SalesQRY", dbOpenDynaset, dbSeeChanges) With RS ' Modify data in local recordset. Do While RS.EOF .Edit If RS <> Forms!frmPoS!Invoice Then...

Hi, Please I just bug into this problem on my small access application being used by 2 individuals using the same shared Application on a network. The puzzle is when both of them update the same item in a one table, one freezes while the other may scale through. My request here is any code that...

Hi, I just want to find out if it is possible to have items (any product) display within a form in a grid-like boxes as in 4 or more in a row and 10 or more columns? I will greatly appreciate if anyone can find a way out for me in this regard. Thanks, John Moore

Hi, can someone provide me with VBA code to update multiple tables on a split backend. There are 2 or 3 system interconnected to the same backend and my puzzle is when 2 systems are updating the same Item, one will freeze while the other will update successfully I have been using queries to...

Hi all, can someone here give me sample VBA code to UPDATE Multiple tables/Querries at the same time from one FORM? I have the following code which I don't know the reason why it is not working after series of trials: Private Sub cmdSales_Click() On Error Resume Next Dim SQL As String Dim SQL2...

Hi please how can I resolve this issue? "Compiler error" The code in this project must be updated for use on 64-bit systems. Please review and update Declare Statements and then mark them with the PtrSafe attribute...

Hi, I am having problem with my code. This code which have been working for me before now just started to throw error of Compile Error: OverFlow for the following VBA. Global g_Enabled As Boolean Public Const salt As Long = 7038117603# Public Function Encrypt(strIn As String) As String Dim...

Hi, forgive me for asking this question again. I know this issue have been attended to many times. But I still cannot get it done. I have an ms-access form to send email without outlook support, using vba. The following are the items on the form: textbox(From) textbox(To) textbox(subject)...

Hi, I am just wondering the best and easiest way to sync MS Access backend with other users online. I tried google cloud but don't know how to connect google cloud to my Access table. I am also thinking if I can purchase office 365 online to do the syncing. Please I need your best advice on...

Hi, I am just wondering the best and easiest way to sync MS Access backend with other users online. I tried google cloud but don't know how to connect google cloud to my Access table. I am also thinking if I can purchase office 365 online to do the syncing. Please I need your best advice on this...

Hi, I have done a lot of search before coming up with this puzzle. I have a desktop App that I would like to connect to cloud for syncing with other device. So I thought the first easier step is to link the DB with my SQL server and then connect to google cloud, as I thought would be cheap, but...

Hi, Please I have the following fields of a form: txtSender txtReceiver txtSubject txtbody btnSend My email configuration is: ayz@gmail.com password: omniFavor2010 Please someone use these data to show me what and how to insert code for send email from access 2010 in the absence of outlook...

Hi friends, I have an access tables that I need to be copying excel data from different sources and from different sheets. Please how can I do this with VBA / Module?

Hi, I have an access app that I would want to make available for different PCs online because they are in different locations. What is the right way to make this happen? Can I use offline sharepoint or VPN. Please advice me on better way to make it through. Thanks, Moore