Search results

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...

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...

I make a crosstab query the items in the raw header and months in column header, quantity is the value. I set column for maximum qty of months. the problem appear if one item duplicated in one month, access take the maximum of individual value not for the summation of every month.

HELLO, i have a form like in attached image field C is calculated field =A/B I have list box and I am adding records to it the problem appear when I am trying to retrieve data in list box to the form again .If field "B" is empty in the list box the field "C" appear like in the image #Type! the...

hello, I have a login form i want to use the dim function to put the userlogin in the dash board form i made Dim getuser As Integer getuser = [UserLogin.Value] DoCmd.OpenForm "DashBoard" Forms![DashBoard]!text5 = getuser i think there is a problem in the syntax of [UserLogin.Value] thank you

I made entry form and I have a column with an attachment type. I want to run scanner directly from the form. the available now is to scan the document to the PC then upload it as attachment to the database

i have used this code to view a message to confirm saving the case yes & no working well but the case cancel i need to make me remain in the same record without saving, but it work like cancel Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Dirty = True Then If MsgBox("Do You Want To...

I have a form contain 4 combo boxes used to filter a query it all working well when I used this form as a sub form in a navigation form and try to run the query, access request the value of the parameter

access by default save all records immediately In the entry form the access save the entry always on closing or pressing new, I need saving to be after pressing save only

Hello, this my first post here I have a source table with fields: item, manufacturer & supplier. every item have more than one manufacturer and more than one supplier. i have another table for purchase order, the same fields are available also, I made lookup for the field item from the source...