Recent content by nexus

Rose:<br><br>Personally, I think your best bet would be to write a server side script that returns a static recordset.&nbsp;&nbsp;it's harder to work with (checking all changes/additions/deletions when the user submits changes) but it solves the compatibility issue.<br><br>p.s. I've only done...

I'm trying to create a collection in one sub, and pass the results into another sub.&nbsp;&nbsp;Is this possible?&nbsp;&nbsp;TIA.

apologies, I should have been more specific.&nbsp;&nbsp;The problem in particular is with an application we are developing, and the program works fine when the user manually creates the shortcut, but we don't want to have to document this &quot;workaround&quot;.&nbsp;&nbsp;We would like to know...

An application created with the Office97 ODE (an Access application) doesn't install properly in Windows 2000.&nbsp;&nbsp;The installation runs fine in both Win95 and Win98, but when you install on a Win2000 machine, the install can't create the application shortcut.&nbsp;&nbsp;Anyone know what...

Hey folks.&nbsp;&nbsp;I'm a student who has taken a few C programming courses, and would like to program more in C.&nbsp;&nbsp;My problem has always been thinking of something to program.&nbsp;&nbsp;I would like to slowly work my way up in difficulty, but I have no idea what kinds of projects...

Running an installation program that refuses to create a shortcut for the application.&nbsp;&nbsp;Possibly something changed with the ODE tools, anyone have any ideas?&nbsp;&nbsp;TIA.

need some help with a master/subform issue.<br> <br> I need to generate an SQL query to populate a combo box in the subform based on a field on the master form. I'm not sure if I should be doing this in an event, or a function. My other problem is limiting the number of records possible based...

I was wondering if there was some easy way to lock all fields on a form based on the value of one field. Thanks!

don't ask me why we need to check naming conventions. anyhow, seems they don't care about runtime, so I'll just write crude but functional code! I'll be working for Microsoft in no time... hehehe. Thanks for your help!

Hi! I need to make a function to check that users are following a specific naming convention. I'm thinking about making an array with all the acceptable characters, or an array with all the unacceptable characters. However, each time I need to check a string, I'll have to compare every...

I too have been searching for a good book to learn Access programming. However, I have found that many books that talk about &quot;learning&quot; Access simply refer to using the database, not programming VBA. I can't say I've seen any of the books you've listed, so I can't advise you there...

Coding standards are tough to put in stone. Everyone has their own stye. Here at my job, they don't have anything on paper, just general rules of thumb. For example, the general format of a function, subroutine, or event handler is usually:<br> <br> Private Function Foo(blah)<br> On Error...

I got it! used the GotFocus Event of the field and said if the value isn't null, lock it, else unlock it. THANKS GUYS!

Thanks for the help. If I try locking it in code, it locks ALL the fields on the form, and I can't enter new records. I'm pretty sure the subform idea would work, but I won't be able to implement it until I get some sort of approval.<br> <br> I like the locking idea, but is there any way to...

I'm not sure if there's some function in VBA that let's you specifically prevent updates on certain fields, or if I have to put some code behind the field. Once the user inserts a value in the field, he shouldn't be able to change that value. However, deleting and re-entering the record is...