Search results

Hello team! Here's another issue with Access 2007. I have a subform that have two group headers; Branch_Name and Commit_ID. The Detail of the subform have four columns; Section (Text), Date Completed (Date), Action Progress (Memo), Action Location (Memo). The issue that I am having right now...

Hello all, I have two text boxes in a form called StartDate and TargetDate. What I'd like to do is when I enter the StartDate, the TargetDate textbox will be filled automatically considering 45 labor days from the StartDate. So, the date shown in the TargetDate will refer to 45 labor...

wow!!! It works perfectly!!! You're the best !! Thanks!!!

Hello everyone! I have the following issue. I have two fields in one table named [TargetDate] and [DateActionClosed]. I'd like to create a querie that will evaluate wich fiscal year represent the date in those fields. For instance, let's say that FY2011 is from 10/1/2010 to 9/31/2011. If...

Yes, that is true. I forgot to tell that I don't wanna use subform. Because subform can only been seen in a tabular way.

Hello, I have two forms that were created to enter data. The main form creates a record in the Parent Table. The second form populates a Child table which have a relationship with the Parent Table. The foreing key in the Child Table is = CaseID and the Primary key in the Parent Table is =...

I apologize Jeannette but is not working. This is what I am doing... On the MainForm: Before update event DoCmd.OpenForm “InspectionFormName”, , , , , acDialog,Me.CaseID Button on the tab --- Click Event DoCmd.OpenForm “InspectionFormName”, , , , , acDialog If Me.Dirty = True Then Me.Dirty...

Galaxiom, would you please write de code. Idk what's the open argument??

Thanks! Let me rephrase it :). First, the Details of a form is the section that is belos the Form Header in Design view. As Header and Footers of the Forms, the Detail o can be visible or invisible. Having said that my question is, should I write the code on the On Click Event of the button...

Hello, I would like to resize a splash screen. I also create the event to open splash screen and then to open a Main Form. How can I create a command to order the database to close the splash screen??? Are ther like standards sizes for splash screen??

Hello, I have a form (ECDataEntry; Main Form) that will populate a Case ID table (Parent Table). CaseID table has a primary key (PK), that is the foreign key (FK) of 3 tables (Child Tables). These 3 tables also have forms that populate them. For instance, one of tables where PK acts as a FK is...

When you suggested the below code and wrote the note about the subcontrol name, to what did you refer?? That might be the thing that I am doing wrong ----------- start code DoCmd.OpenForm “InspectionFormName”, , , , , acDialog When user clicks the close button on the Inspection form, your code...

When I do this the following error pops up The action or method requires a Form Name argument. Any idea why???

That worked really well. But now I have the problem that when the inspections forms opens I cannot add data because the foreign key (CaseID) in the inspection table is empty. The CaseID is the primary key in the MasterTable which is the foreing key in the inspection table. There is a...

Thanks Gina! Although your code work I used missing's code because does it dynamically. The issue that I have now is that the label only shows the bound column. The combo box has the facility name and the state where is located. I would like to change the label like something like this ...

Thank you both! Now how can I set an standar caption on that label. like when nothing is clicked on the cmb box, the label says Facility Name?? Thanks in advance! Paul

Hello, I have a label that is associated to a combo box that shows names of facilities. This combo box is on the header of a form (cmbName). The label (label240) is on the detail of the form. What I would like to do is that when I click a facility name in the combo box (which has a drop...

Would you please give the example. I'm trying to do the exact same thing. Thanks

Thank you very much Beetle! Is there a way of doing that without using a subform??? Like creating the button that will show hidden fields or even a input box to enter the data for the new record for the inspection table???

Hello everybody, I have a MasterTable that have many "One to Many" relationships with other tables. These relationships are made by a foreing key, which is an ID that is shown in the MasterTable. The others tables have Text, Date, Number and Yes/No data type. I am creating a form that will...