Search results

I am not very experienced with VBA and I could use some help I need to figure out how to code the following situation: I have a publication that is published every 56days. There is a cutoff date to get changes into the publisher to make the next cycle. The cutoff date is 27 days before the...

I have 2 tables that are linked via the personnel_ID field. Table 1 holds personnel information and table 2 holds training information. The link works fine with data that is already in the database. When I add a new record in table 1 (personnel information), I have to manually add a new record...

I am using the following code to send e mail notifications if people are within 30 days of needing training, then if the training is over due another e mail gets sent. Private Sub Form_Current() If (Forms![frmEmailWarnings]![ TngDueEmailSent] = 0) Then Dim rsEmail As...

My problem is two fold. First I am not very apt at VBA programming . Second, I have embarked on a project that is quickly getting out of control. I designed a database with one table to track items at work without knowing much about databases. It worked fine at first because I was the only one...

I am using the following code to prompt the use when a new record is added. Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo Form_BeforeUpdate_error Dim intResponse As Integer Dim strMsg As String strMsg = "You have made changes that will add a new record. Do you want to save...

I have a subform that displays filtered information. The subform is based on a form that contains a cmd button that allows the user to add additional records to the subform. The problem is that if there are no records in the subform query, the form in the subform does not show, therefore the cmd...

I have 2 questions. First, I’m sure there is an easy answer but I have not found it. I would like a list box that is defined by a query, the problem is that the query I want to use is one that the user inputs a value in a dialog box. When the user inputs the value to sort the query, the user has...

I posted this in the VBA area but no replies. I wonder if a form expert can help. I have a form that contains airport information. It opens with a query where the user selects the airport to view. Once the form opens, the user can navigate through the instrument procedures at the selected...

I have a form that contains airport information. It opens with a query where the user selects the airport to view. Once the form opens, the user can navigate through the instrument procedures at the selected airport (on the main form). I have a sub form (on a tab control) linked to the airport...

I am very new to VBA and using Access 97. I have a form that opens and displays filtered data. The query that I am using to filter the data uses an input box to specify the data (from a field) to be displayed. I would like to have a message be displayed when there are no matching records...

I am teaching myself VBA and have come to a roadblock. I have an event (task that needs to be completed) every 56 days, with the countdown starting on a specific date. I would like to show a warning when my database main menu starts up. I would like the warning to only show up 5 days prior to...

I am new to VBA and trying to learn some code. I have developed a database with Access 97 and I am now just realizing the capibilities of access and VBA. I have many questions but right now I would like to know if code can be written for the following: I would like to see a Dialog box with the...

First I am a beginner, but I am trying to learn VBA. I have a form that has a text box that contains the sum of records generated in a query. My question is: can I change the background color of the text box when the number is higher than 0. I would like the background to change to red when the...