Search results for query: *

Hi, I have a challenge that I am hoping you can help with. I need to copy 200 .wav files from a few different servers in to one directory. There are multiple thousands of .wav files in the directories, else I would just copy and paste them manually. The names of the .wav files and their...

Hello - I'm just looking for a bit of direction here. I have a table with two fields that looks as follows: Node | StationID Node1 | 12345 Node1 | 12346 Node1 | 12345-12350 Node1 | 12370 Node1 | 12350 What I need to do, is evaluate all the other stationid's that equal or...

Good Afternoon, I've returned to a problem I was working on a few weeks ago. I attempted to use the suggestion Golom provided to me in the thread701-1232254. However, the number of characters exceeds 6000 in some of the fields. The query takes approximately 25 minutes to run - and I can't do...

Hello, I'm feeling particularly baffled this morning. I could have sworn there was a "Visible" option in the properties window for forms. I'm in Access 2003. Here is the simple task i am trying to accomplish... When the database opens, frmOpen opens. I want frmOpen to be hidden. Simple...

Greetings, I'm feeling particularly dense this morning - was hoping an extra set of eyes could tell me what I'm overlooking here... I have the following bit of code to insert user information into a logging table. I'm getting the Error 3134 message when I open the form. The only field in the...

Hello - I'm attempting to extract team information from a hierarchy string. The format is as follows /ParentGroup/SiteLocation/Manager/Team/ Each of the hierarchy members is of variable length except for the parent group. I am currently attempting to use this expression in my query: Team...

Hello, Wow. I have an interesting problem, and I'm not sure where to start. I am querying from an SQL database from Access 2003, and I have 2 fields that I am concerned about: Server and Values. The problem here isn't this existing query, it's what to do with the data once I have it...

Hello, I have a list of employees with scores from which I need to count how many are >94.99, between 90 and 94.99 and <90. I was wondering if there was a way to do this without having to do three separate queries. Below is the SQL I have so far... SELECT qryAgentEvals3.Site...

Hello, I am hoping you can help me with a small problem. Below are two pieces of SQL. The first is the way it should be, the second is what happens to it after I close and open the database. BEFORE SELECT qryNode1.UserNumber, qryNode1.type_id, dbo_user_aliases.alias FROM qryNode1 INNER JOIN...

Hello - just wanted to share something I figured out today after trying to find a solution that didn't involve VB. If you need to remove a trailing space that TRIM does not remove, the following expression could help (Access 2003)...

I'm using the following SQL statement for a search function. I'm having some problems with the like operator. If you could take a look and tell me what I've done wrong, I would appreciate it. [code]"SELECT tblCoreData.RecordNumber, tblCoreData.AgentName, tblCoreData.AgentID, tblCoreData.Site...

Hi There, I am creating a tracking form where users can enter and view updates in a subform. I am wondering if it is possible when they click the button to add a new update record if the fields could appear at the top of the continuous form rather than the bottom... If it's simply not possible...

Hello all, It's been a few months since I've worked in Access and used SQL and I feel like I've lost almost everything =( I am probably missing something very simple with this issue, so I'm hoping you can kick-start my brain... Here is my dilemma: I have a table of data in which there can be...

Good Afternoon, I have a couple of dropdowns on a form set up for report selection. Based on the selections, a textbox changes values for the appropriate parameters in the query the reports are based off of. Here's the problem: I refer to the textbox in the query as...

Hello, I am making progress on a module that I am using to connect to 4 separate Sybase DB servers. Here is the problem I am running into now. After I update the registry to run the next set of queries I get an ODBC call failed message. The ODBC connection that needs to be used opens an .exe...

Hello, I have a database that links to 4 Sybase databases on 4 separate servers. I've gotten as far as being able to modify the registry to tell Access which server it should go to. The problem I am running into is this: the link requires another program to run to create the connection...

Hello, I am currently trying to run a query (qrySB-Summary) and when I double click on the query, I get the following message: Microsoft Jet could not find the object "qrySB-Summary"... The query is there. I just clicked on it! All of the queries that feed qrySB-Summary work - so the problem...

Hello, I have a record set that will return anywhere from 1 to 3 records. Of those records, I have 2 fields that I am concerned with "Points" and "EarnBackPoints". The Points field can have a value of .33,.66 or 1. What I need to do is apply a value in EarnBackPoints so that the sum of...

Hi Everyone, I'm having a problem with a query not recognizing the "Between" portion of an IIf statement in a calculated field. SELECT Query3.fk_ScorecardID, Sum(Query3.PctCallsHandled) AS SumOfPctCallsHandled, IIf([PctCallsHandled]>0.99,"E",IIf([PctCallsHandled] Between 0.75 And 0.99,"M","N"))...

Hello all, Just have a really quick question. Is it possible to stack queries in code? I have three queries designed to give me the information that I need. They are dependant on each other, and I would like to move them into the code that runs behind the form. I'm not sure if this is...