Search results

So what would be the expression if the fieldname for textboxes: Year, Month and Day were follows: Textbox for Year = BirthDateYear, Month = BirthDateMonth, Day = BirthdateDay.....

What if I have 3 textbox for the birthdate; One for Year,Month, and Day.,Is it possible? What would be the expression for this if possible?

Sorry for the late reply, I was not around for the past 2 days.. Nice One. I have followed the codes you've written and edit some field names and it works great!!!Thanks for the help:D

Yes, Your right... That's what I want to happen in my report.Could you both help me..Sorry for the late reply. I was not around for the past 2 days...:o

Huh!!Can you gave some example PNGBill?if that is okay:o

Hi to all!!! is it possible to make Select Case Condition in VBA which have IIF statement or Condition rather:D?

Hi. Try to use this codes! Hope it will help you... Private Sub cmdsave_Click() On Error Resume Next DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Me.AllowEdits = False End Sub Private Sub CmdEdit_Click() On Error Resume Next Me.AllowEdits = True...

Yeah.. Your right... I hope so...:cool:

..Yes it's an Access '07 Database..Ok. I'll wait...

Sorry for double posting. I have already deleted the other duplicate of this tread...By the way, I Have attached a sample database(Database1) for you to take a look: This should be more likely the Logic: ComboBoxA = "First Year" then If TextBoxA = 1 then TextBoxB = 0 If TextBoxA = 2 then...

I want to have a Combobox that will automatically filled the "value list" fro a certain "textbox". If a user will choose " First Year" which in the value list of ComboBoxA it must produce the "Value List" (may be called "Case Value" I'm not sure with correct term used) for TextBoxB so that; if...

Is it possible to have a fixed format in a report? If Yes, Could You help me by giving the procedures on how to do this or may be code...The report should have 2 columns with the data entry like most of you have probably done by just formatting the column width and height of the report. Now, My...

Thanks Galaxiom

Actually I've used =Sum([Units]) as the record source of the field "Units" and placed it on the page footer that's why it results an error...After a headache in this problem, I tried to placed it under the Report footer and not in the page footer.. Sorry for not understanding well the problem...:)

Uhmm.. Thanks for the help... I've added an unbound text box in my report's report footer and put control on it. Thus, It works pretty cool Have a nice day ahead:D

Thanks for the reply, But still it brings me an error...I have 2 columns in my report, the value of the field "units" were all the same except if the Student had failed in this Subject..The Value of units may be 1.2 or 0.. How can I Add this for several times? Thanks for the help

Hi Folks.. I have a report for students. I'm trying to sum up the field named Units so that I would know how many units was earned by the student.. By the way i have 2 columns in my report:confused:

Thanks for the help for making me understand the subject matter clearly..:D Mykil

Ah.. Okay, Now I Understand.. Thanks to all of you for Helping me...It really solves my problem..

Yes, I already split my database and Produce an ACCDE. But only the Tables which in the BACK END is only editable.. I Couldn't Edit the DESIGN FORM of my FORMS....