Search results for query: *

Both. The Print Preview appears just as the printings. Each of the four settings on the PC's affected print the document in four different sizes.

Problem: An unbound object frame is being stretched and squeezed based on the individual Display Property Settings on PC’s running the DB. Explanation: I have an Access 2002 system I am developing with linked Word.doc letters that the customer will alter as needed (in WORD) and use to generate...

Thanks for responding. cmmrfrds: Are you asking me to paste in my entire SQL statement to this posting? Blorf: Response is a value from the dialog box before this query is to run. The response determines wether to filter on a specific value in the field or return all records. Without the Is...

Greetings, I am trying to filter a query using an Is Null within an IIf statement. Based on a response, I need to return a list of all records with a specific field either empty or not. The Is Null placed directly into the Criteria field along with the field name works fine (ie Is Null Or...

David, One is an auto number primary key. The SELECT Statement is: SELECT Colleges.College_ID, Colleges.College_Name FROM Colleges ORDER BY Colleges.College_Name; However, I have a total of 4 of these windows linked to tables of various sizes that have the same problem. These subforms are part...

David, Actually it feeds off a table using a SELECT statement in the row source to get the list of records. The table has two fields and the column count is two and the column widths is 0";1" Darrell

Using Access 2002 Hi, I have a problem with a combo box in a subform. Only one field is displayed and there is room for three lines in the window before the right scroll bar kicks in. That's when the problem occurs. The right scroll bar covers the combo box drop down activator. If I change to...

Hi, Is there a way to configure the scrollbar on a text box to remain even when the text box has lost focus? I am using a text box to display documented help screens and without the scrollbar it is not obvious to the user that the data being shown is not all there is. Clicking any where in the...

Date reformatting - I have a column of dates in a worksheet that appear as ( yyyyddmm ) I need to convert this field to mmddyyyy but Excel does not recognize the format as a date, therefore Excel will not auto reformat the date unless I manually insert a hyphen between the items, ie yyyy-dd-mm...

I appreciate all the help. The final code does exactly what the customer wants…until they change their mind again. I used: Expr1: Right$(7) & Format$([Hours],”0.0”),7) and Expr1: Right$(5) & Format$([Score],”0.0”),5) for the 2 fields. I noticed that these new fields apparently are linked to the...

Ohhh, that's something new. I admit my Access knowledge base is a little short. Inserting code directly into the Field name is great...but what does it mean? Is there some documentation I can read? I need to do some more manipulation with it. For example: the "##.##" is automatically...

Well, that sounds good, but I don't see how to add this peice to my puzzle. I am already exporting from a query. Where does the field expression you mentioned go in the query? It is not accepted in the Format Field Properties of the fields in question. The VB Code I am using to transport the...

I have created an Export Spec in Access 97 to export the results of a query as a text file. Two of the fields are data type number which fluctuate in size from 0 to 100. The problem is that the "DoCmd.TransferText acExportFixed" command writes these two fields as if left justified. The...

Is there a way to verify a valid drive path or address prior to attempting to make a new directory (MkDir). The CurDir function appears to have problems even identifying the current drive in Access 97 and app.path does not function with 97.

Outstanding! Thanks Chrissie1, that was the key. Darrell

Thanks Chrissie1 I'll give it a try. I have progressed somewhat... here's a question for all. I have a working code, but the system overlooks the variable for year and repeatedly asks for it again. The code follows. [I hear Louis singing in my head] Good weekend! Darrell...

Programmer thrust into Access using VB module. I need to create a one step process of exporting a .txt file using a querry and filtering by one argument. I am working in unfamiliar territory with this one. I have been using the DoCmd to achieve this, but maybe there is a better alternative. My...