Recent content by AndrewWolford

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