| Thread | Last Post | Replies |
|
| I HAVE MESSED UP A FONT | 11 Aug 2006 13:01 GMT | 1 |
I uploaded some font packs and somehow it has messed up all my incoming emails that have the ARIAL font and replaced it with a unknown new - illegible graffiti font... I have been to the font library and enabled and disable fonts and sections but it's still doin it ...PLEASE HELP ...
|
| Criteria | 11 Aug 2006 11:57 GMT | 2 |
I've got a query that asks you for a specific date and returns details on that date: [What Date?] in the 'Criteria' field What I'd like to do is return details between two certain dates. In other words, in the 'Criteria' field return between [Start Date?] and [End Date?],
|
| Counting in several fields | 11 Aug 2006 05:31 GMT | 5 |
Suppose I have a table with some fields containing the codes (integer numbers) of some products (brands) and another table containing the products together with their codes, just like this: ID PRODUCT NAME
|
| How do I set up query to look for parameters in a form? | 11 Aug 2006 05:30 GMT | 1 |
I have followed the tutorial posted by Sal Ricciardi (Using parameters with queries and reports). The form (dialog box) with combo boxes and command buttons works great until I try to set the query to look for the parameters in the form. In design view, I add the following in the ...
|
| How to do Time Calculations in Access | 11 Aug 2006 05:18 GMT | 1 |
I am working on a database for tracking billable hours. In the database I have a table set up that employees enter their daily time. I have two fields TimeStarted - Medium Time Format - Input Mask 09:00\ >LL;0;_. This is the same for both and TimeFinished. I am then creating a ...
|
| Two columns as one | 11 Aug 2006 05:16 GMT | 1 |
I have some records where one column is a part, the other is the problem with the part. One part can have different problems, but all the parts are defective. I need to do a query of the top ten defects. Could I have some advice on how to query the top ten defects?
|
| 45 Days between multiple occurrences. My brain may explode! (help) | 11 Aug 2006 05:11 GMT | 2 |
Hi everyone. I really thought I was getting a handle on all this till this evening. Now I am worried that my brain is going to explode. My db has two kinds of customer services, I'll loosely define them as Type_A and Type_B. I have a list telling me which service category id
|
| Pivot a row header | 11 Aug 2006 03:07 GMT | 1 |
I have a scheduling system that has a union query to join the open service calls between 2 departments. On any given Dat , some techs have 3 stops, some have 7. Right now with my demo code, it shows the following:
|
| Function with two recordsets | 11 Aug 2006 01:48 GMT | 6 |
The following is a sub function of the functions used in our research db. Am encountering an error in my second recordset - called MARKSTRING. COUNTSTRING seems to work fine on its own but once markstring is added
|
| How do I sum colums in Access Query | 11 Aug 2006 01:47 GMT | 1 |
I'm trying to sum each column but it doesn't do it by hitting the "sum" button. However, in the headings of each of the columns, it puts SUM OF, disrupting my existing column headings. Any suggestions?
|
| Compare two fields, find near match | 10 Aug 2006 23:45 GMT | 12 |
I am trying to compare the information in one field to the information in another (basically an automated find/replace, one table to another): Field1 Field2 (Replace With) belmont park n | Belmonte Park N
|
| "Enter Parameter Value" when sorting | 10 Aug 2006 22:28 GMT | 4 |
I'm a bit of an access newbie, so sorry if this question is a bit daft but I couldn't find the answer in any FAQs. When I have a query like this: SELECT [fdTestThis] AS fdSortThis, tbMyTable.fdMonth AS fdTestThis
|
| Parsing memo field into texy fields | 10 Aug 2006 22:00 GMT | 7 |
I need to separate the text in a memo field by the psuedo field headings (not my design) A portion of the memo field looks like this Date(mm/dd/yy):
|
| Cross tab on query results error -1038 | 10 Aug 2006 21:51 GMT | 2 |
I'm having trouble with a crosstab query which I need to transpose to the results of my initial query. This is an example of my initial queries result Key FieldName Psuedo
|
| Using an Access form to enter parameters for a Query | 10 Aug 2006 21:42 GMT | 1 |
I have a query with 4 parameters that feed a report. I have made a form with combo boxes with the criteria for each of the parameters and have it set to open when the report is opened. When the criteria is set for the parameters and the enter button is hit the criteria doesn't ...
|