Summary: I need to have interactive reporting system, i tried to use crystal reports but the system can not give me interactive reports. when you need another ...
Summary: I am the IT manager at a community organisation with about 10000 members. All members data is currently in an Access database on our file server in th...
Summary: I have an old DOS program that saves data to a .dbf database file. I would now like to add data to the .dbf file through MS Access. I have successfu...
Summary: I want to update the changed data in a sheet which is linked to individual sheets created in excel but its not possible once the updated sheet is open...
Summary: can someone please explain what I'm doing wrong: I am attempting to have a textbox on a form assume the properties from a column on a table. I want th...
Summary: You can import an Excel file into Access. Right click on the white-space in the first window you get and select 'import' this should allow you to chos...
Summary: I have a database in SQL Server that already has tables and data in it. I also have and Excel 97/2000 workbook which has sheets named corresponding to...
Summary: Have you considered just linking to the Excel spreadsheet, or do you definitely want to import the data? If linking isn't an option, here's a third-pa...
Summary: I want to automate a process that I perform on a weekly basis for my job. Currently, I have a bunch of SQL scripts that I run through JMP, a comprehe...
Summary: Hi FishMonger, Thanks for the links. I have to admit I am not the most experienced with databases and have only recently started PHP web development l...
Summary: Hry guys, I am about to attempt my first database project. I want to create a small community that is similar to a myspace application but there will ...
Summary: This might also help: Before you begin, make sure the table is not in use. Then use the isql utility to perform these manual steps, entering go after ...
Summary: I am trying to create a search function in a form. it wil search the specified table and return the results in a subform on the same form. This is the...
Summary: I loose some data when converting from text..even when I change the format.. example size column in excel worksheet is formated as text.. but when con...
Summary: Can someone tell me why the following is not working? $query = file_get_contents("import_data.sql"); echo ($query); $result=mysql_query($query); ...
Summary: I would not really call it redundancy as its not linked to the database. I do not want to link it because there are names that are not going to be use...
Summary: Hi, in my Microsoft Access database, I have two tables 'Companies' and Employees' with One2Many ralationship. Each company has link to many employee r...
Summary: Hi all I have two databases in works 2000 that I want to convert to access 97. The first has 16,000 + entries and after copying to excel, the conversi...
Summary: I have two databases. Very simple databases, basic data entry, no links to tables or formulas or anything of the sort. Some employees were entering da...