I must be stupid or something please help me

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a very simple data base with a form called case, I would like to be
able to click on a command button and have a report that displays only the
current records information for printing .The name of the report is
ajustment. the primary key on the form is FDMS.

I have asked this question and received several suggestion but none of them
work for me.
Thank you for your help
 
Terry

If you get a suggestion here in the newsgroups and it doesn't work, continue
pursuing the thread. By starting a new thread as you have here, anyone who
didn't see the earlier discussion, and any of those folks who were already
helping and would be in the best position to help further, are "out of the
loop".

And when you say "none of them worked for me", I have no clue whether what
ever was suggested caused an error message (if so, what message?), produces
results (but incorrect ones), was copied correctly, or if you were unable to
implement the suggestions.

A bit more information would help, but I still urge you to return to the
starting thread and pursue it there.
 
Jeff thanks for the input, I will begin from here
The code I have added to the command button is as follows

Private Sub Command80_Click()
Dim strDocName As String
Dim strWhere As String
strDocName = "ajustment"
strWhere = "[FDMS]=" & Me!FDMS
DoCmd.OpenReport strDocName, acPreview, , strWhere


End Sub

The error messange i have receved is Runtime error 3464
data type mismatched in criteria expression

Note The field FDMS is a 7 digit number

Thanks agin for the help
 
PMFJI,
Is the FDMS data type in your table set to Numeric or Text. Just because you
are storing numbers doesn't mean the data type is numeric. If the field is
text then use:

strWhere = "[FDMS]=""" & Me!FDMS & """"

--
Duane Hookom
MS Access MVP
--

terry said:
Jeff thanks for the input, I will begin from here
The code I have added to the command button is as follows

Private Sub Command80_Click()
Dim strDocName As String
Dim strWhere As String
strDocName = "ajustment"
strWhere = "[FDMS]=" & Me!FDMS
DoCmd.OpenReport strDocName, acPreview, , strWhere


End Sub

The error messange i have receved is Runtime error 3464
data type mismatched in criteria expression

Note The field FDMS is a 7 digit number

Thanks agin for the help

Jeff Boyce said:
Terry

If you get a suggestion here in the newsgroups and it doesn't work,
continue
pursuing the thread. By starting a new thread as you have here, anyone
who
didn't see the earlier discussion, and any of those folks who were
already
helping and would be in the best position to help further, are "out of
the
loop".

And when you say "none of them worked for me", I have no clue whether
what
ever was suggested caused an error message (if so, what message?),
produces
results (but incorrect ones), was copied correctly, or if you were unable
to
implement the suggestions.

A bit more information would help, but I still urge you to return to the
starting thread and pursue it there.

--
Good luck

Jeff Boyce
<Access MVP>
Click to expand...
Click to expand...
 
I KNOW ALL CAPS IS CONCIDERED SHOUTING
THANK YOU THAT FIXED THE PROBLEM -THANKS THANKS THANKS

Duane Hookom said:
PMFJI,
Is the FDMS data type in your table set to Numeric or Text. Just because you
are storing numbers doesn't mean the data type is numeric. If the field is
text then use:

strWhere = "[FDMS]=""" & Me!FDMS & """"

--
Duane Hookom
MS Access MVP
--

terry said:
Jeff thanks for the input, I will begin from here
The code I have added to the command button is as follows

Private Sub Command80_Click()
Dim strDocName As String
Dim strWhere As String
strDocName = "ajustment"
strWhere = "[FDMS]=" & Me!FDMS
DoCmd.OpenReport strDocName, acPreview, , strWhere


End Sub

The error messange i have receved is Runtime error 3464
data type mismatched in criteria expression

Note The field FDMS is a 7 digit number

Thanks agin for the help

Jeff Boyce said:
Terry

If you get a suggestion here in the newsgroups and it doesn't work,
continue
pursuing the thread. By starting a new thread as you have here, anyone
who
didn't see the earlier discussion, and any of those folks who were
already
helping and would be in the best position to help further, are "out of
the
loop".

And when you say "none of them worked for me", I have no clue whether
what
ever was suggested caused an error message (if so, what message?),
produces
results (but incorrect ones), was copied correctly, or if you were unable
to
implement the suggestions.

A bit more information would help, but I still urge you to return to the
starting thread and pursue it there.

--
Good luck

Jeff Boyce
<Access MVP>

I have a very simple data base with a form called case, I would like to
be
able to click on a command button and have a report that displays only
the
current records information for printing .The name of the report is
ajustment. the primary key on the form is FDMS.

I have asked this question and received several suggestion but none of
them
work for me.
Thank you for your help
Click to expand...
Click to expand...
Click to expand...
 
Back
Top