Search results

Hi In my table I frequently need to add a date in a date field for multiple specific records. It will always be the same date (usually current day) for all the selected records. As there can be 200+ needing to be updated I don't want to have to visit each record manually. How would I go about...

No, I didn't. But I've just deleted the original one and replaced it in exactly the same way, using the wizard and it works. Strange. Thanks for your help arnel and DBGuy

Hi. I created it using the wizard.

Can a functioning command button be added to a navigation form? I'm asking because I've added an exit application button underneath the left hand vertical tabs to quit the application, rather than having one on each subform. However, when I "click" the button nothing happens, it doesn't appear...

Perfect! Thank you very much for your help arnel.

I've attached a copy of my database in case it can aid in spotting why I'm getting the error.

I'm still getting the same error for some reason. Sorry to be a pain :o

Thanks for your advice on removing .value etc. I copied and pasted direct without any changes, and no apostrophe entered in the field either.

tblUsers 1ngEmpID – Autonumber strEmpName – Text strEmpPassword – Text Login form TxtUsername TxtPassword NewPwdTxt

Still the same error.

Thanks arnel. That throws up the following error though: Run-time error 3075 – Syntax error (missing operator) in query expression ‘1ngEmpID=’1’ And strPassword=’password”

I've tried adding extra code to achieve the result I'm after. This extra code is in red below but it's throwing up a runtime 3061 error "Too few parameters, Expected 1". Firstly, should the extra code give me the result I'm looking for and, if so, what have I done wrong to get the runtime...

New users to my db are assigned a default password ("password") but I want them to change this at first login and update the record password field in the table. I'm assuming I would need to use a recordset? However I've never worked with recordsets so I'm unsure where to start so I'd be...

This worked. Thanks.

Hi Can anyone tell me why I may be getting a runtime error when executing this code (the code in red is what's causing the error apparently): Private Sub Pwdtxt0_BeforeUpdate(Cancel As Integer) If Len(Pwdtxt0) < 8 Then MsgBox "Please check your password and try again. Passwords must be...

Okay, I thought that might be the case. I've had to ask my IT Dept to restore the last backups before I corrupted it so hopefully I can get them back. Thanks both for your help.

Hi I have a database that had seven tables which I split. However, I added another table then selected to split the database again to move the new table to the back end but all tables have gone missing from the there except for the new one. The original seven do still show in the nav pane of...

Hi I've tried to incorporate you forms and tables into one of my db's (great work btw) but, when I open the login form and select my name from the combo I get the following error. Error13 in cboUser_AfterUpdate procedure: type mismatch I haven't changed any formats in either frmLogin or...

Sorry :o it is a type mismatch error. The code you gave returns 10.

I've made a couple of changes to the db and it has, as I'd expected, thrown up a couple of issues. Missinglinq's reply worked but now I'm getting an error with a tempvars. What is wrong with this bit of code? I'm assuming my syntax for referencing a numerical value isn't correct? If...