Search results

Hello every one how do i design my own Main Menu Bar and display it instead of access menu bar thanks

Dears, i need Extension for Access Developer 2013 i try to make Accde File but it show me: your database is big size also on Accde file , there is a chance to delete table , i don't like that

Hi every body I'm working on northwind database, i would like to add a form to handle Order Returns i want to make a button in order Return form to clone the specified data in sales order and retrieve its data to the order return form thanks

Hello i have the following code to get file list from specified directory: Dim db As DAO.Database Dim TB1 As DAO.Recordset Dim p As String, x As Variant Set db= CurrentDb Set TB1 = db.OpenRecordset("Table1") p = "E:/Reports /*.xlsx" x = GetFileList(p) Select Case IsArray(x)...

Hi every body i have the following code to get excel sheet name and last row number it work fine with no problem but when i go to next record in my form and press the button agin it produce error 91 "object variable or with block not set" please review the code : ‘ this code to get sheet name...

hello every body how can i display multi images on 1 page as a grid view in access report thanks

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

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

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

Hi every body i have an axcell file my program edit this file but some times end users remove it to other location and the program produce error file not found check the path i would like my program to display dialog box for manual searching or to look for file in all drives automatically...

Hi Every body, i have this ode: set RsItems = db.openrecordset("Items" RsItems.Addnew RsItems!Quantity = RsItems!quantity + 10 Rs!Items.update Me!Total = RsItems!Quantity RsItems.close The displayed Value in (total ) is an old value not after adding 10 the problem is the table Items...

HI every one, i have a table contain a combo box with 2bound column the first is Employee_Name and the other is Employee_ID my code is Dim RsStaff As DAO.Recordset Dim VarX As String Set FoodStuff = CurrentDb Set RsStaff = FoodStuff.OpenRecordset("Employees") RsStaff.movefirst VarX =...

Dears, i have a report and aform include one button and date field i would like when i press the button, the report open and show all records but when i type the date the report open records with specified date