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...

I cannot seem to get this thing to work, have been trying for months with no success. I keep getting "Invalid Outside procedure" when you click on the 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...

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)