[microsoft-access] Forum Topics

Take line below which is in batch file and convert it in C# so that I don't have to create a seperate file. Thanks! Any suggestions? I have spent way too long on this. Odbcconf /a {CONFIGDSN "Microsoft Access Driver (*.mdb)" "DSN=NexTest_CDMA_2009|Description=NexTest_CDMA_2009|DBQ=C:\prod\database\nextest_CDMA_2009.mdb"}

[CODE] //copy database files to target directory string fileName = "test.txt"; string targetPath = StaticFormInstances.choose.txtbxTargetDir.Text; string sourcePath = @"\\il93fil48\3GSM\release\testapplication_REL_01_00_09\database"; //Use Path Class to manipulate file and directory paths string sourceFile = System.IO.Path.Combine(sourcePath, fileName); string destFile = System.IO.Path.Combine(targetPath, fileName); //Create a new target folder if it doesn't exist if (!System.IO.Directory.Exists(targetPath)) { …

My projects aim is to create an application that do syntax checking of javascript and html. I am using Microsoft.Jscript reference to help in the checking. Here is the code that I used to get the .js file and do a compilation so that it can generate errors if there …

I'm hoping someone can help me here. I have 2 tables in a access database. I'm trying to join certain data points from both, simple. I've done a few joins already for this site. But the problem I'm having is this one seems to be destined to annoy me. [code]sql …

[ATTACH=right]15792[/ATTACH]Google has been attempting to break out of their search engine based box for quite some time by presenting challenges to some of the IT world's biggest names such as Microsoft and Apple. Now with the new App Inventor that Google has launched for Android it is giving developers more …

Hey guys. So I saw some posts on here from years back about people having trouble with this. Basically Symantec Email Proxy keeps popping up saying stuff like "your email message was unable to be sent..." its some kind of trojan or virus. Can anyone help? Here is my Hijack …

i am writing an application on my pc considered as client, to insert record on a microsoft access database on another pc that u can consider it as server, that has static ip address remotely.i can ping the remote address of the pc that i want to access without problems.the …

I'm having the same problem as a previous post. No sound (wav sound bar gets lowered to min) and hidden IE windows. Cannot kill IE task (comes right back). Neither AVG/Avast/MalwareB detects anything. Ran ESET (offline) and it found the following: C:\Documents and Settings\Craig1\Local Settings\temp\447511515.exe a variant of Win32/TrojanDownloader.Unruy.CD trojan …

I'm learning C# on my own (I know C, Pascal, and about 8 proprietary languages) ... I'm stuck with VS2005 Pro (no budget) so I can't upgrade and I can't use Linq. I'm using Access just for simplicity at this point. What I'm trying to do, is what I've done …

Hi all, I'm working on conference room booking software with MS-Access as the back end. I need to retrieve the records which doesn't clash with the already booked dates. I have a table called conference_room_status which has the fields Conference_Room_Name | BookedPerson | DateFrom | DateTo | TimeFrom | TimeTo …

i hope i'm doing this right. Malwarebytes' Anti-Malware 1.46 [url]www.malwarebytes.org[/url] Database version: 4275 Windows 5.1.2600 Service Pack 3 Internet Explorer 8.0.6001.18702 7/5/2010 8:52:15 AM mbam-log-2010-07-05 (08-52-15).txt Scan type: Full scan (C:\|D:\|) Objects scanned: 260308 Time elapsed: 3 hour(s), 34 minute(s), 12 second(s) Memory Processes Infected: 0 Memory Modules Infected: 0 …

Hi, A bit of a tricky question, so I will try to explain everything in its fullest. I am trying to replicate some of the Terrarium work done by the Microsoft guys, but I dont want to look at any of their code. Anyway I have my base class which …

Greetings! I'm suddenly having a problem accessing web pages in Internet Explorer v7.xx. Getting error message for all web pages: "Internet Explorer cannot display the webpage". File->'Work Offline' did not accidentally get checked. NOTE: I am able to log on to Windows Messenger, just not Internet Explorer Here are the …

[b][i]"Every time we raise the bar, you-know-who stoops to a new level." - Novell[/i][/b] - Novell is a powerfull network operating system. Response: Its not out dated. In fact, Microsoft stole the .NET idea from Novell (Novells ONE Net Strategy)! - Novell requires a bulky client for conectivity Response: Nope! …

Function selectDB17() Dim cn As New SqlConnection Dim cmd As New SqlCommand cn.ConnectionString = ("server=EKS-HQ;database=BGB;user id=administrator;password=admineks2005") cn.Open() cmd.Connection = cn cmd.CommandText = "SELECT KODSTATE,USERID,PASSWORD,KUMPULAN FROM USERID" Dim lrd As SqlDataReader = cmd.ExecuteReader() Try Do While lrd.Read() If lrd.HasRows Then a = lrd("KODSTATE") b = lrd("USERID") c = lrd("PASSWORD") d = …

Hi all I am trying to insert a record into MS-Access database using VS2008 as front end and this is my code i am using to connect to the database. login.mdb has two tables(login,schedules) [CODE] Dim con As New OleDb.OleDbConnection Dim cmd As OleDbCommand Dim myquery As String Dim count …

hi guyz! I've recently finished a database project in Access 2003 and have been asked to deploy it to network machines with Access 2007. the prblm i have is that the users r unable to add and update the records at the same time. how can i ensure that simultaneous …

Hello everyone, I am currently doing a treeview control in asp.net. I want to [B]load the database from MS Access into my treeivew[/B], but I don't know what should I type in my .apsx.vb file. [B]Please help me with the codes [/B]to make my treeview connect to the MS Access! …

Hi I have a very simple database which lists students who have went on exchange both in and out of our university. I am able to do a simple user entered query along the lines of [Enter university] or 'between [enter year] and [enter year]' but here is where it …

[i]I found this in a few different places around the 'net - hopefully it's helpful:[/i] [font=Arial][size=5][color=#0000ff]Correcting System Hang at Startup [/color][/size][size=2]If your system hangs about 2 or 3 minutes at startup, where you can't access the Start button or the Taskbar, it may be due to one specific service (Background …

I often see people asking the same question over and over, "How do I learn to program, and where do I start?" Some people may take that question to the next level by asking, "Which language should I learn first?". The answer to those questions is fairly simple, but also …

Hi There Is There A Way To Make Access File As Exe File Thanks In Advance

Pleae help screens lock up. Ie 8 closes slow like unpainting Scan saved at 8:29:11 PM, on 7/8/2010 Platform: Windows XP SP3 (WinNT 5.01.2600) MSIE: Internet Explorer v8.00 (8.00.6001.18702) 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\svchost.exe C:\WINDOWS\System32\svchost.exe C:\Program Files\AVG\AVG9\avgchsvx.exe C:\Program Files\AVG\AVG9\avgrsx.exe C:\Program Files\AVG\AVG9\avgcsrvx.exe C:\WINDOWS\system32\spoolsv.exe C:\PROGRA~1\COMMON~1\AOL\ACS\acsd.exe C:\Program Files\AVG\AVG9\avgwdsvc.exe …

SCENARIO 1 : I have 3 projects in my solution: 1) Web Project (Presentation Layer) 2) Class Library Project (Business Logic) 3) Class Library Project (Data Access Layer) Following are the dependencies among these 3 projects: 1->2->3 (It means I have referenced PL in BL and BL in DAL. In …

A co-worker upgraded Microsoft Access 2003 to 2007 on three networked computers. The rest were not upgraded. On the non-upgraded PC's we are able to open the database. On the 2007 PC's the file path does not work. I checked the access Trust Center settings and they seem to be …

Private Sub cmdsummery_Click() Set wss = DBEngine.Workspaces(0) Set dbs = wss.OpenDatabase("Gagedetails.mdb") Set rss = dbs.OpenRecordset("tblGage") 'Set rss1 = dbs.OpenRecordset("tblopeName") Do While Not rss.EOF OSQL = "SELECT DISTINCT OpeName1 FROM tblGage WHERE Date =" & SQLDate(txtdate.Text) Set rss = dbs.OpenRecordset(OSQL) MSQL = rss("OpeName1") NSQL = "INSERT INTO tblOpeName (name)" & " …

Hi, I have an access databse, but the data is link to excel, so i cant changes the data inside access database. However, i just want to retrieve the data inside the access database using VB datagridview, but the system pop out an error said 'cannot find the input table …

Some background: I'm a programmer, not a network administrator, who has been asked to migrate some accounting software ([url=http://ioasoftware.com]Integrated Office Accounting[/url] version 3.2) from an existing domain (OLD_NETWORK) to a new domain (NEW_NETWORK). No-body at the office knows how it works under the hood. It is a split Access 2000 …

Can I require the entry to be +-5 mintues of the current time? Thanks

Dear Expert I have got a client with a small network between windows 2008 server and two XP Prof SP3. Folder on window 2008 was shared to be accessed by two users on windows XP. A QuickBooks program installed by a technician from QuickBooks on the shared folder to be …

Hi all I have Created a software using Vb.net and Ms-Access using VS2008. I am using ADVANCED INSTALLER to create a .exe Package and get its deployed. It works well in my machine but in the Destination machine , I get an error as shown below: [CODE] System.IO.FileNotFoundException: Could not …

Hi, I've been puzzling over how to connect these tables on Filemaker for hours, and hopefully someone can point me in the right direction. I'm trying to connect the tables in such a way that when I select a student, and a specific course, I will get all of the …

Hello, I created a database in Access many years ago before I realized what a mess lookup wizards would make. Does anyone have any good ideas or resources of how I can keep the information but undo the lookup wizard? I have created new tables with the same information and …

So, a single user application, all data is local, no remote access .... If a go with an Access file (DB), from the user's perspective, they simply install the app and they are good to go. Is it the same if I go with a SQL DB, or do they …

For the last couple of weeks, everytime I use IE, pop ups keep opaning new windows even though I have the pop up blocker on. This is driving me insane. I have run numerous virus check and cleaned them off but it still happens. Please can someone help?? I have …

1 at first my comp's firewall kept turning off and lagging insanely and if it did, it would "not send error/send error" thing would pop up everywhere, and while doing nothing, like as if i was typing in notepad, avast would pop up and block a "trojan horse" or malware, …

I was wondering what all files this program accesses, and any other info you could tell me about this program.. The program is in the link below. [url]www.thelandofoz.net/help/program.rar[/url] Mucho thanks in advance!! -DaJ4ck3L

I have got problem in updating the access database. THIS IS MY CODE // [code] Dim con As New OleDb.OleDbConnection Dim spl As String Dim ds As New DataSet Dim da As New OleDb.OleDbDataAdapter con.ConnectionString = "PROVIDER= Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Malai\Documents\database31.mdb" con.Open() spl = "select * from REMAINDERDETAILS" da = New OleDb.OleDbDataAdapter(spl, …

Hello. My mother-in-law is having an issue with her computer where anytime you go into a program, the keyboard and mouse will lock up and I can only do a hard reset (holding down the power button to turn off the computer and then turn it back on) to get …

hey, I have a table say 'Student' and it has the regular fields and a PK called 'stNo'. I ahve made a form to view/enter data for this. This is what I want it to do. When you enter a value into "stNo" if its not present in the table …

I have a web application that links to Microsoft Access and opens one of five databases depending on which button is clicked. The purpose of the web app is to open an instance of the database for an employee to use the forms that we've coded in the database itself. …

Hi, I know this sounds like a repeated question but the tips in other threads didnt quite help me, so thought of asking again. I have 2 tables 'tbl_AWB' abd 'tbl_flight'. Flight has the fields "FlgihtNo" (PK), "DepCityPort","DestCityPort", "DepTime", "ArrTime". tbl_AWB has fields 'FlightNo', 'DepCity' and 'DestCity'. The tbl_AWB is …

I didn't find any place to search to see if my question has been asked already. I am a student taking MS Access 2007. I created a report in layout view. I need to use conditional formatting but it is grayed out.Can some help me so I can use conditional …

I have found a tutorial that will teach me how to set up my first Database, but the first thing it tells me to do is right-click on the Data Connections Icon within Database Explorer and choose "Create New SQL Server Database" ... unfortunately, this option is greyed out, so …

I am very new to vb 2008 and have create a simple window forms application which link to microsoft access 2007 database. I build the application exe file already. The exe file is run well on my computer, but when i transfer it by copy and paste the whole folder …

Hello All, I am currently in the process of adapting an application that previously worked only with Microsoft Access to work with SQL server or Access. Previously, all database interaction was designed based upon using the XSD file to create queries (etc). I wasn't sure how to handle the new …

I would like to add code to open the form to the on click event of an unbound OLE object. I know I can easily make a button to open the form and place it in the form , I just thought it would be nice to use this shape, …

[COLOR="Green"]Hi, forums I'm not much familiar at access(and English too). And pleases give me the VBA code and needed property settings to my OLE unbounded object control( step by step). 1. my access version is 2007 2. database file name is 'tense db'. 3. i created my OLE unbounded control- …

[code=sql]Select * from Merit where cat='GEN' order by snum[/code] in this querry, i hav a problem as "No value given or required paramenter" due to snum fiels the Datatype of snum is Numeric

Hello Every one! i'm trying to encrypt my ms access database using the encrypt tool in ms access2003. After i encrypt it, i want to decrypt it, using visual basic so that i could run my visual basic forms. Can somebody help me how to do it? Thank you very …