Search results

Hi all, I have built a database for my company but the only problem I am having at the moment is that I have built a login form that records the user ID's of users that are currently in the database that I can view from a different database (Admin manager). Users are able to click a button...

Hello all, I am currently using the SetValue function from within a macro to set the value of one text box to the value of another. It works fine under full version but when I use it under Runtime which is where the final application will be run from, it brings up the Halt box and will not...

The part about the brackets [] worked a treat. Thats what it was..or a combination of that and the setwarnings thing. Thanks so much. Only another 60 ish forms to go now. I feel a few more posts coming on... Thanks again Gaz

Hi, I have created the following code to use on a login screen but when used under a runtime environment causes runtime error and is giving me a headache. CODE: Private Sub Command7_Click() On Error GoTo Err_Command7_Click Dim Value As Variant Dim stDocName As String Dim stLinkCriteria...

This is really helpful thank you so much! Gareth

Ok great Thanks!! So will I need to put error handling on ALL of my functions? (Oh dear god!) Thanks Gareth

Hi, Thanks for your reply. I am not sure what you mean?? The error says "Runtime error and does not give any specific detail. Once I click on OK it throws me out. Thanks Gareth

Hello all, I have recently finished developing a Complaints Database for my company and we carried out some testing on machines that use runtime only and guess what? Good old runtime errors! I aksed the IT department to give me a brand new blank login profile and when I used this, the database...

Col, Thanks for your response. I will have a look. Gaz

That really depends on what type of network you are using and what software is running the network. Novell networks allow access rights to files but you would need to allow full access in order for users to be able to use the database. You could look into this a little bit more though. You...

Hi, I have a postcode field on a form that allows 8 characters. e.g. ST10 8BY including the space in the middle. The only validation I have been able to use thus far is the above but I would like to know how to validate two letters (AA) then between 1 and 2 numbers (11) etc. Is there any...

Hi, Thanks for your responses. You are correct in assuming that I would need to know about the errors. Gaz

Hi, I have developed quite a large database for my company to register complaints on. At certain points, a user may encounter an error when a procedure goes wrong and I want to know if there is a way I can remove the option to debug when it pops up saying End or Debug. Some of the users are...

Great. Downloading as I type. Can you recommend any good online tutorials as I am begginer with using SQL as you prob gathered. And no doubt I have my work cut out for me right? Many thanks for link! Gaz

Ok great thanks! Also picked up your other post and appreciate your comments. At least I have some steer in using this forum now. Thanks Gaz

Hi, I am trying to learn how to use SQL. Can ayone please tell me where to download/view a comprehensive and easy to use tutorial? Thank you very much. Gareth

Hi! Thanks for your reply. Where would I source MS SQL and how would I set it up. Not in details but would I need to install it on web server etc.. Thanks Gaz

Brilliant! Thanks for your help!

Hi, I curently have a website that has a registration page on it that uses a simple access database that contains a single table with the same fields on as that of the reg. form. What I want to do, in one way or another, is to make some sort of macro that starts once some datails have been...

Great start! The site went a bit weird and it didnt look like my message posted when it actually did it three times. :eek: Sorry