Search results for query: *

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

The account has a password. I have entered the local username and password. The task status says running but the application is not visible.

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

Thanks AceMan. That's exactly what I was looking for!!

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

I found the problem. It was to do with my dcom setting to 'anonymous'

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

BigJohnD, I tried all the links that bcastner posted but none of them worked for me. How did you fix your corrupt registry issue? Thanks.

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

Thanks a lot Steve! This is exactly what I was looking for. Santosh

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