Search results

Thanks guys....appreciate the help. Dave

I have a form which contains a unique reference number. I want to create a button which when pressed will search a table (not bound to the form) for a record which contains this unique ref. number. I then need to check if another field within the selected record is blank or has data entered...

Thanks ghudson. The groups and permissions are set up. I was just hoping to speed up the process of adding each user one by one.

Does anyone know how I might populate an mdw file with users from an excel spreadsheet or something similar? I have a large number of users that will otherwise take me hours to setup. Thanks, Dave

I want to autofill field (a) with the contents of field (b) but only if field (a) has data in it. I can't get the script below to work though I know it's probably just bad syntax on my part...can anyone help. Private Sub FRM___Fault_notes_Enter() Dim fn As field fn = [Fault...

Thanks, I'll give it a go

I have a form which displays a pile of info. I want to have a 'Print' button which when pressed will print the info on the form using an underlying report template...WITHOUT displaying the report on screen first. I can do this using the cmd "DoCmd.OpenReport stDocName, acNormal" but this...

Don't know what I'd do without this site and the help I get from you guys...thanks, Dave

Calander validation rule Chewy, I'm trying to put a validation rule on the popup calander which you sent me a while back. This would prevent users selecting a date which is date()-356. I've trying applying the rule to the date destination field but the rule isn't enforced when you input the...

Thanks Chewy, you've saved me a restless night.

Thanks to both for your repies to this problem. Chewy, I'm wondering if you could have a look at the attached file to see where I'm wrong. I'm hitting my head off a brick wall here. Thanks again, Dave

I have two forms, one with a date field (form1) and the second with a calendar displayed (Form 2). I have created a button on form 1 which will open form 2 in pop-up mode. I would like a selected date, when clicked in form 2, to be inserted into the date field in form 1 and then for form 2 to...

I have two fields, one is a text field and the second is a date field which is formatted in the table as yymmdd. I want to merge the two fields to produce a unique field for another table. I can do this using [Text field]&[Date field] in a query but the resulting field is [Test dd/mm/yy]. Does...

Thanks Thanks guys. Don't know why I didn't think of that....I'm kicking myself as I type this (very difficult!!!)

Hi folks, I'm a bit of a novice when it comes to writing code so I'm hoping you can help me. I'm looking for some code which will cut records, that fall within a specified date range, from one table and apend to another. I'll be creating a modal form which willl allow the user to specify the...

Thanks Autoeng. Following the server reboot however, there was no ldb file associated to this db. There's also a help sheet on Technet which refers to this problem on Netware servers and suggests granting R, W, C & D rights to users to allow them to create the ldb file. Users already have these...

I have a centrally stored db which is accessed by numerous network users. Earlier today the server on which the db resides crashed. Following reboot, users have been unable to access the db and are given the following error msg; "Couldn't use <db name>;file already in use" I know that if I...

I have one network based system.mdw file which controls their rights. Regardless of the db being accessed all users authenticate to this file. This morning users are being told that this file is 'already in use'. I assume soneone has managed to gain exclusive rights over the file. Can anyone...

I'm trying to write a module within Access 97 which will prompt the user to confirm their existing password and enter a new password. The 'Change Logon Password' option under Users and Group Accounts' provides this facility though I'm trying to build a user friendly button within a form. Users...