MikeyLDS

Hello guys, I wonder if you could help me? If this is the wrong forum or even the wrong site please tell me where I can get it resolved. I'm kinda new to MS Access and am creating a database with various forms and queries before even thinking about applying them into my VB .Net project. On my "Client Details" form I have a button which automatically opens a new form with all the quotations that relate to the client in the previous form. I have used a "Client ID" field in each table to ensure that the records are filtered correctly. Everything works fine until I create a new record within the second form ("Quotations"). In the Client ID field I want it to pre-populate with the Client ID in the "Client Details" form. Here is an idea of where I might have gone wrong: I used the expression builder and came up with: "=[Client Details]![Client ID]" Where [Client Details] is the clients table and [Client ID] is the field that I want to copy from the table When creating the new record it just shows "#Name?" in the Client ID field in the new form. Please help ... I'm begging you! :confused:

Er, this may be a simple question that I'm about to ask ... But what event is fired when you press the Enter key after typing in a text box. I'm trying to fire a particular even with the user either pressing bttnSend or by simply hitting "Enter"

I can't believe that nobody has answered this yet ... this guy has probably changed forums by now ... poor guy! You simply put "&" before the required letter in the label or menu control name, etc. Though you might need to change the nmemonic reference in the parent form if I remember.

Cool ... isn't it easy when you know how! :)

Hiya peeps ... 'tis me again. I'm wondering how to automatically show any active windows within the menu structure just like MS Word, for example. It seemed much easier in VB6.

Thanks DiverDan ... could you advise me on how I could do this?

Hiya guys. I'm hoping to display a listbox of just small images like the msn messenger does when the user wants to select an emoticon (eg: 8 accross, 3 down). Is this possible with one of the controls or do I need a user control?

One last thing stustarz ... how come your code clearly shows as "VB Code" and on a white background with the blue and green colours? :o By the way ... it worked well (again) ... I should add you as a buddy ... which messenger do you use?

Private Sub btnShowClientDetails_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnShowClientDetails.Click Dim ShowForm As New frmClientDetails ShowForm.Show() End Sub One last thing ... The .showdialog works ok now but for some reason a different form won't show within my mdi container. The name of the form is recognised but simply shows on top of the current MDI as a stand alone window.

Wonderful ... that works and makes much more sense than other peeps had mentioned ;)

Hey that was very handy! Many thanks guys ... I am now a little confused though. I have about 7 forms and only one of them seems to work (in the context sensitive thingie) :confused: Should these forms be referenced in some other part of my code somehow?

Hiya guys ... met me appologise in advance. I have searched the forums but my question doesn't appear to be answered. When I try to display a form within another I never seems to show. Also when I try to show a form as a dialogue it just shows a new blank form. Here is some of my code: Private Sub mnuOptions_Select(ByVal sender As Object, ByVal e As System.EventArgs) Handles mnuOptions.Select 'Show "frmOptions" form so that user must close before continuing on main form Dim dlgOptions As New Form dlgOptions.ShowDialog() End Sub When I run this it just shows a blank dialog form. I get the same problem trying to show a child within an MDI. Any suggestions?

Hiya peeps, For some un known reason when I try to add a connection to the solution with the server explorer it doesn't do anything and just sits there as though I haven't requested it. Can anyone help me please?

Hi, I'm not sure if this is even in the right forum ... I'm looking for a little advice on how to create an instant messenger within my database app for contacting colleagues. I'm hoping that somebody can lead me in the right direction as I have never tried this before and so need to learn from scratch. Also is it fairly easy to use emoticons aswell. What type of control can host text like this followed by an emote like this: :confused: ? Your advice will be much appreciated. Many thanks