Recent content by BigBlueScreen

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