Search results for query: *

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;

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

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

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?

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)

Hi guys, i have a search form in the form of a tree control, one of the search criteria on this tree control is called "Search by Publisher Name". I would like the results of this Parameter query search displayed in datasheet view on a form called "Assets" instead of a Single...

Hi guys, i have a search form in the form of a tree control, one of the search criteria on this tree control is called "Search by Publisher Name". I would like the results of this Parameter query search displayed in datasheet view on a form called "Assets" instead of a Single...

Is this possible? i have a form called Orders by customer which also has a subform attached to it. I want to be able to create a new query which would search for a customer and the result of that query would open up this existing form. Possible...?

I would like to know if anyone could tell me of a validation Rule that only allows 8 character reference number in a field. I have tried things like '00000000' and '????????'. Gracias

I have a Customer form with fields like CustomerName, Customer ID, CompanyName, CompanyAddress, Postcode. I would like to create a form from the following but i would like the fields to be blank as default but when i type in either the CompanyName or CustomerName in the appropriate fields i...

Hi, I wish to create a search form with the following fields Company Name Customer Name Order ID CHPartner I would ideally like the user to be able to enter criteria in one, some or all of the fields and then press a button and either view the results in a sub-form or in another form. Is this...

Hello guys is there a way to create a form for the password window of your database?

HELLO GUYS, IN RESPONSE TO: I would like to know how to link items on a list box to say a query, form or a report. I have a list box with items like: Search - By Customer, By Company Name by Product. I would specifically like to know how to link these items on the list box to the related forms...

I have a library Dbase With a table called Sign Out used to track borrowed books. Sign Out table has fields like Book_ID, Member_ID, Date_Out,etc. I want a field in the query called "Due Date" which will be the Date Out+7 and i want the sum total displayed in a Date format. At the...

Is there a way of inserting an .swf Macromedia Flash movie into Access? I have tried to do so and it gives me a blank static movie window.

HELLO GUYS, IN RESPONSE TO: I would like to know how to link items on a list box to say a query, form or a report. I have a list box with items like: Search - By Customer, By Company Name by Product. I would specifically like to know how to link these items on the list box to the related forms...

Hello does anyone know of a parameter query which can look for a match to any or all of the characters typed in. at the moment i use the query Like [First few letters of Title] & "*" This seems to oonly be useful for looking up names etc. Any ideas? I WAS GIVEN THE FOLLOWING: DEK25...

Hello does anyone know of a parameter query which can look for a match to any or all of the characters typed in. at the moment i use the query Like [First few letters of Title] & "*" This seems to oonly be useful for looking up names etc. Any ideas?