Search results for query: *

jmd0252, Thanks for the response, they are using OneWorld. I've never heard of someone doing this, so I wanted to check with the "experts." Thanks again, and I'll try the jdetips site. Andrew

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

Nevermind, I got it to work, thanks again!

Thanks for your help, where do I set the column width? I've created a query that selects status_id, status_name from tbl_status, I ran the query and for the field status_id I dragged the sizing handle all the way to the left so that you couldn't see that field anymore (does my explanation...

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

Yes!!!! It worked!!! I've been trying to figure this stupid thing out all day! Thank you thank you thank you. I figured it had to be something like that that I was missing. Thanks for your help! Andrew

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

That was it, thanks! (I knew it had to be something really simple that I was forgetting)... Thanks again! -Andrew

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

Thank you for helping me out, I think I got it to work now. I can link to the tables and view them in Access now. The database will be used by multiple users, but I think the plan is to do a remote desktop connection to the server, and have the Access front end be accessed from there. For...

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

Hmm, still doesn't work. I copied your sql statement and tried to run it as a query and it errored out giving me a syntax error. This is the sql statement I wrote: ALTER TABLE testdata ALTER COLUMN dot DATE; where testdata is the table Im modifiying and dot is my date field. I'm guessing...

Dates get imported from a fixed-width text file looking like this: DOH 20031231 19990514 20010425 00000000 20020918 00000000 My code loops through the table (DO until rst2.EOF) and reads in each date, manipulates the date(as text) and copies the date back to the field as: DOH 12/31/2003...

Thanks Tony, I couldn't get the sql to work. I tried executing your sql code in a query and it gave me a syntax error in the statement. Is there something missing in the above sql? Also, shouldn't there be a ";" after "DATE" Thanks for your help! -Andrew

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

Yes Im using Windows XP. I've been putting a box fan next to my tower when I use the computer until my new case gets here. I think the problem is heat-related as the computer has yet to shut off since I've been doing this. I'll check to make sure the CPU is seated correctly when I transer the...

Yes I'm still looking at this thread. I'm at work right now and will have to wait until I get home to check the voltage. Off the top of my head I don't know what brand the power supply is, but I know its old (1999). Loknar~ I assume I can get the voltage by using a utility found on your link...

Thanks for your help, after playing around with the code I got it to work. For simplicity I only posted part of what the function does which is probably why it wasn't clear what I was doing. Anyway, thanks for the help!