Search results

Hi i have a table which contains: Forename Surname Username I would like to take forename and surname and but the results into a third column called Username. so in the surname field it would be somthing like: Joe.Bloggs (as the username) how to i go about doing this? Thanks in advance

i have a database, which contains pictures. the pictures are shown in a preview box. but when they are double clicked an error occurs ... "OLE server isnt registered, please reinstal it" the database is stored on a newtwork drive. which has docked laptops and fixed PCs the pictures open fine on...

I have a form, which lists all reports i have available in my dateabase. But there is 1 report which i dont want visable to users, how do i restrict access to this 1 form, either by it not showing on the list or password protecting it. users have to double click the report name to open it from...

i have a form, which consists of a tab control, in each page of the tab is a different subform. there is also a drop down list which allows users to select the record they want to view, i could lock the records yes, but i also want the same form to be available as a writeable from. on my...

search and couldnt find anything to tell me how to do this. i have a tab control with contains 8 tabs. but i only want 1 to be password protected. i only need a password entry not a username+ password. so in other words when the "audit" tab is clicked i want a password popup, user enters...

i want to have a query that will find all records with an employees name. is it posible to have a query produce a drop down list of all names entered into the database, and then show all records found matching the chosen name? im guessin i will probably ned VB? can anybody help me ?

i have a read only form. which has a combo drop down box on it, this allows users to jump straight to the record they want to view. but in read only the combo is disabled as well, how can i enable only the combo box??

i want to add a date that is 30 months after the original date field 1 field 2 expiry date renewal date can somebody help me with code to take the date from field 1 and add 30 months to it and place the new date in field 2?? thanxs in advance

i have a code and so on for archiving old records which somebody provided me with. but the code (shown below) only provides users with the name of the record being deleted and no options to cancel the proceedure. i would also like to add a message such as are you sure you wish to archive 'XXX'...

ok this is the problem i have 1 main form, with two subforms displayed on it i want to move data from sub form a to sub form b. while at the same time clearing all data from each text box in sub form a, so up to date data can be added to sub form a any help appreciated thanxs

ive looked searched for existing theads but none are idiot proof :o id currently have an active table with dat in and another table where i place old records from the main table. but im not sure how to go about making the append querie etc.. can any1 provide me with easy guide to append...

i currently have a search feature that opens a pop-up text box where users enter the name of the port. but it searches for exact names is there any way it can search for likeness or part of a port name rather than only displaying results that match exactly? eg. port name is barrow-in-furness...

this is probably really simple... is it possible to only allow one record to be added on a subform.. or a form for that matter? currently i have a form which contains sub forms and i only want the subform to contain 1 record but i will have many records on the main form, if that makes sense...