Search results

Hi, I have a table that keep date of expired items and quantity. My question is how to be deduct from each item programmatically, such that if 10 items are in 3 batches, how do I deduct from batch 1 and if batch 1 has exhausted, then deduct from batch 2 and so on. Here's my demo: Ball Pen...

What I mean is broadcast directly without using third party software or how do you mean?

Hi, I am just looking if there is any one who has VBA code to broadcast SMS from customer table in an automated manner or manually. Thank you in advance for response

Thanks for the quick response. But what I am really looking at is how to filter the various amount where the records are on Cash Payment, check deposit, Draft, Bank Transfer, since all payments are in the same column in multiple rows. I want to sum all cash payments, all draft, all Bank Transfer...

Hi, I have an issue with Access report. I have a report that display total transactions. Now i want to insert Total fields like: Total Cash Payments Total Bank Transfer Total Check Payment Total Draft Payment Total Balance to display at the report footer. How do I go about this. What format do I...

Hi, Can someone help me with vba to export report in ms Excel format (Access 2010). Thank you Moore

So what is the possible cause then I need to resolve this very soon, please

Hi I am having an error on my program that has been working since. It's split database. It's reporting that "Invalid Database Object Reference." How do I fix it? Or is because I am using Access 2010 in other systems? Regards, Moore

Thanks for your response. But I mean the Application windows not just a form inside the Application Thank you, please try more

Hi house, can someone help me with code to prevent windows from being closed either accidentally or from the red X by the right-top-corner? Thanks Moore

Okay thanks anyway. Let me see what I can try and come up with

I haven't tried anything really because I don't know how to insert the criteria [WHERE UserID=field1 of table A] or something like that Maybe I should better use subform to display records from current user binding subform to mainform, if this cannot work

What i mean is that i have 2 or users that are entering some figures into a table. There is a textbox that display the sum of their entries. So what i want is how that textbox can sum only records of on current user, maybe using user ID as criteria to fetch the records and sum them. That's all

Hi, just can't figure how to display only records of current user in a textbox using DSum function in Access2010 VBA Please help me out if you can. Thanks in advance

Once again, thank you for your kind gesture all these while. I am blessed by your responses. May God Almighty reward your efforts

Thank you very much. It worked well. But I would like to add, supposing I don't want to backup to CurrentDb and maybe I want to backup to any folder the user set, what is the syntax to implement that? Thanks once again

Thank you once again. Does that means i will be putting tables name one by one, because I have many tables in the database to backup

Thanks for your quick response, Arnelgp. I implemented the code but it gives me an error in the following line: set td=db.tabledefs("anyLinkTableNameHere") I also change my backend name like this: set td=db.tabledefs("DinavicNew_be.accdb") but to no avail. So how do I correct this?

Hi, Please what is the right synthax to backup only the backend of my database. This is the code i try using, but it only backup the frontend and my database is splitted and in different folders on a network: Public Function db_backup() Dim sourceFile As String, destinationFile As String Dim...

Yes and No Yes because the connections are through LAN, but No because they are always on field work, so they only connect when they are in the office to use the LAN, then they update their records and the various changes will be effected in every devices