Replies

Oh, allright, I’ve tried
sSQL = “Select [tbl_500 – Data].[Pay Date] FROM [tbl_500 – Data]” with the same “success” LOL
Thanks

Imagine there are Excel files saved in directory as
abc-12012004.xls
abc_1/12/05.xls
abc122320004 etc.
And every pay/period it adds up.

So I can ask Client to use naming convention, but how am I suppose to control it when I am gone?
Plus people will come and go and here is no IT people to check on it or fix it if broken.
Then how am I suppose to find new file if I don’t know (it is not set) what date does it have?

I need to come up with whole System Idea and I can’t because all this is a nightmare (datawise…lol)

Let say I allocated file on Share Drive and told to save Excel files into it. How will I be able to find the newest one and extraction is going to have to be done using Wizard, right? hmmmmmmmmmmmmmmm

I never linked Reports to Excel, I would rather do it from Access as I need to write Queries and add calculation and stuff…
I can however instruct them to use set location but sometimes those Reports are Summary for few month and file is only weekly, by-weekly etc. So I have to combine them.

I am trying to think of which way is best, I am open for suggestions.
Thanks HansV

How do you know all this? It is awesome, it worked!!!
Thanks so much and have a great weekends.

Dim dbR As Database, rsResp As Recordset

I’ve tried Dynaset…no luck

Thanks

I would compare resident tables espesially those aren’t big.

Thanks so much for bearing with me, we are almost there, I mean all works except once in 20 searches I get error messages like “Data has changed” and I know because I am changing it. LOL

I’ve added Private Sub cmd_Clear_Click()
List_Result.RowSource = “”
txt_Search.SetFocus
txt_Search.Text = “”

End Sub

I would like one button to change caption to Clear record instead of having 2 buttons, can’t find in help.

Thanks HansV for your time and help

Thanks so much for bearing with me, we are almost there, I mean all works except once in 20 searches I get error messages like “Data has changed” and I know because I am changing it. LOL

I’ve added Private Sub cmd_Clear_Click()
List_Result.RowSource = “”
txt_Search.SetFocus
txt_Search.Text = “”

End Sub

I would like one button to change caption to Clear record instead of having 2 buttons, can’t find in help.

Thanks HansV for your time and help

With “Like” – only headers shown when performed text or numeric search.
Thanks

With “Like” – only headers shown when performed text or numeric search.
Thanks

Hi!
Now I am entering item in search textbox. Result shown in a Listbox. Then I want to enter another result and if it is Last Name – I am getting error message “Data type mismatch in criteria expression” When it is 37988 it searches.

Also those 2 problem columns wouldn’t show unless I will close and re-open ListBox.
Thanks again

Hi!
Now I am entering item in search textbox. Result shown in a Listbox. Then I want to enter another result and if it is Last Name – I am getting error message “Data type mismatch in criteria expression” When it is 37988 it searches.

Also those 2 problem columns wouldn’t show unless I will close and re-open ListBox.
Thanks again

HansV,
THANKS so much!!!

HansV,
THANKS so much!!!

Thanks a million. I just found out that our Access install was Customized, so some features does not included. They will reinstall MS Office now. Good Day and thanks again