Search results

I am still working out on this problem. Any help guys!

Hello guys, I am asking again for your help on my problem. I have this subform which is on continousformview. On one combobox, you are to input ItemID. One ItemID is related to one AccountingID. If I have 5 itemid in the subform, when I click the Journal Button, it would suppose to lookup the...

Thanks Dave. I was thinking of having a monthly service or support. Can I suggest monthly db compact as its maintenance?

thanks for the replies guys. Its really not happening right now. I guess I have to stick to what is available. thanks.

lets disregard all that so that you wont be distracted. The products form you have there is some sort for the purpose of updating the quantity on hand of your existing quantity on hand. And you have a query AddQty as your update query. Since you are using update query, we can remove the form...

yes, you are using the pname combobox as your criteria. you cannot do this because this form is bound to products table and your pname combobox is bound also to pname field. especially your pname field is set to noduplicates. I think you should make another combobox for that matter if you want...

Private Sub ComboP_Name_AfterUpdate() Dim ActualQOH As Integer ActualQOH = DLookup("QtyOnHand", "Products", "P_Name= '" & Forms![FormProducts]![ComboP_Name] & "'") Debug.Print ActualQOH End Sub change your dlookup format to that above. see if that works

Oh I am sorry, I may have conveyed my question wrongly. What I mean is what kind or type of service or product or support that we can also provide for a fee after we have sold the main product (the software) ? Like monthly maintenance of the database or what more?

What perhaps could be the possible after sales services, support or product can be done or offered when a program is sold?

What you have said about the hackers is true Wiklendt. Moreover, Selling the db is one of the factors in my db planning. For now I am not going to use other db aside from Access. At present I am experimenting and learning, researching ways as part of my planning.

thanks wiklendt. I am also using version 2007 and I have also done your advices. With the question of Atomic Shrimp asking me ("But it really would make more sense if you told us what result you're trying to achieve - in general terms - what problem are you trying to solve here?"). Probably...

First off, there are many ways to ensure that the textbox in your form is not empty. You can use the on click event of your save button to check (write code that will check for null textboxes) any empty textbox that are needed to be filled first before saving. Next, I dont know if the error...

You are correct Atomic Shrimp and I know that functions need to be triggered. Actually I have tried to use autoexec macro to run the function on db startup and using loop in the function to determine any opened table or query. However, when you use loop, it only performs that function and...

If I may restate my question: How can I use the above code I posted that it will run when the database is opened until the database is closed. (the database is not running on runtime mode)

I agree and it is true that users should only be interacting with forms. It is for the purpose of my learning that I would like to ask how things are done in Access like this one. I would like to learn more and in depth about Access.

Somehow I know that tables and queries dont have events. Is there another way to detect or determine that a table or query has been opened?

Hi everybody, I have this code to determine if the table or query object is open and close it if open status: CODE: Option Compare Database Public globalobjstate As Boolean ' booleans are initialized to false Public Function objstate(Optional objname As Variant, Optional objtype As...

I suppose. :D

I see. I think I should gather more information from the internet to find way for this workaround?

I see. Will try on that Adam. Thanks.