Summary: Im trying to implement a function in Access 2003 to allow the application to find a given field from a give another field in the same record. e.g. I h...
Summary: Message: I'm trying to do a program in Access to my husband clinic, I need first to check if the patient is male or female then if it is male I need ...
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: 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: 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: 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 created a database from data I inherited from another person. The data has three tables ' Mother, Child, Follow up Child data. The data on follow up...
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: Sorry, I was'nt very clear. I have set up a macro with an import specification for a text file which has records for 4 fields, into a table. For ex...
Summary: I want to use macro in access to create a new column in several different tables. These columns shall consist of a prefix that I choose, typically "PM...
Summary: I have a problem with margins of reports in Access 2003.I have make an application in Access 2003 with a lot of reports.For all reports in OnOpen even...
Summary: I need to perfrom calculation at the lowest level in a product hierarchy and then roll up the result without recalculating at higher levels. How this ...
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 want to attach my purchase order files (microsoft word 2003 files) to records in my access database. Is it possible to link or better store them in ...
Summary: I'm using an several queries in an access 2003 database to track emails coming into various outlook/exchange folders. My problem is I have to manuall...
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: I am working on a Microsoft Access project and need a validation rule for the job number. I need it in the form 09-140 where the 09 represents the cur...
Summary: The recommendation for tables in Access is One Record for every...fill in the blank. So, one record for each customer. Having two tables for the cu...
Summary: I try to include MS Access 2003 crosstab query design code (internally generated SQL) into a VB6 module. Here is the ColumnHeadings definition which ...
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...
Summary: ok, in excel i know there's a feature called FIND (Main menu ->Edit->find) which helps one locate words/features in the datasheet. but my question is...
Summary: I need a way to show a graph based table/query in MS Access form. I tried using OLE MS Graph and placed it in a form and then change rowsource to my ...
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: I solved this problem when using Access 2003 by exporting data into Excel but having upgraded to Access 2007 where this is not possible, I’m trying ...
Summary: ery expression? Using Access 2003... I have a query setup to only output the following expression when certain conditions are met (so that only the wa...