Search results for query: *

A friend brought me a floppy on which he had been saving a Word document. When he tried to open it this morning he couldn't. The file now has the extension .prn instead of .doc. He doesn't know what happened. What does .prn stand for and can this file be fixed?

I have the following code in the AfterUpdate event Private Sub DecalNo_AfterUpdate() If IsNumeric([DecalNo]) Then Me!DecalDate = Forms!frmDecalDate!PaymentDate Me!DecalType = "A" Me!DecalAmt = 15 Me!Workstation = CurrentUser() Me!time = time() Else Me!DecalDate = Null Me!DecalType =...

I have Windows XP on new computer. Which version of Access is compatible. My old computer had Access97.

When you use this expression =DMax("FieldName]","tablename")+1 to get an incremental number where do you put the expression? thanks from a novice. Also could someone point me to a book or web site that would have examples that show how the functions can be used. This forum...

Is there a limit on the number of records that display in a combo box? I have a wierd problem. My form is based on a query with a lookup combo box that has been working fine to bring up the record for the name in the combo box. After I archived more records in the table I have this problem: When...

Can anyone tell me how to alter this so I get a zero when there are no entries to sum TRANSFORM Sum([Daily Entries].Credit) AS [The Value] SELECT [Daily Entries].RevNo, Sum([Daily Entries].Credit) AS [Total Of Credit] FROM [Daily Entries] WHERE ((([Daily Entries].AcctNo)=".08")) GROUP...

I am a self-taught Access97 worker with gaps in my learning, so please have mercy! I have a query based on a crosstab query. In the query I have a calculated field Tot:[Jul]+ [Aug] Works fine unless Jul or Aug is blank, then returns nothing; that is, won't return the Aug amount. Jul and Aug are...

On my form I have a text box named CheckCode. On its After Update Event I have code which automatically fills two other text boxes. This has been working great for several years. Then I got the idea that I wanted the first text box to repeat data from the previous record so I put in the default...

I have a report based on a query. In the query there is a calculated field DueDate:Date()+ 31. I want the date to appear as June 9, 2002. My choices give me 6/9/02 or Sunday, June 9, 2002. Is there a way to get rid of the Sunday? This seems like a choice that Microsoft should have given. Thanks...

I purchased a laptop with Microsoft ME operating system. Then loaded my Access97 from the original CD. The icon for access was not put on the desktop. When I located the icon and clicked it I get the message that I have not specified the correct path to a database or a database at all. Has...

I am using a text box in the form header on a subform to calculate bal.due. It takes the total due on the main form and subtracts all the payments on the subform. But I don't want the answer to ever show less than zero even if the payments exceed the total due. How can I do this?

Suddenly for no reason, I cannot create a report from a query using the report wizard. I have tried in two differenct databases. I have tried on two different computers on the same network. I am using Access97 on Windows NT. Has anyone ever had this problem. It starts out fine until the end when...