I'm sure this post will receive a few detailed responses, therefore this will be a general one.<g>
The Format function in Access allows you lay out the Date / Time in anyway you wish! The CDate function will allow conversion. See the Access Help file for a complete list of available options...
Hi Mary,
>I'm going to start over as you suggested.
Good girl!<g> You are in good comapny with spaghetti coding, we are all guilty of this at some stage.
The trick is to realise when it's getting totally out of control .. If you are trying to do something that on the face of it appears...
Hmmm!
Functions will work almost anywhere provided you use them as functions ... in Tables, Forms. Queries, Macros, Modules etc.
Type the function name, place the cursor in the middle of it, then hit F1 for help. If the function exists in Access then you'll see the semantics and the...
Mary,
>I really don't think this should be so complicated!!!
You are right! The following has a name .. it's called spaghetti code!!<g>
************************
If (IsNull(Forms!frmStaffInfo!frmBidSubform!FRI)) And (IsNull(Forms!frmStaffInfo!frmBidSubform!SAT))...
Zebra print folder huh? How about a zebra print ( or other weird and wonderful backgrounds ) on the forms? Why
not even trigger a few mp3/wav/midi files when the forms open - wild animal sounds, drums et al! What a database!!
Full marks and extra gold stars from the lecturers shall be...
Cor! Such excitement .. almost pornographic :-) You are very welcome Kaz, glad I was able to help, ages since I've answered any Access Queries ( pun possibly intended.. )
Kind regards,
Chris
support@xeotech.co.uk
Please be kind enough to define a 'pretty' database, and a 'funky' macro!<g> This sounds like all databases should be ( too many dry VB people out there with no sense of humour MCP = Mirth Can Provoke )!!
So Lou, don't make it too 'funky' especially for an assignment...
Regards,
Chris...
Place something similar to the following in the Row Source Property of your Combo Box,
SELECT DISTINCTROW [Table1].[category] FROM [Table1] where [category]="chair";
Replace the final string in the above with the value in
the field you are looking at and the list in the Combo Box...
Did this task quite a while back.n Think codewas alittle spghetti -ish. Want me to find it for you? The onl;y snag was that the laser printer duplicated the text printed on the check itself due to security features!!
By all means email me at support@xeotech.co.uk
Cheers!
Chris Pugh...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.