Search results

If you have no forms, then there would be no reason to "require" linked tables.

You must use a pass-through query to run TSQL statements directly on SQL Server.

Put a Breakpoint on the Docmd line. Go into the <b>Immediate</b> window <i> Ctrl G </i> and type in: ? strSQL Hit enter. That will return what is in the variable. Copy this to a query. Query Window <New> <OK> <Close> <First button on toolbar SQL> <Paste> <!> Debug that and correct your VBA...

Have you tried Ye Ole: Environ("Username") ??

Use this. Then it will work for any precision: Function CRound(MyVal As Double, Prec As Integer) As Double CRound = Int(MyVal * 10 ^ Prec + 0.5) / 10 ^ Prec End Function

I don't believe that would work if there were no results return from the nested select. It won't return a null value ... just no rows at all.

You'll have to check if there are any results first. Something like this: IF EXISTS(Select YourValue From YourTable) Select YourValue From YourTable ELSE SELECT 0

Sure thing. It is always nice to see that our efforts are appreciated.

OK, let's line things out here ... You are running SQL 2005 Reporting Services You have a MS Access database as the data source where the data is stored locally in the Access database. My guess is that you are trying to reference a query in that Access database which uses an Access function...

I'm guessing you are looking for the DateName function. SELECT DATENAME(MONTH, [Date Entered]) AS Month_Name

This is not a simple T-SQL problem, but rather a formatting issue. In Access, a quick fix would be: Format("01/2/1998","mm/dd/yyyy") A T-SQL fix would involve using the CONVERT function. Refer to BOL.

Well, I'm guessing you are doing this query in Access ... so there is no MONTHNAME function ... try: Format([Date Entered], "MMMM") If you are looking to do this in SQL, you will have to do a CASE statement for the month: CASE MONTH([Date Entered]) WHEN 1 THEN "January" WHEN 2 THEN "February" : :

If you don't have a scheduled Windows task, then how can you ensure the database is open and working on the first day of the month? Basically you need to ensure a form is open and have the timer event set to check if Day(Date()) = 1

Hey Wideawake ... are you asleep? Did this solve your issue?

Try MID(YourField,5)

I know of no tool, but the way I have done this is to rename the table in the master DB and see what breaks. Maybe not the best solution, but I am able to get the rats to leave the ship. BTW, in the databases where the linked tables are, instead of using the Linked Table Manager, open up the...

When the asterisk is selected, then you need to populate a recordset containing the values in the combox box (minus the *). Then use a Do loop. Psuedo code: If ComboBoxValue= "*" Then SET rst = openRecordset("Your ComboBox Query") Do While NOT rst.EOF Call DoTheExport(rst!Dept) rst.movenext...

You must go into the design view. Click on the protractor thingy in the toolbar for the forms. Select the checkbox and hit delete.

As David's article points out, there are issues with using the GUID, especially for it's un-intended purpose. I would really think about my last suggestion. Especially if this is going to be used for any period of time.

Check out the OFFSET function