Search results

So, what is your question?

Get rid of the entire GROUP BY clause, and change HAVING to WHERE.

Hello, Clipper, Generally speaking, if you write programs as an employee of the Company, using Company resources, the Company retains IP/Ownership of the code. If, however, you write programs as an independent contractor, with the Company as your Customer, and using your own resources, you...

Ahhhhh, there's your problem! Yes, you DO need to purchase the distributable version.

Then your computer has gremlins. There is nothing more we can do for you. I have deployed such solutions with the Redemption.dll file on machines elsewhere, and the /S switch in the command string worked perfectly on all of them.

Try modifying your code like this: Sub regRedemption() Dim redPath As String redPath = "C:\Redemption.dll" 'or whatever other path Shell "regsrv32.exe /s """ & redPath & """" End Sub You do not need the vbMaximizedFocus WindowStyle flag for this Shell call.

Yes, there is. You can program your front-end interface to perform the following tasks upon startup: * Check for the existence of the Redemption.dll file on the client computer. If it already exists, skip this procedure and resume the rest of your front-end's startup. * Copy the Redemption.dll...

Have you tried this for the WHERE clause?: WHERE ((([Patient Info].[Next Eye Exam]) Between CDate([Enter Earliest Date]) And CDate([Enter Latest Date])))

fugifox, There IS a way to do this with a single SQL statement. Assume a table like the following: MyTable ------- Field1 Field2 Field3 -------------------- 123 Mike 33333 123 Jones 88888 456 Smith 55555 456 Peter 7777 789 Julie 33333 Your SQL statement would look like this...

You're welcome, I'm glad it worked for you. :)

Or, to put it more simply, each User's machine should have a copy of the front-end on the machine's local hard drive.

SELECT SUM(Value) as QuoSum FROM Jobs WHERE YEAR(QuoteDate) = YEAR(GETDATE()) AND MONTH(QuoteDate) = MONTH(GETDATE())

If the database is merely a front-end, linked to SQL Server as a back-end, then each User should have a copy of the front-end. The Users should not be all trying to open the same front-end file.

To accomplish what you want with Table 1 and Table 2, do a search on LEFT JOIN syntax for SQL Queries.

CHAOSinACT, Please re-read lagbolt's post. You can change: DoCmd.RunSQL "Delete * from tblOutlookFolders" ...to: CurrentDB.Execute "Delete * from tblOutlookFolders" ...in order to accomplish what you are after.

Try: 1) Create a new database 2) Import ONLY the tables from your old database (no queries, no forms, no reports, no NOTHING else, just TABLES) 3) Create a new Query, in SQL View (Do NOT switch to Design View) 4) Paste the SQL from the query into the SQL View, then save the query (Again, do NOT...

What happens if you import ONLY the tables into your new database, then try re-creating the query?

Try the following: 1) Create a new database, then import all objects (except the problem query) from the old database into your new database. 2) In your new database, manually re-create the query. See if the problem persists.

Try changing: Conn.open "DSN=TestSQL;UID=TEST-PC\TEST;PWD=*****;DATABASE=TestSQL" ...to: Conn.open "DSN=TestSQL;DATABASE=TestSQL;Trusted_Connection=True;"

Check out the following link: How to send e-mail without using SQL Mail in SQL Server