Search results

Pleasure, the decision to go SQL Server Express takes a few simple answers: 1) Free SQL Server 2005 vs Free SQL Server Express 2008 ... 2005 is well founded, 2008 is new and if the data is critical, I like to go with the solid well used...2005. 2) The SQL Server Express 2005 bundle comes with...

I am looking for the best approach to a complex set of forms and their interaction. Environment: Microsoft Access 2007 ... Jet Be (at the moment) Main Form Recordsource is TxnHdr (Transaction Header) key is TxnID Subform Recordsource is TxnDtl (Txn Detail) Linked by TxnID .. Key is...

Yes, Access 2007...Sorry...There should be a function in 2003 to add existing fields, A also have the Beta release (pre version 1) and that function is available in the beta, but I'm not sure how to trigger it in 2003. Bob PS: It is in the tools function in 2007.

In the Form Design View, In Design, top right corner you will see "Add Existing Fields". Click that and select the new field and drop it onto the appropriate place in the form.

Differences between Sql Server and JET http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html Yes you can just do Access Jet, and not have many problems. The relationships go bye bye in Access when you create an SQL Server BE. You can...

The easy answer is to create the tables, forms, macros, VB code using SQL Server Express 2005 (free edition). Then, pull back the tables as local tables and remove the SQL Server links, and rename the local tables, and create a JET BE for use until you need to go SQL Server. Qustion from me...

I really do not understand your question. In any event, using VB code in the combobox after update, you can do whatever you want with the table data and subform data. You may wish to update the tables and do a requery, which will populate the subform, if it is a bound subform. If the subform is...

Wouldn't have to....I use a structure similar to this, but it could be if volume is low.

Yup, but it may be a better solution, once de-normalized.

Many ways to do this. 1st...to reference a selection in the combo box... Me.Combobox.Column(n) n starts at 0 2nd...To feed bound fields in the subform from a combo box selection...in the After Update of the combo box set the recordsource for the subform to the combo box selection then requery...

This is probably overly normalized for you, but the concept is what I thought you wanted.

Try : Dob < DateAdd("yyyy", -12, #04/30/2009#) in your criteria. Corrected thanks to raskew.

I have found a number of the toolbar commands do act differently when dispatched from VB. Even when you use a sendkey equivilant to Pressing a hotkey for requery. The Filter is especialy tempramental as to when it is removed, a requery actually executes prior to the filtr remove when stacked...

Smiles, so sorry Ms lala... If linking in a large environment, security, password handling, etc must be consisdered....just a note for others reading the post.

Good point missinglinq. What if you do not want a record saved? DoCmd.CancelEvent (in the Before Update Event of the Form) Then close form. Lots of new code for you Kate....smiles.

Sorry, thanks for the correction, flew this out just before bed off the top of my head.

If you just want to ensure something was entered... Private Sub textbox_BeforeUpdate(Cancel As Integer) If IsNull(Me.textbox)= True then Msgbox "textbox cannot be empty" Cancel = True End if End Sub

Your best bet is to continue with the Me.textbox = "" and use the Before Update event to test for valid data entered. You will notice, if an error is found, you set Cancel=True and probably want to do a msgbox message.

Try this link http://www.accessdb.info/content/view/112/45/ Editted: Sorry for the too fast reply....the answer is there Both of these options are performed in the textbox After Update Event: Me![In].Form.Visible=True shows the form In Me![In].Form.Visible=False hides the form In Or The...

LOL, Switch the order, Close Open Private Sub Menu_Click() DoCmd.close DoCmd.OpenForm "frm_FrontTutorScreen" End Sub Or Private Sub Menu_Click() DoCmd.close acForm, "frm_tutor", acSaveYes DoCmd.OpenForm "frm_FrontTutorScreen" End Sub