Search results

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

i try this code in other table include both id number and name and it work successfull but my table above has a combobox include both id and name but only display the name and the messagebox display id field i would like to display the name fieled instead of id

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

i use access 2003

Dears, i would like to hide the access window and only startup form should be appear. your care will be apprciated

that is goooooooood and fix my problem

thank you my friends i find out the solution Private Sub CopyFile_Click() Dim date1 As String date1= Format(CDate(Date), ("dd-mm-yyyy")) FileCopy "E:\musab\book1.xls", "E:\musab\PPlant Daily Report " & date1 & ".xls" End Sub

Dear All i have a file on E:\bee55\DailyReport.xls i have this code Private Sub CopyFile_Click() Dim strPath As String Dim date1 As String date1 = Format(CDate(Date), "yyyy-mm-dd/ hh:mm:ss") & ".xls" strpath = "E:\bee55\Daily Report" FileCopy "E:\bee55\DailyReport.xls", strpath & date1 End...