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: 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 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 have created a table in SQL Server as- create table weatherreport (places varchar(20), cdate datetime, maxm int, minm int, vdescription varchar(40))...
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: I am executing a query from the VBA using the docmd.openquery command. The same query is also the record source for the form I want to use. When I cal...
Summary: It depends on your database. I am not 100% sure on MySQL, but in Access or SQL 200x you can use a left join / right join command in the from clause. ...
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: 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...
Summary: When creating a query, you can use non-displayed columns to further sort your data. You do this by unchecking the box for that column. If you have 3 s...
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: 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: 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: 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 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: 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: 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: 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...
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: 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 have a table in Access 2007 that has all fields as Text. However, some of the fields on older tables have a mix of Text, Date/Time, Yes/No, and Num...
Summary: This changed a bit with Excel 2007 Create and ODBC datasource that points to the database you want to use. Click on your spreadsheet where you want y...
Summary: Get this error whenever I try to print preview in Access 2007: There isn't enough free memory to update the display. Close unneeded programs and try a...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
