Search results

Hi, I want to create a custom calendar in Microsoft Access and schedule appointment by categories, such that when an appointment has been scheduled in any category at any given time, no other appointment can be schedule on it until that appointment is cancelled or expires. Can anyone give me a...

Thank you for your response. So how do I prevent anyone who has exhausted his / her limit for making further expenses until next week, next month or next quater? Thanks, once again.

Hi, I want to develop an expenses platform. My problem is how do I create it such that when an impress amount has been approved by the admin/manager, all daily expenses cannot exceed that approve sum for the weekly/monthly or quaterly. And moreso, until that approved sum is exhausted, new...

Yes, it's a split database use in 2 system

Hi, I want to ask what I can do to resolve a case of when I run an update query behind a form, I get a reply than Changes have been made since you save the... or someone else has made changes to... (Save |Discard |Copy) If I clicked Save, the operation will be carried out else the operation will...

Thank you, so now what is the best way to reframe the query? I actually copied the SQL statement from my QBE design I was using which included the calculations

Ok, having my code changed to SQL statement, here's the ERROR generated: Dim StrSQL As String StrSQL = "UPDATE (tblOutbound INNER JOIN tblClient ON [tblOutbound].[ClientID] = [tblClient].[ClientID]) INNER JOIN tblItem ON [tblOutbound].[ItemID] = [tblItem].[ItemID] SET...

Ok, having my code changed to SQL statement, here's the ERROR generated: Dim StrSQL As String StrSQL = "UPDATE (tblOutbound INNER JOIN tblClient ON [tblOutbound].[ClientID] = [tblClient].[ClientID]) INNER JOIN tblItem ON [tblOutbound].[ItemID] = [tblItem].[ItemID] SET...

No, I have earlier use Update Query, but it will update some and not update the last record, especially when there are many records. Then I thought I have find a way out through recordset update. Although, it was working before now

Hi, I have an application that update multiple rows (between 10-80) records at a time. My challenge is when I click the update button to update records up to 30-50, it skips the first 11-29 records and update the rest. Please can some tell me why it's like that? Here's my VBA for update: "On...

Hi, Can someone give me VBA code to send SMS as an email to API using HTTP or email port including current customers transactions as message Thanks

Thank you all for your contributions. I have sort myself out now. For records sake, I used DAO recordset and all I did was add error checker Thanks

Hi, can someone help me with to check why this VBA synthax is wrong and give me the correct synthax to Update multiple records in 2 or more tables based on criteria on current form: CurrentDb.Execute "UPDATE tblItem INNER JOIN (tblClient INNER JOIN tblOutbound ON [tblClient].[ClientID] =...

Hi, I want a textbox where I can search anything based on a table/query and a drop-down like box to show related searches under the textbox.

Hi, I am just worried how to update multiple record using ADO since when I used DAO, update is possible with few records, but when the records gets to 50 or more, error rises. Here is the code I used: "Dim RS As DAO.Recordset Set RS = Me.RecordsetClone With RS .MoveFirst...

Hi, I have a continuous form that I set it add new record property to no. So how do I add new row with button if I need to?

Hi house, please can someone help me out with my access program? I have 2 or more system interconnected to one BACK-END file, while the front-end are on each system. But my problem is when 2 or more users are using the same table/query through their respective front-end, the systems report...

Ok, can you give me the parameters to route it through third-party. I mean Codes to connect to the third-party. I already have a third-party in companies like www.clickatell.com, but how do i connect my access app to send SMS thru them? Thanks in advance

Hi, I hope this is going to be easy. I want code to be sending bulk SMS to customer numbers after purchase has been made thanking the customer for patronage and send customer invoice by SMS. I have gotten API from clickatell gateway. So please I need urgent help. Thank you in advance Moore

Although I have not really test it out, but from the look of things, it will work. I never thought I will receive a sound reply as this. Thank you for the reply