Search results

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 :)

:) Yes, I do still need help, you'd have to go in detail a bit. Or, I can give you my database to give you an idea of what I am trying to achieve. Question, would it be really hard to send it to Word directly?, The purpose behind the word file is that, its a legal document and I don't want...

Exporting datasheet to word, how is this possible using vb. Actually, I do have a thread in Form forum. But, I think not a lot of people visit that place. Anyways, I have created bookmarked and used datavariable to export the data (by ansentry's help). But the only thing that it exports is just...

objWord.ActiveDocument.Bookmarks("bmInformation").Select objWord.Selection.Text = (CStr(Me!Form4.Form!txtinformation)) okay this is what i was using for the subform, I don't know if I am wrong, but I am getting only first selection that user made. Since its datasheet, it should give me as many...

Thanks, but after checking off all the required ref, I am getting a new error, Error No:3265 Item not found in this collection. I think either I am improving, as error is no longer same or I will be lost soon :( Thanx and sweet dreams :)

tried looking for the error and found out either its corrupt or have to compact it, tried compacting it and then created another database, still no hope :( i feel like crying now. One more thing I forgot to add, the first line of defining variables, where it says dm dbs As database, if I don't...