Search results for query: *

Hi, I'm trying to create a crystal report and the data source is two linked SQL views. I need a parameter that asks for the start date and ending date. The field that I'm trying to use is a date field on a linked subreport in crystal. When I run the report I do get a prompt to enter these dates...

I have a piece of code(I didn't write)that I think may work in a combo box I have on a form. Users would select a policy title from the combo box that they want to enter information associataed with title. That information is in a subform. I'm not that good w/VBA. If someone could briefly tell...

I've looked at this issue over and over again, but I don't see it, maybe someone can help me. I have a date field on my form (FieldA) with this format "mmm-yyyy" and another date field (FieldB) with the same format. I input this number- 05/01 and it turns to "May-2003" or I...

Hi Guys, This is the problem, I have a main form, when the user double clicks in the autonumber field a popup form comes up to enter comments associated with the current record. The code looks like this: Private Sub Policy__DblClick(Cancel As Integer) Dim stDocName As String Dim...

I believe the append query is what will work. Thanks

Yes alr, reuse of title number is important to the user because there are currently 300 active policy titles and if numbers are not reused it could get 3 times that size. I already have a field in my table called STATUS. Guess i'm just searching for other ideas. Thanks, nubianqueen

I have a table called Policy Titles.The user wants to delete a title when it's no longer in use, so the title number can be reused.As the designer I feel no record should be deleted but just made inactive. There is still the issue of reusing the title numbers. I thought I could use a make-table...

This is not exactly what it sounds like. I have a pop up form called Comments. It is a table on the many side of a table called Policies. I split it up because there can be many comments for one Policy. I have code set up so when a user double clicks on the policy# in the Policy form the...

I thought I was done with this issue, but after looking at my table, the TargetDate field is not populating into the table, it's only in the from. What am I missing here,

Thanks for the help,I had problems with the DateAdd attached to after update, but it worked in the control source property.

I have two fields,[ReviewedDate]and [TargetDate]in my table and on a form. The task is when a user enters ReviewedDate (format = mmm-yyyy)I need the TargetDate field to automatically populate a date of 12 months in advance). I'm pretty sure I should use the DateAdd function, but does it go like...

Thanks everyone. I created a blank database and moved all the objects from the old db and then did a compact and repair afterwards. It worked!!! Appreciate all the help.

The form will not open in design either and the click event code is still attached to the command button.

I have a database in access2000. There are several command buttons on a form that opens other forms. I am not sure what happened but when I click on any one of those command buttons I get the message "Module Not Found". When I go and try to open one of the forms myself they won't open...

Iwould like to know how did you resolve this, if you don't mind sharing?

Hey Guys I'm sure this question has been asked before, but I've been looking through previous messages and I haven't found a answer yet. I have two forms, Form1 and Form2. Form1 is from the one side and Form2 is the many side. I have a command button on Form1 to open Form2. Primary Key is...

Thanks for the response, my question is for FoxProProgrammer I made an adjustment on the first line of your code, I don't need to check for a range of time in the call in field so this is what I have: "If (Hour(CallInDateTime) = 24)Then.......... I only want to make sure the time is not...

I have two fields (CallInDateTime)&(CallFinishDateTime)with the format as mm/dd/yyyy h:nnAM/PM. Big problem with users forgetting to put in the time portion and of course 12AM defaults in. To prevent all the time spent on cleaning up my tables I put code in the BeforeUpdate event on my form so...

I have a database that tracks the duties completed by cetain users. One of my tables has 10 questions with a yes/no data types. The questions are a subform and query based. What I have to do is count each yes and each no for all 10 questions on a daily bases, then find a overall total and...