Require help with Access 2002 Lookfor Function

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

Guest

Dear Support,

Microsoft Access 2002 V 10.26
Question; Could I request a suggestion on a problem I am facing.

Fresh to MS Access, tho I am able to generate a useful database for our
quotation register. I have this working as a new quote operation only.

Inside a macro I have a command line on the runapp tag ie:
C:\Program Files\Microsoft Office\Office10\EXCEL.EXE
"V:\quoteregisterr\emailquoteform.xls"

This is where I send the data when starting a new quote.
Now I would like to see if, Can I call a completed quote back?

Problem I am finding is ie;
LookFor = InputBox("Please enter a Quote Number:", "Search Database")

Could I get some suggestions on how to use the LookFor function
on the command line inside the MSaccess runapp tag?

Thank you in advance and have a great day!
Mark
 
I see no one has helped you already, so I'll give you some
words of advice. What you are trying to do is at an
intermediate level of knowledge that needs a fair amount
of background knowledge to do. As you said, your new to
this and it would be too hard to "teach" you how to do it,
where as these forums just to "point" you in the right
direction.

As such, I would point you in the direction of getting
some training if you wish to accomplish this. Sorry.
 
Well thank you for pointing out that I am new to access.
My learning curve is up to myself being able to work around the command line.

When my boss installed a copy of access onto this pc, it didnt come with any
help files or books on access.

I have more skills working with excel, I wrote this to preform a search for
a model number with our main list of products, when I am able sort out a few
issues first with my boss, free up some time for myself and attemp to
approach this at a different angle.

Thank you for your time BTW.

1 Dim LookFor As Variant
2 Dim y As Range
3 Dim myRow As Integer
4 LookFor = InputBox("Please enter a Model Number:", "Search Database")
5 Worksheets(2).Activate
6 If LookFor = "" Then
7 Exit Sub
8 End If

9 Set y = Worksheets(2).Range(Cells(1, 1), Cells(6000, 1))
10 y.Activate
11 y.Find(What:=LookFor, After:=ActiveCell, LookIn:=xlValues,
LookAt:=xlPart, _
SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:=False).Select
12 If Not y Is Nothing Then
13 myRow = ActiveCell.Row
14 search_again_After_row = ActiveCell.Row
15 search_again_After_column = ActiveCell.Column
16 End If




Cheval said:
I see no one has helped you already, so I'll give you some
words of advice. What you are trying to do is at an
intermediate level of knowledge that needs a fair amount
of background knowledge to do. As you said, your new to
this and it would be too hard to "teach" you how to do it,
where as these forums just to "point" you in the right
direction.

As such, I would point you in the direction of getting
some training if you wish to accomplish this. Sorry.
-----Original Message-----
Dear Support,

Microsoft Access 2002 V 10.26
Question; Could I request a suggestion on a problem I am facing.

Fresh to MS Access, tho I am able to generate a useful database for our
quotation register. I have this working as a new quote operation only.

Inside a macro I have a command line on the runapp tag ie:
C:\Program Files\Microsoft Office\Office10\EXCEL.EXE
"V:\quoteregisterr\emailquoteform.xls"

This is where I send the data when starting a new quote.
Now I would like to see if, Can I call a completed quote back?

Problem I am finding is ie;
LookFor = InputBox("Please enter a Quote Number:", "Search Database")

Could I get some suggestions on how to use the LookFor function
on the command line inside the MSaccess runapp tag?

Thank you in advance and have a great day!
Mark

.
Click to expand...
Click to expand...
 
Back
Top