[microsoft-access] Forum Topics

Hi I want to convert Sql Server Database to Access Database , I have one database and it has different tables and view also. please help me how to do this ?

Hello, everyone, My question deals with Excel, and not Access, but I understand they should be roughly the same. I have an Excel worksheet which contains several tables. The tables are actually named ranges; basically, I grabbed an area, gave it a name, and -voila!- it is a table. Until …

HI guys, I have finish my project in vb.net and publish it without errors. The problem is this: As my project finished installing in the pc, an error occurred saying that the path where should be my DB Access is not there. Although I manage this problem by manually copy …

[B]SELECT staff.StaffNo, semester.SemesterID, teach.SubjectID, teach.Sub2, teach.Sub3, teach.Sub4, teach.Sub5, teach.Sub6, teach.TeachLoad, (IIf(IsNull( teach.SubjectID),0,1) + IIf(IsNull(teach.Sub2),0,1) + IIf(IsNull(teach.Sub3),0,1) + IIf(IsNull(teach.Sub4),0,1) + IIf(IsNull(teach.Sub5),0,1) + IIf(IsNull(teach.Sub6),0,1)) * 3 As teach.TeachLoad, FROM (subject INNER JOIN (staff INNER JOIN teach ON staff.StaffNo = teach.StaffNo) ON subject.SubjectID = teach.SubjectID) INNER JOIN semester ON staff.StaffNo = semester.Staff[/B] i …

How to make or set this as autonumber in msaccess-vb database? from 00-00-00 up to 9999-9999-9999 how to make that code to become autonumber? and what code can i use in my database when the new entry is equal to existing ?(The same primary key)

I am writing a video program, everything works fine except I am often (ie most times, but not [I]every [/I]time) getting the following error: Unhandled exception at 0x6076fde0 (msvcr90d.dll) in javaw.exe: 0xC0000005: Access violation reading location 0x0a450020. I have tracked it down to this function: [CODE]//fill the buffer from data …

Why my code in my VB-access database is not working. my add code is not displaying the inputted data it only displays the gridline in datagridview. I already connect the database access file. What's wrong? Can anybody help me? thankz.

Hi. so i'm using ms access 2007 as a database, i have here a table of TRANSACT IP which has the following columns of Transact_ID, IP_ID, Date, Time, Average, Min, Max. i have to produce a report in which i have to query from this table with the follwing format: …

guys How do you Create Database in MS Access Using Oledb in vb.net?

Hi, There is something wrong with my code. I can't seem to access the database anymore not can I add new data information. I am suppose to create a registration form with username and password. Then save it to a database on MS Access. Then login using the login form. …

How to make the form size automatic setting the size equals to the screen. or Maximize the whole form including the form components.

Hi, I have made simple database in MS access. I want the front end for that database which can be easy to use the database for 3rd person. Can anyone help me. Saroj

Hello I am new to ASP and Access Databases really as well. I primarily use PHP and MySQL/Postgre.I work for my university in web admin department and due to rather sloppy coding in the past by workers have to rewrite an ASP form that writes to an Access DB. I …

Hello, I have just started using databases, but I am totally stuck. I made a database and table using MS Access. The table has three columns. ID, Code, and Letter. Basically, the Code column stores a number for each letter (eg. 1 = A, 2 = B, 3 = C, …

Respected Friends.. I need help from your side.. Im using Visual Basic 6.0 with MS Access, I wish to create a automatic serial number for my program, It will show HITE001.. HITE002...HTTE003... same time it will show in form load stage it will automatically show in combo box( last record …

I use Docmd Open query to open one append query in the script that has another code in it. When I run the script, this option will opo out: "You are about to run an append query that will modify data in your table" "Yes/No" If I answered "Yes", the …

I am receiving my secure WiFi from a distance and would like to set up an access point to strengthen the signal at the receiving point. My current setup is a D-Link Randbooster wireless N Router with WAP security. My Belkin wireless N router has the ability to be set …

Hi I am new to VB.NET but for my final year project have started a system for childrens daycare center. I want to create user accounts which I think I should be able to do in acess. How do I link this to VB.NET? is it hard? what will vb.net …

Yesterday mom mom got a nasty that is not allowing her to access anti-virus sites for updates or downloads. I found some mirror sites and stuff, and ended up getting Malwarebytes, Spybot, the Stubware and HJT. I will post the HJT log here in a second, IVe tried all kinds …

Hi! I have a vb.net project on a jump drive that connects to an Access (2003) database (located on the jump drive). My problem is when I change computers, I have to change the drive letter the jump drive is located. Currently, I have the following code and have to …

Hi there, I got this annoying problem... I have to create dynamically an image control that has got to be accesses later through javascript. In other words, I got an image that was created in the page code, and using javascript I got to be able to work with it …

Can you help us for our project in creating a daily record transaction? Do you have any codes out there or samples, and help us in connecting it to the database thru Microsoft Access. Your feedbacks are highly appreciated ASAP.

Greetings. I have a question regarding MS Access Me.Filter. In short, I am building a personal database for my CD and DVD collection and I have a few CD's that start will a number instead of a letter - such as the band, 3 Doors Down. On my form, I …

hey guys i really can't solve this problem, hope you can help me. the problem is, i use this codes to get the data type of a column from an access database Form12.ListView1.Items(j).SubItems.Add(myData.Rows(i)!DATA_TYPE) but what displays in my listview are numbers like (130 , 3 so on..). How can i …

hey guys i really can't solve this problem, hope you can help me. the problem is, i use this codes to get the data type of a column from an access database [code] Form12.ListView1.Items(j).SubItems.Add(myData.Rows(i)!DATA_TYPE) [/code] but what displays in my listview are numbers like (130 , 3 so on..). How …

Hi All I got lots of help from this site Here I am facing 1 simple problem but can't point it out, So I need urgent help from you all. I am using Windows 7, VS C# 2008, Access 2007 My Access database have 1 photo column of OLE Object. …

So I've been reading a lot about Access 2007, but all the books and tutorials don't talk about the stupidly easy questions. I have a SharePoint 2007 running on a server that my team has access to. From what I've read, SharePoint can easily display information and generate reports based …

search data in listview by using a textbox, this is my code sample cos i have been able to display data in access on listview so i want to perform a search function... Imports System.Data Imports System.Data.OleDb Public Class Form9 Dim Passport As String = "" Dim searching As Boolean …

Hi, I have this database based on this logic: There are projects in a company. In each project, different employees different roles. One employee could have different roles in a single project. Also, can work in different projects at the same time. Some projects could be added but role of …

Is there any ways to allow the text box in a report to show the lastest date from the database? For example: 24/2/2007 15/4/2009 21/6/2009 14/7/2010 13/10/2010 i want the text box to have 13/10/2010, which is the lastest date out of the 5 date(which I have more in my …