Search results

can you explain a little please as i am fairly new to this tried before an even if there is or isnt any data goes straight to contact like a tab stop

sorry dont quite follow i am new to set focus

this is what a am tring to do: i have a report that show me various postcodes like this postcode field surcharge field ab43 1ul 6.00 ab1 1un 6.00 hu1 1un 0.00 nr11 1ez 0.00 ky11 1en 12.00 ky1 1up...

i have a form based on a query which finds results from a postcode so when i enter a postcode it will give reults for street, town and county what i want to do is goto field street if no results found and if results found goto to contact field so basically on exit of postcode field if street...

thanks worked a treat had to enter = before the count and put 8ft in brackets cheers this has baffeled me for ages

on my report i have say 10 records per sheet of mixed garden sets 6ft table 8ft table 10ft table how can i count these so say there are 4 8ft tables at bottom of report it show 8ft tables=4 thanks in advance simon

hi what is the on exit event code so that if there is no data in field then goto another field instead of tabbed field regards simon

i am trying to create a button / command to import an excel file which i have been emailed

thanks neil

my firend has the same database as me what i am trying to do is put a command button of some sort to send an email to my address can somebody help regards simon

i am trying to create a message box based on something like a query the query contains a postcode field so basically when i create a search button on click event message box asking user to input postcode to find then this will open the query form based on results entered by the user any...

Can someone help in simple steps please as i am fairly new to this: i have just upgraded pc and transfered files from disc to new pc, installed office 2007 etc.. but now my date() funtion isn't working and i i use it quite a lot in queries and forms i need to get this up and running again...

i have just upgraded pc and copied files from disc to new pc installed office etc... but now i am getting error message id automation error and a problem with my date() functions i have changed date() to now() which seems to have got rid of error but have lost date() function any help...

thanks works a treat

I am trying to figure out the following on a report: say i print a report out and on the report there is 10 records how do i show them as 5 down one side and 5 down the other i am at the minute getting 5 records down one side and the same 5 on the other side basically i am trying to save...

I want to spruce up my forms with a clock etc.. anybody know where i can find some cool controls thanks people simon

Hi all, I am trying to create a form with a password protected screen which has my companies logo on it: Basically i have created a form called password with two fields and a logo which starts up when database is run. From this i want it to do the following: Username=John Password=(...

i am trying to do the following we have 2 customers that use the same report so what i need to do is hide a field on a report something like this i think if customer is not like "customer1" then hide field "comments" if customer is like "customer2" then fields visable thanks in advance

thanks worked a treat

yes same directory