Thanks NeoPa.
As I understanding it, subscription of MS365 Personal or Business Standard would include DataVerse.
I take it from you answer that DataVerse should be easier than SQL Server. I'd love to try it. I suppose there will be experts here offering DataVerse support if I encounter technical challenges.
Thanks!
Joe Y
Last Activity: Nov 16 '22, 07:27 AM
Joined: Oct 19 '11
Location:
-
Access Backend Cloud
I have been looking for an easy solution of placing Access backend files in the cloud. *SQL Server, Azure SQL, or SharePoint are just too much of challenges. *
Since Microsoft launched the Power AP last year there are a couple of YouTube videos from (seemed to be) MS employees talking about Dataverse as a good place to migrate backend data to. *I have not seen discussion about Dataverse here. *Has anyone here have experience of Access... -
NeoPa,
The original VBA in the Cancel button's Click Event is -
...Code:On Error GoTo CmdUndo_Click_Err On Error Resume Next DoCmd.RunCommand acCmdUndo Dim dbs As Database Set dbs = CurrentDb Dim strOrder As String strOrder = Me.TxtOrderNo MsgBox strOrder, vbOKOnly dbs.Execute "Delete [DBA_inv_payment]* from" _
Leave a comment:
-
Hi twinnyfo,
For some reason the delete SQL is still not working after I copied the code to my database. I wonder if it has something to do with these codes locating inside of a "Cancel " button's click event? I know this may sound silly, but I can't think of anything else.
Since I have this speculation I have tried to comment ( ' ) the line below. However, this did not resolve the issue.
...Leave a comment:
-
SQL VBA Delete statement not working
Hi,
I have an access database that handle sales and shipping. In the shipment form, user can click a button to take following actions.
1. Check largest invoice number in the order table [DBA_order_heade r] then add 1 as new invoice number to be assigned to current order record.
2. Add new record to two tables associate to invoice payment: [DBA_inv_payment] and [DBA_inv_pymt_de duction].
There is... -
Thanks for the update. Looking forward to all patches released. My users have various versions of Office installed.Leave a comment:
-
Thanks for the advice. I’m working on the workaround suggested by Microsoft. Let’s hope they issue the fix soon.Leave a comment:
-
DJRhino1175,
I've never dealt with registry. Can you guide me through where to save the .reg file? Most of the users are using Windows 10 pro, some are Windows 7 Pro.
Thanks in advance!Leave a comment:
-
There is a workaround suggested by the support page. However, I have lots of VBA using query. Making each change is going to be a big challenge.Leave a comment:
-
The page from Microsoft I found from Google results is -
https://support.office.com/en-us/art...3-f21636caedec...Leave a comment:
-
Query is corrupt error message 11-14-2019
All of sudden, many vba functions in my Access application using query are not working with error message "Query is Corrupt".
Google results has one page from Microsoft dated 11/14/2019 referring the issue to a patch updates for MSI of several builds.
Does anyone know when MS will fix this issue? Will it be automatically repaired when fix is done by MS or is there some steps we need to do to fix the prob... -
Frinny,
You guided me to the right direction of using Join. The prompt response and helps is why I like to ask question in this forum.
Much appreciated!Leave a comment:
-
NeoPa,
You are right. I am evaluating if the prompt from Access of "## record updated, Yes/No" is a good or bad thing to user.
Thanks,
JoeLeave a comment:
-
It works! However, I had to put the query in a string and execute the query with DoCmd.RunSQL in order to make it work.
Somehow, when I put the update statement directly in the VBA, Access keep popping up error message asking for “expect end statement”.
Below is the codes that worked for this case.
Thanks to both Frinavale and NeoPa for concept and VBA helps.
...Code:Dim InvSQL As String Dim strJID
Leave a comment:
-
Thanks Frinavale. I will try this approach. I am not a VBA expert so it will take a while to tell results.Leave a comment:
-
UPDATE with WHERE conditions reference to fields in other table
In my access database there is a transaction table named “T_Inv_Transact ion” that has records of ingredient quantity generated when a Job_ID is created.
The fields in this table related to my question includes followings. There is no primary key assigned to this table.
Job_ID
ProdID
ProdV
BatchQTY
UOM
Each time when user hits a production button, a Job_ID is created... -
Okay, thanks for the advice.Leave a comment:
-
Thanks zmbd and jforbes. Storing the date/time stamp in separate table is a good idea. User specific date/time stamp is even better.
However, without involving OnCurrent event, record opened by key word search won't be recorded. This is still something I wanted to include.
I am reading articles about Pessimistic locking vs optimistic locking. Is this the direction that I should research about that may be a solution...Leave a comment:
-
Problem with listing recent opened records
In a multi user environment I am trying to add a combo box to a form that lists all records recently been opened and the list is sorted from newest to older date/time. User can open a record with this combo box.
The date/time stamp of the record needs to reflect the open time either by search results or by go to record with another drop down list of the same form.
The reason I wanted to do this is because I have hundreds... -
zmbd, Your helps are greatly appreciated!Leave a comment:
No activity results to display
Leave a comment: