1,597 Topics
 | |
 | Hi all, I am working on a PHP project. Im having a problem giving the 'src' for a image, because the image file is placed outside of the www folder :(. Let me explain more. When I log in to my server using FTP logins, it gives the directory structure … |
| | Dear All, I have a text file containing these lines: [QUOTE]12345 12 123 1234 123456 1234567890 123456789032453 1234567890724832445 12345.123456 12345.123 12.12 12[/QUOTE] And I want to read them from c:\numbers.txt and store them into an array and then do some calculations, then save the results in another file(c:\results.txt). I have …  |
| | Hi there, i new here and i would like to seek for advise or help regarding this matter. I have trouble in joining 2 table. the error is "type mismatch in expression" the query is Select R.*, P.HphoneNum, P.HeirHpNum from PendingReport R, PatientTable P Where P.PatientID = R.PatientID but when …  |
 | Hullo, I would like some one to help me connect my access database to my website. The Database Name is school.mdb and the website is <URL SNIPPED>. Thanks |
| | General Question, no code: I have the daunting task of automating the import of mysql, ms sql and ms access into a central location. I've nailed the microsoft crap using ms sql DTS but even with mysql odbc drivers, cant seem to nail that one. The optional is that I …  |
| | Already image path is being is stored in database... I want to retrieve it and want to display images in asp pages(IF I CLICK A HYPERLINK OR BUTTON IMAGE SHOULD BE DISPLAYED) ... Plz help with sample code. Regards Jose |
| | [B]Helo everyone , I am beginner in programming , it have been 6 month I just start studing at university , right now I am working on project creating a dynamic website where people could live coments above the images or videos like in youtube for exemple. What concern PHP … |
| | Hello , I am working on getting this Mortgage repayment calculation code to work for my Access07DB, the code for was copied from some 2006 post on a vb forum. But some things I cant get to work [COLOR="red"]I will put the bad lines in red[/COLOR] [CODE] Option Compare Database … |
| | Hi all! I hope someone has a solution to this MS ACCESS 07 report problem: I have two textboxes in reports details (lets name them box1 and box2) Both area populated by report recordsource. Both show fine. But I would like to colour the bottomborder of box1 with different color … |
 | Hi I'm doing a project where I need to have people register by entering a username and password. When they click register I want them to be added to the database, but I'm having trouble doing this. Can anyone help? This is my first time using VB. This is the … |
| | Morning I have a question here How do I go about it in Access say if I want to split a line (row) into different lines like these fields? Drug name1 Drug name2 Drug name3 Drug name4 Drug name5 Drug name6 So what I want is to split the Drug … |
| | Hi thanks for reply, I just tried that and it does the same - both phrases on the same line in the RTF memo field Ive used vbnewline in a msgbox before and works fine, but it stumped me as to why its not working in memo field. once i … |
| | Hi, My program keeps coming up with an Access Violation after I moved the code manipulating my linked list from the main function to a sub function. Looking at it with the debugger, I found that the sub function destructs the linked list, and then the main function attempts to … |
| | Hi there (Can DoCmd.openform allow formname from stored string value?) I am needing to vary the FormName part of the .openform based on a result looked up in another table. as I have 10 Different forms that will be specific to a certain kind of record. My code something like … |
| | Using Microsoft Access 7, I want to print out labels from my database, on 30-up label stock ( 10 rows, 3 across, 1" high by 2-5/8") using HP Deskjet D4360. I can't get the bottom row on the sheet to print. Everytime I change the margin, it never stays the … |
| | Hi All, I am trying to convert the following access update query into TSQL without any luck: UPDATE tblCattle INNER JOIN tblFarmDetails ON tblCattle.strEartag = tblFarmDetails.EarTagNo SET curMartPrice = tblFarmDetails.MartPric WHERE (curMartPrice=0 Or curMartPrice Is Null); First I tried simply pasting in the query with no luck so below is … |
| | HI everybody I am a beginner and have a very simple question to ask. I am working with M.S. Access in Microsoft works version 9.I want to set the current date in every new record i visit without actually typing the date.As in access 2003,Cntrl+; key is not working.and i …  |
| | In my VB6 project i have a text area field, iwant to insert data which i give in that text area wants to insert into Access database. For that which data type i need to take for that column. 1) If i take Memo or text as datatype: only singleline … |
| | Hello everyone, I currently doing a database project, which is part of my coursework, and I am having some difficulties. So, I am making it in Microsoft Access 2003. In my form, I want have to tabs (Client and Music Store), and I already have 2 tables, for each tab. … |
| | Im in over my head and have a small project to complete using MS Access. It involves setting up 3 tables, creating forms, queries and a report. I have a narrative that describes what is needed. I am willing to pay to get this done, but for somebody that is … |
| | 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.