Search results for query: *

I have tried both methods with the same results. I renamed the tables when I used ODBC(using Oracle 92 driver) and a pass-through query still times out if I enter a parameter and not the exact date.

Yes, the Oracle connection works, shows all the data and the query works if an actual #date# is listed in the criteria. It just doesn't work when a parameter query is used.

Thanks but I have tried that already. Anything I type into an input box does not seems to work. (error message is ODBC call failed)

Thanks but this won't work. The user is not experienced in VBA. What she is trying to do is be able to change the date every time she runs the query through an input box by using [specify date] in the criteria of design view. If she enters an actual date in the criteria it works. It's also...

Thanks. I tried it but this query is in Access 2003 and it says the statement is invalid when I add it to the beginning.

This is the query that I am running: SELECT TEMPUS_PERIOD_ACTUALS.PA_PEREND_DT AS Week, Sum(TEMPUS_PERIOD_ACTUALS.PA_REG_HRS) AS Reg_Hrs, Sum(TEMPUS_PERIOD_ACTUALS.PA_OT_HRS) AS OT_Hrs, Sum([TEMPUS_PERIOD_ACTUALS].[PA_OT_HRS]+[PA_REG_HRS]) AS Hours, TEMPUS_EMPLOYEE.EMP_EMPLOYEE_TYP FROM...

I am running a query in Access2003 that has a date parameter query in one column. The query works if I type in a specific date in the criteria, however if I use a parameter query, it times out. My date format matches the format on my computer's Regional settings. Can anyone suggest how I can...

How do I tell what the missing expression is?

When I execute the query below in Access2003 I receive the above error however it works fine in Access97. Any suggestions for modifying it in Access 2003? Thanks! SELECT TEMPUS_PERIOD_ACTUALS.PA_PEREND_DT AS WEEK, Sum([TEMPUS_PERIOD_ACTUALS]![PA_REG_HRS]+[TEMPUS_PERIOD_ACTUALS]![PA_OT_HRS]) AS...

I have inherited a database which compacts everytime it loads. The database is on the network. However lately users are getting the above error message first thing in the morning, then the problem just goes away. I have checked and there are no users in it, there is no LDB file. Does anyone...

When I use ODBC to link to an Oracle table I get #Name in all the columns. The same link used to work in Access97 but not in Access 2003. Does anyone have a solution? Thanks in advance to anyone that can help me.

I can update a DTS package using the API but after it is saved the visual presentation is messed up. The variable that is referenced in the DTS support web pages from Microsoft (and many other places) is pVarPersistStgOfHost This variable is used as part of the methods that you can call to save...

Thanks for the solution!!! It was what I needed.

@ACT is a variable which I provide, but the code doesn't work even if I use a hard-coded number such as '12345678'. @p3ActID is the result of the function. What I'm trying to do is extract the last 8 characters of a variable, just if the input value is a number. Thanks.

Can anyone tell me why the following code won't work: declare @p3ActID varchar(10) declare @ACT varchar(10) IF ISNUMERIC(RIGHT(@ACT,8)) begin @p3ActID = RIGHT(@ACT,8) end end if Thanks in advance!!

We use File DSN's to connect to Oracle and SQL databases using NT Login and password. The File DSN only shows the connect string and does not contain user names or passwords so security is not a problem.

Can anyone suggest code that will auto-login a user while using file DSN's? I was able to do this using a System DSN but don't know how using a file DSN. Thanks for any help!

Is there a way to set the printing defaults for a report? I want this report to print on 11 x17 paper without having to make the changes each time I print the report. Thanks!

I can't thank you enough. It works perfectly!!!

Thanks! I would appreciate it if you could get me started on the correct syntax. Thanks again!