Search results

Hello everyone, I current use the dir() feature to find out whether a file exists, but I would like to be able to find out when the file was created or modified. The file would be a pdf file, etc. Does anyone have a suggestion to retrieve this kind of data and pull it into an Access form...

Rich, Thanks for the suggestion but here are my two issues: 1. My form is embedded into the main form so it won't show up in the caption. 2. I am using a continuous form and I think the users would be confused if it did show up in the caption. I was thinking about using a mousemove event to...

I wasn't sure how to title this, but here is what I was trying to do: Let's say you have a form with 5 fields. The query behind the form has 10 fields. One of the fields in the forms is either a Y or N representing if the invoice has been paid. Is it possible for the ControlTip Text to popup...

Thanks ghudson. I appreciate the help. I was searching in the "forms" forum only (not sure why) and I couldn't find anything, but after you made this post I went and searching again and sure enough there was more than one post regarding this topic. Anway, just wanted to say thanks and assure...

Hello Eveyone, Is there anyway to specify a different "application icon" for each report/form in a database. I know if you go to Tools/Startup you can say, Use as Form and Report Icon, but can you pick a different icon for each form/report? Thanks, Randy

Hello everyone. I have been trying to figure out how to set our database up to be able to apply payments to multiple invoices. Here is a screenshot straight from Quickbooks. Right now I have a table that has the invoice, date of invoice amount of invoice, customer number and a few other items...

Unbelievable, it works great. Your a life saver. Thanks to you and it looks like a thanks goes out to Rich. Have a great day, Randy

Does anyone have any suggestions for this problem. I am experienceing the same problems that winkmich is. I know the code is referencing the subform correctly because when there are records, it returns a number rather than #Error. I just can't figure out why it won't work. I'm using Access2002...

I currently have the following code in my form: Private Sub prname_AfterUpdate() Me.PRACT_ = DLookup("[LNACT#]", "tblPCSLicensees", "[LNNAME] ='" & [PRNAME] & "'") If Me.PRACT_ Like "1001" Then RO = "O" ElseIf Me.PRACT_ Like "1003" Then RO = "O" ElseIf Me.PRACT_ Like "1006" Then RO = "O"...

Rich, Worked perfect, not sure how I missed this solution. Thanks again. -Randy

I currently have a query that uses the following in the criteria field (1001 Or 1003 Or 1006 Or 1182). If possible (this seems fairly easy but I can't figure it out) I would like to reference a table instead. So for example, if I had a table with one field and four records, I could change 1003...

I currently have a form with two subforms. You select a customer and the first subform filters all their invoices and the second subform filters all their late fees. This form is used to apply payments as they come in. So, I have a field where you type the check amount and a field that tells you...