Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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