Recent content by shahiq

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

attached is a sample table. thanks

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

Table name: bbbb Column name: gg

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

Appreciate of you could enlighten me more.

I know how to export the table to XML which is quite simple. But exporting a table Conforming a specific schema/XSD needs bit of coding I think for which I'm looking for some help. Thanks

I want to know how to export to XML according to the structure given. Here I have attached a sample XML file which was exported conforming the same schema. I believe we can have VBA code to do this. Thanks

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

When I give the receipt for print as I told some wiered characters are being printed here I attach how it comes........... Please help me brothers Im in deep trouble as my deadline is going to be over.....