1,557 Topics
|
|
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' … |
|
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 … |
|
|
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) … |
The End.