Search results for query: *

Hi! When Report formula =((Sum([TimeSpent]))*25)/60 gets moved to a Report Footer it calculates Total for the group. Next Formula =(Sum([TimeSpent]))/([Proj]) when moved to a Report Footer gives the same result as in a group. So it doesn't calculate a total. I have 6 formulas 2 of which do...

I am running code4 Ok, when I am running it as a Module - table gets populated. When I run it on Form cmd Click event I am still getting that error. Public Function cmd_Run_Click() Dim sSQL As String Dim dbR As DAO.Database Set dbR = CurrentDb() DoCmd.SetWarnings True sSQL = "Insert into...

I am having a form with a list box where dates should be displayed. I am Running Report that is suppose to run for Selected in ListBox dates. What is the best way to do it to insure Report performance? Simple but forever..:) Also multiply dates selection should be available. Report is based on...

Having a field in Access97 that populated with 12/20/2004 format date and 12202004 format Date. Datatype of the column however is Text. I could Append it to a right datatype table but can't use recommended solution Exp1:DateValue([Date_Column]) Gives me an "Data type mismatch error" I will...

How this is happened with these two? Why 2 words? Is there story behind it?

Hello and good week everyone! Here is my "other" headache. I am consulting for a client and building Reporting System for them. Client using People Soft query downloaded to Excel file. Every time whoever runs those queries saves them on Share Drive with whatever names(Dates) in whatever format...

Hi! Can you please help me to help my neighbor, she has new PC with DSl and she got virus, when she is running virus protection it tells her that it can not remove the virus. I think whatever she've got is more advanced and overruling. We suppose to meet Monday and try to figure out what to do...

Please help me with this issue. I started to develop System using Access 2002. Then Access wouldn't Import Excel files. I found out it was due to custom installation of Access 2002. However Access 97 Imports all well. I need to transfer my 10 Reports and all tables and queries into Access 97...

I've built Access Report that shows Date by SuperLastName. How can I force Dates to be sorted Asc if datatype is text? Thanks

Hi! Can you please try to help me with this huge headache? I am running code in Access2002 Private Sub cmd_Search_Click() Dim mSQL As String, ListSQL As String, StrRS As String, txtStr As String Set dbR = CurrentDb() DoCmd.SetWarnings False dbR.Execute "Delete from Search_Result" mSQL =...