1,557 Topics
 | |
| | Hello Everyone, I am trying to find a good way to get information from a website into a access 2007 database. Im thinking I should have the website write a text or xml file with the data on it and then have some program (or access itself if it can) … |
 | Confusing question? The only way I can explain it best is to show it: [CODE] Table1 --------------------------- Name Num1 Num2 Num3 Devin 224 18 845 Scott 322 32 652 Jim 179 46 929 Tim 202 41 562 [/CODE] [CODE] Query Getting Max Value --------------------------- Num1 Num2 Num3 322 46 929 … |
| | I'm trying to create a Web Form Application for my class final. I downloaded the zipped file and extracted it of course. When I go to Data/Add New Data Source and follow the prompts in the Wizard I get to the screen that you choose your Database Objects, I get … |
| | Greetings, I have been cracking my skull all weekend trying to find a solution to this, and I have no idea how to search as I'm not sure what to search for (I have performed a search, but it didn't show what I was looking for, hence, the post). I … |
| | Hi, I’m trying to return a value from VB 6 to Access 2007 report and the unbound textbox remains empty. It seems that actually the problem is not coming from the coding itself, but due to connectivity between the two ends. In fact, I tried to enter a Beep instruction …  |
 | Can anyone help me create an .exe using Mirosoft Access. I have an Access application and I want to place an .exe file on the server so that everyone can have access to it. Please Help!!:!: :cheesy: |
| | Hello All, I am not incredibly skilled in visual basic. I have manipulated script to suit my needs but have never written it myself. I am in need of help/direction. I have a database which was designed by someone else. I am looking to update a table in this database … |
| | I do hope this is the right section (since VBA is so close to VB 6.0). Well here is my dilemma: I am trying to have Access return a customized report. The format I have been asked for it to be output as it the following: Machine type // where …  |
| | hye, i need help about asp.net..i new in this language. so i don't know how to connect database from ms access to asp.net and submit button. the situation : when the user click on submit button, the data that they fill in will insert in database. |
| | Is it possible to get the max values from the columns in 1 table and copy them into another or would this not be recommended. The more I think about it the more I begin to think it isn't such a good idea. Here's an example what I'm looking for: … |
| | Hello All, I am trying to add data from a dataset to an access table(.mdb). I am getting this error when I try to insert the values in the table. This is the code [code]DataSet ds = new DataSet(); Console.Write("The NAME IS: " + FileName.Text.ToString()); ds.ReadXml("C:\\Dallas_Test\\Offense_7_1_2010\\" + FileName.Text.ToString()); ADOX.Catalog cat …  |
| | Hey team, i'm having a problem with this query, [code] "SELECT * FROM marketingDB WHERE company_name LIKE 'allied' & '*'" [/code] the program ive written runs fine and it doesnt show any problem with the query infact the exact same query works fine on access but when i put it … |
| | HI this is my code.it uses access database.But givs me this error java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. import java.sql.*; public class DetOrderNum{ public static void main(String[] args){ Connection con=null; ResultSet rs=null; Statement stmt=null; int pkey=0; String mn="jin"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:MY-PIZZA","",""); String q="select order_num from Order … |
| | I am new to MySQL and navicat as well. I have been creating a database in Access and now adding records. I added about 50 records earlier and then saved them to my flashdrive to import the new data in navicat using the import wizard. The reason I have to … |
| | Hi team, I'm having some issues getting the results of my query to output on a data grid. I'm using an sql query to get the data from access, which is working fine, but then I want to output it onto a datagrid. My code is as follows just for … |
| | Hello, I have been trying to migrate some code I have written so I can use the advantages of Collection items in several forms I programmed in Access 2002. I was using an array list to collect information from a machine part and its resulting defect, then display a small … |
| | I am updating an Access 97 DB w/ VBA code to Access 2007. The VBA code uses DAO objects that Access 2007 references when I converted the db files (first from 97 to 2002, then to 2007). My problem specifically is with the two references: "Microsoft DAO 3.6 Object Library" … |
| | Hi, i want to retrive data from a table which has a composite primary key. This is the query im using; "select price from Item_size where primarykey='"+pk+"'" But it does not work. Im using MS Access. can anyone help me!  |
| | I'm hoping someone can help me here. I have 2 tables in a access database. I'm trying to join certain data points from both, simple. I've done a few joins already for this site. But the problem I'm having is this one seems to be destined to annoy me. [code]sql … |
| | Hi all, I'm working on conference room booking software with MS-Access as the back end. I need to retrieve the records which doesn't clash with the already booked dates. I have a table called conference_room_status which has the fields Conference_Room_Name | BookedPerson | DateFrom | DateTo | TimeFrom | TimeTo … |
| | hi guyz! I've recently finished a database project in Access 2003 and have been asked to deploy it to network machines with Access 2007. the prblm i have is that the users r unable to add and update the records at the same time. how can i ensure that simultaneous … |
| | Hello everyone, I am currently doing a treeview control in asp.net. I want to [B]load the database from MS Access into my treeivew[/B], but I don't know what should I type in my .apsx.vb file. [B]Please help me with the codes [/B]to make my treeview connect to the MS Access! … |
| | Hi I have a very simple database which lists students who have went on exchange both in and out of our university. I am able to do a simple user entered query along the lines of [Enter university] or 'between [enter year] and [enter year]' but here is where it … |
| | Hi There Is There A Way To Make Access File As Exe File Thanks In Advance |
| | Private Sub cmdsummery_Click() Set wss = DBEngine.Workspaces(0) Set dbs = wss.OpenDatabase("Gagedetails.mdb") Set rss = dbs.OpenRecordset("tblGage") 'Set rss1 = dbs.OpenRecordset("tblopeName") Do While Not rss.EOF OSQL = "SELECT DISTINCT OpeName1 FROM tblGage WHERE Date =" & SQLDate(txtdate.Text) Set rss = dbs.OpenRecordset(OSQL) MSQL = rss("OpeName1") NSQL = "INSERT INTO tblOpeName (name)" & " … |
| | Some background: I'm a programmer, not a network administrator, who has been asked to migrate some accounting software ([url=http://ioasoftware.com]Integrated Office Accounting[/url] version 3.2) from an existing domain (OLD_NETWORK) to a new domain (NEW_NETWORK). No-body at the office knows how it works under the hood. It is a split Access 2000 … |
| | Can I require the entry to be +-5 mintues of the current time? Thanks |
| | Hi, I've been puzzling over how to connect these tables on Filemaker for hours, and hopefully someone can point me in the right direction. I'm trying to connect the tables in such a way that when I select a student, and a specific course, I will get all of the … |
| | Hello, I created a database in Access many years ago before I realized what a mess lookup wizards would make. Does anyone have any good ideas or resources of how I can keep the information but undo the lookup wizard? I have created new tables with the same information and … |
| | So, a single user application, all data is local, no remote access .... If a go with an Access file (DB), from the user's perspective, they simply install the app and they are good to go. Is it the same if I go with a SQL DB, or do they … |
The End.