Search results

What does the subform do, alert when there's a "conflict"? What do you mean by "conflict"? Duplicate? If all the query does is to "notify" of a "conflict", why need a subform to base on it?

Didn't get a thing after reading the post! Please rephrase. Also, please delete the duplicated post. Thank you.

Or you can default the Date field in your table as Date() then add a control on your form with its control source is your Date field and make the control's enabled to false. There won't need to enter anything. It will always be filled in with the current date.

I'm just brainstorming this. One way to accomplish it is to create a new .mdb; link all others tables and run a macro. The linking part might take a while too unless it can be automatically done also which I think is doable, isn't it?

Requery The idea here is to just requery the combo box itself. See attached. It's a very simple sample, created just for you. Try add a new number and see if it've been added to the combo box after you close the new-entry form.

Adding that works out great. Thank you. I'd still like to know why it isn't called before the looop though. I understand that adding DoEvents really forces it to do so but logically, the function should be called first then the loop. I also do not think that using DoEvents is the perfect...

Hi all, Does anyone have any idea why a function does not get called before a loop such as a for loop eventhough the Call is placed ahead of the loop? Example: Function ShowWait is placed before the For loop but when you run the example (attached), the calculation takes about 1 second but...

Have you tried this to see if it works Okay. If it indeed works okay, you will have to use a different way to filter the form, will get on that later. Private Sub New_Project_Click() On Error GoTo Err_New_Project_Click Dim stDocName As String Dim stLinkCriteria As String...

You mean you didn't know which attachment was the most updated one? Thanks for sharing.

Ok now, let's try this. Using the sample I sent you, directly from the tables, enter some dummy data for projectID 0 and 1 then try loading the form again to see what happens. This will not solve your prob but just try to see what'll show. The reason you're getting a white, blank subform is...

Ok, now try it.

No! it was loaded via a command button which uses your posted codes. See attached.

Every loads fine to me. No white, blank subform. See picture.

Here you go, a small sample, created just for you.

Can you include the tables, please? (make copies of the tables as structure only, no data) Or you can try (for now) using table's name instead of SQL statement (Select statements) for the RecordSource of the subform.

How about this, IMHO: Dim str As String Dim n As Variant Dim FD As Date, TD As Date FD = Forms![Report Menu].FromDate.Value TD = Forms![Report Menu].ToDate.Value str = "[RemitDate] >= FD AND [RemitDate] <= TD" n = DSum("[GSTPaid]", "queryJobRemittance", str) ... Haven't tried it...

In your button's onclick sub, change your subform's SourceObject to whatever subform's name. subfrmMenu.SourceObject = "subform's name goes here"

I'm having a hard time picturing what your form would look like. Can you draw it up somehow? or explain more.

In addition to the above, if you want to just open it, use hyperlink.

Quicker way Here is a quicker way to solve your problem - see attached.