Search results for query: *

Thanks all for responding. It has been quite a few years since I did any of this And forgive me, but am not familiar with TGML. The paymentType must be selected and only certain payments will be membership dues, therefore the Paid thru date will be updated. The other payment types do not...

...Byte If PaymentType = 0 Then DisplayMessage "You must select a payment type." Cancel = True Exit Sub End If bytMonths = YearsPaid * 13 Select Case PaymentType Case 1, 2, 3, 4, 10, 12, 13, 14, 18, 22, 23 'If this is the first payment, set Paid Through from...

Thanks so much for your reply, lionelhill. I don’t have much experience in this type of coding so the methods you describe are intriguing but a bit over my head. Will do more research to better understand what you are advising. BTW, this is volunteer project so it is not as if my life...

Before posting my sos, I had looked at and studied the dlookup function. But I must be doing something wrong, because I could not get it to work with the if statement. That is why I posted hoping for some further guidance. Thanks for the suggestion though. i will just have to keep trying....

I have a lending library database (access 2010 on Windows xp). I have another patron registration database. I can link the Transactions (book loans) table to the registration database. Now what I would like to do is when a patron registers into the library and an item is overdue, a message...

In Access 2007, I have an option group bound to a field in a table. When user makes a choice, what is recorded in the field is the Option Value number. How do i get it to store the Text Value. Thanks

...= 0 Then DisplayMessage "You must select a payment Type." Cancel = True Exit Sub End If bytMonths = YearsPaid * 12 Select Case PaymentType Case 22, 23, 24, 25, 26 If IsNull(PaidThrough) Or PaidThrough < Date Then ' If this is the first payment...

The text box does populate with all the reports. The error occurs when a report is selected. I have used this procedure in the past, although in prior versions of Access, with no problems. Am thinking that this may be some quirk in 2007. Am still trying to get used to this version.

...via a query: SELECT MsysObjects.Name, MsysObjects.Type FROM MsysObjects WHERE (((MsysObjects.Type)=-32764) AND ((Left$([Name],1)) Not Like "x*")) ORDER BY MsysObjects.Name; The users can choose a report to view by double clicking on it. This is the event: Private Sub...

Thanks PHV for your fast response. And how would I accomplish enabling code execution on the pc/

I have an MS access 2007 database designed on the windows virtual machine on a MAC. Everything works just grand if it is running on the MAC but when I load it on a Windows XP PC, the macros and event procedures do not work. I have checked all references and all are the same. Code also compiles...

I am using the query grid to calculate a future date based on a specific date field. All is fine except #error appears if there is no value in the specific date field. This is the code in the query grid: Next IEP: DateSerial(Year([Last iep date]),Month([Last iep date])+6,Day([Last iep date]))...

Hi all, I have a function to calculated the length of time between specific dates and return results in terms of years, months, and days. This function is called in the query grid as: Length of time: Age([Start Date]) If the start date is null, it will return #error in the calculated field...

In a 2 page report, is it possible to have the first page print landscape and the second page print portrait orientation? If so, this would allow for duplex printing rather than printing the first page, reinserting and printing the second page. This second page would also have to be a second...

Thanks JB, works like a charm....

I need to keep the record in the underlying table and then clear the form...Thanks

I have an Access application which sends messages via Outlook. All works well except that when Outlook closes and the user is returned to Access, the original message is still on the form. I would like the form to be cleared and ready to accept new data. Below is the code used. Any...

Real strange problem...I have a form based on a table. A combo box retrieves the matching record when selected. All worked fine until now. Records show in the combo list but when selected, I get the error message that the text entered isn't an item in the list. This does not happen with...

I designed an application in Access 2000 using the code to hide the database window. The application opens to the Switchboard. All work just fine except the REPORTS menu. Clicking on a report, nothing happens. I have tried several options, including creating a new form just for the reports...

I have inherited an access table that needs cleaning. the Document Name field contains unwanted characters that I need to get rid of. This is what it looks like now: IRT%20INTERIOR%20TRIM.pdf What I need to do is remove all instances of %20. Is there a routine that will accomplishe this? I...