Search results

Hi Wayne/RG, Thanks again for your help. Unfortunately the problem still lies unresolved! Zero length values were definately allowed in the table. I have also taken the approach of declaring each item and setting it to - MyItem = Nz(MyControl, "") .Fields("MyField") = MyItem etc... Still...

Hi Rural Guy, Thanks for the tip with '.Value'. I'm still pretty new at this game so every little thing to help me tidy my code helps :) I tried using Nz - and still had the same problem. Not sure what else to do other than recode using DAO....it may be the only option - but I would not of...

Hi there, I have a form that uses ADO to create a new record in a table. I have used the form successfully throughout the development of my database (with Access 2003), but am now having trouble with earlier versions. I get the following error - -2147352571 "Type mismatch" when attempting...

Hi all, Just looking for a little advice on data protection. I have a split database which is accessed from the front end (forms only). All data is stored on the back end, which is hidden away from the user. The database is password protected, and both sides use a login authentication to avoid...

Hi all, Just looking for a bit of help with hyperlinking on a form. Basically, I am adding a 'read more' function to a quiz program I am writing. I have a label simply called 'Read More' that sits on the form. I need to set a hyperlink to this label, that is looked up from the DB as the...

Hi guys, Just wanted to thank you both again for your help. My apologies for the delay in getting back to you - I have been offline for some time. Scott - you were correct in stating that the parenthesis were missing from the statement. Just as a note on that - using the single parenthesis...

Hi again, Thanks for your help! I have tried to get the code working with no success. At first run I received a syntax error (with UPDATE statement). My vb script looks like this - If Me.defineteam <> DLookup("Team", "tblEmployees", "[lngEmpID] =" & Me!cboEmployee.Value) Then MsgBox...

Hi all, First of all....my first access database and I'm still a VB newbie...so my apologies if this is a stupid question. I tried searching the web and this forum but could'nt find what I was looking for. Basically, I am developing an authentication script for a training tutorial. The user...