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: Hello, I have created a database in MS Access that has multiple forms in order to help my co-workers enter "invoices" for our customers and to keep up...
Summary: I've got a question about SQL query in MS Access, for example I have the following data: Table1: NAME ______ CITY ____ FAV vahid ______ NY ______ A va...
Summary: Hi, I want to edit a query in Access using batch file. I am trying to edit a field[jobID] based on criteria. I want to open the query in design view...
Summary: I am trying to export a single record from an MS Access 2000 database to an html template. Is there a way to do this without having to do a lot of pro...
Summary: I'm trying a small database program using MS Access 2003. I have a number of tables ( 5 in number ) as one side related to a single table as a many si...
Summary: Our agency maintains a Paradox 9 security database. Within this database is table (with 1311 records) which contains demographic data for all employe...
Summary: I had MS Access 2.0 for a long time. Then I got MS Access 2000. There's one thing that bugs me about the newer version: when moving between a form's f...
Summary: How to create a function in MS Access?Pls help!! ---------------------- Hello, I need create a function in MS access 2003 which run a ***.bat file in...
Summary: Hi, I have a MS-Access 2003 database. I modified the properties of one of the tables(added name description). After that, the reports using this table...
Summary: I have a report in my database is run off a cross-tab query. The report shows totals by quarter. In the crosstab query, Quarter is one of the column...
Summary: I have created an MS Access db, 2 of the fields relate to time...StartTime & EndTime. From this I have created a query to display the attendance time...
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 have a db designed using MS Access that I would like to distribute to my friends. But I want to make sure that they cannot change VB coding. How do ...
Summary: I want to be able to export a table in access to excel and if one of the values is 0 or less then a certain number i want the background color of the ...
Summary: INSERT INTO [table] ([column1], [column2],....) VALUES ('value1', 'value2',...) Note: those brackets don't denote optionally; it's how MS Access forma...
Summary: Hi, I'm trying to run a query similar to the following: Select category, count(distinct names) from tableA AA inner join tableB as BB on AA.ctr#=bb.c...
Summary: I have read a few of the responses here, and am impressed with the replies. In that regard I'd like to ask this question. I am attempting to implemen...
Summary: I tried and have researched this puzzle but I give in. I need some professional help.. I wish to run a simple MS Access query for a list of records w...
Summary: have to summarise something in ms-access. am using access 2003. i have a query with the following fields. (this query has some other fields also. this...
Summary: Is there a shortcut key in MS Access 2000 for adding a new record? I haven't found one, and when I want to add new record in form view, I have to clic...
Summary: Hello All, I work as a programmer for a direct mail company. Here is my problem: I am developing a Access (.mdb) database for a company that we just...