Summary: I am a novice Access user. I am unable to get the answer from DLookup that I am expecting. Question: I just need to find out the minimum wage in e...
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: 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: 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: 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: 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: 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 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 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 have created a time card database that calculates total hours. Also, I have two tables employees and time cards. In the employee table all of their...
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: 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: There are several ways to do this, depending of course, of what version of Access you're running. To see several options, enter "secure database" in ...
Summary: I am proficient in most software but have very limited experience with Access. My question is this. Say I have a table for several months containing d...
Summary: Access 97 "Save as HTML" converts hyperlinks to HTML code I have an Access 97 database with hyperlinks in one of the fields, for example: < a href...
Summary: I'm trying to design a query in Access that will find similar records (not dups). I have two tables with UserIDs. One is the result of a previous quer...
Summary: Ok here is my problem. It’s kinda silly but here goes. . . . I created a database in access to track my ever-growing DVD collection. I have a form t...
Summary: I have a large number of sheets (120) in a single Excel workbook file. I can import each sheet individually into an Access table using the import wiza...