Recent content by Massoud

Hi I'm developing an Application with PHP and I'm using MS-Access as the database. In my table , I have a field with the type set to Memo. There is no problem when writing in the table , using INSERT INTO ... query. I've checked the data manually and the data is complete. However when trying to...

Hi I'm trying to find a way to highlight rows (or have different format from normal rows ) of my subform based on the value of two fields ( deb and cred fields ) If they are equal the normal formatting is used. If not, that specific row should have different forecolor ( or back color or etc.)...

Hi I need a query to calculate the sum of amount for each type and each customer in a specified range of date ( date is saved in yy, mm , dd fields) I have created query4 in the attached file using the sum function and where condition, however it doesn't calculate the total, instead only shows...

Hi, I have two tables Inputs ( with the fields : GoodsId, Net , Quantity) and Outputs ( again with the fields : GoodsId, Net , Quantity). How can I design a query so that in each row I have the following result GoodsId, SumNetInput, SumQtyInput, SumNetOutput, SumQtyOutput? I need the sql...

Hi. I'm setting up a farsi website which uses MSAccess databases. When I work on my localhost (apache), everything is fine. However on the web site, when retreiving my data from the MSAccess tables it shows the text in a series of ?????. I think it is a problem with the encoding. I'm sure the...

Hi experts, In my financial reports and regarding a special "field" three things are very important: 1- sum of the field at the end of each page (which I think I know) 2-sum of the field at the end of the form (which I believe I know) 3- at the beginning of each page the sum of the previous...

This is my my code Private Sub bt_moincreate_Click() DoCmd.OpenForm "account_new", , , , , , OpenArgs:=Me.kol & "~~" & Me.kol_code Me.accounts_moin_sub.Form.Requery End Sub account_new form inserts the data in the table.( the query line works well) but the accounts_moin_sub...

Hi I need code to copy a mdb file and rename it to a name decided by the code. thanks again

Hi To add new records in the subform, I use a dialog box. after submitting the data the subform doesn't update. I have to close the main form and re-open it again and then I can see the new record. I have the same problem with combo boxes. At some conditions it is needed to open dialog boxes to...

Thanks GolferGuy. It is very good to know one is on the right path, especially from an expert. How about using Public variables that are available to all forms and queries instead of your frmUtility text boxes. I've now tested both methods and don't see any preferences of either way.

Hi ajetrumpet, welcome aboard. The idea is that since the program will have many forms to be opened and viewed, and it is required to surf between forms back and forth, we want to avoid to have too many opened forms on top of one another. So I decided that I will have only one main form opened...

Thanks OlcayM Actually the problem is not with opening of form1 or form2 in the main form. To describe the problem better: form1 has a subform1 in it (datasheet) with a specific record source. It opens up and the subform1 also shows all the records I need. When we push a button in form1, we...

Hi again In my main form, I have a subform which I use to show different forms by it using the Me.subform1.SourceObject = "form1" Inside the form1 , by running some procedures, it is required to open form2. And form2 is again to be opened in place of subform1 in the main form. So again I...

Thanks wazz. but to keep the track of forms from the beginning I used a public variable as string and in it i stored the names of the forms in the LIFO (Last in first out) way. This way I can always get throug my steps back to the main form. Any idea? Thanks again.

Hi all, In my access program I need to surf between various forms, back and forth. To open a form I usually use the docmd.openform .... way. This works, but doesn't close the previous form. What I need is a way that every time, only one form is open so we are not confused. Also a particular...