Search results

Two simple questions!! Firstly, I have re-linked the tables from FE to BE. It seems without any openrecordset statement, the module could recoginze the path automatically but not module with openrecordset statement. Is this the case?? Then it also seems to me once the FE re-linked the BE, no...

Thanks! I will try to see on tomorrow!!

Re: backend path syntax in internat Sorry! The DB is in my company and I now at home!! I will posted the screen once I am at my office! Thanks!! But based on the above information, is that my problem is mainly not included the "DAO" in the statements!!? Thanks!!

Re: backend path syntax in internat 1. Sure. I have re-linked all the FE to the BE. 2. The VBA statements are stayed in FE 3. error message is 3219. And I don't really know what they are telling. Something like property had been replaced etc Thanks!

I have splited the system into foreend (FE) and backend (BE). FE and BE are located in different PC lying in company internat! However, I found there always give an error message 3219. And, nseems it is caused by not pointing correcly to the BE when I open tables, the syntax are as follows Dim...

Solved! The select statement should be as follows: Me.[Main] Form.RecordSource = "select * from MASTER where MASTER.Transcode = '" & SCODE & "'" Me.[TRANS SUBFORM].Form.RecordSource = "select * from transaction where transaction.transcode = '" & SCODE & "'"

Me.[Main] Form.RecordSource = "select * from MASTER where MASTER.Transcode =" & SCODE & "" Me.[TRANS SUBFORM].Form.RecordSource = "select * from transaction where transaction.transcode =" & SCODE & "" given SCODE is the current transcode which is using to control which set of master and...

DO I miss something!! How to show the recordsource for the main and subform?? IN fact, I have the transcode in both link master and child fields!! Thanks!!

rickyfong, I am quiet unsure why are you using Code here? Is the Main form and Subform not related? Why has this not been defined in the Form design set up? Are you creating dynamic Subform? Even if that is the case, just assign the Recordset to the subform; why are you looping through? Hi...

I am trying to do a simple Do-while loop to display master and relevant transactions in form/subform environment under Access 2003. Below are some of my statements: Dim dbs As DAO.Database Dim TRANS1, TRANS2 As DAO.Recordset Set TRANS1 = CurrentDb.OpenRecordset("Master", dbOpenDynaset) Set...

I have created a combo box for user to select the list name in the box list and then retrieve relevant information. However, recently I would like to enter a defined value which is one of the value in the box list directly to the combo box, and then requery, and finally could show me the...

I am using simple copy statements as follows to copy the content from one table to the other, but the ACCESS 2003 keep on telling me there got an error "3022" problem, it is about index or primary key duplication or empty problem etc. do while not trans2.EOF trans1.addnew trans1.[name] =...

But my doubt is how can I post the result in the report?? Place a variable in the footnote?? In fact, I would to put the wording near the report sumtotal area!! Thanks!!

I am going to create a continuous transaction printing report about half A4 size per tranasction. Just want to know exporting the data to EXCEL and triggle the EXCEL to print the report or directly using the ACCESS 2003 report function to create a report layout for printing is more convenient...

In case, 2 users are goint to input 2 different new records to the same table. Should the table locked mechanism worked as point 1, or they are freely to insert new records without any constaint!!. In case not, is that the first locked user can insert a new record, and the second would get a...

I am trying to create a report with customer information and related transactions. That is a master purchasing record with a few tranasction records per transaction. Just want to know how can I included some wordings in the ACCESS report which are based on the report sum total of the...

How can I run an Access 2003 file automatically, after double click the Access 2003 Icon?? Many thanks!!

Hi! I have FE and BE structure under Access 2003. Just want to know under this environment, can I use 3 separated PC front end stored at each to input data to the same BE table at the same time. Provided that, for each new input, it involved 2 tables with one new Master and one or more than one...

Any body!? Please Help!! Thanks a lot!!

After changing the syntax, the results are the same as before. Just want to know is that I have to do something after the db.Execute STRSQL statement, in order to link the condition with the query inside the subform. Please note that I had removed all conditions from that query!! Thanks!!