Recent content by wannabepro

Thank you so much guys, and tell you the truth I have learned almost everything from this board. I will try these codes today and will let you guys know how it works out. Thanks once again :)

I want some guidance in regards to how should I export access form as a report to excel. I already have fields with formulas in it and here I have fields where I have written down the numbers, so when these numbers get exported to excel. Excel will be populated with with these numbers and all...

ansentry, sorry for bringing this topic up again. I wanted to know, how can i be able to add data on diff tables from diff subforms. Lets say I have three subforms and three tables. Now how do i export the data so it fits its own into its own tables, rather than overlapping. I am sure I am...

ejstefl, thanks a lot.

So what else should I try???

ejstefl, I don't think union query will work. I tried it, but it wont. :( thanx for the input.

Thanks mresann, I would really appreciate some help. I know Cross tab didn't work, nothing is working. :(

Here is the demo of the application I am trying to create in ms access. I don't know, how I will achieve this goal. As it looks quiet easy, but getting me stuck. If you look at amount column, it has two columns spliting to show diff values. Cross Border values are coming from "AG"'s account. I...

No Help :(

Pat, thanx, I did try that before, but for some reason it didn't work for me. And now all of a sudden it did. Proly, I was doing something wrong before. But, I really appreciate your help :)

Okay here is my code, I had thread open awhile back. In regards of exporting main form and subform to word. Here is the code, I am still having problem with it. I can't seen to take export nothing or if I switch around dbs.close and rs.close, I end up exporting whole subform (meaning all the...

Select * From tblloan Where [TeamPeople]<>"AP"; It gives me all the values without 'AP' which is initial of a user. But I want his values to be in second column. Select* From tblloan where [TeamPeople]="AP"; I know its a very simpl query, but I am getting confused. I can't join them to make...

I have a query that calculates the 'amount of credit' depending on the draw down date (which is when they started circulating the loan docs b/w two parties). Anyways,, the question is how can I make two columns of 'amount of credit' instead of one. Because one of the team member is dealing with...

I appreciate all your help and bearing me for this long, thanks a lot. I am afraid to ask for one more favor, I know that you will be able to help me out. I have done all the coding and stuff and its working fine, except for one thing. The subform, when it imports it takes all the selections...

that would be a gr8 help if you can post it. I would really be thankful to you :) Thanks ansentry for bearing me this long, I know I am a headache :)