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

Er, you couldn't give me some sample code for that could ya?

"All is well!" :)

Hello peeps ... I wonder if you could help me? I've been trying to use the update method to save any changed that I have made. The changes made via a datagrid work ok but they never seem to work when changed with a control on the form. 'tis driving me nuts! :(

Thank you for your info ... maybe I'm getting somewhere now. When I use the ds.GetXml() function it shows me updates that I have made. If I change any data in a DataGrid it seems to work but not an ordinary text control.

Hiya, the .HasChanges is currently set to true and there is no AcceptChanges coding at all in my project. Should there be? I set the connections up using the wizard.

Hiya guys ... man I love this forum! I'm trying to update data that has been changed by various controls that are on my form. Here is my code. It appears to be right to myself but no matter how I tweak it, it doesn't seem to be working for me :( Try daClientDetails.Update(dsClientDetails, "Client Details") MsgBox("Updated!") Catch dataException As Exception MsgBox(dataException.Message) Me.BindingContext(dsClientDetails, "Client Details").CancelCurrentEdit() End Try Just so it makes sense: daClientDetails is the DataAdapter dsClientDetails is the Dataset "Client Details" is the name of the Table created in MS Access The message box comes up so I know it has used the previous function. When I check if changed data has been saved by "reloading" it again it just brings up the previous set of info. And the error handler doesn't return anything. My load event is written like this: dsClientDetails.Clear() daClientDetails.Fill(dsClientDetails, "Client Details") Any help would be much appreciated. :)

Yes, it was possible on VB6, can be very handy too! :P

But the User ID field "is" assigned in the database. When I load MS Access it puts a key next to it and when I use the wizard it even shows it in bold. Any other suggestions?