Search results

Your more then welcome

Thanks missinglinq. Really nice to see your still at it. I remember you helping me out of quite a few sticky situations a few years back in another forum. Just in case I didn't say it then, Thanks so much. Regards SmallTime

Sounds like you already have this cracked. Just make a continuous form with the Records Source based on the table of completed training. You already have a Yes/No field in the table which will become the control source for an object on your new form. whether you use, a check box or combo box...

Not sure if I've got the right in of the stick here Your first subform RecordSource is tblHoursAvail which has a field HoursAvail1, so you can point to it without problems. Your OTHER subform RecordSource is tblSignup (No HoursAvail1) Can you now see where the problem might be? You don't...

Hi my friend I think I get the gist of your question but need a little more info. Is your form bound to the table you're searching? do you have any field names on the form and the table? What have done so far? Also, if you break your question down to smaller bite-size units it might help...

You'll have to decide which event to place this in, depending on when you want then colour changed. Maybe in the 'on open' event of the form If Me.Town = 1 then Me.Town.ForeColor = vbRed else Me.Town.ForeColor = vbBlack 'or what ever colour you like end if Or you could use conditional...

Hi ya, I haven't looked at your attachment as I try to avoid downloading files, sorry. But I think your form is probably based on a query with the criteria pointing to a field in the deleted tab. Go back to the data source and see if anything's missing Also, go to the code window and from...

Not too sure about this as I haven't played with hyperlinks for a while but you could save the hyperlink as text and then change it back on click Suck it 'n' C Regards Smalltime

Try If Me.Dirty = True then Me.change = Date() Me.Dirty = False end if

Ah ha, It works just as suggested. I did the very same thing yesterday and it wouldn't play. Later, when trying to make a query, I discovered I'd some corruption creep into my working project and imported everything into fresh database but didn't try playing with the macros after that. Now...

Will post the screen shot in a while, just have to pop next door and help my dear old neighbour with an email.

Ah yes, you wrapped the problem in a nutshell. The whole block moves. What I want to do is move the End IF part ONLY so I can have lots of lovely nested if then's Thanks for the pointers Take Care SmallTime

ah just spotted the continuous form bit. In this case you'll have to base the form on a query that has data from both tables. Sorry SmallTime

Maybe it's a little too late for me (gone midnight) but I think might have over complicated you question. Try to simplify things a little. Also, just as a side issue when you're doing calculations learn to love the Nz. Take Care SmallTime

Hiya, You can use DLookup to display data from an unrelated table, something like; DLookup("[Location]", "tblLocations", "[COMMON FIELD NAME IN tblLocations] = Forms![FORMNAME]![FIELD ON FORM NAME]" Place the code in one of the events (maybe AfterUpdate) if you want to display more than...

Yeup, intellisense is a really good and helpful addition. I did also open the query in ProwideFoods but still no fields. I suspected something was amiss which compacting wasn't sorting out so imported everything in a new database and hey presto all is now well. I started this project 2 days...

Hi Bob I got the calculation done OK, just went back to good old VBA and managed it in no time. I've just started using 2010 and it seems odd that the field names aren't appearing in the expression builder. Is it a feature! Regards SmallTime

Using Access 2010 Does anyone know why fields aren't appearing in the expression builder As you can see from the attached image there should be 3 fields in expression categories column. This is really stumping me. Regards SmallTime

I'm giving up on the new marco for now, it's just taking too long and not that easy to read, but that might be just me not being used to the interface. Also seems a little limited in scope and usage, I would have expected a lot more from the guys at Ms before rolling out something so...

Ahhh just spotted your "Attention: Any advice" Thanks anyway