Search results

Hi Paul Thank you for the quick response! Where would i place the Dlookup code? Is there a way of having an IF statement, like If Environ(Username) is in tblUser then Open Form msgbox "Welcome" & Environ else msgbox Environ "you do not have access! Contact admin to request approval" end if...

Hi There, Im trying to use the Environ Username function, which i have working! But i want to compare the result with a Username Table to determine if they have access etc... Any ideas? thanks Aron

The only problem is the companies use 5 different Sage accounts and some of the suppliers have been set up via a Sage auto generated number and some have been Manually written using text? e.g 0000000112233 or RDFEF. So i wanted to create a column so i could have a standardised format? thanks Aron

Hi There, i have created a Union sql Table View, that i have connected to in access. Its a list from 5 different companines of Supplier accounts. I need to create an autonumber for this table? Not sure if this may be more SQL based than access, but any pointers would be greatly appreciated...

Is there a way of loading SQL-Views instead of Tables? will this enable them to only be read only? If so how do you add a view into access? thanks

I've looked into this and we do have other permissions, i am just use to using mine that enables me to do everything! So if i add the Table using an account without Write permissions will that resolve my issue? thanks!

Thank you for the reply! Umm how do i go about that? is it done within Access? We use a generic login for SQL will that matter? thanks

Hi There, Im fairly new to access, so apologies if this has a very easy solution. Basically i want to view an SQL Supplier Table, I have added this table but its allowing me to edit it which i do not want. I only want to use its information, I've created a query on the table which is my view...