Search results

Done Plog. Waiting for your thoughts of my forms and queries...

Please understand that I have attended the schools only upto 10th standard in India. Everything I read, build and Share is being done out of sheer curiosity and Passion that I share on my works...

Yes. I agree and will stop putting likes ;)

1. Giving all the autonumbers the same name is not helpful. It makes it extremely difficult to see relationships without opening the relationship window. I want to create the Entities as we see in the real word. For example I also feel that the Table name is sufficient to know it is a...

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...