Search results

i did what you said but nothing happened,still the same error

Thank you for your quick reply. I tried your solution but it still popups the error :The expression is typed incorrectly, or it is too complex to be evaluated. I have to mention i live in Greece and the regional settings are Greek,that is the system uses dd/mm/yyyy. Is the Conc function so...

Hello everybody I am desperate,i need your help guys .I can't find a solution to the following problem!I have been searching for hours for a solution but i haven't accomplished anything. In a Module i have the following useful code(i found it in this forum as far as i remember) which...

select distinct works! I cant make Instr work! I used the followin code but nothing still the same Do While Not rs.EOF If Not IsNull(rs!Fld) Then If InStr("vFld", "rs!Fld") = 0 Then vFld = vFld & ", " & rs!Fld Else: vFld = vFld End If End If...

Thank you, i will try the Instr function. I think that maybe a "distinct" after the "select" would solve the problem! What do you think about that?

Hi everybody, I have been using the following piece of code that refers to concatenation of multiple rows in queries. http://www.access-programmers.co.uk/forums/showthread.php?t=64611 But i want to ask for something more complicated if anyone can help me in this forum. I need a small...

Hi Jon K, your Concatenate Multiple Rows Access 2000 code is an excellent piece of code that has saved me a lot of times. But i want to ask for something more complicated if you can help me . I need a small adjustment of that piece of code but i am confused. I want the concatenated field to...

Hi everybody, Jon K this is an excellent piece of code that has saved me a lot of times. But i want to ask for something more complicated if anyone can help me in this forum. I need a small adjustment of that piece of code but i am confused. I want the concatenated field to include only...

all the fields of that form are bound to correspondent (same name) fields in Table1. What is it that you are missing and i can't make myself clear?

the bound field of the combo is Address1 on table1.All records for this fieeld in this table are Null from the start.This table has only values for the customer id name surname,but it has null values for the address1 field. So ,in form1 which depends on table1 the user sees values only in...

In the Current event procedure of the form i tried this: Me!address1.RowSource = Me!address1.RowSource but it still has problem. When i select something inside the 1st combo regarding 1st record of the form,this selection remains and it is visible. But when i move to the 2nd record of th...

The combo box is bound to the relevant field of the table that the whole form depends on (Table1). Here is what i really want: In my database i have seperate tables for Customers and their addresses and phones,that is to say a customer may have 2 or more addresses or phone numbers. So in this...

can anyone help me,please?

Hi everyone, I experience the following problem. I have form1(datasheet view) which get records from table1. In this Form1 there are 4 fields customer_id,Name,Surname and Address. Address is a combo box which gets records from a query (customers_and_address_query : SELECT...

I think that the lines of code that should change are the following: 1)Set rsc = Me.RecordsetClone 2)SID = Me.ypothesi_id.Value 3)Me.Undo 4)Me.Bookmark = rsc.Bookmark where the ypothesi_id is the txtbox in the subform of the Client_form(main form) Please can...

Thanks,but you dont tell me something new. I know that i should write the beforeupdate event of the ypothesi_id txtbox,it was my mistake to type afterupdate. It is one field i want to prevent duplicates into and i use the beforeupdate event of that control not the form's event. i dont know how...

Hi everybody,i would be grateful if someone could help me on this: I have the following code to prevent duplicate records Private Sub ypothesi_id_AfterUpdate() Dim SID As String Dim stLinkCriteria As String Dim rsc As DAO.Recordset Set rsc = Me.RecordsetClone SID =...

I want to thank you for your attention and help in my topic. Do you have msn or skype so that we can communicate ? Mine is mihalist80@hotmail.com,if you dont have problem ,add me to your list.

Sorry,it works with the is Null I was performing the queries in view mode and actually it didnt do anything at all I double clicked on it and it did the job. Thanks for everything.

When i design the query,in the sql view,the code which is generated is the following: UPDATE Af1_temp SET Af1_temp.card_number = [entity_code] & [branch_code] & [account_number] WHERE (((Af1_temp.card_number) Is Null)); But anyway something is wrong with this code,i changed it to the...