I am using Access 2002. I have created queries in hopefully the normalized form. tblSurvey, tblQuestion, tblAnswers, tblResponseoptions. I have also created reports. Now I have been told the user wants to pick and choose which question go on the report. Gee Wiz.. Can anyone point me in the...
Hello I am using Access 2002 on a WinXp PC. I have the following in a query.
Count_E_Months: IIf([CEYear]=Format(Date(),"yyyy"),DateDiff("m",[Contract Effective Date],DateAdd("m",1,"1 " & Format$(Date(),"mmmm yyyy"))),0)
Count_R_Months...
I appologize if this has been posted before I have been searching all afternoon off and on and have not found anything yet. Using Access 2002 SP3 on an Windows XP
:eek: .
I have a table that contains the following
name
effective date
renewal date
monthly premium
I need to calculate the...
Hay everyone
Just wanted to ask if anyone has suggestions for a check printing program. At work I am going to get an export file from a SQL Server database and it into another table use Access97 front end to print checks. If anyone has already been through this I would appreciate any insite...
I using the following code from this forum
Private Sub Text0_KeyDown(KeyCode As Integer, Shift As Integer)
Dim stFront As String
Dim stBack As String
Dim lPos As Long
If KeyCode = 9 and Shift = 0 Then
KeyCode = 0
lPos = Text0.SelStart
stFront = Left(Text0.Text, lPos)
stBack = Mid(Text0.Text...
I am using A97
I have several fields on the detail part of a report like:
QNum A1 CorrA1 QWeight txtDecision
Qnum is the question number
A1 is the users answer to question
CorrA1 is the correct answer
QWeight is the Weight of the Answer
sumofquestionweight
txtDecision is a calculated field...
I appologize in advance for this confusing question.
I have a table that list parentID,Desc,ChildID,Desc
Here is my problem...
The hiarchy of the system I extracted from is you have a group (parentid)which is a "parent" to a subscriber (the childid). The subscriber(parentId) which is a...
I have a report with a query that looks like this:
mbr# macro result micro microresult
1 -1 Positive 0 Null
1 0 Null -1 Neg
My report is grouped by mbr# I want them all on one line, but because there are NULLS in result field. I get a blank if I...
I have search this knowledge base for this error and have found my error and the solution if the expected is 1, but in my situation I have 2 parameters not two. How can I handle that?
My parameter for a [DATEADMIT] field is Between[Forms]![frmReportRange]![DateBegin]AND...
I have a report that contains a controlsource to employee the value is either T or F I set up an unbound field whose controlsource is IIF([Employee] = "T","Yes","No"). When I run the report I get
Syntax error(comma)in query expression [IIF([Employee] = "T","Yes","No")]. What am I doing...
I have a form that has several check boxes. I need to know if cb5, cb7, cb12, cb19, cb24, cb25 cb30 and so on have been checked. I also need to know if the count of these checkboxes that have been checked is greater then say 4.
I can write the statements individually such as If [cb5] = -1...
I have a database that is split. currently they both are in G:\projects\
I need to move the backend database to a production drive I:\. The front end will be on a local PC.
Here's my question... In a few of the forms I need to write information to a table in the backend database using the...
I have the code"
strCount = Forms![frmcallhis]![mbrid]
intCount = Dcount("[mbrid]","tblcall","[mbrid] = 'strCount'")
intcount = intcount + 1
intcount is always 0 even if there are several calls for mbrid
I'm just trying to get the count from tblcall based on a mbrid and up by 1.
Thanks
I have a form that some information is written to tables the form is not based on. (So I have VB code opening the table and populting using the With statment)
This all works fine until the user wants to add another record to a new member without closing the form. I have a SAVE button the user...
When I click in a text box that contains a formated date field the curser could be set in the begining middle or end of the field with the format of _/_/_ ... Is there anyway to use the On_Click event to left justify the curser so the user can start typing the date at the begining? It works...
I have a survey form that runs from a query. When the user chooses a members# in the combo box it filters and gives only the Surveys filled out by the member and allows the user to enter a new survey if they want to. This works!! Here is what doesn't.. When I click on the combo box to choose...
Hay everyone and happy holidays....
I have a question and maybe you have a better solution then the way I am going about it.
I have vba code that based on a form sets some checkbox to true. The problem is I have several forms that use this same code so I have written several versions of this...
Hay all,
I have a table which contains ProgID and MbrID. I have a form with no record source. On this form I have 3 checkboxes. What I am trying to do is display which program the member is in could be multiple.
I have code written as follows:
Private Sub Form_Open(Cancel As Integer)
Dim db...
I have a questionaire form that basically has y/n answers. but one of the questions could be a multiselectionlist. Such as which of the following have you done. The list may be horseback riding, hiking, snow skiing etc. I would like to capture the anwswers of the questionaire in a table. How...
I have a reporting database which contains information on the number of times a member has placed a call. I want to report various information about this call. On a form I have a list box that can choose multiple members. (I have 100,000 members but only around 70,000 show up in list box. I...