Search results

the Error at last Row ...when No rcord

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

Thank you very much for the quick response Yes, this is exactly what I want..I knew how to get customer data by querying..My problem was with adding the address or phone number..I used the RunSQL method. But it works wrong . DoCmd.RunSQL "INSERT INTO CustomerT ([Address] )VALUES (" & txtAddress...

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

yes.. that what I want thanks arnelgp You did a good job for me..and I thank you very much How do I hide the empty fields?

its a good idea arnelgp.. what about if i want each subject in column .. and student as a row ..did I make crosstab?

thanks Gasman for replying There are some subjects in which passing scores are different This means that I make one module for similar subjects in passing scores And do other functions for the different

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

you are awsome my experts ..thank you isladogs and arnelgp... its perfect your solutions

i do it before..and same thing if there is no answer..i think the only one to change the message to force the user to click ok..and make delete button if he want to delete record in combo: If MsgBox(strTmp, vbOKOnly + vbDefaultButton2 + vbQuestion, "Not in list") = vbOK Then

i did like this: Response = acDataErrAdded If MsgBox(strTmp, vbYesNo + vbDefaultButton2 + vbQuestion, "Not in list") = vbYes Then but still message

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

I think I'm going in the wrong direction..I'll try to change my plan again

im trying to use this cod .. but tell (too few parameter) Private Sub isActive_AfterUpdate() If Me.isActive = True Then Dim db As DAO.Database Set db = CurrentDb Dim rst As DAO.Recordset Dim StrSQL As String Set db = CurrentDb Set rst = db.OpenRecordset("SELECT...

Why did i choose this method? Because I have to choose the main examination(category), from which the secondary tests are branched. With each main examination, I choose the secondary examinations(tests), which in turn move to the sub-form(patientTestingF) that is related to the main form. The...

i cant make i cant make CHKID in test table because it just refference table i select what i want and copy to subform patientTestingF which related with main by CHKID

you mean to use recordset to add records to table patientTestingT AND then refresh patientTestingF to display the records?

tkank you Ranman256 for Replying I know to use Appending ,, but it is not work..i think because the related id of sub form with main ? i don know exactly why not working.. this is my demo

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

You are right..but my client has a lot of workers and he wants to count 30 days per month to calculate salaries..this is how the agreement with them..honestly, I did not come across such an agreement thank you plog