5,053 Topics

Member Avatar for
Member Avatar for rgivascu

I have setup a global variable. I need to store in this variable the value of Max(RequestID) from tblRequests. Then, I want to assign the variable to a label control on a form when the form opens (On Load event). Then, I want to run a query to include this …

0
57
Member Avatar for PerplexedB

I need functionality to retrieve the new pk, like I could in DAO. I would like my "nLog" function (see code below) to return the new pk. I have found [URL="http://support.microsoft.com/default.aspx?scid=kb;en-us;815629&Product=adonet"]this[/URL], and I was able to make it work fine in my environment, so I'm pretty sure the problem I …

Member Avatar for PerplexedB
0
161
Member Avatar for hi5.ankit

I have 10 buttons and a textbox on my widow form. 11th button to fire the operation. Task is that i need to input a no. in the textbox ranging from 1-10, and press the fire button. This should change the forecolor of the respective button in the form. Suppose …

Member Avatar for ddanbe
0
95
Member Avatar for AssadC

So here's the deal. I was an idiot and clicked on a file to download from an unknown host and let it extract. I didn't do anything so I restarted the computer and after that could not boot into windows at all. I would be able to get to the …

Member Avatar for BritLee
0
142
Member Avatar for khaled_jawaher

I want to use java to access microsoft sql server express remotely.i have allow remote connection in the database that i have.and i allow port 1433 through firewall. the code is: [CODE] import java.sql.*; import java.lang.*; public class Jdbcconn { public static void main(String[] args) { try { //load the …

0
61
Member Avatar for pburk

VB6Query20071120.doc Hi VB6 I am trying to have 2 ACCESS databases open at the same time in order to populate the 2nd one with data from the first one. The problem is that it appears that I can only have one connection to a database at a time. Is this …

Member Avatar for geethasethu
0
500
Member Avatar for ivayla81

Hi, As I am browsing the internet, multiple IE windows start popping up uncontrolably. The only way to shut them off is through task manager. The same thing happened on a co-worker's computer once, so I am fairly sure it's a virus. Here is the MBAM log Malwarebytes' Anti-Malware 1.46 …

Member Avatar for crunchie
0
311
Member Avatar for Blaine Tuisee

Need some help understanding Server 2008's infrastructure. Running a program that requires access to the Document and Settings folder. I have full admin rights but it's still giving me an access denied message. Any help?

Member Avatar for agonzalez
0
107
Member Avatar for tgreer

First, sorry for posting this here, but I couldn't find a VBScript forum on Daniweb (which I find surprising). I'm working with binary data in several different projects. Below is an example of code that works to retrieve a static map image (PNG) from Google: [CODE]strFileURL = "http://maps.google.com/maps/api/staticmap?markers=2200+S+Western+Ave+Lisle+IL&zoom=14&size=400x400&sensor=false" Set objXMLHTTP …

Member Avatar for tgreer
0
771
Member Avatar for mandy84angel

I finally figured out how to auto fill a record in forms. YEAH! Yet I ran into a new problem. Sigh! tblEmployee holds frmEmployee information. qrySiteName pulls information from several other tables giving the details of each location. On frmEmployee, I have it to where when I select the SiteName, …

0
65
Member Avatar for spage23

HELP ME! I'm a college student and use my computer ALL of the time. All of a sudden this thing called Relevant Knowledge started popping up on my computer. I wanted to get rid of it, so I stupidly clicked the button that said stop receiving these messages or something …

Member Avatar for confusertech
0
602
Member Avatar for Michael_SB

Malicious Virus attack! Dear Forum members; I am running Windows 7 Ultimate 64-bit. I contracted a dsc.exe virus yesterday. Solutions I found for removing it did not work – I assume they were written for other OS’s. However, this morning I managed to remove it using MBAM. I quarantined all …

Member Avatar for jholland1964
0
548
Member Avatar for digital11

Hi. I've been having this problem with Firefox & Chrome where searches are taking me to wrong sites. I've done everything as required with Gmer, Malwarebytes etc. Here are the logs:- GMER One log: GMER 1.0.15.15281 - [url]http://www.gmer.net[/url] Rootkit quick scan 2010-09-20 19:25:09 Windows 6.1.7600 Running: 0g2vzqhn.exe; Driver: C:\Users\BOBBYD~1\AppData\Local\Temp\kwkirpoc.sys ---- …

Member Avatar for crunchie
0
366
Member Avatar for jozz3

I'm writing a query that will produce the athlete's id, their name (first name and last name combined into one column), the total number of games they have participated in, and the total number of medals they have won. This involves a number of tables. In one query, the number …

0
70
Member Avatar for sophisticated19

Hi I 'm trying to develop a database whereby all information input via vb 2008 will be saved into a microsoft access database. I've tried to populate a few information. The data was saved at that point, but when i reopen my system the next day, all the rows are …

Member Avatar for marketingmaniac
0
175
Member Avatar for arctushar

Is there any way to convert microsoft access database to mysql data. Please help me

Member Avatar for appnub
0
255
Member Avatar for alex k

Show the details of sales orders which are paid more than 14 days after the date of the sales order. SQL: SELECT SO.OrderID, D.DistributorID, D.FirstName, D.SurName, SO.OrderDate, P.PaymentDate, P.PaymentAmount FROM SalesOrder AS SO, Distributor AS D, Payment AS P WHERE D.DistributorID=SO.DistributorID AND SO.OrderID=P.OrderID AND DateDiff('yyyy',PaymentDate,Date( ) ) - DateDiff('yyyy',OrderDate,Date( )) …

Member Avatar for bill51
0
90
Member Avatar for Sinha's

sir,i i have two date columns today_date and doj_date.both of them are varchar data type.now i want to update today_date='01/06/2010' to '01/04/2010' where doj_date='01/04/2010'.that means only the month column. ihave used the following code update installment_scheme_customer set substring(today_date,4,2)='04' where substring(today_date,4,2)='06' and substring(doj_date,4,2)='04' . but it is showing error like this …

Member Avatar for bill51
0
114
Member Avatar for jbrown72188

I have a simple form in which i have a contact name combo box. The combo box gets info from a querry (name, contact number 1, contact number 2). I want the name to display in the combobox (which it does) and then contact # 1 and 2 to display …

0
98
Member Avatar for thosecars82

Hello there I have this question. I have a PC with an old Pentium 4 and Windows XP installed on it. This PC has only 512MB. The Windows explorer's window gets really slow, almost stuck, whenever I browse "my images" folder inside of "my documents" folder. This "my images" folder …

0
116
Member Avatar for linlives

Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 9:56:16 AM, on 28/06/2010 Platform: Windows XP SP3 (WinNT 5.01.2600) MSIE: Unable to get Internet Explorer version! Boot mode: Normal Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\Ati2evxx.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\svchost.exe C:\Program Files\Common Files\Symantec Shared\ccProxy.exe C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe C:\Program Files\Symantec Client …

Member Avatar for cottom
0
170
Member Avatar for Chofi

I've been having one problem after another since yesterday morning. The problems started with notifications that an application could not be executed, because the file is infected. I ran Malwarebytes Anti-Malware and that seemed to do the trick, at least until this morning, when problems started showing up. In order: …

Member Avatar for cottom
0
361
Member Avatar for awmantonio

Hi everyone! I have an installment payment program which have Hijri date (Saudi Arabia) and I already have the code for it's converter inside the forms (using datetimepicker for the Gregorian & maskedtextbox for the Hijri). I'd like to know how can I convert or produce the corresponding equivalent Hijri …

Member Avatar for lolafuertes
0
793
Member Avatar for elavip

Hi, please help me get rid of this nuisance. It opens sometimes in the background, or with an ad or annoying sounds. Logfile of Trend Micro HijackThis v2.0.4 Scan saved at 12:57:18 AM, on 22/09/2010 Platform: Windows XP SP3 (WinNT 5.01.2600) MSIE: Internet Explorer v8.00 (8.00.6001.18702) Boot mode: Normal Running …

Member Avatar for anhbloginc
0
264
Member Avatar for jmainzer

i have done hijack this and the report follows Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 22:00:40, on 18/09/2010 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Boot mode: Normal Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\Ati2evxx.exe C:\WINDOWS\system32\svchost.exe c:\Program Files\Common Files\iS3\Anti-Spyware\SZServer.exe C:\Program Files\Trusteer\Rapport\bin\RapportMgmtService.exe C:\WINDOWS\System32\svchost.exe …

Member Avatar for crunchie
0
280
Member Avatar for zbibliophile

This is my first SQL project. An Access database was converted to SQL Server 2005 Express using the DTS utility. The old AutoNumber fields were automatically converted to int identity not null fields. However, when attempting to INSERT a row, such as the following ASP code, [CODE]Conn.Execute("INSERT INTO tblAdmin3 (fldA3Username,fldA3TimeIn,fldA3Date) …

0
85
Member Avatar for pwb72

Hello. I'm running Norton Internet Security 2009 on WinXp with SP3. Two days ago, I checked my Intrusion Prevention log on Norton and found the following enrty: An intrusion attempt by PAULSHP was blocked. Application path \DEVICE\HARDDISKVOLUME2\PROGRAM FILES\MOZILLA FIREFOX\FIREFOX.EXE Risk Name: HTTP Misleading Application Download Request Attacking Computer: PAULSHP (192.168.1.2,1219) …

Member Avatar for crunchie
0
651
Member Avatar for Anila S

I am using VB & Access to create a program for a clinic. I want to create a Report. The Report is - Toal quantity of each medicine received & Issued. I have created the Table in design time & in runtime contents in the table are deleted and new …

Member Avatar for bmpvkm
0
196
Member Avatar for zachattack05

I have been reading through a rather lengthy Microsoft document regarding UX (User eXperience) design and standards. There are many great suggestions that I have started to adopt. But something occurred to me last night while working on my solution and I wanted to solicit some ideas and possibly have …

Member Avatar for Diamonddrake
0
108
Member Avatar for bloodlust25

good day everyone! im a 19 year old noobie and i really need your help right here... im not sure if im in the right category but im hoping someone could help me here... when i log in to my account in normal mode, everything is [B]black[/B] (no wallpaper, not …

Member Avatar for benmar
0
921
Member Avatar for BrentA

Hi, Helping a friend with their computer. They're currently having a problem accessing internet. In Internet Explorer they get message "Internet Explorer cannot display the webpage". Can only use Windows Messenger on internet. A couple days ago started getting all kinds of porn pop-ups. * Ran Windows Malicious Software Removal …

Member Avatar for crunchie
0
342
Member Avatar for kjet1

I am trying to create a switchboard button in Access 2007 that will open a password input box as a security for a form. The switchboard button calls a macro which will then invoke a macro to run the following code: [CODE]Public Function Password() Dim stDocName As String Dim stLinkCriteria …

Member Avatar for kjet1
0
165
Member Avatar for zachattack05

Having a problem here...not sure if it's something simple or not. I'll be honest, threading is new to me so I'm not quite sure what the problem is here. Let me explain the problem first and then I'll post some code. I have a method that runs in a wizard …

Member Avatar for zachattack05
0
165
Member Avatar for ja0

Hi, I am just new using the Microsoft Application Blocks .NET. I am using a custom one... The problem is that when I call the SqlHelper parameter as "SqlHelper. " it only shows to me "Equals" or "ReferenceEquals". Why I can get the others...? [CODE]public void ExecuteNonQuery(SqlCommand sqlCmd) {...} public …

0
119
Member Avatar for FeralReason

Not sure if this is the right place to post this. I've built a number of websites but have just now been asked to provide a password protected page that allows different customers FTP access to download files. I feel dumb. Having never done anything like this before. Obviously I …

Member Avatar for pritaeas
0
204
Member Avatar for awmantonio

I have program in VB.NET 2008 where I want to update the premamt cell value in the tblPrem Access table, where the premno is the maximum (autogenerated as 1,2,3...), but only within a specified set of common numbers in a column (contno) I am currently saving. This contno is from …

Member Avatar for awmantonio
0
110
Member Avatar for Abbernacki

I am attempting to create 2 fields that will create decimals so that I can take these decimals and create a percentage in a new field. Here is what I have and I can't seem to get the errors gone. [code] WOAVG = IIf("[WOIssued]=0", "", Val(Nz(WOCompleted, 0)) / Val(Nz(WOIssued, 0))) …

0
75
Member Avatar for dhughes1074

I am using a shared MS Access database where I set the custom properties each time a user opens the front end, but for each property I am setting, they are being deleted by Error 3167. This has only started happening once the DB is being shared, but the code …

0
63
Member Avatar for mio_user

Please help I'm on the verge of tears. 1) I cannot open most of the programs in my computer i.e. iTunes, My Computer, My Documents,Control Panel. A blank window just pops up and hangs. 2) I cannot 'Save As' files from the internet into my computer either. If I try …

Member Avatar for crunchie
0
407
Member Avatar for carmenjulia1958

I need to make 2 tables for my computer class one would be the suppliers the otherone the products and I can't seem to get it started can you help me

0
63
Member Avatar for Majaheni

Hi guys can anyone help me I would like to put files like application forms and pictures on my site to be available for free downloads. I have got no idea how to go about, can someone help me with the code. Regards Majaheni

0
85
Member Avatar for tcsikany

I am having trouble getting this to work in a subform My Form is called frmFacilities My Subform is called QAMain subform The first combo box in the QAMain subform is RiskLevel Its Row Source is: SELECT tblRiskLevel.RiskLevel, tblRiskLevel.Description FROM tblRiskLevel ORDER BY tblRiskLevel.RiskLevel; Its Event is: Private Sub RiskLevel_AfterUpdate() …

0
76
Member Avatar for hiproverbs

Good morning. I read and followed the instructions posted on this site. I ran the Microsoft Malicious software removal tool and it identified the Alureon.h virus. I could not fully delete the virus as I was unable to access the Internet and get the rest of the manual steps to …

Member Avatar for crunchie
0
175
Member Avatar for MARKAND911

I have made an application with MS Access 2003 as my database. I made its setup and installed in a pc which MS Office 2007 installed in it. I am getting an error of "Microsoft.Oledb.Jet.4.0 resource not found". And my setup is not working. What to do now?

Member Avatar for MARKAND911
0
87
Member Avatar for weasel7711

I am not really looking for anyone to hold my hand through anything, but I am looking for someone to direct me to meaningful data/literature on the subject be it books/websites/videos/etc. I work for a small family business that repairs specific types of production machinery. We have a database that …

Member Avatar for weasel7711
0
192
Member Avatar for kingster113

I'm having trouble trying to update or delete records from my database. Basically, I have a datagridview(DGV) in my form and the following is what I wanna do. The user could directly change/edit the values in the DGV and just click the update button to update the database. And the …

0
111
Member Avatar for deanem

For our homework in our Computer science class, we were tasked to research by asking expert advice on database forums. We were first asked to download Census data to be analyzed using Microsoft Access. The data contained facts about 1% all people living in large US Cities at the time …

0
74
Member Avatar for thakkar2000

My computer is infected with some sort of malware called AntiMalware Doctor. This is like a scanning program that appears to pop up and scan my computer. It also has a windows security logo that pops up on my taskbar. Aside from getting scan popups, the main problem is that …

Member Avatar for crunchie
0
215
Member Avatar for Lord_cheese

Right, I'm new here so many appologies if this is a duplicate thread. I cannot open McAfee, MSN and various sundry programs. I've done the normal with SpyBot (love that program) and have no positive result to speak of - basically, I'm flumixed. It may be down the amount of …

Member Avatar for crunchie
0
169
Member Avatar for bubba-bo

Hi, I am having trouble with a question and am wondering if someone knows where I am going wrong. I am to list the patients of a hospital (persons that have been admitted) that have a next of kin listed as a staff member. I am to list the patient's …

Member Avatar for macca21
0
86

The End.