Search results

I did not see a "Security" forum or the like, so I am selecting this one... I apologize in advance for posting this. I have read many, many articles related to this issue but most of them appear to remain unresolved, so I'm trying to supply the details... I was called in to make some forms...

Help! What seems like a simple problem is driving me crazy. I have a form (one of 2 that are nearly identical) that appears to be opened “filtered”. When the form opens, none of the controls react to clicks, it does not allow edits. It has a feel as if a master lock is on the form...

I have developed a desktop (single user) Access application. I am looking for a method to compact and repair a back end db in the easiest manner possible. I am using Access XP with a front end of approx 80 MB and a back end in the 7MB- 12 MB range. I am compacting the front end by using...

I would like to find a way to limit records into a table by using VBA code. I have a couple of tables that contain data specific to the user (licensed). It is my understanding that these are much safer if entered in code vs. sitting out in a table where clever users may track them down. For...

I would like to find a way to limit records in a table by using VBA code. I have a couple of tables that contain data specific to the user (licensed). It is my understanding that these are much safer if entered in code vs. sitting out in a table where clever users may track them down. For...

I am preparing a database application that will be used by one person in an organization. Frequently , (every year or two) the program will be given to another (usually a laptop) user in the organization as that person assumes the task of the program’s operation and responsibilities. I would...

Much is written about the msoFileDialog problems in Access. I am confused with what I am reading. I am using Access XP (2000) Developer version and have used the msoFileDialogSaveAs without any problem. HOWEVER, I have not created a runtime version yet. A couple of articles seem to state...

calendar/referential integrity Sorry I have not responded sooner, Neileg. Thanks for your interest. I have spent the last week and a half re-doing my tables. I have added a/n primary keys, re-did some foreign keys, and generally buffed up the "backbone" structure of my application. This has...

Calendar/Referential Integrity I am attaching a sample DB to view in hopes of conquering the problem first posed in this thread. Again, my intent is to post all items to my calendar (from tbl Events). The calendar does not allow room for much, so only a short description of the event and...

Events; referential integrity Neil: I'm trying to understand the psuedo-solution you proposed to me as shown below. I am doing fine with tblEvent, tblEventType, tblEventDetail. I am a little confused however with tblDetailType and tblEventDetailJunction. I recognize that this is meant to...

Thanks fr your well thought out answer. It happens yesterday I had a day of outdoor projects that gave me a chace to think about your previous reply. I now have to agree with you and will concentrate on that solution today. With your last reply (attached) it gives me a little more to think...

not normalized Neileg: The different event tables were constructed because, aside from dates and times, the events all have different characteristics (fields). The fields of the tables Programs, Meetings, Social et al are significantly different, reflecting the different characteristics of...

I am struggling with a solution to this problem involving maintaining a calendar or central list of Events. I have 5-6 "Event" tables ( e.g., Social, Meetings, Programs, etc.) each of which I would like to take the date and time from, along with a brief description, and add those fields to a...