Search results

That's all the Database Has. Just thought having a column to denote the birth of each record. For example: The Shop owner may say: "Yeah we have covered that area from this year onwards" Customer Anniversary offer Now. It's has become an habit of mine to add a Moment column for every Key entities...

SELECT Customer.ID, [DD] AS Delivery_Date, Subscription.Session, Customer.NameVal, Item.ID, Item.NameVal, Subscription.Rate, Nz((SELECT LAST([Volume_Switch].[New_Volume]) FROM [Volume_Switch] WHERE [Subscription].ID=[Volume_Switch].[Subscription_ID] ),[Subscription].[Volume]) AS Delivery_Volume...

Moment is nothing but a combination of Date and Time.

Main Subscription Form: Delivery Drafts: Why I call it Drafts: Because its the form which loads all the deliverables from the database and make it acknowledged after Delivery.

Why this much fast

one of my schoolmate's relations is running a small Dairy. He asked me to develop an inventory cum software for him. I choose MS Access as the Base and escalate to further technologies if needed. This is my ever Database I am developing for a Dairy. Upon thinking. I have derived the following...

Please report. Thanks

Thinking of becoming a One...

"Thala" This is how we call him here...

C:\Windows\Microsoft.NET\Framework64\v4.0.30319\RegAsm.exe C:\Users\arrow\source\repos\Gowtham\Scale_Project\bin\Debug\Scale_Project.dll /tlb /codebase did the Magic

Imports System.IO.Ports Imports System.IO Public Class Scale Private WithEvents SerialPort As New SerialPort() Private Const COM_PORT As String = "COM5" ' Change this to your COM port Public Sub New() ' Constructor logic here if needed With SerialPort...

I may use if I someone concludes its availability in ms access queries... who knows? which weapon is needed in which fights...

Problem solved but 'ANY' is still there. So can we conclude ANY cannot be used in access queries?

'ANY'way to make it work Doc?

Customers can request for items. So if the customer is already a subscriber and the same subscriber already having a subscription in morning, we just have to deliver ASAP (Morning) but if he has subscriptions only for Evening then no other way. we can deliver only on "Evening". Session...

I am getting syntax error

Session: IIf("Morning"=Any (SELECT Subscription.Session FROM Subscription WHERE (((Subscription.ID) Not In (SELECT closure.[Subscription] from [Closure])));),"Morning","Evening")

Hi All, Good Morning. I am Developing a VSTO Solution (Ms Outlook VSTO Addin). In this I am trying put an Ms Access database file as the Datasource using the Datasource Wizard. Everything goes but at the last step I am getting the following Error: An error occurred while creating the new data...

Actually I am building a software tool for a Milk Vendor. In India, still many doesn't have a mobile phone at least, then only email. I am thinking of the following: Cstr(replace(".",cdbl(Now(),"")) But the problem is Outlook lacks Replace() in the auto-value property of a custom form