Rose:<br><br>Personally, I think your best bet would be to write a server side script that returns a static recordset. 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...
apologies, I should have been more specific. 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 "workaround". We would like to know...
An application created with the Office97 ODE (an Access application) doesn't install properly in Windows 2000. 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. Anyone know what...
Hey folks. I'm a student who has taken a few C programming courses, and would like to program more in C. My problem has always been thinking of something to program. 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. Possibly something changed with the ODE tools, anyone have any ideas? 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...
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 "learning" 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...
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...
I need to be able to requery a subform when the master form changes from record to record. Do I just put a <br>
Forms![subform].requery in the BeforeUpdate or AfterUpdate event of the Master form? TIA...
We're running through an Access front end against a large Oracle database. Lately, there's been a slowdown in the Access application when we create new records or delete old records. However, if we run the operations (create or delete) directly through the Oracle database, it takes much less...
I believe I've incorrectly placed a function in the wrong event. The database starts up with a startup screen on a timer, but I may have left the OnTimer event blank, so now Access locks up. Is there any way I can modify the code behind a form without opening the database? TIA...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.