Search results

I have a main form with two sub forms. Main Form - Single Form Subform 1 - Datasheet Subform 2 - Datasheet I have the Main Form parent to Subform 1 child. Subform 2 is also on the Main Form. Can I, and how, make subform 2 a child of subform 1? I appreciate your help, Thanks, Ken

Normalizing this beyond what it is would be very difficult. The PKs are Employee_ID, Job_ID and Emp_Task_ID already. The week days contain the data. I could seperate the Week Days into a seperate table but... Everything currently accesses the table the way it is. Also to complete the entries...

I'm trying to figure out the query or queries.

I have a table with the following fields: Employee_ID; Job_ID; Emp_Task_ID; Weekday_1; Weekday_2; Weekday_3; Weekday_4; Weekday_5; Weekday_6; Weekday_7 Each row basically records which Employee on which job preformed what task on which days (via hours). But!!! Let's say that I would like to...

Thanks, This will take a little testing. From memory, I thought I had a problem calling a second instance. But... I will certainly try.

I thought you could not run more than one instance of and Access db at a time. However, just a few minutes ago I opened two different dbs multiple times. The only difference with these two dbs are that they are Access 2000, and yes I still have a couple of them lying around, upgrading isn't a...

Thank you, It took a bit of trail and error, but I finally got it. There were actually two problems. Explicitly calling an object - which was my first post. Never ending loop - When I made a change to a cell it called the Change Event that made a change to a cell which called the Change...

Sorry to bump this, I know this is an Access group. But can anyone help with Excel VBA or direct me. It works fine except in office 2007.......

I just posted this in the Excel forum, But if any VB person can help I would really, really appreciate it. Thank you, http://www.access-programmers.co.uk/forums/showthread.php?p=899951#post899951

I am using an Excel app that is being used in Office 2005 and 2007. It works fine in Office 05 but 09 it crashed with I found this http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319832 which I thought would solve my problem but... I guess I don't understand the problem enough. Can...

I do not mean to ask a foolish question. However are there any clear reasons to use VB over Access? I am using MSSQL Server as our backend and tend to have A LOT of views, tables and sometimes even stored procedures. However I also tend to have local tables and queries for speed. I...

Is there a way to control Conditional Formating in code? I have a Form (DataSheet), when a check box is unchecked two other fields have a yellow background. Works fine. However I would like to delete, turn off, not use Conditional Formating sometimes. I have gotten disable to work but it...

okay and thank you,

Can I email it directly to you rather than make it public?

All of the tables are comming from MSSQL

it's all remote data.... Will that work?

Sigh... not yet. Run-Time (or is it a Fun-Time) Error

Hmmm, closer I think but??? From mainform: I don't think it is really working. It tabs from the last text box to this one (txt_Move_Focus_1). Then I tab again and it moves from here (txt_Move_Focus_1) to the subform. This is on the control in the main form. Private Sub...

Totally wrong??? I have a couple of combo boxes on the main form that you can tab to. Then I have multiple subforms. So.... it would be nice to move from subform_a:control_a to mainform:control_xxx. But... I what I need is: Move from mainform:control_c to subform_a:control_a Move from...

I'm still doing something wrong. I started with the subform (code below). All it does is move between the three text boxes within the subform. Me.Parent.sfrm_PE_Worksheet_CO_TM.Form.txt_Budget_CO_Projected.SetFocus It looked simple but I'm still stuck???