Recent content by MAAS8000

Wait guys, I need time to read about this then return to you Mr. Plog Actually the button save is not the access save or is a VBA command add data in two tables

How I can enforce Pessimistic Locking?

The problem in the first post " if two user hit the button save in the same second. they will take the same number. one of them will be saved the other will have a problem"

my system is like a point of sale the user select the needed items then press "save" In the database I have two tables one detail and the other is summary of the transaction when press save the VBA code add the items in the detail table and create the transaction number according to the above...

try this in the login form i made a button to open the linked table manager with this code Private Sub Command52_Click() RunCommand (acCmdLinkedTableManager) End Sub you can update the DB address first then make login

let me check why i belt it like this

is there another way for creating transaction number rather than this function (Dmax) from the master table

I have a system with a back end and and multi front end. many user use it in the same time. i am using the below function to create transaction number. the problem i am facing that if two user hit the button save in the same second. they will take the same number. one of them will be saved the...

First I want to thank every body here because I learned so much from you. I am a pharmacist. I developed a simple access system to use it in our pharmacy I make a short video for it Sterilized Pharmacy Preparations System - YouTube I need your precious suggestions and comments and I am asking if...

Sorry, the problem was in calling the function, it was a stupid mistake

this my arabic code. honestly it is not made by me i found it through the web and use it in Excell for several years. it works very well in excell but i couldn't use it in access. i may have a problem in calling the function or may need some edit in the VBA. as my mother tounge is arabic, my...

I have a big Module to convert numbers to words. for example "1230" after using the function is expressed as "One thousand two hundred and thirty". it works good in MS Excell. I have copied the same VBA Code in a module in my access project. In one form I tried to use the function , I can find...

thanks I solved it I made the month summation in the first query then the crosstab next

sorry, i hope this is clear

i have edited it should be 96 & 104 but access get the maximum value from the table in this date 96 is sum of two data 63 + 33 104 is sum of 67 + 63