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'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: 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 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, 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: If the goal is to have all the data in one table, and your Customer Name is all one field (not recommended, but okay for now), make that the Primary K...
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: Hi all, I need a help in MS SQL Express query. I have a table named "tblTotalCust" and the fields are: [Date] date, [ServedTime] date, [TotalCustomer]...
Summary: First view the query in design view. Link VisitTable-VisitID with Activity_VisitTable-Visit ID and Activity_VisitTable-ActivityID with ActivityTable-...
Summary: I done one program in MS Access using Form with VBA coding. I can't retrive the table field's caption into report label's caption . pls help me! ...
Summary: Hi, I have the following UNION query in MS Access: SELECT DISTINCT "DOM " & mDOMExceptions.ExceptionID as ExceptionID, mDOMExceptions.[Status], mDOMEx...
Summary: I would suggest 2 queries. The first to get the MaxSalaryByDepartment, and the second to get the Details for those values returned by the first query....
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: 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: 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 just cant connect to my MS SQL server. the server is MS SQL server 2000 enterprise edition (installed in w2k advanced server), and i'm connecting to...
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: 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...
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 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: Hello all I am a true beginner at this and need some help. I am moving large ammounts of files from one directory to another and set up a batch file t...
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 ...
![[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
