Recent content by DaveMere

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...

Thanks Allan, your approach worked fine. I always seem to have problems calling queries from code . . . perhaps this will see the end of them.:cool: Cheers!

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...

Of course . . . I had the tables linked to the network maps rather than the absolute path. Many thanks Sergeant! :D

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...

I see. Thanks SJ. That will come in most useful for scanning the drives myself in code, and I can see how I could present a list of available drives on a form in say, a list box. However I can't seem to view any of the directory structure beneath drive letters using this method. What would also...

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...

Cheers Miles. Works a treat.

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...

Excellent.

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

That's an interesting solution. Problem though - the characters Chr(10) and Chr(13) appear as ĕĕ rather than space and carriage return. I assume I'm missing something? Dave