Search results

Hi EternalMyrtle, Thank you for the reply and I am trying to call the combobox event on lostfocus and it says Argument Not optional..... Private Sub cmbSong_Lostfocus() Call cmbSong_NotInList End Sub

Hi there, I have a combo box and I have 02 events to fire in sequence but it won't worked any idea. First event is Onchange event which I am using to fill out the other combo box values as and when I press key the second combo box will show the values pressed and I want to display the pressed...

Hello Gizmo, Thank you for the reply, I have Installed the ADP for TM-20 Epson receipt printer and tried there code samples with the instructions, I have the printer live and it give me message that "Failed to Open Printer status Monitor", "Printer is not available" etc. I am unsure how to get...

Hello Gizmo, Thank you for the reply and Yes this is the correct manual posted by you and here is the dropbox link for the PDF of the image in better quality https://www.dropbox.com/s/p84kqak346ji2bm/EPSON%20TM-T20%20Screenshots.pdf, please review and let me know if you will have some...

Good Day hope you are well and have a wonderful week, We have an Access database that opened some cash drawers attached to the computer through USB and it is working perfectly. We have some of the cash drawers that are attached to the EPSON Receipt printer and we also want to open those Cash...

Hello All, I have a question that I have a Microsoft Access database (.accdb) front-end/backend split and I want to give the database to my company client. As we have the different path for the backend/frontend linked. I want some code that will popup if the database location is not found and...

Thank you for the reply, For example if I delete ID record # 3, I want the sequence to always be 1,2,3,4,5,6,7,8,9,10 not 1,2,4,5,6,7,8,9,10. Please let me know if there is a way to accomplish this. I am not sure recreating the column with SQL Server linked database through VBA? or compacting...

Thanks Eugin. Do you any VBA Add-in where I could manage my code libraries. I would like to have some useful VBA things. For example in some cases if I will have to copy some controls that has VBA, I would have to copy the control and then copy the codes for each control.

Hi again, Is there any free Addin/tool that would be helpful for Access VBA to Write Queries and passing parameters, additionally does there any Addin exist where I could manage my code libraries and use the same for different applications. Thanks Mohsin

Hello, I have a Microsoft Access database with SQL Server backend with 10000 records in my table, I have a autonumber field and in my database the purpose of the autonumber field is just to keep the record sequence (not to treat as a unique identifier) and I don't want to use a number field to...

Dear Jdraw, Thank you for the reply, User will enter different time and it is not current time, No its Morning 8:30 AM, 1530 works perfectly with input mask but we want to enter 830 instead of 08:30 (and its definately a morning time), Any Idea how to get this done? Thanks Mohsin

Hello, I have a field in my table where I could enter time, I have formatted the field as "Short Time" with date/time data type. I have added a Input Mask for the time with 00:00 so we could only type 1530 quickly and it would taken it as 15:30 time. As there are thousands of entries each day...

Hello JackKaptjin, Thank you for making an example for me, I will review and will let you know that how it goes. Many Thanks Mohsin

Dear Programmer, I am building a Work Order Database and I have a Main form and a subform (in Datasheet View), I have 02 buttons on Main form and I would like to reorder the records by users and on report I would like to print out with the same order sequence. I have attached an Image for quick...

Dear Ice Monster, Thank you for the reply but they don't have any drivers and are USB Cash Drawers work on simply plug n play, I have not found any API, attached is the Image of Port one of them are using, any idea to open the drawer on the screenshot port COM5? Thank you Mohsin

Hello Programmer, Hope you are well, I am building a database in Microsoft Access and my client has the followed USB Cash Drawers and they want to open the Cash Drawer through a command button in Microsoft Access, I am not sure how to open the cash drawer through VBA command, Can anyone please...

Cronk, Many Thanks that's exactly I needed :) Cheers Mohsin

Hello JHB, Thank you for the reply and Yes I am talking about the different pages in Excel file (Worksheets) and not columns in Excel file, a little bit more clarification by default there are 03 sheets (Sheet 1, Sheet 2, Sheet 3) and I want these name of the sheet to be imported in a table...

Hello All, I have an excel file on my drive with the following path "D:\Json\Solve.xlsx", I only want to get "Sheet Names" and Import the sheet name into a table in Microsoft Access, Any idea how to import "All Sheet Names" from the specified path into a table, Every sheet name would be taken...

Yes i know that Access is trying to help me with the issue is with the data type like i import all in "Short Text" and access ask me for a "Memo" field, i know my data is imported successfully and the need is just to drop tables with error, that would be great if you know the trick of dropping...