Recent content by PARSO

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

pass. create a blank form, add buttons and link them to forms, queries or whatever you want it to open. then to have the menu show at database startup go into tools > startup and select the form to display at startup. you can use the built in switchboard manager but not recommended. use the...

try 'admin' as the username, with a blank password?

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

assuming that the admin will be the ones entering data, and users will just be reading it. check out this sample database, as it lets you restrict write access to different user groups...Try this...

read through this thread as it tells you how to restict write access etc... Try this

do you mean lock it from everybody including admin, or just the users?

if i read this right, thats why you should create your own, menu form, that will allow you to have as many 'sub-forms as you want, and will place them individually, so a button on a normal input form can go to a subform withiut the user seeing the main form.... if that makes sence?

i made some changes, see if any will help you? i tryed 2 simplyfy the relationships as well. but maybe you had it the way you did for a reason?

does this help??....take a look ....

made a few changes. maybe you should rethink the fields that you had listed in the querys, your relationships may also need changing. and i could only find the field named "IKGA England Number" on your form not in any tables???

for numbers only just set the data type to 'number' not sure about the text only,

sorted it. I simply added Not"Audits" to the query

the list box is being populated by the following Row Source: SELECT [MSysObjects].[Name] FROM MsysObjects WHERE (Left$([Name],1)<>"~") And ([MSysObjects].[Type])=-32764 ORDER BY [MSysObjects].[Name]; I got the code off a forum, prob this 1. but i dont really understand it i just know it...

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