Search results

Sorry I forgot to mention from Visual Basic. I am trying to trigger the AfterUpdate event in the combo box after click another button. Thanks.

Is there a way to trigger an event in a control?? When my form loads I want to be able to trigger AfterUpdate event in a combo box control. Thanks in advance.

Yes it does. TAL.

Why didn't I think of that before. It sure saves a lot of tears. TAL Guys

Hi, I have a form that has various fields and I want to add a tab control for grouping them more logically. So I add a tab control and drag and drop the various fields into the different pages of the tab control. But this does not work and the fields appear in all the pages of the tab...

I want to be able to produce a report that counts the number of new members joined in a particular month/week. I have a table tblMembership that records the joining date. How can I use this information to produce a such a report.

!!HELP Me. Has anyone encountered this problem before.

Pat, I got you. What you are saying is that in the table level it is still an integer but you use the Choose() function to translate the full key. Thanks

David R, I got it to work. I used a form to have a subform - the subform contains the query. This way query opens within a form and user can use close button to close form. Thanks

David R, Thanks. I got the solution now. Its answered in the "General" section. Thanks again

David R, Yes, you could be right. I'll give it a try ASAP. Thanks.

David R, Thanks for your suggestions. No I don't have a problem with Database normalization. Lookup wizard would not help either. I just want to make it more convenient for the user to call up a old record make one or two changes and save as a new record. Sorry!! I'm afraid that I still...

No comment on this one yet!! Even if is not doable please let me know. I am going to try using a subform within a form. Any comments??

Can somebody help me out here please????

Hi David R, This might sound dumb but I can't get it to work. Here is my situation that I tried. I have "table1" with "field1" of text type. On the form (bounded to table1) I have created an option group "frame1" with labels "buy" and "sell". In the frame control I set control source...

Hi David R, Sorry about posting in two different places! I'm not sure how your solution works as I tried button your code in a button. I want to be able to bring up a dialog box containing all the values of the underlying form. Then the user is allowed to make changes to it and then save a...

Scenario: Book type is bounded field with choice of "Hire" or "Sell". I can set up an option group but it would mean that I will store 1 or 2 respectively in the underlying table. Can option group be programmed to store other values besides numbers.

Dear R. Hicks, Here is the code in the close button: Private Sub btnClose_Click() UndoMain Me, "tblBookInformation Temp" DoCmd.Close Here is the code in field with validation: Private Sub Book_ID_BeforeUpdate(Cancel As Integer) Dim sBook As Variant Dim sCriteria As String sCriteria =...

Scenario: I have a button that executes a query which returns results in a datasheet. Is it possible to have this datasheet within a form with a close button. I don't want the user to click the close from the file menu. Any help is much appreciated. Please advise.

Problem: Form is used to input book information like author, title and etc. A lot of the times the information is the same except for the volume information. I want to be able to copy information from a book record and modify to create a new one. I've seen many similar postings but have not...