Search results

Hi, I've got a parent/sub-form set up, both of which derive their data from linked tables connecting to a central database. As a result I've had to add coding to the NewRecord events to fetch the next primary keys from the database. Unfortunately I'm finding that one loading the new record...

Hi, I'm having problems calling a simple query from the VBA associated with one of my forms. The code goes thus: Private Sub Form_Current() Dim rs As Recordset Dim db As Database Dim qryMaxAlp As QueryDef If Me.NewRecord = True Then 'query database here and find out next alp_key Set...

I am getting the error RunTime '2105' You can't go to the specifed record. Just converted my test database to read from a sybase linked table rather than the development local table. It reads fine but the new record button now gives the above error. I presume I need to code myself a new record...

Hi, I'm buliding an access system in which the forms and tables stored in seperate databases as such: forms: \\server\dir\myDatabase.mdb tables: \\server\dir\data\myTables.mdb myDatabase has a load of linked tables from myTables. Problem; my network drives are mapped differently from the...

Hi, Does anyone know if Access has a built-in control that allows users to scan the directory structure of their PC? Similar to the DriveListBox and DirListBox controls in VB6? If so, how might I get access to it? Thanks Davemere

Hi guys. One of my users appears to have locked herself out of Access whlist attempting to implement security. She's unsure as to exactly what she did (ie whether it's workgroup or simple password security) but the resulting situation is as follows; Opening any Access database, prompts for a...

Hi, I'm setting up a function whereby an email is automatically sent once a certain function is complete. I'd like to set 'sender' details in this email. Is there a way in Access to retrieve a user's network login details, specifically their username? Cheers, DaveMere

Hi all. I have an access database with workgroup security enabled that has been converted from Access 97 to Access 2002. Since then, the security is behaving strangely - prompting for passwords when it shoudn't and, more seriously, nor prompting when it should. I've done nothing to the...

Evening all. One of my users has several Access databases, one of which has security enabled, and so requires her to join a particular workgroup. The others don't. Is there any way I can set up one desktop shortcut to join this workgroup AND open the relevant application? Cheers, Dave

Hello all I have a report set up to print out a sheet of address labels. It takes the various address fields into text boxes and then order them thus : Name Address1 Address2 Address3 Address4 I'm required to format the report to print out to a specific label sheet (3 x 6 on an A4 sheet)...

Hello all. I've converted a 97 database to 2002 and the following error has been generated. "Missing or broken VBE reference to the file WZMAIN80.MDE" This isn't my database unfortunately, and I don't really know what this means. Help? Dave

Hi all, Quick question - is it possible to set up a user account that has permission to add users / modify user rights but NOT to modify object design? Cheers, DaveMere

Hi all. When I try to look at the security settings for my DB, I receive the error message Record(s) cannot be read; no read permission on 'MSysAccounts' My view settings are set to display all hidden tables etc, but I can't see this object anywhere. Does anyone know what / where it is...

Hi all. We're currently undergoing a conversion to Office XP, and I've got to test the conversion of an Access 97 database to 2002. I'm experiencing constant problems with this. The problems basically revolve around the security settings for the database. Is anyone aware of some MS protocol for...

Hi all. I'm trying to upload an image for an avatar, but it's a .bmp file. How do I convert this to the required .gif or .jpeg? Cheers, Dave

I've got an Access 97 database which I'd like to convert to 2002 (new NT operating platform). The problem is that the database has workgroup security set up. As a result, I can't get into it from the 2002 version, nor does it give me the option to convert. However, I can't find a way to remove...

Hi all. One of the functions in Access 2002 is when, for whatever reason you are unable to delete a record from a table, an error message appears telling you why (for instance ref. integrity). I've accidently suppressed this message function. Anyone know how to get it back on? DaveMere

Is there a command which I can attach to a command button such that the button opens Internet Explorer at a partiular url address? Thanks. DaveMere

Hi all. I've written some code in the form_current procedure that is designed to query the user when they try to create a new record, then proceed accordingly. Basically; If msgbox ("Confirm") = vbYes then (Run query to fetch next primary key and create new record) (This bit...

Hi all, I'm trying to adapt a text box in a subform to reference a value on it's parent form. The subform is present on the 2nd tab of a tab control. The value in the parent form is called "JobNo". I've tried inputting the term "=[Parent].[JobNo]" into the subform textbox data source, and this...