Search results for query: *

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...

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...

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!!

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!

Can anyone tell me why the following view doesn't work? The SELECT statements work fine on their own, but they won't work when I add the IF statement. Thanks to anyone who can solve my problem! ALTER VIEW WKCTL.V_P3_BACKLOGS AS IF substring(ACT,3,1) in...

I have an Access 97 database which I just split into a front-end and back-end. I converted the front-end to Access 2003. One of the forms in the database is based on a query. If the query returns no records, none of the fields appear in the form when I open it.(form looks blank)Any...

When I try to open a Word 97 document that is already opened by someone else, it asks if I want to make a copy. When I say yes, it will not allow me to save it. I have the same permissions as others to that file location, however they are able to save to it. Any suggestions? Thanks.

I am trying to set a field in a form in Access 2003 when it's loaded but I get an error message saying it can't find the form. Can you please tell me what I'm doing wrong? This worked fine in Access97. dim url as string url = Forms!frmMain!Path.Value Hope someone can help. Thanks.

Is there any way to document the keys assigned to linked tables in a query in Access 97? Re-linking tables deletes these keys and they all have to be re-set again. Thanks.

Is there any way that I can do a text search through the contents of all Stored Procedures? I'm trying to find all Stored Procedures that run only on a certain day of the week. Thanks.

How would I calculate the difference in minutes between the following dates, ignoring the difference in days in MS Excel: 7-21-04 1:10 AM 7-14-04 12:10 AM I'm trying to get a result of 1 hr. Thanks!

My main Switchboard has 7 Items, one of which calls a second Switchboard. The second Switchboard has 16 Items(in 2 columns of 8), with one button allowing the user to return to the previous Switchboard. If you go back to the previous Switchboard, the screen shows the 7 items from the main...

I have created a function that passes 2 parameters to return one result. The function works properly in SQL however when I call it in a DTS package, I get the following error: Procedure or function has too many arguments specified. If I remove one of the parameters, it works fine, however...

When I run the following SQL statement I get an error saying "Invalid column name(E99000). select wkctl.parentwo_convertToPP(E99000) Here is the code for the function: create function wkctl.parentwo_convertToPP_T(@parentwo varchar(9)) returns bigint as begin declare @numparentwo bigint...

I am trying to convert anything over 1000000 to &quot;A00000&quot; and over 1100000 to &quot;B00000&quot; etc. The following code returns the correct string: declare @char_parentwo varchar(9) declare @parentwo bigint set @parentwo = '1129356' If @parentwo > 999999 and @parentwo < 1100000 set...

I am trying to create a function that changes the first 2 numbers to 'A' when the number reaches 1,000,000. The source is a numeric datatype so I need to convert it as well. Here is my code, which works as long as it's not a function. Any help would be greatly appreciated! create function...