Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AndrewWolford

    JDE testing question

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

    JDE testing question

    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'...
  3. AndrewWolford

    Please Help! Access deleted all my forms!

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

    populate combo box question

    Nevermind, I got it to work, thanks again!
  5. AndrewWolford

    populate combo box question

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

    populate combo box question

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

    Server benchmarking ideas?

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

    referencing a subform in sql

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

    referencing a subform in sql

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

    Selecting a "field" not in a table - possible?

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

    Selecting a "field" not in a table - possible?

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

    How do I connect to a SQL server back end?

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

    How do I connect to a SQL server back end?

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

    changing field type in code?

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

    changing field type in code?

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

    changing field type in code?

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

    changing field type in code?

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

    *seemingly* random shutdown

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

    *seemingly* random shutdown

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

    reading in a user-specified range (excel)

    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!

Part and Inventory Search

Back
Top