1,597 Topics
 | |
| | Hello all, I'm using MS Access as my DB for a very simple web site. Everything was running nicely till all of a sudden I can't inset rows into any table in my MS Access database. In my tests I even created a fresh and clean table1 with one number … |
| | ok. i am woking on a web browser for a friend of mine. everything works except for the favourites / history code, which is giving me an Unhandlded access violation. i have tryed using [CODE]Try[/CODE] but then it gives me a file not found error when attempting to append the … |
| | I want my Access form to return a result based on data entered in a text box and combo box. I have 4 queries: qryA, qryB, qryC, qry D I want the user to be able to select A, B, C, or D from a combo box and then enter … |
| | Can anybody advise on the way to set up an ODBC connector for a desktop MS Access MDB Front End to connect to an MS Access MDB Backend on a remote (internet) location? Thanks Max |
| | Hi, I have ms access as front end software to be used for employees in my company. Every user will have different access to the contents inside based on their role. For example, manager will have different access from the others. First attachment is the image for limiting user access … |
| | Good evening everyone! I am working on a documentary and I have 10 000 short videos to sort! I am looking for a database/software program which will help me. In brief I want to attribute several categories to files, in order to find later (when I will make the documentary) …  |
| | 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 … |
| | I have a small company Database that tracks our repair orders. I have a query that I would like to execute based on criteria that the user inputs. I am new to VBA so most of my code is based on google research. I took a technique of wrapping my … |
| | [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 … |
The End.