Recent content by Mwaki

You're right @jdraw. I am rushing this. I will take some time and do what you've recommended. I need to get it right. I'll be back if I get stuck again. You guys are really helpful!

I started on the DB yesterday so thank you for the heads up with the spaces. I will implement it promptly. Also, I had just started on the quotations table when I realized that the RefNo would be very instrumental in the entire DB. I understand your suggestion @plog when you say that I could...

Here is a screenshot. I found the upload button:D

I would post a pic but I cannot seem to find the button to post an image :D. The Quotation table is supposed to have stored the quotations that I would be issuing to plausible clients. If it is approved, I would need to create an invoice then a receipt for the same work. However, not every...

Well, there is already a date field in the table. There, I will record the date the quotation was issued. However, I need to create a reference number that would be used when I am eventually issuing a proforma invoice and a receipt. This is where the this important number should be generated.

Let me add a bit more context to my question. I already have an autonumber in the same table known as "Quote ID". The field I am trying to create is supposed to create reference numbers for each quote that I create i.e. RN-0818-0001. I want the reference number to indicate the month, year and...

Hey! I am trying to create auto increment values for a short text field that have the following format RN-0818-0001 RN-0818-0002 .... and so on I have entered the default value in the field I want to use as =Format("RF") & "-" & Format(Date(),"mmyy") & "-" .... But unfortunately I...

Hey guys! I'm new here and also to Access. I did a small project with the program back when I was in Highschool but that was almost a while ago. Anyway, I am currently assisting my dad to automate his small business and since hiring a programmer is quite expensive, I thought I could whip...