Search results

ah It works now Perhaps I hadn't saved the changes to the table when I changed format Thanks for spending time on this prob!!! :D

aye This is the problem - the Date_Created field (I changed the name) is set to short date datatype, and its default is =Date() , but I see all that does is hide the time (if I click on the cell, I see the full date and time - as =Now() would produce) so no wonder I can't match it to a date...

bizarre It doens't seem to work (I also changed fieldname DAte to Date_Created) I can see that Date gives me 04/02/2004 (same value as I have in the db) and the Date_Created field in the table is set to short date, deafult value --> =Date() Ive even tried the code behind a new button (in...

I have a form displaying some jobs and dates. I want to code a button that filters all records to show me today's jobs only, but I'm having some trouble ' Apply filter to show only today's jobs DoCmd.ApplyFilter , "Date = '" & Now() That doesn't work because Now() also contains the time...

sorry everybody - off the record again It would have to be a quote from the cheese shop PS Can you use 2-tone colours in access?

ah Rincewind, the cheater of Death... Maybe Death might have been more appropriate? :p I like that idea (the fun element) Cheers for that

oops spoke to soon: DoCmd.ShowAllRecords Ta anyhow!

Hi people, I'm after the opposite of this: DoCMD.ApplyFilter Any help is welcome :)

ah, worry not... I know what you mean - those fluorescent yellow and green forms with electric blue buttons.. I've seen those too :) I'll stick to Acces's default colour schema, apart from the logo I'll use for the db I find this resource (link below) invaluabe anything colour-related...

cheers Thanks people - that's the bit of inspiration I was after Appreciated :)

making access beautiful This is really more of a desing issue... and some may find it downright bizarre... MS Access is a clever tool, but making a db look sleek would be a great bonus to finish off some hard work. Anybody here have some tips to share on this issue (or maybe a link with some...

Already seen this Actually, it turns out the in-built con formating tool does what I need cheers anyway! :)

Hi people, There's a few good examples here about continuous forms with con formating, but they all alternate between 2 colours. I have a continuous form, showing some fields - one of which is a status field. There are 3 statuses and so I want to colour each status differently. I succeeded...

cool thank you guys :)

I have a form based on a table. In it I have a combobox pointing to an employees table with just 2 fields (ID and Emp_Name). Does the combo box have a property to allow me to type in a new name and create the entry at the employees table? cheers

cheers that's good enough for me! cheers for that PS i'll be back when i break it

If I had a table called "Newspapers" with the following data: PK Newspaper_title Publication Country I would assign Newspaper_title as the Primary Key, since it is unique. However, looking at some northwind examples, I noticed that the table would look more like this: PK...