1,597 Topics
 | |
| | Can Somebody plz tell me how to give the form ,a footer & header. I want to write in Heaer-REPORT FIRST But i m not getting how to type the text in Header & Footer, plz reply. Bydefault the user is able to resize the form,I also want that the … |
| | Hey guys, I'd posted earlier about creating a database for a vaccination clinic is a slum. All the responses were really helpful (thank you!) but I'm encountering some further problems. In a table named "Table Children" I have a "Date of Birth field" and and an "Age at the time … |
| | I made a query for inserting a value from text box to MS ACCESS db [CODE] sql = "INSERT INTO Equipment (port_number,display_name,equipment,tonnage,user_privilage) VALUES (" & CLng(txtPort.Text) & ", '" & CStr(txtDisplay.Text) & "', '" & CStr(txtCA.Text) & "', " & CLng(txtTonnage.Text) & ", '" & CStr(cmbUser.Text) & "')"[/CODE] Actually I … |
| | Hi, i use simple login with a login page where user place u/n and p/w. The data are compared to store data from access db. If matches, open a secure page. So far so goob. In secure page i wanr to show a gridview with user's data, so he can …  |
| | can anybody explain what the difference between the 2 codes below? i'm using visual basic 6 and i'm connecting access dbase. and one other thing, i'm trying to connect access 2007 with my vb6 but i can't remember the code, i know the code below works with access 2003 and … |
| | Hi I am a new user in access and created a database to use in accounting practice. I want to create a query control that will show the opening balance, plus fees less closing balance = 0 as all data are imported from another system. The problem is that the …  |
| | Dear all, I've thus far created a simple Access database to keep track of all the pumps my (mining) company uses. What I want to do, is create a form which will automatically archive previous data if new data is written into it. For example, I have a pump that … |
| | how can i insert an image to ms-access database using java swing form and vice versa. |
 | Dear All, I have a small database which has two tables, table A = Stock and table B = Sold, these both has same fields including quantity, I have all my items in stock table, but what I want to do is when I sold something and entered in sold … |
| | I'm trying to paste some text into a memo field and am getting the message "The text is too long to be edited". The text is 64K, which I believe is the max. I even did a character count on it that came to 64,360 and the limit I learned … |
| | i am editing someone else's code that creates a tracking log for a website. It is written in perl but the file is report.mas and there is another file that has to be altered too report.mas.obj for the file to work.. I am very confused what type of code this … |
| | Im having trouble with a running sum for my VAT analysis section of a report. Whats happening is the vat is calculated and rounded appropriately. But the running sum seems to be calculated on the pre rounded figure, is there anyway to rectify this. So i have following figures [I]245.70 … |
| | Compare field Field1 with Ucase(Field1) return 0 ever.. but I have any register with Field1 in mix case. Why Access retur every igual ? |
| | I'm trying to convert ms access to filemaker pro. |
| | Hello, I have been looking for a data integration / transfer program able to help with Access. I have had some advice but have not found the right software yet. The main feature is being able to migrate important quantities of contacts and data on a daily basis. The migration …  |
| | :( I am have been trying to update changes from my vb.net program to an access database file and it simply will not work. I have am using table adapters. I'm not familiar with SQL so i can't go that route. It updates the dataset fine but not the database... … |
| | Hi how do i call a pdf file from a form in ms access please ? |
| | I'm trying this: [CODE]$recordset = $conexao->Execute("select * from PRO where CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd(\"d\", +15, NOW()");[/CODE] PRO_DTCAD is REGISTER DATA PRO_DURAC is DAYS TO EXPIRE But: [QUOTE]PHP Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> Missing ), ], or Item in query expression 'CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd("d", +15, … |
| | I am using MS ACCESS, and have 4 tables to update, from 2 different tables/spreadsheet Where table tb1- Client Index, Name, address and zip. tb2- user index, Sales rep, client index tb3- user index, Managers tb4- client index, Sales Target Master 1 has Name, address, Sales target and sales rep … |
| | In defining MS Access tables where a 1 to many relation exists what is the best way to define a table containing the “many” records. For example, a database with orders and line-items might have the “line item” table with an order-number and a line-number which would define a unique … |
| | I want to process data entered into an Access 2007 form and then append the data to a table within the database. I started with a simple form with a button running a macro which ran an APPEND query, and this was fine until we needed to add some conditional …  |
| | Hi i need some help. i am trying to run a process that will move records from one table to the other and i am getting this error msg " Description: Catastrophic failure - Number: -2147418113" in the detailed error log but on the interface m getting something like Error … |
| | I have a small project in c# and ms-access I use query builder to manage my tables in ms-access. the problem is, select qeury works great, update query works great, delete doesn't work , and there is no error msg!!!!!!1 please help!! [CODE] OleDbDataAdapter adapter = new OleDbDataAdapter(); string queryString … |
| | Hello, Being on Access, I would like to transfer some data onto Mysql. But I cannot. Is there an easy way to transfer data onto Mysql? I am thinking that it should not be that hard to do. Thanks for your help. |
| | Please tell me how can i access the cache in C++ code .... ???  |
| | I have a customer form, connected to an orderform with an order details subform. I want to select a customer record in my customer form and click a button (that I have setup) and it opens that customer record (using customer ID) in my order form. I created a button … |
| | Hi, I recently imported about 18,000 records from filemaker into access. I initially exported the data as a csv file, i then opened it with excel and saved it as an xls spread sheet. Once i cleaned all the data i proceeded to import it into access, however i now … |
| | I am trying to capture the COUNT of employees who are off by running a query from a table that has employee name and START DATE and END DATE of their vacation days throughout the years. I need to pull all employees who are GONE over a period of DATES … |
| | OK I have an assignment on my Access course, I find this site really good and require some help if possible. Basically I have a login screen which checks the Access Database I am using the code I have is this: [code] Username = txtUsername.Text Password = txtPassword.Text 'Following code … |
| | Hi all :) I'd like to make a little vb.net program that executes searches on a msaccess database. I use a textbox to get the value to search and than i'd like to search all the values that has the textbox value in the middle. So, the queries should look … |
| | Is this the right place to ask the following? I have 2 tables in two different MS Access DB's. Access allows the ability of inserting data from DBA.table1 into DBB.table1, using the format [dba].[table1].[dbb].[table1]. Here's my problem. Using a single SQL Statement I can't figure out the following. DBA.table1 has … |
| | I am attempting to use VB2008 Express to Display, Edit, and Append an Access database. I can display information fine, but for some reason updating the database is posing an issue. The code below runs fine and doesn't throw any exceptions. However the Access database itself does not update. When … |
| | Hi Daniweb guys, This is my problem: My .mdb (microsoft access 2003 file) is containing pricing table and client table. (I used visual basic 6 to create an application) The user can install my application in their own pc and record their client into a provided client table. But, the … |
| | I want to create a data base so that i can keep record of individuals and search their record easily Students under go different personality tests and checked by three different teachers of differnt departments. After their test these three teachers sit in a meeting to discuss each student in …  |
| | I am trying to do something I think should be fairly simple. Basically, I was going to do a multiple if statement, but there are 30+ values. I was wondering how I could have a text field and if someone types in a value, it searches a table to see … |
| | Hi guys, I have a question, but first I'll explain my scenario. So I've got this datagridview where I use it as a look up for a certain table in Ms Access and I want to update just 1 field in that table. My question now is that, [B]can I … |
 | Far from being made superfluous by the Internet, a [URL="http://www.ala.org/ala/research/initiatives/plftas/2008_2009/index.cfm"]recent study[/URL] by the American Library Association finds that the library is often the only source of free Internet access in a community. More than 71 percent of all libraries (and 79 percent of rural libraries) report they are the only … |
| | Hi I was wondering... how can I publish a web service but only to few client programs? I thought maybe a solution is simple apache access (for restful service) but maybe it's another way..? thanks in advance |
| | Hello everyone. I need to learn how to do it? Suggestions, any site tutorials that you find it useful or anything related to it would be very useful. Need this until 8 September! Help. |
| | Unrecognized database format <Faculty of Science>. (Error 3343) |
| | Help! I think that this should be easy but I have not been able to find the correct VBA code to get the Form to print only [U]the current record [/U]not all 1651 records. I have a command button (Print) and walked through the wizard correctly to print "only the … |
| | i want to create student information system. but i have not a single idea regarding this problem. the requirment is thatit should have tables, forms,subforms,relationships,switch board manager,macros, main form. queris,(DDL and DML),SQL functions of the following entities STUDENT,TEACHER,DEPARTMENT,COURSE. u can also contect me on my ID. <EMAIL SNIPPED> please i … |
| | Hi all, I am a perl newbie. I am using a perl code to read a column full of data from 1 field into an array [CODE]for(my $i=2;$i<table->last_record;$i++) my @data = $table->get_record($i,"Date"); [/CODE] Now for example if my @data[1] consists of list of numbers, I need to find the diff … |
| | Hello everybody, :) I'm trying to import an access database to mySQL by using c#, I'm using this software: MS Access to MySQL from Bullzip, and it seems to be working ok; by using c#, I can display all data from tables, using this connection: [CODE] private void btndisplayBooks_Click(object sender, … |
| | I have a website i want to know how to connect my website to the Interent directly. |
| | do anyone 1 knows hw 2 access other running windows in desktop using VB??? i saw it in a buk |
| | Hey guys, I'd like to create an access database for a vaccine clinic I am managing in a large slum here in South Asia. So basically I want to create a form that auto-populates. Say a baby comes in: I open a new form, assign a unique id (probably the … |
| | Hello, We are trying to find a new open source ETL tool. Basically, we need our new software to perform tasks such as ETL, data migration and data synchronization. For now, the program would not be used on large projects. There are a few open source tools on the market. … |
| | Hi All, I have a typical problem. We have established product developed in ASP. Now I want to add security and access cotrol to upload directory and files. I could not find anything that can help me to write code in ASP. But in ASP.net C# and C++ there is … |
| | Southeastern Arizona Medical facilities have a grant to install a new network for patient information exchange. Who knows anything about the AZ Access Data Exchange - might be called AMY? What kind of network is needed? etc Dr Sundance |
The End.