Search results

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

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

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

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

Hi I have a parent-child base table (accounts) with the following fields: - id - parentid - name every record's parentid is either 0 ( which means it is in the most upper level) or another record's id (which means it is the other record's child) different levels of records are being used. I mean...

Hi, In my subform's oncurrent event I want to change the value of a text box (docid) on the main form. The name of the subform is : AsnadList This code doesn't work: Private Sub Form_Current() Me.Parent.docid = Me.DocumentId End Sub I keep receiving this error message: Method 'Parent' of...

Hi We have a database implemented in MS-SQL server 2000 on a local machine. I want to use some of tables in my access (or excel) program. Can I link to the table? Thanks

Hi experts, I have a mainform in which there is a subform. Is there any way that I can retreive the value of the selected cell of the subform in the main form? Currently what I usually do is that using a text box and setting it's control source to that special field in the subform, we have the...

Hi, Attached is a project I'm working on. We want to calculate the total delays on each day. In a form called 'main' there is a subform for the delays on that date. But the 'Total Delays' control does not work. I have used the following format to get the total from the subform...

Hi. can we access the results of a saved query as we do with tables such as: set docs= CurrentDB.OpenRecordesets(QueryName) ..... Thanks

Hi. I want to run a sql command in my vb code using: docmd.runsql "sql command string" Is there any way to put the result in recordset variable as we do with tables: dim docs as recordset set docs= currentdb.openrecordset(tablename).... Thanks again.

Hi. I want to run a sql command in my vb code using: docmd.runsql "sql command string" Is there any way to put the result in recordset variable as we do with tables: dim docs as recordset set docs= currentdb.openrecordset(tablename).... Thanks again.

Hi! I'm looking for vb code that by giving the name and path of an mdb file, links all of the tables defined in it to my database. (Access97) Thanks

Hi every body. Is there any way so we can lock one or some of the rows of a form which is viewed as a datasheet, depending on the value of one of the fields (or change other properties such as text color) ? I have to do this in Access97. But if it's impossible in 97 please let me know in other...