1,597 Topics
 | |
| | hi i have this form, and a subform datasheet.i need to copy selected row/record from the datasheet to the corresponding textboxes. i have used this, but it will copy the whole column title and the record, and i dont know how to separate the string of copied data into textboxes, … |
| | I've looked all over the internet for a suitable solution to my problem, and I just can't fine a simple and effective one; so I hope I can get some help here! First off I am programming a hotel booking system for my college computing project. This consists of a … |
| | hi all hope some one can help me out im a php guy and ive got an application i want to make that will run on windows and ive never program for desktop before and i really need some advice. here is the scenario iv got my website with a … |
| | i wonder it possible or not to put video in access form ? if anyone know please answer if not, what about flash ? if can please tell me too . thank you very much  |
| | Does anyone know how to programically create an html document for an Access WebBrowser control? For instance, in Access 2010, to browse to a webpage, say [url]http://www.daniweb.com[/url], then assuming you have a WebBrowser control named "webBrowser", then you would use the following: [CODE]Me.webBrowser.Object.Navigate "http://www.daniweb.com"[/CODE] Now say, you want to dynamically … |
| | Hi I have a c# console app that calls some access 2007 queries. One of these queries throws an error "Undefined function 'MonthName' in expression". I understand that some functions that are available in VBA cant be called from c# and if i comment out the 'monthname' function the call … |
| | Ok, so after hours and hours of testing and searching online I'm almost convinced that this can't be done, but I'm asking here for help maybe someone can give me any idea as to why this isn't working. I'm doing this query: [CODE]SELECT * FROM( (SELECT t1.PAG5 from table1 t1 … |
| | I have done this query : Balance:[Medical]![Price]-750 but calculation total didn't show up , and it show up to enter parameter value? help me.... |
| | I'm running a structural analysis program in VS2010 which iterates through a loop up to 4000 times. The program keeps breaking on me around the 960th loop and gives the following error Unhandled exception at 0x0040cd1d in Structural Analysis Program.exe: 0xC000005: Access violation writing location 0x00000000. The error seems to … |
| | Hi, I am running this line of code to insert some data into table. I am using select case on one of the data. When I run it, this error was generated: "Syntax error (missing operator) in query expression 'CASE dbo_tblFinanceApp.UPADisclosed WHEN 0 THEN 'Undisclosed' WHEN -1 THEN 'Disclosed' END' … |
| | Hi, I am working on a project for work that requires the <%# Now() %> function output to be inserted into a text box field that passes it's value to an Access 2007 DB with the rest of the form data on submission. I am able to either make the …  |
| | I am using Access 2010 and have 2 tables: ORGANIZATIONS [id], [categoryID], [requirements], [address], [city], [state], [zip], [web], [person], [title], [phone], [fax], [email], [paperwork], [brochures], and [dateModified] LIST [ID] and [list] The data types are either text, number, attachment, memo, hyperlink, or date I have a form with a listbox … |
| | Haven't used this stuff in years since working at IBM and Compaq in the early 90s. Different career path. Need to fix a guy's access 2000 software by tomorrow -long story -totally corrupted - needs something from scratch and his pictures of screens. Don't have the time to program and … |
| | Hi all, I have a table where it stores Process. The Process has each processNumber which is unique, & the processNumber indicates the step of a procedure. My problem is, user request to add a Process in between existing processes. In other word the new Process overwrite the existing process … |
| | hi pls help me on this.. i'm using this code to get data from record: [CODE] MyNum1 = DLookup("[Outcome]", "Remark", _ "[IDRemark] = Form![SelectTxt]") OutTxt.Value = MyNum1 [/CODE] my prob is when the data in [Outcome] is null , access having error to still get the null value from the … |
| | i m facing problem while conencting with sql server mangemnet studio A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. … |
| | Do anybody know where can i find example of database management system all topic especially fast food restaurant(if possible). |
| | I have an odd issue. The company I work for has old databases that were built in Access '97. They've since upgraded to Access 2003, 2007 of course, and are in the process of upgrading to 2010, but a couple of databases still only work in '97. I'm tasked with … |
| | Hi people, I have created a form that allows me to search customers from a datagrid table which holds the information from the customers table. I use a textbox to enter the phrase to search for and a search button. I can find the records within the datagrid table but … |
| | I have a database that has a simple search form where you enter the 'Search Text' and then mouse click the 'Search' button and the results are displayed. Alternatively if the Enter key is pressed twice, first time to enter the text and tab to the 'Search' button, and the … |
| | I'm successfully importing a .dbf table into access using the get external data wizard. The issue is the data structure of the imported table. For instance, a filed with num(5) in .dbf will appear as double (without any field length) in the imported table in access. This limits onward use … |
| | hi i have a question in getting values from two table i ave two tables Table1 and Table2. table 1 have data and table 2 may have the same data as table 1 and more. and also table 1 may have the same data and some which is not in …  |
| | Hi I'm currently using vb6 and ms access for my database. So far the application runs good, but the rumor (or fact) that access are not powerful enough with multiple access and also it has low data limitation (around 2 Gb), it scares me. I don't want my clients to …  |
| | > Is it possible to convert older > version of FileMaker Pro > to Microsoft Access 2000 I suspect FileMaker can save its tables as .DBF; Access can use .DBF tables directly or can import them. Alas, I don't think you can convert any part of your application EXCEPT the … |
 | I hope you could help me with my documentation. Please help me to compare and give advantages and disadvanatges of the following based on your experience: MS ACCESS FORMS versus VB.NET STANDALONE APPLICATION versus WEB APPLICATION (intranet) for example : __________________________________________________________________________ 1.CATEGORY|2.ACCESS FORMS|3.VB.NET(WINFORM)|4.VB.net(WEB)|5.comments ___________________________________________________________________________ 1.DEPLOYMENT|2.fail|3.fail|4.pass|5.when deploying standalone applications,you need to … |
| | I have searched and cannot find out why my code will not update the database. The program stops at the mDA.Update(mDS, "temp_data") line with the following error: System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217904 Message=No value given for one or more required parameters. Source=Microsoft Office Access Database Engine StackTrace: at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] …  |
| | i try to make the running sum of quantity using query with a expected output [CODE]ID | Date_in | Date_out | Quantity_in | Quantity_out | Quantity_Run_Sum in01 |17/2/2011| | 300 | 0 | 300 in02 |17/2/2011| | 400 | 0 | 700 Out01 | |20/2/2011 | 0 | 100 | … |
| | Hi all. Not sure if this is the right forum, but it seemed the most appropriate from the list. I'm helping to develop a ghost-themed site. As it deals with an urban legend, we're pretty sure that kids will come across it, but don't want them to visit. There's really … |
| | please help me.. I don't know ho to make that. Thanks |
 | I think the title says most of it. How do I, in MS Access using VBA, get information from a workbook which I can then put in as a recordset in a table? I know that excel has an easy workaround for other excel workbooks, and I've read somewhere how … |
| | 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 … |
The End.