Search results

thanks - if your referingto automatic logout by selenau837 then yes thats what im looking for --of sorts -- i wanted more to close the database down say after 30 days and then offer a password that would unlock it -- but ill play about with what you directed me to and see if i can adapt that -...

i already have something of that sort using a combo box but since the actual date is also in the same type of combo box (they just select which month the form attrributes to) i wanted something different so as not to confuse the user and cause them to enter the wrong box

Has anyone created a situation where you would block a program after a certian number of records have been inputted. maybe by disabling the form which cannot be again used until a password is entered. yes youve guessed it -- i want to let the program run until the client is commited -- but then...

i have a subform that contains data for each month of the year i want to place a set of buttons under the form for each month so that when a particular button is pressed the data for that month is displayed -- rather like a combo box would could anyone supply me with the vb code to do this...

unfortunately the third video stops half way through i do have this program working already using a query and a duplicate form ie i click a button that opens an identical form but relating to a query that filters out all but the name in the combo box i just thought that there was a simpler...

the code you offered brings up the same syntax error my combo box has a row source of SELECT DISTINCT tblMain.Featuring FROM tblMain ORDER BY Featuring; and is bound to column 1 it is not set to any particular format

i realise this is an old question but ive read through so many answers but fail to make it work i have a form with a selection of textboxes, one in particular named 'Featuring' which contains peoples names i also have an unbound combo box called 'cmbFeaturing' containing a list of names my...

in answer to both questions -- i do create a new record in the subform --which automatically puts in a new account balance -- the rest is left empty awaiting next weeks input. ive tried the docmd in a variety of ways but it doesnt seem to like moving to the main form the subform contains...

i have a form that contains customer info -- address etc... and a continuous subform simillar to a bank statement. i fill in the record in the subform and it updates the balance for that customer then goes to the next line ready for the next input, creating a new line number. this works ok...

im grateful for your very informative and well structured reply your answers have been clear and precise and i think i know where to go from here thanks again

i have used excactly the same criteria that you mention and it works fine -- for the first event of that name -- but in the combo box the name comes up many times if it is the first of a group - 'bob jane dave' and 'bob sally' for instance --thats what im trying to get rid of - ive also...

my database contains a series of pictures and a record of who is in the picture. in group pics people are named together in one box eg. Tom Dave Jane. i want to be able to choose a name from a combo box and show all pics that contain a certain person however to d othis i would have to disect...

My apologies forget i asked -- it was actually a corrupt table that caused the error - copying works excactly the same as before

has anyone had a problem with copying tables from one database to another -- it used to be so easy by just dragging from one database to another but in 2007 this isnt possible -- it seems to want to delete records rather than copy over - am i missing a setting to allow this?

you were right combo boxes were bound to the wrong columns --i blame the wizard lol -thanks for replying

i have a combo box in a form listing various people featured in pictures. i expected that if i chose a person from the combo and created a query with the criteria [Forms]![form name]![combobox name] in the person field then i would get a list of all pictures relating to that person -- this...

it works thanks thats what i wanted - i guess it wasnt as difficult as i first thought

i have a table that contains a selection of meats -- beef turkey etc and also their weight. i want to end up with a report that gives an order list containing the count of each meat at each different weight ie 12 turkeys @ 20kilo 15 turkeys @ 25kilo . i have considered using a combo box that...

can you elaborate on the replace method please

i have an Address textbox that has key behaviour as - new line in field. this allows me to put the complete address in one box, post code is another textbox. this is fine if i want to create window envelopes but - if i want the address to look as one long line in a report it wont work since the...