Search results

Hello - this is really just an informative post. Not sure if anyone else has run into this either: My main form's load event initializes an object. (Dim myObj as obj, Set myObj = New obj) This works fine if I manually open the form. However, I have an Autoexec macro which calls a...

Is there a way to create custom methods for a treeview control? Possibly in a class module? For example, I'd like to create a CustomTreeView.Populate method. I know I could just create functions in a standard module that does the same thing, but curious as to whether extending the existing...

Hello - I am developing a component of my application which performs about a dozen tasks, each task having its own procedure. It roughly flows like this: 1.user chooses excel file to import 2.data from file is imported into a temp table & recordset created for data validation 3.field values...

I am working on my survey application. I have a tblQuestions which contains survey question data. One field, QuestionOrder, determines the sort/display order of the questions in my datasheet form. example: 1 This is a question 2 This is another question 3 Yet another question 4 You get the...

Hello - slightly basic question but have been unable to find what I'm looking for thru search. This is more of a 'theoretical' question Table1: Field1 Field2 Both fields comprise the compound PK Table2: Field1 (fk to [Table1] - I want this to be a concantenation of F1 and F2 from table 1)...

Hello I am currently designing a patient/practice management database, this will be to retrospectively track the demographics and patient information for those who visit a particular department. There are several divisions (roughly 3) in this department that the patient can visit. Each...

Hello, apologies if this has been asked before, I have tried several searches. My question: Is there any way for my VBA code to update when I change a control name. Currently, If I have written a click event handler for, say, Text43, and then change the control name to txtEntry, I need to...

I have a form with 3 subforms. They are all correctly linked. Main form is MainID (PK auto) field1 field2 etc Subform 1: subform1ID (PK auto) MainID (FK to mainFormPK 1 to n) field1 field2 etc Subform2 subform2ID (PK auto) MainID (FK to mainFormPK 1 to n) field1 field2 etc Basic...

Hello. I use a survey database design based largely from Duane Hookum's "At Your Survey" This allows for multiple surveys, each with their own set of questions, and each response to a question is stored in a surveyResponse table. For those of you that are familiar with this design and other...

Hello. I made this database, based on Duane Hookum's "At Your Survey" design. It was made for medical survey-questionnaire responses. It is attached with some sample data so you can see what I am talking about more easily One of the tables, "questionTable", lists all of the questions...

Before I begin: yes, I have searched the forums :D I was looking for some help on VBA syntax. I have a continuous form with a text box. I am trying to limit the entry validation of the textbox to a set of numbers (most likely 0,1,2,3,4,5,95, and 99) BUT ALSO allow text strings of any...

Hello again, quick normalization/relationship themed question: picture of relationships is attached I have a main table which lists study name/number, and several other tables which list study information (recruit method, recruit criteria, etc) The study number is unique, there can be many...

Hi, I've searched quite a bit on these forums already to no avail, so I decided to post the question: I have two cascading combo boxes. They work fine. I added a NotInList function for the second combo box. Private Sub cboMethodName_NotInList(NewData As String, Response As Integer) Dim...

Hello! Attached are two JPG files showing screenshots of my tables, and their relationships. I just wanted to see how my normalization looked to you guys and if im on the right track! This is for a survey type database with multiple separate surveys.

Hello there, I have a question, which I know is most likely very basic, but for some reason I keep drawing a blank on what to do. I figured I would post what I have so far, and see if anyone had some feedback. This database is based on an outline on paper. SO for example: 1. Category...

Hello I have a database set up that is used for data entry. There are about 30 or so tables, and a seperate form for each table. Each form's recordsource corresponds to its unique table. Some of these tables/forms are the same in design, but the data being entered into each is different...

Hello all, glad to be here I wanted to bounce this idea off the members in the forum, its more along the lines of managing multiple databases rather than individual design. I am a recent incumbent at a position where there are many individual access database files for the department. (Each DB...