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

Thanks for the reply but I got it sorted..The ISP had set up incorrectly and had only registered the reverse lookup (needed an A record). Thanks,

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

If you can provide a link that would be great or what should I search under. Many Thanks,

I have to sign into my outlook client and say yahoo for example because my email does not forward from that domain. Hope that clarifies a little. Thanks,

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, This is the code I'm using currently.. Private Sub OpenFormDialogBox_Click() On Error GoTo Err_OpenFormDialogBox_Click Dim stDocName As String Dim stLinkCriteria As String Dim VbMsgBoxResult As String stDocName = "FRMDialogCaseBox" DoCmd.OpenForm stDocName, ...

Hi, Made suggested change and now I'm getting a error on form "Object Required". Any idea what this is in reference to? If not, Can I send you a copy of my DB? Thanks for your help, Jd

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

Thanks for all your help.. Jd

Hi Anyway I could send you a screenshot of what I would like it to resemble?? Thanks, Jd

Hi, Thanks for the quick response..as the form is now,when opened data is already populating subform--I want it either to appear but blank or somehow set visibility to no until after update of combos. Hope that clarifies alittle.. Jd

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, If I was going to use Quantity (Qtylow and QtyHigh) as a range how would I structure my statement using Dlookup. Thanks for the help, Jd

From what I've read this seems to be the answer..Thanks for putting me on the right track. Will post back after I have a chance to play with it. 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