Recent content by eloise

Hi there I have an Access XP front end and SQL Server 2000 back end application. In my store proecdures I have written error messages, to handle some of the inputs the users try and save to the database. The errors appear if incorect data was entered by a user, however this disruptes the way...

I need to disable the user being about to double on a record if they have no user access. Can anyone help

Thanks for getting back to me regarding the problem disabling the shift key from the user. I have tried out all suggestions but nothing seems to work. This includes looking at the FAQ's. The problem is i have to program this functionality using the AccessObjectProperties and I am not sure how...

Thanks for getting back to me regarding the problem disabling the shift key from the user. I have tried out all suggestions but nothing seems to work. This includes looking at the FAQ's. The problem is i have to program this functionality using the AccessObjectProperties and I am not sure how...

I am having a serious problem with trying to disable the shift key in Access Project. I tried using the help index and it stated that I had to program it using AccessObjectProperties but I not really sure how to do this. Please Help Me.... Thanks in Advance

Hi I have an access front end(xp) and SQL Server 2000 backend. I want to hide the store procedures (displayed as queries in access) from my users. Could anyone help. Also how do I prevent the user from using special keys (shift , enter) to see behind the application. I have changed the...

Hi I'm trying to delete a record from a table in SQL Server using a store procedure. The table name, column and record id are parameters being passed in. I don't want to hard code the table name, column or record, as this store procedure will be used for many tables , columns and records that...

Hi there Does anyone know how to create a text box in Access VBA. I want to create a text box for each recordset returned. Thank you in advance.

Hi There I'm new to Access forms and vba. I was wondering if you can create a text box in VBA? I want a text box for each recordset returned, but unsure if this can be done and if so how. Thank you in advance

Can you count the amount of columns in a table in SQL Server? If so, please tell me the syntax. Thank you in advance

Hi there I have a multi-column list box, it contains 9 columns, however out of those nine only the first six columns (data) are being displayed. The data is correct and available for all nine columns. Can anyone help? Thank you in advance

Hi I'm new to access and sql server and my question is this: I have a form that acts as a login dialog box. When the user enters the correct details a user id is returned from the database. This helps me identify the users access to other forms in the application. I want to store the...

Is it possible to attach a value from a text box to a public constant variable set in a module? This value is to be used throughout the project. If so please help.

I have tried this but i receive an error saying "Constants, fixed-length strings, arrays, user-defined types and Declare statements not allowed as Public members of object modules" Is there anything that I have to set or do first of all. Thanks in advance

Help How do i declare a global variable that will be used throughout my application. I need this variable to store my user id, which will determine what the user can do on various screens. Thank you in advance Eloise