Search results

hi folks, i have a question about developing a packaged dbase application. i want to be able to distribute an application that does not allow the end user any way to view the code and table relationships w/o having to set up user/workgroup security. is this possible, (MDE)? can anyone...

hi pat. thanks for the response. i was told to use that "Cancel = True" statement and i could figure out what it was doing. as soon as i posted that thread i realized that i forgot the Else part of the code, but thanks for the suggestion. it was helpful.

here's an easy one. i just created a little form where i hide some controls based on a selection made in a combo box. he's the code: Private Sub RequirementType_BeforeUpdate(Cancel As Integer) If (Me.RequirementType <> "Recordkeeping Requirement") Then Me.RecordkeepingSource.Visible = False...

that's not what i meant. i don't expect IT to maintain the application in question in any way at all. i was speaking in generalities.

thanks Fofa and Harra. you are completely correct Harra in your statement about corporate IT focusing on a centralized control strategy and i think they feel i'm invading their turf. the biggest problem i see with lumping everything into a "centralized" control strategy is you can lose...

thanks chris. one more bullet in my holster. could you elaborate a little more on SQL licensing fees and deployment. thanks

thanks again Fofa. you bring up some good points. i think your right about IT trying to switch all the DAO code to ADO instead of just including the proper reference library. i also think they are not familiar with ease at which Access 2000 converts to 2002. i think their frame of reference...

thanks for the response Pdx_man. i'll give it a try.

Hi Fofa, thanks for the response. i can understand you points about Access' pitfalls as a true client/server application. my thinking was that this is not intended to be an enterprise solution, and the simpler i can make this application the better. i would like to avoid having to go to the...

Thanks everyone.

Hey all, i need some artillery to throw back at some corporate IT folks who hate Access and was hoping to get some of the wonderful experts in this forum's opionions. i'm developing a small application in Access to basically turn a large document into a electronic version with some other...

Hi folks, I've run into a little snag with one of my forms and i was hoping someone could help me with this. here's the problem. i have a form with various data validation controls that erases the invalid value and changes the BackColor property of the controls when invalid data is entered...

yeah i was thinking along the same lines. importing the tables into the FE might also be another option. either way i have to make sure all my ControlSources for forms, queries, and reports are properly set. thanks for the response rgreene. it was helpful.

i recently came into the same situation described in this thread. i have a follow up question to this. is there any way to get both the FE and BE into a single application (unsplit)? so basically i'll only have one .MDB file? thanks for any suggestions everyone.

Hi all, I was wondering if someone would ever want to reference a record in one table to another record in the same table. i'm not using this information in a function like DLookUp. for example the information in record 001A might be related to the information in record 021A of the same...

thanks for the response bertus. i'm currently looking into the dual boot configuration, but i'm still a little hesitant to jump right in. i'm not very comfortable yet with partitioning my hard drive and the other tasks required to run such a system. i need to do some homework. although i...

i'm not sure if this is the right forum to post this question on but here goes. more and more i'm getting very interested in linux and i was wondering how ms office, particularly Access, works with Linux distributions. does anyone have any experience with this. i basically have no experience...

thanks for the response pat. i didn't know how, but somehow i expected that doing this was slower. as always yours and everyone elses responses clearly outlined the answer for me. thanks

thanks for the responses sean and dcx693. i couldn't quite figure out why someone would do this, but i guess as with most things in Access there are multiple ways of doing things and multiple ways to justify them. thanks again for your comments.

hello everyone, i've just inherited a database from someone. after tinkering around a little bit i've noticed that the original developer used SQL (typed) for their report's recordsource. basically, they typed the actual SQL code in the RecordSource property. usually i base all of my reports...