Sabtu, 16 November 2019

Re: [MS_AccessPros] Re: Billing software for a store/shop

 

adding on ...you can generally turn anything into a barcode ... numbers as well as text. Pick something that is unique

Lets say you have a control for accepting a scan,

and then the user scans something in. Alternately, the user could type the characters that are often printed below the barcode, and then TAB to end the entry

Let's say the barcode is a productID. If the control is unbound, code could run on the control AfterUpdate event to find what the scan refers to.

Alternately, if that control is a bound combo that gets its list from, for instance, products, then the record is found . There could be code in a NotInList event to add another product on the fly if what was entered wasn't found.

hopefully this gives you more things to think about. Realize that barcode readers are simply alternate ways to input what one could type on a keyboard, and a barcode font is just another way to represent characters.

have an awesome day,
crystal


On 11/16/2019 8:10 AM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:

hi Khalid,

Access treats the scan just like you typed something on the keyboard ... so no extra coding required ;)

Make sure the barcode reader has the ability to program a TAB after the entry. Some give you option to add ENTER as well -- at least one, and preferably TAB is essential to not have to write code to figure out when an entry is done. Many barcode readers, also called scanners, plug into a USB port.


a barcode is simply something printed in a barcode font. Barcode readers will have fontlists they can interpret. The barcode font(s) you install on your computer will appear on the font list for every Windows application.

When you design reports and labels to show barcodes, change the control format to a barcode font instead of something like Arial or Times New Roman. When you buy a bar code reader, you should also get barcode fonts.

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

On 11/16/2019 2:26 AM, khalidtanweerburrah@yahoo.com [MS_Access_Professionals] wrote:
I'm using windows 10 and access 2007. Just for information.

regards,
Khalid


---In MS_Access_Professionals@yahoogroups.com, <khalidtanweerburrah@...> wrote :

Hi all,

Nice to hear we are moving to a new group, Wish all the success there also, congratulations to moderators.


Some of my new clients are asking for instant billing software for their shop with support of bar code machine. I need help in this regard, either some template for it or other support would be highly appreciated.


regards,

Khalid

__._,_.___
Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Re: Billing software for a store/shop

 

hi Khalid,

Access treats the scan just like you typed something on the keyboard ... so no extra coding required ;)

Make sure the barcode reader has the ability to program a TAB after the entry. Some give you option to add ENTER as well -- at least one, and preferably TAB is essential to not have to write code to figure out when an entry is done. Many barcode readers, also called scanners, plug into a USB port.


a barcode is simply something printed in a barcode font. Barcode readers will have fontlists they can interpret. The barcode font(s) you install on your computer will appear on the font list for every Windows application.

When you design reports and labels to show barcodes, change the control format to a barcode font instead of something like Arial or Times New Roman. When you buy a bar code reader, you should also get barcode fonts.

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

On 11/16/2019 2:26 AM, khalidtanweerburrah@yahoo.com [MS_Access_Professionals] wrote:
I'm using windows 10 and access 2007. Just for information.

regards,
Khalid


---In MS_Access_Professionals@yahoogroups.com, <khalidtanweerburrah@...> wrote :

Hi all,

Nice to hear we are moving to a new group, Wish all the success there also, congratulations to moderators.


Some of my new clients are asking for instant billing software for their shop with support of bar code machine. I need help in this regard, either some template for it or other support would be highly appreciated.


regards,

Khalid

__._,_.___
Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)

.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] Re: Billing software for a store/shop

 

I'm using windows 10 and access 2007. Just for information.


regards,
Khalid


---In MS_Access_Professionals@yahoogroups.com, <khalidtanweerburrah@...> wrote :

Hi all,

Nice to hear we are moving to a new group, Wish all the success there also, congratulations to moderators.


Some of my new clients are asking for instant billing software for their shop with support of bar code machine. I need help in this regard, either some template for it or other support would be highly appreciated.


regards,

Khalid

__._,_.___
Posted by: khalidtanweerburrah@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Jumat, 15 November 2019

[MS_AccessPros] Billing software for a store/shop

 

Hi all,

Nice to hear we are moving to a new group, Wish all the success there also, congratulations to moderators.


Some of my new clients are asking for instant billing software for their shop with support of bar code machine. I need help in this regard, either some template for it or other support would be highly appreciated.


regards,

Khalid

__._,_.___
Posted by: khalidtanweerburrah@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Query corruption

 

You can install the patch if you have sufficient permissions. MS is aware.

Sent from my iPhone

On Nov 15, 2019, at 5:05 AM, pdk444444@yahoo.co.uk [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

  

A couple of days ago I started getting query corruption messages on my update queries - it seems there is a fault in the latest software update patch. What can be done about it?

__._,_.___
Posted by: Patty Mapes <patty.mapes@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (5)

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Re: The Update query issue

 

You will probably have to ask the user to uninstall the KB. Otherwise you will have to do a ton of temporary rewriting of your queries.

Regards,
Bill Mosca

------ Original message------
From: Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]
Date: Fri, Nov 15, 2019 12:49 PM
Cc:
Subject:Re: [MS_AccessPros] Re: The Update query issue

 

The user has the KB installed. I will try the step into

Jim Wagner


On Friday, November 15, 2019, 1:45:28 PM MST, wrmosca@comcast.net [MS_Access_Professionals] > wrote:


 

Oops! I found your closing paren. Follow Duane's advice. But find out if the user has the bad Office Update KB installed (see earlier posting).-Bill


---In MS_Access_Professionals@yahoogroups.com, > wrote :

Jim - I see a wayward parenthesis right before DateDiff. Either remove it or put a closing paren after ProcessEventEndDt = False
If (DateDiff("d", EventEndDt, currDate) > 0) And ProcessedInv = True And ProcessEventEndDt = False Then

-Bill

---In MS_Access_Professionals@yahoogroups.com, > wrote :

Hello all,


I am having issues with a line of code for the UPDATE statement. I have created a query and then created the update query and pasted the sql statement into the line of code and modified it to be relevant and it is still not working. can someone give me some direction please. It is a mission critical database and the user is calling my boss and complaining



Thank You


Jim Wagner


here is the code. it is crashing on the


Do While Not rs2.EOF
    Id = rs2!EventID
    ProcessedInv = rs2!ProcessedInv
    ProcessEventEndDt = rs2!ProcessEventEndDt
    EventEndDt = rs2!EventEndDt
   ' MsgBox "INner Loop" & EventEndDt & currDate & Id, vbInformation
   'if the event is over but the inventory is not put back, the loop in run
    If (DateDiff("d", EventEndDt, currDate) > 0) And ProcessedInv = True And ProcessEventEndDt = False Then
   
       ' MsgBox "INnermost Loop" & EventEndDt & currDate & Id, vbInformation
        cntr = 0
        Set RS = Form_frmMainEvents.SubformEventDetails.Form.Recordset
        RS.MoveFirst
        Do While Not RS.EOF
       '  MsgBox "INnermost Loop" & EventEndDt & currDate & Id, vbInformation
            Q1 = Form_frmMainEvents![SubformEventDetails].Form![quantity]
            colName1 = Form_frmMainEvents![SubformEventDetails].Form![Item_Name]
            Lcntr = DateDiff("d", rs2!DeliveryDt, rs2!EventEndDt) + 1
            For cntr = 0 To Lcntr - 1
                invDate = DateAdd("d", cntr, rs2!DeliveryDt)
                CurrentDb.Execute " Update Tbl_InvDetails set [" & colName1 & "] = [" & colName1 & "] + " & Q1 & " where Tbl_InvDetails.InvDate = #" & invDate & "#  ", dbFailOnError
            Next
            RS.MoveNext
        Loop

__._,_.___
Posted by: wrmosca <wrmosca@comcast.net>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (7)

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] We're moving!

 

thanks for the update, Bill! ... and Ben for the recommendation -- groups.io was also a suggestion for another group I monitor; seems it will suit us well! I hope to see y'all on the other side ~

have an awesome day,
crystal


On 11/15/2019 2:24 PM, wrmosca@comcast.net [MS_Access_Professionals] wrote:

We are moving to Groups.io (https://groups.io/g/MSAccessProfessionals) on Nov 25th. At that time I will close off all new posting at this Yahoo group so we don't lose anything. Please join us. We will have the same moderators doing the same great job of keeping things organized.


All of our files will be migrated to the new group as soon as possible. Groups.io owner says that so many Yahoo groups are moving to his host that he's having a hard time keeping up. I guess that's a good sign. 


Existing members here will be added to the new group. You should get a notification when that happens. And you can always leave if you want to. It'll break my heart, but that's OK.


Once again, the new group is at:

https://groups.io/g/MSAccessProfessionals


Feel free to join any time. I'll try to get everyone on the non-moderated list as soon as I can.


-Bill Mosca

__._,_.___
Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)

.

__,_._,___
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)