Recent content by ShanVel

Hi Thinh, Thanks for your tips. That is correct but I am not sure how do you build your SQL if I have more than 50 child tables related to one parent. The SQL based on your idea would llook something like this, if there is one child: SELECT tblProject.intProjectId, tblProject.chrProjectName...

Hi, I have an access database (2007) and I have a parent table (Projects) and several child tables. For a new project record, I want to copy a child record from another project's child record (as a new project's child record) and then plan to edit the copied record. My copy operation works...

Hi folks, Does anyone know how to convert access report to PDF via VBA by clicking a button? I am building a report on the fly which will be based on: - selecting a project through a combo box - and building a query by joining several tables related to that project and then I should export...

Hello folks, I need your help. I have two forms, frmProjts1 and frmPassword. frmProjts1 has a combo box called "cbBox1" and it's ‘row source type’ property set to Value List and ‘Row Source’ property is filled with Value1";"Value2";"Value3";"Value4" What I am trying to do is when the...

Yes. I agre with you and that's how any RDMS works. My intension for copying is to copy and then edit/modify that record for another project and save. Since I am dealing with lots of text (memo type) I thought it's a good idea to copy a record from another one and edit to save some typing. I...

Hi Folks, I want to look up a record on Form1 and then copy that record (all fileds are of memo data type on the underlying table). Now I want to close Form1 and open another form (Form2) and set all the fields of Form2 to the record I copied from Form1 and save the Form2. Do anyone have any...

Folks, I need your help on GROUP BY clause. I have been struggling to get his report in a way I wanted for some time now. Here's what I like to do: I am writing some project related data into a temp table (tblAppendForRskTblReport) by clicking a command button on a form. The data in...

Thank you everyone for all your inputs and let me give a try. Shan.

The_Doc_Man: Thank you very much and I have to tell you that I need to shift gears between working on A2003 and doing my regular engineering functions. So, my apology, it took a while to check the response on the forum. The keyword table looks like a great idea and the way to proceed. I...

The_Doc_Man: Thank you very much for your detailed tips. I am fairly experienced with VBA and other access objects and let me give a try. I have another question. Once I have built the database and running I would like to add search functionality. The user should able to do a search with some...

Thanks Pat. Is there any other way of handling this problem other than using OLE object type? Also, I don't have A2007, but A2003. Shan.

Folks I need your help; just wanted to get your opinions here. I work in a small engineering group and we have lots of reference documents in word and excel which we typically use for any projects. Currently, all these files are stored in Lotus Notes database. Unfortunately, they are pulling...

Paul, Thank you very much for the speedy and a detailed response. runtime - can you show me/direct me to a link in the forum on how to do for my application? Sounds like this is what I need to do in order to have a complete control for my application. UNC path...

Paul, Thanks for a detailed response. By the way, can you explain to me what is RUNTIME MODE? For question 1, you suggest to split the database with the FE on each person's PC mandatory. But on Q4, you are talking about creating MDE. Does it mean MDE for FE only? I have one another...

Thanks to all the folks in this forum who helped me to develop my fist access database application. Access is a great product and I really enjoy working. I need to put this db for full scale production use and I would like to brainstorm some of your experiences on the security issues I need...