[microsoft-access] Forum Topics

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 …

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 …

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 …

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

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 …

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 …

Hi, I have a java program with quite a lot of classes. I'm facing a problem with accessing some variables from another class. May I know how to I access it? Is it possible?

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 …

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

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 …

I have just started writing C code in dev-c++. The programs are running fine, but each C program shows me the following warning: [QUOTE] [Warning] command line option "-fno-access-control" is valid for C++/ObjC++ but not for C[/QUOTE] The test program I used was: [CODE] #include<stdio.h> int main(){ system("pause"); return 0; …

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

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 …

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

Hi everyone Could someone please help me, I need to loop through all the records in a column in my access database, Currently my program only views the first record in the column and does not go any further, I tried a While loop but I get a NullException error …

Hello everyone.. I desperately need your help to tell me how can i retrieve the data that i've stored in an access db column and display it in a combo box in a vb2008 project? thank u in advance..

Hi! I am having a problem with the project I am working on. The project will have more than one query; however, I cannot get the simple one to work yet. I have a form with two text boxes and a button. I also have an Access database that I …

I am trying to develop a subroutine that will send an IM to a user. The idea being if the user is online, the code sends an IM to the user via communicator. If the user is offline, it sends an email. The code does work, in that it does …

Hello, everyone. I have a small program, and i want that program to show how much RAM the whole system is using, and i want it to show how much R.A.M my program is using, any ideas on how to do that? is it hard?