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...

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...

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 =...

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...

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...

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...

Hello, I have a form that have three tabs. In one of the tabs I have many fields that belog to a table (InspectionTable) that uses a foreing key that relates it to the MasterTable of the database. I would like to create a button in a form to allow users to add a new records in the...