Search results for query: *

You wonderful guys thanks a lot, really grateful. Managed to crack this a year after putting in the original post.

Actually it hasn't worked. Theres a syntax error, presumably where the first ( is...

Thanks PHV, YOU'RE A STAR.

Hello chaps, is it possible to use the CREATE SEQUENCE facility in access SQL for creating reference numbers of fixed length? e.g. CREATE SEQUENCE CUST_ID INCREMENT BY 1 START WITH 1000234 MAX VALUE 2000000 NO CYCLE;

Guys please i still need help with this. I just need the 'recipient' form to capture the 'Sender ID' from the 'Sender' form ONLY when you wish to create a new record in the recipient form. FOR FURTHER CLARIFICATION: an earlier sample of the database is located at...

Yep tht's right, will try again and let you know.

SORRY BYTEMYZER, Here's what i should have said at the begining: It's when i try to create a "NEW" recipient by clicking the empty spot at the bottom of the 'recipient' subform on the 'senders' form. When the recipient form opens up,I have to specify the Sender ID first before i do anything. It...

Doesn't work, keeps saying: Run-time '2465' Microsft Access can't find field "recipient" referred to in my expression.

Hi guys i have 2 forms one called sender and the other called recipient, the related field for these two Forms is called "Sender ID". When i fill in a senders details and then go to the recipient form. The recipients fom is accessed by a On Dbl_Click event on the recipient subform which is...

BRILLIANT, WORKS PERFECTLY!!

I have a table called centres which has 4 columns 2 of which are called 'State' and 'Collection Centre'. I have now created a form from this table, the state and Collection Centre boxes are "combo boxes" and would like when a state is selected, the Collection Centre combo box will automatically...

...Search button. At the beginning i started by creating a query that produces all the fileds listed above in the first post. I used the Like "*" query. The biggest problem with this is that i would like to have blank fields to type in my search criteria instead of the populated fields...

Sorry i dodn't see your post on time fredk. PaulBricker's faq will help you.

FOUND IT, Gif89.dll THANKS ANYWAY.

FOUND IT, Gif89.dll THANKS ANYWAY.

Can this be done and have it work as an animated gif and not a still image?. What control do i use?

Can this be done and have it work as an animated gif and not as a still image. What Control do i have to use?

Is there a code for changing the colour of a row in a datasheet when the mouse is rolled over it, or On Click?

Thanks

Anyone know a formula for adding the sum of values in a column? Just as you would do with Excel i.e =SUM(A1:A40)