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 … |
The End.