Search results for query: *

Hi everyone, I have what I hope is a quick question around JD Edwards and testing within test environments. I have a client that says they maintain two DB/2 databases, one test, and one production. For testing, they say they 'detatch' their production objects and custom libraries and 'point'...

I doubt there is any way to fix this, but it's worth a shot. I was working in the vb editor of one of my forms, when my computer all of a sudden started doing some heavy processing (pointer went to hourglass for about 30 seconds). I didn't think anything of it and continued work on my code...

Hi, I have a subform (datasheet view) that is tied to a table. In the subform there is a 'combo box' field called "Status." Status is tied to the column "status" in the table. The dropdown is populated with a query "select Status_Name from tbl_status;" Here is...

Hi all, I have a Compaq Proliant DL740 server that I would like to do some performance benchmarking on. Over time, the server seems to be processing data slower and slower and I would like to be able to compare how it running, to how it should be running. I am not a server expert, so I...

Hello everyone, I can't seem to figure out why my query isn't working, I could use some help... All I'm trying to do is reference a text box on a subform in a sql query, but it doesn't seem to be working. Here is my query: SELECT * FROM table1 WHERE table1.id = forms!formMain![table1...

I have what I hope to be an easy question, but I can't seem to figure it out. For simplicity, I'll use a basic example. I have a table that I'm selecting fields from (name & address). I want to create a field (city) populated with "Seattle" to display in my query results, but...

Hello everyone, I am very new to SQL server, so please bear with me... I have a SQL Server database that I'm trying to build an Access front end around. There are 2 SQL tables that I need to access with 1 form. I understand that I can link to these tables by going (in access): File>Get...

Hi all, I have a sub routine that takes a date from a field in a table and converts it to the proper date format and copies it back to the field. My date comes in this format: "20031231" and gets copied back as "12/31/2003" The field is dbText. here is the code I have: Do...

Hi everyone, I've written a small function in excel that reads in a range into a dynamic array but I can't figure out how to make the range "user specified" and can't figure out how to call the function from a cell in excel. Here's my code so far: Sub testfunction() Dim myCell As...

Hi everyone, I hope I'm posting this in the correct forum. I have a computer that appears to be randomly shutting down. Its an Athlon 1.4 with an Asus motherboard. I have Windows XP. Here's a description of the problem: I'll be using the computer and without warning it will simply turn...

Hi Everyone, I have a question about how to handle null values in a text file I'm importing. The txt files that get imported are fixed width. The problem is that a lot of the time these txt files have null values instead of spaces to seperate the fields. So the file would look like...

Hi everyone, here's my problem. I have created a database that uses a lot of VB. It contains some forms, some tables, and a bunch of various functions that I've written. There are about 4 or 5 users of the database and the problem occurs when one of them goes to use it. It works fine on my...

I'm having a problem getting my code to run properly. Here's the overall process I'm trying to accomplish. I've got a table, from that table I'm running a query that pulls certain information, then exports the results of that query to Excel for charting purposes. Heres the code: strSQL =...

Here's my problem: I'm trying to write a query that selects a field from a table (easy part) based on a user-specified field (hard part). I have a form with a text box (txtUnion). I want whatever fieldname the user types in this text box to be selected from the table (testdata). Here's the...

Hi all, I'm trying to find a way to export a query to excel from Access and I'm having a bit of trouble. I am familiar with the following method but it seems to only work when using an existing, saved query: DoCmd.TransferSpreadsheet acExport, 8, currQuery, outfile, True (where 8=excel'97...

Hi all, I'm trying to find a way to export a query to excel from Access and I'm having a bit of trouble. I am familiar with the following method but it seems to only work when using an existing, saved query: DoCmd.TransferSpreadsheet acExport, 8, currQuery, outfile, True (where 8=excel'97...

I just had the weirdest thing happen. I was working in my database modifying a SELECT query when I got up to use the restroom. I came back and about 3 of my tables are gone! I didn't do anything to the database, I didn't run any queries (they're all select anyway) and nothing else was going...

This seems like it should be so easy but I can't get it to work! I have a table that contains employee SSN's, Names, Salary, etc... Its about 100,000 records long, the problem is that about 40,000 of those records are dupicates. I'm trying to figure out a way to look through the table and if...

Hopefully this will be an easy question... I'm trying to document a database I've been working on and want to print out the tables in design view (so I can see the name, type, and desc of the each field in the table). I can't find where you can do this, does anyone know of any ways to do this...

I know there has to be a way to add new fields to an existing table in code. I've tried creating a SQL statement string that contains "ALTER TABLE testdata ADD newfield text null;" and then executing the statement in code. The problem is I can't figure out how to add more than 1...