Recent content by humer

that I did: I made a replication of all databases and I tried to synchronize them. Of corse - no good results. my proposed solution after your post, I think to do the next things: 1. after all the data are completed I take each db in part and I convert the autonumber to a number field type...

Hello !! That is a very interresting thing: I made a database with 20 tables. After I made it I send it to many (15) people to fill it in. The problem is now to synchronyze all this copies of the same database, but with different content inforamtion. Can somebody tell me how can I import all...

Hello !! I have a address composed frrom more fields: Street, Town, Region and Zip Code. I want to made a guery that will made only one field with all the information. Another question with the same idea. I have 2 tables relied by the 3rd table to make a relation: infinite to infinite for the...

I use OR only in the concatenation of the fields. The data is token from the table Fin_Programs and the criteria is Print (Yes/No field). the problem is if I can access the table field value from the recordset! -------------- thanks

Hello Again me, I changed a litle a code to make the final result, but I have a problem. The problem is accessing the field 'rst!Fin_Program_ID.Value' : type mismatch. Help me please :( Dim Criteria As String Dim rst As Recordset Dim sql As String Criteria = "" sql...

ok i think iwasn't understood. my only poblem is to access the fields from a query, that means than i don't know how to make the condition in the for. below i write the pseudo code For (variable < number_of _rows) Criteria = Criteria & "[Fin_Program_ID] = '" & Query!SPTrue!Field[variable]...

in the next code i want to select from the query 'SPTrue' all the fields and apend it to the string criteria. executing this is an error that reports to that "an object value is required". i know that my problems is in the for condition but i don't know how to made it :( can somebody to help...

ok no, i don't need this field in the table, but i use it like an selection tool in this subform ... is it possible to assign it or not ? can i assign the ch. box with the record

Hello everybody i've got a question: is it possible to make a continous form where for each record to assign a checkbox for a record, not for all thanks

A new problem: I want to change the visibility of some fields in the report from the same form. I made some checkboxes in the form for selection of the fields that I to view in the report. By default the fields from the report are invisible. Here is the code that change the visibility, but it...

A new problem: I want to change the visibility of some fields in the report from the same form. I made some checkboxes in the form for selection of the fields that I need in the report. By default the fields from the report are not visible. Here is the code that change the visibility, but it...

thanks you very much that realy works I have one more question: can I change the visibility of some fields in the report in the same function ???

Re: Re: problems with docmd.openreport 1. if the checkbox is selected then apend the criteria 2. yes, there are this fields 3. valid = true 4. the message of the checkbox is the criteria that is selected exemple: I selected from the combo cb2 Criteria1 and I has valiadate the checkbox c2...

Hello everybody. I made next function that open a report with a condition that is made from a combo box in a form what is attached with a checkbox. If the checkbox is valid then for the criteria is attached a additional condition. The problem is the next: if there is more that one condition...