Search results

  1. Ethereal

    Email Report (UNDER DEADLINE)

    Personally i would look into the outlook object and email it that way ---------------------------------------------------------- Private Function GetOutlook() As Boolean On Error Resume Next ' Assume success fSuccess = True Set mOutlookApp = GetObject("", "Outlook.application") ' If Outlook...
  2. Ethereal

    Open File

    Ok, a little shakey on this. Code the shell command for opening test1.avi with windowsmediaplayer.exe just write "path" if there is supposed to be a path b4 these filenames
  3. Ethereal

    Open File

    How would i go about executing a file... say Test.avi, i would like it to exe just as if you were to double click it. Is there a way to do this ?
  4. Ethereal

    renumbering a unique value'd field

    Right, I was requerying the listbox before i updated the table... then being silly enough to not look at the table.... It does work in the sample! Another reason i was getting duplicates ... switching from design mode to run mode mid write state tt
  5. Ethereal

    Textbox

    set the controll source property of the text box to the corresponding field in your table, make the record source for the form that table first though
  6. Ethereal

    Textbox

    Not a problem! 15 posts for 2.5k mark RG!!
  7. Ethereal

    Textbox

    where are you storing what you have written in the "comment" box ?
  8. Ethereal

    renumbering a unique value'd field

    but I need it renumbered as well like when i enter seq#3 into 1,2,3,4,5 the end result should be 123456, pushing the old records down the line so to speak
  9. Ethereal

    renumbering a unique value'd field

    Thanks for that, At least now it will work once the "cleansteps" method changes the records correctly :(
  10. Ethereal

    Duplicate Specified number of Records

    I'm not sure about how to duplicate, but if the serial numbers are unique shouldn't they just be an auto number ?
  11. Ethereal

    Textbox

    The control source of the Textbox (aka what it is bound to) should be referencing a field. Go to the table where that field is and go into design mode and switch the field type from Text to Memo
  12. Ethereal

    renumbering a unique value'd field

    I think everything on this sample is working properly Note: had to make mach table for the odbc's but i'm pretty sure it is working properly, or more correctly, working as it was!
  13. Ethereal

    renumbering a unique value'd field

    Ok, I got that all into my code with updated names etc... but um, it doesn't do anything .. lol :( When i pop the SQL into a query and run it, it seems to be coming up blank even when there are duplicate values for [Step] and when i took out the WHERE clause so the query would just be the...
  14. Ethereal

    renumbering a unique value'd field

    BUMP.... Please help!
  15. Ethereal

    Buffering Images

    I am not sure where the "continuous" property is. I "know" it would be better for only one record at a time, but the people i am developing for would "ideally" like to view multiple photos at same time.
  16. Ethereal

    Buffering Images

    I have a form that displays pictures controlled by a field in each record (linked) I was wondering if there is a way to buffer the images so that it doesn't take approx 60 seconds to load up 16 .jpg images...
  17. Ethereal

    renumbering a unique value'd field

    I would like to avoid using a float value because of its use elsewhere in my application
  18. Ethereal

    renumbering a unique value'd field

    as of now I am only letting them add/remove the "steps" and it would renumber accordingly in both these cases to represent a sequential system. On your "run code to renumber the other records" I am not good at working with recordsets, and need somebody to point me in the right direction.
  19. Ethereal

    Trimming the middle out of a string

    Look into functions like Midstr(), Instr() and Left()
  20. Ethereal

    renumbering a unique value'd field

    Hi, I was wondering if there is a way to renumber a series of records in a field that uniquely identify's the record. Say my field was PROBLEMfield with records containing values 1, 2, 3 , 4, 5 these values represent the order in which something is implemented. So if the user wants to...
Back
Top Bottom