I was able to create the logic in Access by calculating days in a month and then adding values to the corresponding month and year columns dynamically in a loop for the total number of months between the start and end dates.
I want to recognize revenue using daily convention for maintenance revenue in Access but it's very challenging and complex. Not sure if anyone has done it before.
example:
Order# StartDate EndDate ProductID Price Jan-06 Feb-06...
1000 1/5/2006 1/4/2007 110 $120 $8.87 9.20
In...
I am trying to setup my laptop for multiple monitor, basically using my laptop's display and an external monitor using ATI radeon mobility 7500 card. The drivers are all uptodate but when I click on Display -> settings I don't see the 2 monitors like 1 & 2. It always says
'(Multiple Monitors)...
I have scheduled a task using the task scheduler wizard using a local administrator account. The task status says running but the application is not being executed. I am just using a simple task where I run the 'Calculator' application. But it's not opening the calculator application even though...
I tried that probably 20 times but still doesn't remove the reference to the old network location. I tried adding the library from the new network location but it doesn't update the reference location.
Is it because the reference is an 'exe' file and not a 'dll' file? Maybe it's registering...
I have a reference to a library which is on a network share drive. I now switched servers to need to change the path of the reference library but it won't change. Everytime I try to browse to the new network location it keeps the old one unchanged. How can I fix this? Is there a way to delete a...
I have an order management database that is split into FE and BE. I have copied the FE onto every user's PC. Each time the user works on the FE and closes it after some work on forms/reports...., the size of the FE keeps increasing. I am not making any design changes to the FE so not sure why...
Thanks timekeeper. I found another thread that addressed my issue where I can change the controlbox property to No and then create a save button and put my code there.
I have an unbound form with a save button. When a user clicks on the X button to close the form, I want to pop up a message box asking if they want to save the data or not. If yes, then I want the form to remain open so they can then click on the Save button and save data.
If they select No...
tman,
I will try the link. In the meantime I just installed the Access Runtime on each user's machine from the Access 2009 pro CD and am having them use the FE with the BE stored on the server. I have protected all my code and forms so users can't make any changes or get into design mode.
When I go to Start->Settings->Network and Dial-up Connections window, the list is empty. All I see is 'Make New Connection'. I don't see any other connections. My computer is connected to the local LAN in my company and also at home but I never see anything in this window. This is strange. Does...
I am trying to use the package wizard to create an executable for my mdb file. When I reach the 'Installer Experience' window it asks me select an install Language. I select 'English' and then it asks ' do you want to cache the english install files now'. I say ok and after a few seconds it...
I have a subform that shows customer and their order ids based on a 'customer' combo box selection. I want the user to double-click a specific Order id and a new form to open that shows all details on that order. How do I achieve the double clicking to open a new form with all the order details...
I am trying to read a string from an excel field that has a single quote within it. For instance : "St.John's Hospital".
I pass the value into variable say 'sString'
Then I run the statement in VBA
Docmd.RunSql "Insert into Table1(Name) values('" & sString & "')
Since I am passing the string...
I have a table called Commission_Main which contains transactions for all Salesreps.
I want to export the transactions for each Salesrep into individual excel spreadsheets using the Salesrep name as the criteria. I am trying to use the docmd.OutputTo but it has no criteria or where clause.
I...
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.