Search results

A bit blurry of an image but it works! lol The AfterUpdate event occurs after changed data in a control or record is updated. Syntax expression.AfterUpdate expression A variable that represents a Form object. Remarks Changing data in a control by using Visual Basic or a macro (macro: An...

research an events trigger before you start to code. I don't know if it is the right one you may need, it was just a conceptually correct guess! haha

You're going to have to use oncurrent and afterupdate events to populate your form. I think hahaha

Was this put through google translate :S

Its honestly for the next developer to use as a template. I would do it all for you but I don't have the time ^_^

Dummy values

I got you until the end there, but here is a setup that might work if you use a form to load this process. Private Sub LoadReportName() ' For loop Dim i As Integer ' Parameters Dim paramA As String: paramA = InputBox("Prompt Message A", "Title", "Default Value") Dim...

Type Mismatch? It doesn't look to me, from the screenshots, that you're working with much VBA. So my first guess is to go and look at your table's design views and make sure that any fields(that you're linking between tables) are of the same data type.

Make sure your main form isn't Modal. This option can be found in the "Other" properties tab of your Form Properties menu. Be sure your code to open the query is something like this. If your query is not a saved queryDef, replace the "qryQueryName" with your query string. DoCmd.OpenQuery...

So it does open a window with your results, but that window is behind the main form?

Welcome to the forum! Also, I can't help but read your name as G Mill Fart... hahaha :P

Is it weird that I am becoming bored of programming...

This application simply visually displays the order of which the selected Sorting Method follows. They line size randomizing is for the affect of different data values in different orders. It is for people who are learning about sorting.

Commented Version for learners =] Public Function ConvertStringToDecimal(ByVal str As String, _ ByVal def As String) As Variant ' Parse Parameters. ' If Len(Trim(str)) = 0 Then: ConvertStringToDecimal = "No...

I want you to know this isn't a "HEY LOOK WHAT I CAN DO" post. I genuinely love to code and learn about things like this.

I've been looking into writing an access form used for hard drive analysis and came across hex values. This made me start dabbling with numbers again and came up with the following function. If you're a person that enjoys playing with numbers, could I get you to think of any scenarios where I...

Good catch Galaxiom. Never would have thought the module and sub would be the same name! :D

The problem is that you can't call a private sub in module from a separate form. The sub in the module has to be public. The sub on your forms module can be private.

ACtually show me what you've got now.

use Public Sub AgeStartSetCombo(ByRef frm As Form)