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 Chriss Miller 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. raymondo

    Permission problem

    Thanks RhythmAce and feherke. It turned out to be the form action. Short tags were off and after changing my script to long tags it worked without a hitch. Raymondo
  2. raymondo

    Permission problem

    Sorry, I'm really new at this and thought the message about no permission meant there was something amiss with my Apache set up. I 'll sart start with a very basic script and work up. Thanks for looking at it. Raymondo
  3. raymondo

    Permission problem

    Hi, I'm an absolute beginner trying to teach myself Apache, PHP and MySql. I have a PC running Windows XP and have set up a local server. The installation went reasonably well though it was rather daunting for a complete beginner. Anyway, I got things working and set off with PHP book in hand...
  4. raymondo

    Uniqueidentifier

    The autonumber 'datatype' will create a unique long integer for each record you create. Is this what you're after? Raymondo raymondo@rossar.net
  5. raymondo

    How do I not display Null/Zero fields on a report

    Thanks DrSimon, As a first step, it's a goodun'. I suppose I could use something similar to shift all the other up - accessing their position properties or something. I'll give it a go. Raymondo raymondo@rossar.net
  6. raymondo

    How do I not display Null/Zero fields on a report

    I have a report based on a query. Five of the fields may null or zero. For 3 of these fields, if the value is null or zero I don't want anything displayed on the report (field or label) - as if those fields did not exist as it were. Is there a straight forward way of doing this? Thanks...
  7. raymondo

    Form-subform: Cannot update field message

    The only code attaced to the subform is an AfterUpdate event for the cost textbox that refreshes the subform so as to display the new total in the footer. Anyway, whatever was causing the glitch disappeared after I redesigned the subform from scratch! Raymondo raymondo@rossar.net
  8. raymondo

    Form-subform: Cannot update field message

    I have a form-subform set up which is essentially enrolments for courses. Each student may enrol in many courses. This was working fine until I added a few fields to the subform and included a course-cost total in the subform footer. Well, it still does work, but when a new course is added, I...
  9. raymondo

    Moving Records To Available Table

    What about an append query into the new table followed by delete query on the old table? Raymondo raymondo@rossar.net
  10. raymondo

    how do I compute Julian dates?

    As a onetime Astrophysicist I can assure that the Julian Date is defined as above. But I agree with you, it really doesn't matter (which rather begs the question why did I even bother to state it - let's just say a personal foible!) I must admit also that I'm stumped as to what you could do...
  11. raymondo

    How do I set a control in a subform from the main form (and vice versa)?

    IÆve seen a few of these type questions floating about so here are a few tips. LetÆs call our forms myMainFrm and mySubFrm. Trying to use an expression like Forms!mySubFrm![aControl] = aValue from myMainFrm wonÆt work because when a mainform-subform is opened, only the main form figures...
  12. raymondo

    how do I compute Julian dates?

    I hate to be picky but your date is not a Julian date. The Julian date is defined as the number of days starting from 0 at 12 noon 1 JAN -4712 (4713 BC) in the Julian proleptic calendar which was favoured by astronomers for many centuries. Your date appears to be one of the many variants of the...
  13. raymondo

    Type Mismatch

    I think the problem is here If IsNull(Me![AspRat]) Then Me![AspRat].Text = "" Else lngAspRat = Me![AspRat] Me![AspRat] = Null End If If, on the first entry into this function, Me![AspRat] is NULL, you assign "" to it. Fair enough. But...
  14. raymondo

    Converting Access 97 to xp, Help needed

    The only real question is does the converted db, once compiled, work the way you want it to? If yes, there's no more to do! Raymondo raymondo@rossar.net
  15. raymondo

    Selecting multiple values from Combo Box for query

    In Access 2000 at least, there is no MultipleSelection property for comboboxes, only for listboxes. Raymondo raymondo@rossar.net
  16. raymondo

    List Box Item Selected Automatically after Requery

    If you are happy to leave the focus in the listbox then you could use a combination of the SelStart and SelLength properties for the control. Check them out in Access Help. Just set them both to zero after your requery. Hope this helps Raymondo raymondo@rossar.net
  17. raymondo

    Converting Access 97 to xp, Help needed

    One, unfortunately rather painful, solution. Export all your modules to text files. Clear them from the database. Convert the db. Set the DAO library. Import all your modules. An alternative - Create a new db in XP. Make sure the DAO library is set. Import your old db piece by painful piece...
  18. raymondo

    Input mask flexibility

    You can actually set the focus on a specific character in a field. Look up SelLength and its relatives in Access help Raymondo raymondo@rossar.net
  19. raymondo

    How to set: If no data is entered on form, you can't continue?

    Since you can't check that the data entered actually makes sense then you can only check for Null or blanks if IsNull([field]) or Trim$([field]) = "" then don't load report send message whatever end if Hope this helps Raymondo raymondo@rossar.net
  20. raymondo

    Input mask flexibility

    Have you tried putting the area code in the DefaultValue property? or perhaps the area code plus zeros? Raymondo raymondo@rossar.net

Part and Inventory Search

Back
Top