| Thread | Last Post | Replies |
|
| downsize a chart in Excel | 25 Jan 2006 15:40 GMT | 1 |
How do I reduce a chart in Excel that I have written, to a size I want to print
|
| Number sequencing | 25 Jan 2006 15:09 GMT | 2 |
I have a Grouped/Total query and I want to have a running count on each record as they are generated in the query starting from a value from another table, which is not included with the query at the moment. I think that i have to subquery the value in from the other table but am ...
|
| Selecting correct records for parameter update query | 25 Jan 2006 14:31 GMT | 2 |
I want to use a macro to trigger an update query from a subform called fBenefitDesignView. The update query has a parameter which requires the user to enter a date. The date is then updated to the underlying table Benefit Design. However, I need the query to be filtered for the ...
|
| How to include "/" | 25 Jan 2006 13:57 GMT | 6 |
I have the following query: SELECT Orders.OrderID, Orders.InvVWD FROM Orders WHERE (((Orders.InvVWD) Like "*" & [Enter Invoice Number] & "*"));
|
| Combining records from two queries | 25 Jan 2006 13:35 GMT | 9 |
I fear that this is going to have an incredibly easy answer but I can't see it. Sorry if it's long winded. I have a a number of related tables: tblStudents, tblMentors, tblSchools and tbl Placements. tblPlacements acts as a cross connection table. A Placement
|
| Date Format | 25 Jan 2006 13:17 GMT | 5 |
Is there a way to remove the seconds from a "general date format" in a text box???..
|
| create a query that will pull data from last week information only | 25 Jan 2006 13:07 GMT | 3 |
I have a d/b that keeps track of my customer service reps performance service levels. I update the data on a daily basis. I normally report the information out on a monthly and YTD document. I have recently been requested to report the prior week info.
|
| using a field from a querry in some VBA code on a form | 25 Jan 2006 12:58 GMT | 4 |
Can anyone please help me with this. I need to reefer to a field from a MS Access query (the query has been created using the query by example grid and not SQL) on a form. The field name is "BinQty" and shows up as "SumOfBinQty" as the Groupby and sum options
|
| Form based on query crashes | 25 Jan 2006 12:58 GMT | 7 |
I am using this on a budget/actual form but it crashes "sometimes" when I open the form. No consistancy as to when it crashes... any suggestions? Thanks! SELECT tblProjBudAct.ProjID, qryPlanDetailShort.SQFT,
|
| Add Num of Appointments for Week | 25 Jan 2006 10:32 GMT | 1 |
I am having difficulty creating a query to att the number of appointment scheduled for the coming week: The window is a static Monday through Sunday. The day the appointment was scheduled is stored in "Booked".
|
| Why is my query acting like this | 25 Jan 2006 09:43 GMT | 1 |
SELECT DSM.MajorDep, Psychotropic.Prescribed, Safety.SafetyRisk, Info.ResId, Info.TodaysDate FROM ((Info INNER JOIN DSM ON (Info.ResId = DSM.ResId) AND (Info.TodaysDate = DSM.DSMDate)) INNER JOIN Psychotropic ON (Info.ResId = Psychotropic.ResId)
|
| insert/append query in vba.. | 25 Jan 2006 06:27 GMT | 1 |
I'm working on an a2000 mdb linked to sql server tables. I'm pretty new with sql server, and trying to copy a Form's row and it's associated subform rows. The main form row copy is good, but not sure how to go about the subform row copies..typically i would do an insert/append... ...
|
| Default values in queries | 25 Jan 2006 02:05 GMT | 4 |
We have a staff database with primitive user level security which basically consists of several fields that default to the user's initials and stamp the time that the record was created/updated. This works fine for us using forms however when records are updated using
|
| Formula not working in a Query | 25 Jan 2006 00:41 GMT | 7 |
I am helping someone to setup an database in access. We have the tables and forms, reports,queries setup. But on of the query that we are having problems with. We have an formula inserted to do some calc's in a field in the query. But it does not allow us to use it. It worked all ...
|
| multiple queries in Access 2003 Reports | 25 Jan 2006 00:25 GMT | 3 |
Is it possible to base a report on more than one query? I have two text boxes, each based on a different query. I just used the properties value of the text box and then the control source to put in the two different queries. The first text box has the following:
|