1,597 Topics
 | |
| | Hi- everyone. Good morning. I have an access data table and I designed a form in ms vb 6.0 Placing lavel, Textbox, Command button, datacontrol for connecting with ms access table. Thus I succeed and the form is showing the records from ms access table. but now I want to …  |
| | Hi I spent the morning hacking together the basic components of my own MVC framework, which currently only parses a url, loads the class and calls the right method... Because I obviously dont want someone to be able to access the 'add/remove' methods associated with future classes, i need to … |
| | It seems that leaving for 5 days for a holiday has taken a toll on my internet accessing capabilities. Before i left everything was fine and dandy on my wireless modem. i come back, kaput. heres the sitch... Main PC (connected to modem) -------> My PC (Wireless reciever to main) …  |
| | I have a table in Access with multiple foreign key fields. I would like to populate this table from Excel with SQL. Hardcoding values works fine: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES (x,y,...)[/CODE] Nesting SELECT statements like this fails: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES ( (SELECT f_key_x … |
| | Hello everyone I currently have a form w/ two text boxes so that the user may enter the dates they wish to display in the report. The report consists of multiple clients per page and the date that they purchased an order. What I have under the button sub procedure … |
| | I design A wed page in html. and An Access database. please show me how do I link them |
| | I'm working on my first game in C++ and SDL. The game compiles and runs perfectly on both my boxes (Arch Linux and Windows XP). When two of my friends were to test the game, one of them (running Windows Vista) said his machine BSoD'd every time he ran the … |
| | Hi All, My knowledge of databases and Access is almost zero but none the less I have to try and solve a problem with a small home-grown Access database and hoping someone can help. I've done many searches and can't locate what I thought would be an easy answer. There … |
| | Hi. I've made a record on a table which would be used as a comparison to other records in the table. for example.. table: recordID 100001,Company Name recordDI 999999,Company Name i want to compare record 1000001's Company Name with record 9999999's Company name. How do I do that? thanks! |
| | I hav created a database using a windows application form in vc++ i can add and delete entries in the database.. but my prob is that the database s nt getting updated.... it says that "[COLOR="Red"]no value given for one or more required parameters[/COLOR]" my update code s as follows … |
| | Hi GUys Just wondering if any one can help me out. Basically i wnat to create an SQL query which will take the input of the user and query that specific variable: e.g the user enetrs in a field, the value entered is assigned to variable "srch", then in my …  |
| | Can anyone provide a quick solution for INSERT the entire excel sheet into a access database. This is a click button event that just opens a excel sheet in a windows form. What I like to see is some example how to INSERT the same excel data into a access … |
| | hi every1 i m creating a simple ms access project. i created a report ,when the user opens it,it opens a query which askes user to enter name. the user enters the name and the report by that name generates. is there a possibility that when the name is asked … |
| | Hi, Can anybody tell me how to make a button in an access form that connect me to a website? |
| | Hi all, Now I've spend hours on google without findeing a solution to this small problem. I have a running program that uses an access database as datasource. When startet it opens the mdb in exclusive mode. [B]Now the problem:[/B] I need to read (and only read) the data from … |
| | hi, i m trying to run a query on an MSAccess table, but it does not give me any count but only 0. There are 3 null values which i should be getting but it does not give me the result. This query works perfectly in MSSql Server 2008. the … |
| | Hello everyone I am new to access and have been trying to teach myself a bit lately. In any case, I have a problem with a specific text box(NumofMonths) within a form. I need for the default value to be 12 and that it may be edited. This text box … |
| | how can i save the path of the picture i've browsed. i'm using vb.net as my front-end and ms access as my back-end. thanks in advance :) |
| | Hi I am learning C#. I created two forms. Form1, Form2. Inside the program.cs -> static class Program -> static void Main() -> I am doing Application.Run(new Form1()); I have a public variable in Form1. That is "public static int myCode"; Inside the Form1-> There is a button -> button1. …  |
| | Hello. I have searched, and found database tool the [URL="http://www.powerdbtools.com"]PowerDBTools[/URL]. Who knows how can I convert my Access database to SQL 2008 with this tool? Thank you. |
| | ok so i two columns , one is type and the other is price. what i need to do is add everything up. so instead of like many rows of computers and their costs i need like said computer and the total sold are $346488 for example note i havent … |
| | [CODE]Private Sub Form_Load() s = InputBox("please enter staff id") t = InputBox("please enter your password") Set db = OpenDatabase("C:\Program Files\Microsoft Visual Studio\VB98\my new prj\prj1.mdb") Set rs = db.OpenRecordset("staffper", dbOpenDynaset) Set ro = db.OpenRecordset("timetable", dbOpenDynaset) Set rm = db.OpenRecordset("staffattend", dbOpenDynaset) Set rt = db.OpenRecordset("staffmsg", dbOpenDynaset) Set rp = db.OpenRecordset("staffpass", dbOpenDynaset) 'rs.MoveLast … |
| | I have a database, which keeps track of peoples training dates, they have to complete the training yearly. I can run reports to see who is overdue, or comming due in 60 days. I would like to be able to run a report like this, however, I would like it … |
 | Hello everyone, my task once again is to design a video rental database. I have done all i need to but but am having problem in getting the due date. from the dateRented and DueDate. what query or code will i use? i will appreciate an urgent reply Thanks Y'all. |
| | I have a website that i have uploaded an applet to. In the same dir as the applet, I have uploaded three textfiles that the program uses. The applet works perfectly in the appletviewer runing off of my computer, but when i upload the class online it seems that the …  |
| | Greetings, I am creating a data entry form with a subform. Currently I am able to save the mainform without filling out the subform. What needs to be done to stop the user from saving the main form with the subform blank? Thanks in advance Asha |
| | I have an Access database (Databas1.mdb) with one table (Tabell1) containing one column only (SomeData). The column is Text and has the primary key assigned to it. Executing the code, i.e. clicking btnAdd gives a synrax error on the INSERT INTO-command when reaching the cmd.ExecuteNonQuery()-statement. [CODE] using System; using System.Collections.Generic; … |
| | Hi, While trying to debug some performance issues, we narrowed down the problem to calls to Entity Beans taking long time. Original design is nice and generic but does not scale up in this case. Here are the details: - J2EE application. - Oracle DB - Entity Beans used for …  |
| | I have this problem from time to time, and at the moment. I set a breakpoint in the code to debug. I remove the breakpoint after I am finished but the program still pauses at that point. Press F5 and it continues fine. Close the database and reopen it and … |
| | i have an access table that contains the following: ID Number, Store Number, Sales Region, Item Number, Item Description, Unit Price, Units Sold and Week ending. One of the queries requires us to find the best selling products by quantity and another by units sold. I'm confused on the formula … |
The End.