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...

Mostly because the main procedure needs to pause, while one sub procedure that applies user updates can be run any number of times, depending on how many changes the user makes, and once the edits are done, return to the main procedure were it left off...and I'm not using any dialog forms for...

This whole import process is controlled by a form, which I have designed as a sort of "wizard," using a tab control which changes tabs at each step in the process. So tab 1 is step 1, which has a textbox and a "browse" button for the user to select the file. The user clicks "Next," and the...

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 always check out different web applications and see how they are laid out. Recently I was looking at the "fogbugz" application because I like the color scheme and layout of controls. I try to minic web applications because they are usually clean and simple, and it's what people are becoming...

These are really almost the only kind of databases I work with. Over the last 3 years, with a great amount of help from this forum actually (couldn't have done it without the posters here) I've designed a survey database application I give to researchers for them to enter data for their...

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...

Maybe call the Form_Timer event on a mousemove over the display bar object so it reinitializes.... I haven't messed around with Form.TimerInterval, but maybe there is a way to determine IF Form.TimerInterval = 30000 THEN call Form_Timer

Compile error: Variable not defined

Yes thank you - but that's my whole problem. Enforcing referential integrity in this case is not allowed for some reason. Edit: Just looked at your example. In this case, I would want to relate both field1 and field2 to field21.

Most likely an autonumber key field

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)...

Here is the re-design. The append query inserts the data fields from "VisitAreaData", depending on the "AreaID" selected. So if Inpatient is selected, all the VisitData for the Inpatient visit is inserted into the VisitDetails table (parent table is the Visit table, which contains the...

Right, but now when I link each visit area table to the billing table, the information gets duplicated, because the PK of each seperate visit area table can repeat as the FK in the billing table..... I've been messing around, and have tried putting all the visit area data into ONE table, as...

Thanks for the response - the gender fields is the gender of the baby. The tobacco/drug fields, along with all the other fields, have been pre-determined by the docs to be the fields they want to collect, along with the responses they want, so I have to incorporate them as-is. Billing...

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...

bumping thread

I know this. The saving is what is causing the problem. When the focus leaves the main form to the subform, thats when the record changes on me. I have to navigate back to the record I was entering to start entry into the subforms Negative. I took my .requeries out of the main form, I also...