Search results for query: *

I converted an app from Access 2003 to 2010 in windows 7. All worked fine except that if the PaymentType is not selected, it should display a message that a PaymentType should be selected before proceeding further. It worked fine in old version but not in 2010. Below is the code. Can't...

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

Am designing an application in Access 2007 and cannot seem to get VB code to update field. Am using a tab form to enter payments and need to have the paid through date calculated automatically and entered into the paid through field in the Subscriber table. Below is the code for the after...

Working in Access 2007. I have a form with an unbound text box which populates reports 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...

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...

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...

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...

I have been tasked to design an Access application to track hardware, software and licenses etc. I have a general idea of what is required but would appreciate if anyone has done this before and could advise me or point me to a site that would provide some guidence/model. Thanks much bdm

I have been tasked to design an Access application to track hardware, software and licenses etc. I have a general idea of what is required but would appreciate if anyone has done this before and could advise me or point me to a site that would provide some guidence/model. Thanks much

I have a form which allows user to select and report and filter options to create reports on the fly. All works fine as long as the filter is on a text field. If it is on a yes/no field or a date field, I get a data conflict message. I understand that any number value in quotes "" is...

I have not done much vba in excel and any help would be appreciated. When a client has fallen below a determined benchmark for any 3 consecutive reporting reporting period, I would like to have the 3rd cell change to the color red. Can this be done? The info I have read thus far gives me...

How can I update a combo control on a form to reflect the latest value entered in another form? I have a payment form which updates the subscribers form on the afterupdate event. The only control which updates is the paidthrough control. I need to also have the payment type update. I have...

I have created labels in an Access 2000 database using the label wizard. Avery 8160. 3 colunms across. Saved it and when I open it up, it is in a 1 colunm format. How and why does this happen. And how can I solve this. I need to keep these labels as they are for mass mailings which are...

I have a quit button on a form to close down the access application. There is also some other code attached to this event that must run each time the quit command button is clicked. For that reason, I do not want the users to have any other options for exiting the application. How can I get...

I hsve a form which allows for printing various reports. All the coding for the report is attached to the click event of a command button on this form after the choice has been made. If there is no data to report, how can I avoid getting a run time error # 2501 message that says the open...

I have a report and need a total of all the records and then a total of just certain records. In the report header I inserted an unbound text box with =Count(*). This works fine in counting all of the records. Now I also need a count of those records that have no SubscriberID. So in another...