Search results for query: *

Hi All, I need to take a single table that exist in each of the .xls files and combine them into a single file. The twist to this is that the table can span multiple tabs.. It always starts on tab 2 beginning with the header "machine parts" (data on line 6) and ends with the header "machine"...

Hi All, I need to take a single table that exist in each of the .xls files and combine them into a single file. The twist to this is that the table can span multiple tabs.. It always starts on tab 2 beginning with the header "machine parts" (data on line 6) and ends with the header "machine"...

Hi, I am having an issue setting up my Remote Web Workplace. It works fine internally but externally it only works off ip address(https://xxx.xxx.xxx/remote). When I ping remote.domain.com internally it resolves to private ip(192.168.x.x). Externally when I ping remote.domain.com I get an error...

Hi, Recently migrated to exchange 2003 (within the last 6 months), now we need to sign into outlook and web-mail client separately in order to retrieve all of email. Would like everything to come through outlook. Any help would be greatly appreciated.

Hi, I'm trying to disable a project if = "closed", but its greying everything & nothing is disabled. Heres the code I'm using : Private Sub Form_Load() Me.NavigationButtons = False Dim dbs As Database Dim rst As Recordset Dim strUserID As String Set dbs = CurrentDb() 'checking UserId exists...

Is there a way in code to make the first login exclusive and subsequent logins read-only?? Any help would be GREATLY appreciated. Thanks, Jd

Hi, I have 9x contols on a form that after updated I would like the variance and total columns to update. I used the following code in each of the 9 controls.. V1.Requery CapTotal.Requery Only the top row I can get to work; and this only works for variance. Any help would be GREATLY...

Hi, I'm trying to get a warning box message to appear when the "Case" box appears Null; using this code: Public Sub LabelWizard(strQueryName As String) ' launch the label wizard with the specified query On Error GoTo HandleErr Application.Run "acwzmain.mlbl_Entry", strQueryName ExitHere...

Hi, I have a subform "FRMPlantMachineSub"; in which I need on open to appear blank. I tried entering: Private Sub Form_Load() Me.FRMPlantMachineSUB = Null End Sub error--"object doesn't support propert" Any help would be GREATLY appreciated.. Thanks, Jd

Hi, I'm really stuck..I have a subform in which I have 3 fields Item(combo3), Quantity(TxtQuantity), and Price(TxtPrice). I need to based off of user input match a qty on TblPrice and return a price to user on form. ANY help with this would be greatly appreciated. Thanks again, Jd

Hi, I'm trying to create a query to run a summary report of all machines using selected criteria off of a sub-form; and I am encountering quite a few problems. A- Values displayed under machines are some strange derivative of the number I entered in the price table. What do I need to set the...

Hi, Can someone tell me why this won't work..?? =IIf([Make]="2","",(IIf([Item]="Equipment","Deluxe options pack"))) Let me know if you need more info.. Many thanks, Jd

Hi, What I'm trying to do is set up a crosstab to compare two makes & multiple models. Here is the querry I am currently using which pulls up by make & model, and allows you to choose various options. SELECT Manufacturer.Manufacturer, Machines.Machine, Catagories.Catagory...

Hi, I'm trying to get a running sum total; this what I have.. =Sum([Price]*[Forms]![mainform]!text4), this was placed in report footer. All I get is 0.00 when I run the report..any help appreciated.

Hi, Anyone out there have any idea how to import the conversion rate listed on http://finance.yahoo.com/q?s=EURUSD=X into a Access DB..(unless someone knows of a better site that auto updates). Any help greatly appreciated.