Search results

Hi my Expert.. I have button to select or deselect all OptionButton in continuous form and change its caption ...but its select just first OptionButton ..not all OptionButton Private Sub cmdSelectAll_Click() ' Toggle the state of OptionButton1 Me.OptionButton1.Value = Not...

Hello My Expert I have tblPurchase with PurchaseID AS primary key and purchaseDate and tblPurchaseDetail with PDID AS primary key and PurchaseID as number and ItemID AS number and purchasePrice as currency...what I want the latest purchasePrice for each Item according to latest purchaseDate any...

Hi Expert.. I used module to sum Amount according to CustomerNumber And CurrencyType its working Good and give me the Result im main form of saleInvoice but..when there are No Records in the table give me Error "invalid use of null".. in "TotalAmount = rs!TotalAmount" How can I FIX that...

Hi Expert when Im trying to renumber of sub_form for every new invoice ..i used this for control source of unbound textbox =IIf(IsNull([ItemCode]);Null;Nz(DCount("ItemCode";"SalesOrderDetailsT";"SaleID=" & [SaleID] & "AND SaleOrder <" & [SaleOrder]);0)+1) its work good..but I Get Error at the...

Hi Expert.. I have a sales form..when I type the customer's name..it brings me the address and mobile number automatically And when its not exit...I will enter the address and mobile phone in their respective text boxes and they are added to the customers table Any Advice

Hi everyone.. I have a query to display students' scores..and there are 8 subjects..such as mathematics, physics, chemistry, etc..each subject is in a field In case that the student obtained a grade between 20 and 24 in mathematics, we write in the field (pass) In case that he obtained a score...

Hi Experts.. i used the below code for entering new record inside combobox..if i choose yes from popup message its fine but when i choose NO..display popup message (the text you Entered isnt an item in the list)!! How can i prevent display this message? thank you all ----------------------...

Hi Experts I have subform (TestF).. when I check select every time copy the test name to subform (patientTestingF) ..and when click on select all ..copy all testName to (patientTestingF) I used this code..but it used the same record every time I selected and not going to new record..any Advise...

Hi Expert.. Is there a function through which all months can be considered to have 30 days, so that when I subtract a first date from a second date, the months are considered to have 30 days? so i get the Result of days I can do it with a query but can it do it with vba thank you All

Hello, my Experts.... I have a function that calculates the number of years, months and days of real service for the employee.. taking into account the leap years in that period.. but I am not sure that it calculates the leap years.. Is there a proven function for this purpose with the long...

Hi all experts.. I found this file on one of the respected sites..and when I enter a value in the search box, it shows me the records..and it works fine.. I tried to create another form that has a text box to search in that form..I tried a lot, but it shows me an error..any advice, I am...

Hi experts.. I get some code below from CHAT-GPT to close form after 10 second when mouse not move is there any suggest ..thanks Private Declare PtrSafe Function GetCursorPos Lib "user32" (lpPoint As POINTAPI) As Long Private Type POINTAPI X As Long Y As Long End Type Private m_x As...

Hi ,Expert I have 3 field in query as shown ...I have yearNu and monthNub ... and subtractMomonth ..when I enter 15 in subtractMomonth ..the resault is YearNu=18 and MonthNu=11...is there function to do do this thanks for all

Hi, I have table as shown ..and I have form with 3 textbox txtID,txtField,txtResult how can I get txtResult=125 when txtID=2 and txtField=field2 any suggest for that...thank you

hi sir... I have table like Table1 have this fields i want concanetated descreption of cusName according to dates.. like this: thanks my Experts

Hi Experts I know how to hide the fields that have no value in the report..but I don't know how to arrange the fields that have a value..I mean one by one without the hidden fields spaces Is there any suggestion? thank you so much my Experts

Hi Expert.. when i make encrypt password to my database..the size remain the same when i compressed with WinRar is there any advise thank you

hi experts.... Can anyone tell me why I get an error message "loop without do"? for this code Do While Not rs2.EOF For j = LBound(MYarray) To UBound(MYarray) If rs2.Fields("ISSUE").Value = MYarray(j) Then store = store & "," & rs2.Fields("ENGINEER").Value...

Hi Experts.. I have a continuous form representing customer invoice amounts When I receives a certain amount, its subtracts the amount of each invoice ... and the rest represents the remaining amount of the last invoice as shown in attachment any advice plz

Hi EXPERT.. its possible in Excel..but I have no idea how can do it in access I have this table and I want it like this im thinking about crosstab.. but no have idea how to do it thanks for all