General Forum

Hello every one, I asked a question earlier and now I'm refining it to make it clearer (Because I'm now getting to understand my problem). I have a table "Products" and an attribute "Quantity". I also have a subform in the Invoice from and the subform is created using a query "Invoice_line_quiry". There is in this query "Invoice_line_quiry"...

How Can I copy cloumn "Sql server" to an array in VB.net? thanks

I have a form with two subforms. The main form holds the Order Number and basic information. The 1st subform holds an abbreviated list of products in the order and the data source is a table that uses master and child fields to populate. The 2nd subform holds product details and I am attempting to use a query with one parameter to...

Hello everyone,,, Here is my problem, I'm using MS Access, I'm building a mobile inventory system.I have a table (Products) and I want to update the Quantity of mobiles each time I perform a sale operation. Sales operations are performed through a Form(Invoice) and in that form I built a subform-that was built using a query- where most of...

Hi people, I have a function which will receive 2 parameters:the date field in GMT time and the user's time zone. I have to return a datetime field in the user's time. the thing is the server records the GMT time and that is put into the database. but when reports are to be generated for a user who doesn't belong to the GMT time zone, for...

I need the script Ischoolad. The website where it orignated is no more. If anyone has a copy of it. Please let me know. Thanks.

I have to do data dumps from our Unix server (I can't connect directly to the tables) to populate data in an Access db. The current code I use to ftp these files is pretty cumbersome - does anyone know of anything more up to date I could try?

Although the jpeg from which the OLE value is taken are few hundred kb they increase the dbase size for 5-6 mb. With 20 records the size of the file is 300MB?! What am i doing wrong?

Hii Dudes, Iam Hariprakash. Today I was searching for DB2 DBA in google for exam 701. I got this link. This is very interesting and just now I joined this group. I took the exam 701 last tuesday and got only 59% 42 out of 70 and 43 is pass. I prepared with roger sanders book for 701. please advise me on how to prepare for this exam. i am not...

Ok, I have having a problem joing these two queries. Can anyone please help me out here. These are the results of my two queries: These are the values in the A1 field of QueryA COCKBURN 2 GT KW 1 GTN 1 IPP GT1 IPP GT2 KALG F5

software: abcDB DesktopStudio platform Pocket PC 2003 tables: equipment: eqID equipment 1 CPU 2 monitor 3 printer

I get the following error on page when I click Login button: I've attached Code. Please please help . ExecuteReader: Connection property has not been initialized. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it...

Hi all, I am currently working on a form that will allow a user to tick off certain medication errors. A user can select up to five errors, there are around 15 listed. I was wondering if Checkboxes woudl be the best solution for this or is their a better approach? If checkboxes is the best approach coudl someone please tell me how to...

I have a form that runs off of a query. The query has you enter three items. and . When entered correctly it displays the results on the form, however it the numbers entered don't match to any record it displays the form just with no values populated. I want it to display a message box saying "No records match the inputted items" or...

I create a proxy class from a wsdl of a web service. When i instantiate the object of that proxy class, every time i run the code i get an exception that some dll or assembly missing. And all the dlls pointed by the exception seems to be junk or garbage. Also, the exception object shows source as mscorlib. Any pointers to this error? ...

Hi, I'm really new here. I just posted to a thread, but that was before I updated my options to automatically subscribe to threads I responded to. I see no other way to subscribe to a thread. Does anyone need a little extra "good karma"? Thanks, JT

Hi Everyone, I have a web portal. On one of my web forms, I have a Comparevalidator for my textbox "FuellingDate". I configured it to do a DataTypeCheck for Date. When user puts in a date in a format of "dd/MM/yyyy", example: "25/5/2005", it is valid. This works for my development machine, but on the production machine, it complains about this...

I am trying to filter a subforms combolist options through a combolist on the main form. Heres what i have: Form: frmOrderDetail Datasource: tblOrders cmbOrderSupplierID w/ control source orders. Subform: frmOrderDetailSubform datasource: qryOrderDetails cmbItemID w/ row source: SELECT ., .

I need to take any amount of rows and turn them into one single row. I'm exporting some data from sql. The program its going into only has one note field. I've used UNION and those types of functions, not sure what to do this time. This is SQL server and will be part of a stored procedure. example data: NOTES NOTE...

I mentioned earlier I'm trying to use DllImport to pull in functions from a dll. I'm using the InteropServices and ComponentModel. The issue is the compiler complaining about the "[" around the comand. Example [DllImport("declspec.dll") public static extern int da4300_CountCards(); The error is on the "["operator? I am following the...

Sorry if this is a stupid question but ive been struggling with this for a little while now. I am trying to get a text box on a form to display a text value according to which record is selected using a query: Open the form with appropriate record: Private Sub butCreateOrder_Click() Dim stDocName As String Dim stLinkCriteria As String ...

i want to achive a simple thing i..e when i click on a link in the mircrosoft browser's controll it should have a border around the link !!! or button e.t.c new in this forum n new at C# programmin plz help me guy's im stuck at dis cheer's n thanx in advance :)

Hi Everybody! I developed one website using VWD Express Edition and SQL server 2000 as my Database. Now i would like to publish it on my server.But I came to know that VWD doesn't have utility to publish a website. Any one can please guide me how to publish my website ? email: kirtimistry2001@hotmail.com Thank you Kirti

hi, i want to know how to do few thing in my program. program will sit in the systray and when user want to print something from any program(word, reader, notepad, etc) my program will get few data( filename of the document would be sent to the printer and size of the filename ). ho i can do this.

Can someone please help me! I have created a db in Access 2003 and the overall file size keeps doubling periodically. Before I noticed this phenomenon the DB was at 65Mb (could have been happening earlier). It then doubled to around 120Mb, then 241Mb and finally it was at 480Mb!! I had a back-up of the 65Mb version so I just copied the new...