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?
We all have to start somewhere.
Create a textbox in the heading of your report with a control source similar to this:
="Checks written between" & [Enter Start Date] & " and" & [Enter End Date]
This has worked for me.
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 =...
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...
I don't mean to interrupt, but could I suggest another solution. I created a command button on the productID form to open the supplierID form. The supplierID form is based on a query. In the supplierID of the query build a criteria [Forms]![frmProductIDName]![SupplierID]. If your ProductId form...
I created another combo lookup box based on a query in which I set the criteria to be >r. Now all the names below "Springer Wanda" appear in my new combo box. Does this turn on a light bulb for anyone? I don't want to have two combo boxes to bring up my records but at least now I have...
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...
The SQL for my crosstab query is as follows
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 BY [Daily Entries].RevNo, [Daily...
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...
I am entering a series of checks and their amounts. The form automatically fills in the accounts that are to be debited and credited. I want to enter the bank code and check code for the first record then the subsequent records would repeat the same bank code and check code for that series of...
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?
Thanks for the reply. Was finally able to create report on another computer. Decided it was either my memory or processor. I really appreciate this forum. I have gotten several helpful ideas. Thanks again.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.