Search results

OK BUT , FOR THIS I'VE TO INSERT THREE COPIES OF SAME REPORT"PURCH VB Query" in Detail Section and set a txtboxnum to "=+1" and set the IIF functions to detect and process conversion from number to Words i.e if 1, text= "Original Copy" will it be good forever ??? for multiuse F.E/B.E...

i have created a module under module section of my DB My Report Name : "PURCH VB Query" the code is as follows : (what is want tell you later..) Sub Erlick() DoCmd.SelectObject acReport, "PURCH VB Query", True '"PURCH VB Query", acViewPreview, "PURCH VB Query" For i = 1 To 3...

??? don't understand what trying to say . buddy pls. clarify and post a screenpic of your errors !

ya that's good and also simple tricks work: right-click it --> Conditional Formatting --> type here the Expression to identify and create a situation and select formatting this is also another way

ya i Agree with you. "Delete Post" hyperlink shud lead to a pop-up window which shud decide whether post has received a reply and a Re-Quote by Thread starter, If Yes, a Request form will appear . If No then the Thread will be Deleted after 7 days without any moderator's stop. The Deleted...

can i know which pc config + browser u r using. I am using IE8+win7 and just working Fine ! Speeds ! good ! some firefoxers also face problems i think

Dear Moderator/Admin.web My suggesstion are to the real ongoing problem and it may Exist also : users post their questions 8 out of 10 users get their answers and solved 2 out of 10 users get some help/advice, but still not solved .... the 2-out-of 10 thread starters generally behave to be...

I Knew it, but was somewhat confused about the ACCDB ext. so i posted this Question It's not necessary that you know something and to Affirm/Confirm you shud not post any quest. in AWF -

JHB, i knew it, I understand what i see I am not Impaired physically ! Ok ! as u r saying ! But thanks for good reply !

Hi, I am having following config : Resources : 1. PC 1- win8 + ACC2003 + Backend of MDB Database + FrontEnd to use no localserver installed 2. PC 2-winxp + ACC2003 + FE to use , noLocalServer installed 3. PC 3- win7 + ACC2003 + FE to use, XAMPP Web server installed now my question is...

be my ques still stay unsolved for what purpose ACCDB ext is used Answer: a) this is just Simple DB Ext. for ACC2007ver , not any hi-fi-Project -hi-end version Answer: b) Just for reading only Pls. do Reply me :cool:

simple goto the form in which u want this and dbl-click on Properties button leftmost to Scale/Measuring line then goto Event Tab There are many events in form, like Onload, OnUnload, OnKeyUP AfterInsert if you wish that before adding/after adding a record your query/SUB VBA shud check then...

hi there i am seeing in many posts, Questioners post Sample DB with accdb extension What type of file it is, What's the purpose served and why people use it and is ACC2003 able to open it or not? i am bit confused bout MSACCESS Formats if anyone, pls also let me know all the extensions...

So when you open Report based on above query a dialogbox will pop-up saying "Fromdate" [ Type start date] and press enter Next dialog pop-up as "Todate" [Type End Date Here] Press enter

Your report must be based on a Query to do this Queries are Magician who pulls specific data relevant to our thrust So in query, specify following criteria in Date Type Field (anyone date type field) Between [FromDate] And [ToDate] And your report will only get those data filt. by query...

your IIF statm shu look like this : =IIf([TotalBookings]=[MaxPeople],0,[MaxPeople]-[TotalBookings]) but if you're looking for Sorting/Grouping on Fields Search AWF or Google for "Grouping Query" words like that And thanks for reading.

pls. SEND Screenshot of what you want and what is happening wrong i've gone thru your Db . There are soem Script Errors VBA Correct those and then Re-post Screenshot of the problem !

hey yahya263, listen Just Re-create subform and then check it. Delete old subform -------------------------------------- God is Merciful

upload your Sample DB with Sample Data so anyone can check n post the needful code

DID YOU TRIED FIRST FUNCTION First (SupplierID) Try it , and then revert. It is for returning First Recordset of as per Expression given or you can try Duplicate Query wizard for the same, as it shall reveal the same results i think, i suppose . Pls. check n let me know Experts Pls advice...