Search results

Guys! I have been working on this TV program guide and got stuck with reporting. Here is my table. I trying to build a query on access to have a report presented as attached image. also I have attached excel file of the table for any helper to work around. Some help in this regard is much...

I am trying to generate a sales report from my SQL database. My management would like to get a report of sales movement which shows sales total current month as of todate and sales totals of last month as of the same day. for example todate is 2/10/2013, I want the totals of January as of...

Hey Everyone Need some help here. Here is a SQL statement. Need your assistance to undertsand how to change the Column "gg" to Short time format. ALTER TABLE bbbb ALTER COLUMN gg dateTime thanks

Hello I want the msgbox to return each data in a separate row!! How am I doing to do that? Dim strUrl As String Dim StrMsg As String Dim StrTask As String Dim StrAccount As String Dim StrName As String Dim StrCustMob As String Dim StrAddress As String Dim...

I am having some problem with the following code. I have put the code behind a button. its working perfectly fine when I use it on MDB version. The error message comes when i convert it to MDE. Can somebody please tell me what I am doing wrong? Quote Private Sub Command259_Click() Dim...

Can any one explain to me how i can export a table with following fields conforming attached schema. listing name_abbreviated datetime_start datetime_end classification captioned title synopsis Here I attach a sample XML generated using the table conforming the attached schema.

Brothers... Can anyone please tell me how I should create tables on MS SQL Database complying with the attached XSD. I have tried different ways but it doesnt seem to conform with the XSD. I think its something to do with how I set tables and its related fields. <?xml version="1.0"...

Can somebody please tell me how I can export data in XML format complying with a specific XSD. Here I attach the XSD. Many thanks

I have this POS application designed by myself and want to print receipt on Epson Receipt printer. The printer is set as default and the receipt page setup which I designed in Reports is set to print in default printer. But when I give for print some wiered characters keep on coming until I...

Special Printer Control Characters I have created POS application for my business that uses an Epson TM-U220 Series (Type B) receipt printer with tear off. I have formatted a report from my Access db as a receipt, but I need to send the hex string "1B69" in order to activate the paper cutter...

Need some help on a command which would close any on screen active form. I want to have this Esc key enabled as an autokey to close any screen active form. I know how this autokey thing works but unable to figure out proper code. thanks

Hey guys.... stucked in one thing..... I need to extract Month and Year together from a date in a Query. for example if date is 4/19/2007 i want to put this as April 2007. Any idea ...? thanks

I have an access POS application which prints receipt on a receipt printer. I do not have a specified length of the receipt as sales vary in the quantity of items . Does anyone know how I can code it so that the last text is the end of the report and the paper is cut off right there? And also...

Guys, I have been working on this Inventory application using Ms Access and I am almost done. A big thanks to some beautiful tips on ur forum. However I ve got stucked on one little thing. Its, for example when I create a purchase order and start entering Product items in Purchase order, I dont...