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 derfloh 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: *

  • Users: d1004
  • Order by date
  1. d1004

    extracting date & time from a string

    Suppose I have two types of time field. One is in military time, and another is regular. For example 1610 ---- military time for 4:10 435 ---- regular time for 4:35 I need to make this two fields consistent in order to subtract them to get the completed time. But I don't know how to approach...
  2. d1004

    Substr function: grab yr from the 20030101

    Is there a function that could help me separate out the following date into year & month. The date is stored as 20030101 rather than 01/01/2003
  3. d1004

    Getting a value from an url

    url = http://...index.htm?(Name=namevariable) I've tried to put the following code into my html page, but it is not showing up. This is index.htm <script Language=&quot;JavaScript&quot;> var qry = location.search var qrytextnosplit = qry.substring(1) var qrytext =...
  4. d1004

    Open an excel spreadsheet inside Access

    If I have an Excel spreadsheet that I want to be open inside an Access form, what command should I use? I tried using RunApp and Shell function, but it doesn't seem to work. Any suggestion would be appreciated. Thank you!
  5. d1004

    Make an unbound label visible and unvisible

    I will...thanks for letting me know...All this time, I never star it.
  6. d1004

    Make an unbound label visible and unvisible

    Ohhh, that works..But now I have another dilemma...But it doesn't relate to this issue..Anyhow, thank you very much.
  7. d1004

    Make an unbound label visible and unvisible

    My problem is that once the user click on a button, a label would be visible. That part I got it. But after they go to the next record, I want the label to disappear. However, that is not happening. Basically, the only time the label appears is when a user click on the specified button for...
  8. d1004

    Subform Errors connect to OLE

    I created a subform and w/in my subform is a frame with 4 radio options (Apple, Orange, Grape, Banana). The purpose of this frame is when the user select a certain fruit, it populates the shopper ID and the current date into the field. And I use the following code: Private Sub...
  9. d1004

    Email Info using ASP

    It still give me the same error message.
  10. d1004

    Email Info using ASP

    Well, I used the following codes, but it gave me the following errors: Dim objMail set objMail = Server.CreateObject(&quot;CDONTS.Newmail&quot;) objMail.From = &quot;blah@blah.com&quot; objMail.To = &quot;blah@blah.com&quot; objMail.Subject = &quot;Testing&quot; objMail.Body =...
  11. d1004

    Email Info using ASP

    How can I email my Request.QueryString or part of it to a recepient w/o bringing up Outlook mail form. It just do automatically. once it is done executing the page. If I use the mailto, it brings up that mail form. Any suggestion on bypassing that. thank you.
  12. d1004

    Grab current users into textbox default value display

    I tried the environ(&quot;username&quot;), and it works for Window 2000 OS, but it wouldn't let me for Window 95. Is there any other method? Thank you
  13. d1004

    Update the form

    What if I had the Default Record Locking as No Lock because that seems to let two users use the form without one going into read-only
  14. d1004

    Update the form

    I tried all this, but what is happening is that let's say user 1 open the form and use it. Everything works great. But when user 2 open the form, it is read-only, and the userID field populate the user1 ID rather than user2. I guess what I am trying to do is to have a capability where both...
  15. d1004

    Update the form

    Is there a way that I can have two users using the form at the same time and possibly updating the information at the same time too. One way I was thinking was to open the form as a read-only, and when the user click the update button, then it changes from read-only to editable or something...
  16. d1004

    Stored current date into table

    I'm not really good with code, but what I'm trying to do is stored the current date field from my form into my table. So what I've done is put =Date() in the Default Value Property and the table field name in the Control Source. But that didn't work.
  17. d1004

    Grab current users into textbox default value display

    This is a really stupid question, but can I put that function inside my Private Sub UserID_Enter() Thank you!
  18. d1004

    Grab current users into textbox default value display

    If current user ID log into the network, I want to have the capability of putting that ID into my current user txt box. Is there a way to do that. I know in DOS, you grab that by using %username% Thank you, -D1004
  19. d1004

    Timeout Error Messages

    I haven't change any codes. The only thing I've changed is that I've added more records into the database. So far, my database contains about 17,000 records. I don't think I have max out my capacity.
  20. d1004

    Timeout Error Messages

    So do you have any suggestion as to why it takes so long to generate my report? I try to index certain fields as well as compact my Access database, but it still takes 10 minutes to generate the page. The thing that it puzzles me is that it didn't take this long before?

Part and Inventory Search

Back
Top