Search results

I would suggest taking off the cascade update, and definately the cascade delete. You don't want to hit delete record to find it deletes all the relative records in the database. If you are using [Serial #] as a field name not a good idea, use something like SerialNo (don''t use spaces either...

Just straight out of left field here. Perhaps have them listed in a column, each with an number combo box beside them, drop down 1 to as many items on form. once the form is populated. select your alternate order via the combos. Then a sort of refresh key that does a re-write of the positions...

A report header is usually the first page to print, and the footer is the last. If you want it to appear on each page, you need to move it to the page footer. If I understand you right. lightray

out here we say Tu Meke!, which means Awesome! ... and I'd like to add my appreciation as well. I've only been here for a short while, but you guys (non-gender specific) seem to go to amazing lengths to help us out. So thanks from down under.:)

Thanks Teams, I discovered the problem, but seemed to get the wrong answer. Yeh! you're onto it Rich. I tried also Me.[EndDate] but my input test Saturday 25/11/2006, said it was Sunday! not sure what's happening there. However I have implemented the fabulous gemma's idea (sorry Rich, ;) she...

Yeh! it was a typo in the post. Are you able to test it in a MsgBox? I wonder if its a problem there, perhaps pass it in as a variable? I will try ... lightray Select Case Weekday(Me.EndDate) Case 1, 7 txtWeekendDay = WeekdayName(Weekday([Me.EndDate])) MsgBox...

thanks Pbaldy, too focused on the other cases not to spot that, and it would have taken me a while. have a little trouble with the Msgbox now as I want to display weather it was a 'saturday' or 'sunday'. from the original code posted I've also tried: WeekdayName((WeekDay([Me.EndDate])) as...

The short answer is no!, you have to design a second form using the query as input. The Forms wizard will do a pretty good job to start with. lightray :)

Hi am having a problem with my weekday formula (kindly provided by the forum) thanks:) However I am using it in a Select Case and it doesn't appear to be working. I have tracked it from a breakpoint and it just bypasses the checking. My code Is: Select Case Me.EndDate Case...

Thanks again, Rich, Gemma. moved back to the before, (before I moved it to the After) ... it's settling in but I have a few other scrub fires to sort! Will post final solution when all done.:):) (one each) lightray

Gemma: Thanks, your suggestion has come with measured success in the After event. I have wound up with the dreaded runtime error #-2147352567 (80020009). mainly because I decided to set the startdate to oldvalue as well,(and setfocus there, from Exit event), and startdate is a required field...

Thanks Guys & gals, I'll sort it in the morning ZZZzzzzz %)

then try a search on color or colour, plenty there! this one first off the rank! http://www.access-programmers.co.uk/forums/showthread.php?t=117601 happy colouring :)

right click on the field in design view, conditional formating et al is there! ;) as a design feature yellow is not a good colour to use on a white page, lightray :) Edit: perhaps not conditional for reporting!

I don't think that was a good solution: Me.EndDate = "" gives me the dreaded; runtime error #-2147352567 (80020009) "the macro or function set to the beforeupdate or validation rule property is preventing [mdb] from saving the data in the field. or was that what you were expecting? lot of posts...

How does the user select them on the form? what criteria are you using to get the selection for the append?

one solution is to set one of your fields as a required field. As long as it is empty on close of form, the record won't save. Mind you have to deal with a couple of annoying exit messages "can't save the record...." but it's a solution. I'd be interested in any other ideas. Lightray

I think your Parts Table should have a Pkey field PartsID in it , you may have one already. When you are creating your House Rooms record (main Table/Form) you can have multiple combos that will store the PartsID in the House Room table. or they can even be simple check boxes so when checked...

Hi, maybe set up a option button or a check box on the form row, then if checked just move the ones where condition is checked. lightray :)

You need a field in your table like ContactType which says what type of contact they are. If you already have one - easy Create a query where ContactType = "contractor" etc and all relevent details. Base your report on this. could even use it as input parameter lightray