Search results

thank you i find the reply Private Sub Clock_Out_AfterUpdate() Dim X, Y, Z As Long X = DateDiff("n", Clock_In, Clock_Out) X = X / 60 Z = Int(X) Y = (X - Z) * 60 Period = Z & ":" & Y End Sub i calculate the minuts first and then i convert it to number

the data type of (clockin and clockout fields) are time not number

Hi every body i create form to calculate the difference between clock-in time and clock-out time, what is the code to do that i have 2 fields the field 1 name clockin field 2 name clockout i have a text box to display result equal the period between time1 and time 2 thanks

Hello every body i would like an affiliate program designed buy MS access

Dears, this is Musab, Sudanese nationality Arabic is my native language i work in Saudi Arabia i always recommend MS access for every employer i work with i love it flexibility very much thank you very much my contact info : aldambo@gmail.com musab@mashaelcorp.com TEl : +966-11-474-0060 Ext...

Sorry i paste the help code by mistake this is the code i put : this is the error : A macro set to one of the current fields properties faild because of an error in a findRecord action argument

i put insteed of this, the exepression : "ID =" & Me.ID

yes it is simple when i'm going to create next,previous,find next but i need the functionality of search button located on the bottom right of navigation button, when you type a char it will search whole fields and match any part in a very high response , it work on text change i try this code...

Hi every body the default navigation buttons on access form is greatest and it has an effective search record field , but there is a bit of problem that is the size of navigation buttons is too small , is there any way to control its size ?? if no !! is there any code to make it as event on...

Hi every body, i have RFID reader (Motorola MC9190-Z ) i would like to send information from reader to MS access 2013 table i have table contain tag number, item name, color, size, Brand and details i need all this information to be inserted on my form or table how it will be is there any...

it is give me a null value even if i enter a full chars

Hi guys, i have a text box ( Supplier_Name) on the main form i would like to filter subform by any part of entered charactor on the feild (suplier_Name) here is my code : Private Sub Find_Click() If Not IsNull(Supplier_Name) Then Me.Suppliers_Details.Form.Filter =...

HI every body i would like to gather the first number of decimal places for example if i ha ve these numbers x = 2.356 & y = 2.6243 i want to be: x = 3 & y = 6 which function may i use

i have a code for browsing to determine location and the code work with no Error but the problem is that : for example when i choose D:\bee55\my folder , the text appear in Textbox1 is D:\bee55 only my folder not included on the text box. what shall i do with great thanks Private Sub...

i try the following code :- Option Compare Database Public FoodStuff As DAO.Database Public RsFood As DAO.Recordset Public Function Open_Table(Table_Name As String) Set FoodStuff = CurrentDb Set RsFood = FoodStuff.OpenRecordset(Table_Name) RsFood.MoveFirst End Function Public Function...

SO my question wasn't clear i mean, my solution has more than 10 forms, on each form i open more recordset so i need a function to be decleared as public like for example:- Function Connect_Table(Table_Name as string) connection = d:\database1.mdb End Function means i need a common...

i have a solution and my VBA was password protected I,m trying to modify the code but i can't remember password is there any way to breake it or remove any answer and reply will be highly appriciated thank you very much

Hi every body, i have three table in my project , on each form in my project i open three tables either to edit or add i open these tables an close them too much times on my code i use the following code Dim FoodStuff As DAO.Database Dim RsFood As DAO.Recordset Set FoodStuff =...

that is what I'm looking for i need a button to open FileDialoge and the value of FileDialoge to be used as the path for my excell file what is the appropiate code and action to do that Great thanks,,

it seem as it is not clear my question is : how to look for a missed file on other drivers and all its folder and their subfolders your reply will be highly appriciated