Recent content by cominapart

Thanks Autoeng.

Hi all. After having read quite a few posts I have noticed an overriding theme of having forms based on queries instead of using tables as the source for the form. Is using queries the best method for the record source for a form? Thanks for any input.

Foster, I did not download your database. Just from reading your post you should be able to create a query based on the table containing the items and their values. Then base the report on the query. hth

latex88, you can try using the "on current" property of the subform using: Me.YourField = Forms!frmMainFormName!YourField Me.YourField = name of field on the subform Forms!frmMainFormName!YourField = name of field on main form

CFP, this occurs when you are trying to enter data in your secondary table/form without having entered data in your primary form/table first. try entering data in your main form first then enter the data in your subfrom/secondary table. CFP, just FYI these guys are great about answering...

texasalynn, an article on Microsofts knowledge base may help. article id 319482.

You can try the on click event of the command button with code similar to this. just need to edit and modify to your needs. Also there are a great number of posts about emailing. Private Sub Command61_Click() On Error GoTo CheckError strToField = Me.SupervisorEmail DoCmd.SendObject...

Thanks jfgambit, i took a look at the forms design. You are right, i don't need any more work than necessary, especially some i would create myself from not doing something right the first time!

sorry for butting in. I didn't see jfgambits reply i was trying to figure this out at the same time.

Argonaught I am a newbie also but maybe this can lead you in the right direction. If your fields go like this: SoldFor - PaidFor = Profit In the AfterUpdate property of the PaidFor Field add this: Me.Profit = [SoldFor] - [PaidFor] Then in the next to last filed before the Total field try...

Thanks Wayne. I'll go to the Forms Forum, do some research and correct my mistake. I am a newbie just trying to make sense of all of this.

When opening a second form using a command button on the first form i have found that it is necessary to use the where parameter to properly do so from the other posts I have searched and read through. However when the form opens it does not appear to do so. Probably does but i do not know how...

Thanks. Thanks Jeremie, i appreciate the help. I apologize for the delay in responding to your post. I will respond immediately next time. That was a good idea to use only an FE portal through to the other databases.

I have been reading the posts on both replicating databases and using FE/BE. I have created 4 databases that tie together to act as one database through linked tables. I understand that i need to split the databases and leave the tables in the back end whilst everthing else goes in the front...

Thanks EMP, worked perfectly!