Search results

well, that was easy. Thanks.

I cannot find a built-in function in Access. Does somesone know how to truncate numbers? For example, 5.568 = 5 4.345 = 4

Thanks a lot Pat. That was much simpler.

But Rich, how do I go about calling that number in a field in my main form?

Thanks RuralGuy. I'm a beginner when it comes to VB. Would you mind elaborating each line. Also, where do I insert the name of the main and subform? Thanks.

I have a form that has a subform in it, which is another table in it. I want to add the number of fields that are in the subform. What is the best way to do so? I would like to write a VB script so that a field in the master field = the count of the records in that subform. Any help is...

I tried to chosee Lookup Wizard as data type in my table so I can have drop-down options from another table. However, I received an error message, "ActiveX component can't create object". What does this mean, please help :confused:

yes. I'm not sure what that field does. I want to be able to create a button to tell the form to show all the records. So what would I do in my subroutine?

yes. I'm not sure what that field does. I want to be able to create a button to tell the form to show all the records. So what would I do in my subroutine?

you're talking about using your statement in the criteria section of the query right? If so, when I do that, after I close the query, it automatically change it back to [forms]![formAnother]![dropdown]

[forms]![formAnother]![dropdown] Is Null gives me no data at all.

This doesn’t sound too hard but I cannot find the answer. I have a form using a query as its source that has a criterion fed from a drop-down box, example [forms]![formAnother].[dropdown]. This works fine when I choose an option from the drop-down to filter some records. However, how do I get...

Thanks both.

I would like to assign a field with a variable depends on the time stored in a text box. The value of the text box is assigned by "=now()" and is based on when the form containing the text box is filled. In my query, how would I write the expression if I want to, for example, assign the field...

The recordset method seems quite complicated. I looked into the Dlookup deal and I think it may provide what I need. However, as a beginner of code writing, I was not able to come up with it after a long period of coding. Maybe I'm naive, but can't I just write a SQL statement to sum all the...

That was simple. Thanks ya'll.

I have a subform that is used in different forms. In that subform, there is a button called CmdFinish that I only want to be “visible” or “enable” in certain forms. Does anyone know how I can code this?

Evil, I follow your logic. However, two questions... 1) what if the field, txtQuantity, has several records, meaning there are several records that have the field txtQuantity since the form is getting its data from a query? see below. I would imagine I would have to add another field to sum...

Perhaps I was not very clear in my request for help. Basically, I have a form that requires the user to enter basic information in the MAIN FORM prior to making an order. The detailed order is made in a different form, DETAIL FORM. I have a button that allows the user to conclude the ordering...

I have never used SQL in codes before. I don’t know the syntax or the structure of writing a SQL statement in codes. Every time I need to check a value, I would write a query to pass the value of a field to a text box of a form, then in the code, I would reference that text box. It is not...