Search results

Hi Gary, I appreciate you help, I did that and it does print, but only one record per sheet of paper, my target is to print 5 records per sheet then prints the back part. Any other idea? Thanks a lot.

Hi Guys, Attached is a DB created on A2K3, I was creating a report with 6 records in a sheet of paper (everything works well) now the problem is, I wanted to create a note on every every record printed on the back of it, the reason for that is that when the user prints a batch of records it...

Hi Khawar & Gemma, WOW! I owe you big time! Exactly what I had dreamed of, works like magic! Thanks a lot guys! Really love this forum! BTW, one more thing Khawar & Gemma can you help me on my post "Crosstab Like Query Data Entry"? Iv'e got it up & running but my problem on my query...

Hi Guys, I again need your expertise, I now have a problem formatting the report, below is the table structure: Case_No Seq_No Auth_Rep 0001 01 John Doe 0001 02 Jane Doe 0001 03 Jhane Doe 0002...

Hi Guys, I think you can hit me again with your expertise, btw thanks (Chris) for the "Crosstab Like Data Entry", anyway I now have a problem formatting the report, below is the table structure: Case_No Seq_No Auth_Rep 0001 01 John Doe 0001...

Hi Khawar & Cris, I solved partially the problem, I put on the "Default Value" of the Field "MyForms!MySubform!txtDate" for the date and so on, works like magic. But I have one more problem left, how do I get the Average of the Scores on my Continous Form? Thanks.

Hi Khawar, Sorry I don't have any idea about Master Detail Structure, I was trying to capture the content of txtEvalDate & txtEvalTitle on the main form (it is on the control source on the subform sbfrmEval). How do I programatically add the date and the title on the frmEvaluation on the...

Hi Guys, The problem with my design it wont register the date & the evaluation title. Jeff

Hi Chris & Khawar, So far I have this form, can you pls. evaluate what is missing or if the logic behind it is terrible? Hoping for your recommendation Jeff

Hi khawar, Sorry for not responding properly on your question, your were certainly right, I do need a transaction table that handles all the scores & remarks on every PC Model based on the date it was created. I was playing with Cris's DB and having a difficulty implementing what I had in...

Hi Cris, Your'e on target!, wow it seems that it can be created, anyways I am playing around it and works good. But upon adding a combo box to sort out the scores on a given day, I can't seem to do it. What I want is the user clicks on a button "NEW" to create a new set of scores on a...

Hi Khawar, Exactly what I needed, I want the form to be pre-filled upon opening and fill the datasheet or beeter yet a listbox and then the user simply fills-out the score & remarks depending on the chosen PC Model. Sorry It's been hard for me to explain things when your in deep sh$t, pardon...

Hi Banana, I thought of doing the datasheet, but it turnsout that the user still have to choose from the drop-down list before typing the score, (that is what my design leads me) but if you have a different approach it will be appreciated. Another option I have in mind is to create a set of...

Hi Pat, Thanks for the quick response, pls. see the attached form design.

Hi Guys, I wanted to seek the help of the Guru's with regards to the problem I am dealing at present. I am facing this difficult problem so far, I need to create a form which required the following entry: PC Model Score AXD125 34 MRT665...

Hi guys, Thanks for the info. I am aware of Bob's FE & BE tool, but going back to my problem I do in need of a utility somewhat like the applications developed using VB.net or other programming languages which has this "Global Installation" that whenever there's a problem with the application...

Hi guys, This is the really big frustration I had so far using Access 2007, I converted all the applications I created in Access 2K3 to Access 2007 because of the free deployment feature, since I mentioned on my previous posts that the "new guy" then always messing around my code. So...

Hi datAdrenaline, Thanks for this quick and meaningful solution for my problem, It works perfect! Cheers!

Hi, As usual I am here again to seek help and guidance to the Masters :). Ok, I'm using Access 2K7, I have an unbounded "Main Form" which houses a Tab with 4 pages, on each pages is a datasheet subform. Now I wanted that when every time I switch pages the datasheet be requeried, I tried...

sorry forgot to include attachment :)