Search results

i have wo sets of data. C code: 1111 and store code :1121 i wish to join these together automatically in another field so as to give Place : 1111-1121 how would i do this cheers

I have found a site that helps with this. http://support.microsoft.com/default.aspx?scid=KB;EN-US;q88657&

thanks

how do i add the british flag like yours.

i still get the message as stated in the first thread. if i enter now() it will work. but i do not want the time

in another database there are alredy dates entered . i want the default date to be whtever the currebnt date is but when i put Date() in the default value box it givews me the error shown below Unkown function "Date" in default value on file people

Thanks mate that brilliant it works

I have done that but when i go to a query. The prompt i have set asks the user to enter the month/year it does not display any results for that month. this is because it wants the day also. still need help.

i would to set the default value of a field of type date/time to display just the current month and year automatically. How would i go about doing that.

sorry mate use dd/mm/yy in the format

Instead of using 99/00/00 use dd/mm/yy as the mask

I have lots of data to enter in the database and i do not want to keep on entering the date in the date field. Is there an automatic way of doing it in access

cheers mate i resolved it by holding down the shift key when opening the database

my colleague before me who created the database ha somehow locked it so thet i can only gain access to interface screen. How would go about getting access to the main screen where i can update the database. The dbase creates a script file *.xvs but as win 2000 has been installed the script...

I have a query that matches one code to anoteher. There are normally 2000 records. i only get 1500 displayed. how do find the ones that are not being displayed Thanks

Cheers mate problem solved

To your question do the end letters mean anything. Yes they do they are multiple instances of the value. The problem is i have a set of values atleast 2000 with these instances and the only thing the links trhge two tables is the primary key values. All i want to do is to get rid of the...

i have to sets of table with primary kaeys as follows 45366rf2 for table 1 and 45366rf2e for table 2. They are both linked by these keys. Problem. when i create a query to search for something in table 1 using the primary key of table 2 it does not work because of the extra letter at the end...