[microsoft:access] Forum Topics

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 …

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 …

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 …

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 …

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 …

how should i retrieve my images that i stored in column having Attachment datatype in access 2007 in my java program??

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 …

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))) …

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 …

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

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

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() …

i have a hard time in connecting my db to my project. cause i want my my cmdSearch_click() connect to my table EmployeeInfo and my cmdTimeIn_click() connect to my table TransactionTable in just 1 form and 1 ms access file.. is that possible?? thanks in advance for answering..

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?

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 …

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 …

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 …

i have made a program for work which is a logging tool which is just filled with text boxes and combo boxes I am tryin to link to a access table so the info I put in the logging tool goes straight into the access table even if the table …

I need a php script to count the values in ms access database and show them in webpage. The reason is i need to collect the inputted strings in the table so i can count which same text has more search.. please help..

HI I am trying to write data to an access table from vb.net. The code all seems to run fine but no data is being sent to the db though! the code i have got is [code] Dim itemcount As Integer Dim MyCn As OleDbConnection Dim sql As String 'Dim …

i want to get records from msaccess when the pin number start from 'twt000'. I am using one variable name is pinnumber to store the value. [CODE]String pinnumber='twt000'[/CODE] how to fetch records from msaccess database.[CODE]pst=con2.prepareStatement("Select * from pin_numbers where pin_number like '?*'"); pst.setString(1,pin); rs2=pst.executeQuery();[/CODE] Please any one help me.

Hey Just wanted to ask a quick question. i am using a MS access database. i have done my selecting and filling of the dataset. What i was wanting to know is there a way to look at the name of the Column where the data is in. I was …

Hi Expert, I already create a datasource name for my Access database. However, I failed to connect to that database using this code: Set db = DBEngine.Workspaces(0).OpenDatabase("dbsourcename", ,"DSN=dbsourcename;UID=MyUID;PWD=Mypassw") Could anyone help me please. Thank.

I want to fetch data from msaccess database using like. but my query not run. Here is my code.[CODE]String pin=cmblocation.getSelectedItem().toString(); rs2=st2.executeQuery("Select * from pin_numbers where pin_number like 'pin&????'");[/CODE]. But my query is not run. Please help me.

Can I get some assistance with the T SQL syntax required to use the contents of this combo box in a pass thru query in order to improve performance response time over the LAN [CODE] [Forms]![WELCOME]![FILTER_BUILDER].[Form]![Combo28] [/CODE] Apparently TSQL doesn't like the "!" from Access: [CODE] SELECT dbo_A_VIEW_LOWEST_LEVEL.contract, dbo_A_VIEW_LOWEST_LEVEL.[Profit Center …

Hi, I have a table Employee that has a coloumn EmployeeID, SupervisorID, and Active(values Yes or No).. I need to find the number of Active Employees(with Active as Yes) under each supervisor.. how can I write the query? I am using Access 2007. Thanks!

Hi I have 2 tables say A and B. Table A has EmpID, First Name and Last Name. Table has Award Recipient, Award Presenter ID(EmpID format). I want to write a select query where I want to fetch First and Last name of the Award Presenter from table A based …

Hi, Please let me know whats wrong with syntax of the following query, its written in MS Access format: Select count(*) from [Demographics/Job Data Table] D1 WHERE EXISTS (Select (*) from [Demographics/Job Data Table] D2 where [D2].[Supervisor ID] = [D1].[Employee #] and [D2].[Termination]=Yes) I am getting a syntax error message …

i have a problem in connecting in access 2003 here is my code Module Module1 Public cn As New ADODB.Connection Public rs As New ADODB.Recordset Public Sub connection() cn.Open("[B]Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Project Management\pm.mdb;Persist Security Info=false[/B];") cn.Open() End Sub Public Sub OpenRecordset(ByVal sRecordset As ADODB.Recordset, ByVal sString As String) sRecordset.CursorLocation = ADODB.CursorLocationEnum.adUseClient sRecordset.Open(sString, …

Hi all...need help from u all...i already develop system using VB.net with Microsoft Access 2003 as my database. when i running in Windows XP it's working great but when running in Windows 7, i can't insert into it...can anyone help me plz

I am having a small problem with dataset problem defination is: _____________________________________________________________ System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217843 Message="Not a valid password." Source="Microsoft JET Database Engine" ________________________________________________________________ and My connecting string is: _______________________________________________________________________________ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="D:\Shop Inventory\database\DATABASE.mdb";Persist Security Info=True;Jet OLEDB:Database Password=123456789" ________________________________________________________________________________ WHERE the password I added is right but whenever I try …

I have created an Access (2010, but converted to 2007) database and I am building a front end to it using C#. I can't figure out how to provide the user with the means to create a new instance of that database. The idea is that the user can create …

Anyone please help me! I would like to learn and create a crystal report with ms access database and view it with crystal report viewer for our special project in school, I have no idea and I tried to look for some tutorials in web but I didn't saw a …

Having Trouble inserting into Access Database. The following attachments are: Capture --> Actual Code Capture2 ---> Access Database Capture3 --> Error Message [CODE] public string saveTrace(Trace aTrace) { //get values from Transaction instance string traceID = ""; decimal amount = aTrace.getAmount(); string transType = aTrace.getTransType(); string dID = aTrace.getDealerID(); string …

Hello everyone! I have a table in acces database named Product(name1(string),name2(string),name3(string),name4(number(decimal))). In a form I use combobox to choose a product after [B]name1[/B] and when I click a button I want to fill some textboxes with the others values of that product. How can I do that? please help me! …

My name is Steve and I am a GIS freak and geek from the days of actually using a pencil and paper but have graduated to the digital age. Look forward to getting and giving some help. My strong points are ArcGIS Models, MS Access, and other Microsoft stuff, my …

hi i wanna combine all three column values in column... i want some thing lik this PartNo Stock Obsolute Replaced order part no 12345 10 12345 12346 10 12346 12347 11001 11001 12348 11002 11002 12349 12349 Empty 12350 12350 HELP ITS URGENT!!!!!!!!!!!!!!!!!

Hey all, I am currently fiddling around with SQL/Access statements in C# and created a very simple dictionary program that will search for the words depending on the length of each text entered in one text box. So when the user presses the search button it the program will search …

I need help for connecting my 'Access' database to asp.net website. Coding is in C# . I was working on making a registration page, but since i was unable to connect, I tried a test code for login and it ain't working :icon_cry: I am using the following code for …

i am new with vb and this is my code that i work with.. there are errors in my code to view data from ms access into data grid.. can anyone help me to solve this problem? thanks... Imports System.Data.OleDb Public Class frmView Inherits System.Windows.Forms.Form Dim DB As OleDb.OleDbConnection Dim …

Good day, I have been trying to add a new record to the Access Database that has already been connected to the Visual Basic Application (Using Visual Studio 2005) that I have been developing, using the DataSource and the DataAdapter objects, though I'm able to add an Insert query and …

[B]--URGENT--[/B] I have created a database in Access 2007 ([COLOR="Red"][B]*.accdb[/B][/COLOR]) format but im not able to connect it to VB6.0 project to access the data. i know how to connect using Access 97 / 2000 ([B][COLOR="Red"]*.mdb[/COLOR][/B]) format but how to connect and use DML queries on a Access 2007 file …

hi all! I need to make a form in Ms-Access as EXE file. So that the file can be runned without opening Ms-Access. I know that, it is possible in Vbasic but whether it is possible to do in Ms-Access. Thanks

Hi, I have a login screen where user enters their name and password. The username and password are stored in access. Then when the user opens forms i need their username to appear in the form. Can somebody give me code for that please. Thanks Krs

im a student of softare engineering corses..i hav a problem.how to insert document that we fill in the table ms access.. tq.

hi there, my name is brian. i am doing a final year project for school and i need to come up with a school databse using microsoft access. can u al give some ideas as to what should be included in the database. eg. what it should be used for...eg …

Hi all: I am working with MS Access and developing a form to let user to enter the caller's info into the database. Let say: Bob first time called in and the user entered all his personal information into the database, let say, next day, Bob called again; for time …

Hi, I don not know how to properly code with VB but I did write scropt with winbatch. I have a MS 2003 Word app that I want to add seven drop down list box's into it that will populate the main list box from the database then once a …

pls does anyone of you help me how to connect vb6 to access.i have a system wherein my pc can receive and send sms.I used nokia cp,and dku50 cable to connect my pc and cp.I want that the text will be store in my access,so that i can see the …

Hi experts out there, I have a program where the backend is access database. I was able to run the program in user's pc after i placed it at C drive. After that, i placed it in the server and created shortcut to the.exe, the program ran. But, when i …