Search results

  1. Y

    how to use the split function?

    Hi Bob it doesn't work on query unfortunately The doctor's table is not relational to the patient's history table (stupid of me) Just think it as a field where i typed Joe Dirty, 1900 maple Rd, New York, Flushing 11379 and now i want to split it up ________ MARIJUANA NEWS
  2. Y

    how to use the split function?

    Private Sub Referring_Doctor_BeforeUpdate(Cancel As Integer) Dim a a = Split([Patsums].[Referring_Doctor], ",") Document.write (a(0) & Chr(13) & Chr(10)) Document.write (a(1)) End Sub what am i doing wrong here? ________ MERCEDES-BENZ W208 HISTORY
  3. Y

    how to use the split function?

    Thanks bob ill try to mess around with it Chr(13) & Chr(10) ________ TOYOTA U TRANSMISSION
  4. Y

    how to use the split function?

    here is a picture of the first form ________ Opium Rehab Forums
  5. Y

    how to use the split function?

    You see the first form I have fetches the data from a doctor's table Referring Doctor: John Smith, 199 Maple Rd, New York, Flushing 11379 The second form fetches the field Referring Doctor from the first form I'm kind of confused myself on how to do this sorry ________ Honda OSM history
  6. Y

    how to use the split function?

    HI Bob, thanks for the fast reply, I actually have two forms First form I have already made. It shows a list of the doctor's in a drop-down box in 1 whole row. ie John Smith, 199 Maple Rd, New York, Flushing 11379 The Second form uses that query from the First Form. If I do use the...
  7. Y

    how to use the split function?

    Hi guys i don't know any vb coding at all I made a query to concatenate a doctor's list Now the QUERY shows all in a single line like John Smith, 199 Maple Road, New York, Flushing 11379 I need it to use THAT query show like this John Smith 199 Maple Road New York, Flushing 11379 I believe i...
  8. Y

    How can view the last row in my subform? *picture included*

    I have got it up to 1 row with the lastest date but the problem is the reason is not corresponding with the date. If i change the reason back to group by 10 rows will appear again. I want only 1 row showing for each ID. http://img293.imageshack.us/my.php?image=68147538cf3.jpg ________ Hawaii...
  9. Y

    How can view the last row in my subform? *picture included*

    SELECT Last(EXAMPLE2.ID) AS LastOfID, EXAMPLE2.EXAMPLEID, Last(EXAMPLE2.DATE) AS LastOfDATE, Last(EXAMPLE2.REASON) AS LastOfREASON FROM EXAMPLE2 GROUP BY EXAMPLE2.EXAMPLEID; is the closest i gotten... but it sorts the last time i inputted not the lastest date. ________ MAZDA PORTER PICTURE
  10. Y

    How can view the last row in my subform? *picture included*

    i made a subform with dates where patients came in for an office visit. how can i see the last row (lastest date where they came in) of my subform Note i can't do after, before, between, equal, not equal... because a patient could of came in a last year. I need the lastest date where they...
  11. Y

    how can I print last lines of a memo? *please help*

    when i print, it always prints the beginning and not the end of the line. I don't have the space to print all of the lines so i prefer to print the end of the line only to save paper. Thanks guys ________ Vapir One Review
  12. Y

    Drop combo box newbie question

    I want to type in the values in my drop down combobox. lets say i type values 2/14/08 Went to the Park 3/14/08 Went to the Zoo 5/15/09 Went to Vacation I just want 5/15/09 Went to Vacation to be displayed while i hit the down arrow in the combo box 2/14/08 and 3/14/08 will be displayed...
  13. Y

    Hi newbie macro question

    would IsNull([DateMod]) and IsNull([TimeMod]) be correct? Or should i put more conditions ________ You porn
  14. Y

    Hi newbie macro question

    I'm trying to set a date/time. When someone calls in the date and time will be recorded. i did this using setvalue date() and setvalue time() The problem is when i change or edit the record, the date and time will adjust because of the macro. Is there a way to set the date and time only...
  15. Y

    Possible to use sql on a ftp server?

    Here is the deal I got localhost connecting with sql on my local computer Can I drag the sql files and place it into the ftp server where it will allow to connect with php? mysql_connect(www.website.com,'','') Is this the correct way of connecting? Or can I use: mysql_connect('MY IP'...
  16. Y

    Multiple users using access at the same time

    Ahh thanks George... I guess this won't be possible for me. Thanks for the input though. ________ Medical marijuana
  17. Y

    Multiple users using access at the same time

    Web Applications meaning html -> php -> odbc Is there any tutorial for this... ________ VAPIR NO2 VAPORIZER
  18. Y

    Multiple users using access at the same time

    Hi thanks for your reply George. I have to this do over the internet =( We have 4 different locations... Is there anyway to get around this? ________ Teen health advice
  19. Y

    Multiple users using access at the same time

    How can I do this with an ftp server? I want to upload the mdb file to the ftp server where multiple users (3-4 people) can access it at the same time. Thanks guys ________ Honey oil
  20. Y

    is it possible to auto adjust the height in the table?

    I have a comments section in a table which sometimes "goes across the row" if you get what i mean. When i try to print it gets cut off. What i want to know is whether or not i can auto adjust one of the rows height so all the information will be displayed. ________ SUBARU 360 HISTORY
Back
Top Bottom