Search results for query: *

For some reason every time I Transer a date stored in a variable over to Excel, it changes the date around but keeps the dd/mm/yyyy, for example, 3rd of october 2004 would send from vb as 03/10/2004, but in excel will display as 10th march 2004 10/03/2004. Is this a known issue? can it be...

Hi Im trying to network 3 computers together all using windows 2000 SP 4. The current setup is ADSL Zoom modem Ethernet Netgear FS108 Router 3 x PCs using Windows 2000 SP 4 All the comps have identical settings and all in the HOME Workgroup yet only 2 of them are talking to each other. The...

Hi, How would i go about the following problem, I have two image boxes with different images in each of them. How would i have them merge into one image box in a position next to each other? any help would be appreciated thx

Bump. Worked out the additional problem, Needed to access the 192.168.2.1 setup screen and configure my virtual servers public ports.

The normal code is the obvious winsock1.localip to determine your internal IP address, but this doesnt locate the ip address of your WAN. Does anyone know the code to make this happen? And additionally once locating the WAN IP how for example would you communicate an IP talker from the WAN IP...

Hi, Currently learning about MSMQ and was wondering if i could set the pathname of the msmq queue to a remote server using an ip address. Currently setting the pathname to a local computer uses the following code, #If bUseDS Then oQInfo.PathName = ".\TestingQueue&quot...

Thx alot Exactly the answer I was looking for

Hi, Just wondering if i can use app.path to determine the drive letter for example I have 2 CDroms labeled D: and E: On the root directory of my cd i have i have numerous folders one of which I want to call my Auto Run from. The application is then run, but when i select the application I...

Hi Sjravee txtData(0) does exist on the form. The code above currently adds 1 text box at a time to a maximum of 5. What I would like to do is instead of adding the 4 extra boxes ontop of txtdata(0) 1 at a time, but as all 4 at 1 time, or on a variable of 2 at a time etc.

I was experimenting with different ways I could use Control arrays in run time. One formula I could not work out was, How do I add control arrays in increments of x The below code illustrates how to add the textbox array 1 at a time during run time. But I could not work out how to add 2 or 3 at...

sorry strsql = "Select * from [sea-asia] Where " _ & "[Country]" & crnow & "" should read strsql = "Select * from [sea-asia] Where " _ & "[Country]" & crdel & ""

Thx for highlighting that. With that info I was able to code a solution to my import command button. All I needed to do to my import template was to add a text line below all the headings. I used the word "Text" as this word is never going to appear for the users required information...

I have an Excel spreadsheet from an external source that causes errors when importing into an Access database. The problem states that some of the columns have a type conversion Failure. The problem is the columns that are being affected are identical to some of the other columns being...

After debbugging line by line I discovered that this line was the cause of the problem objXL.ActiveChart.SetSourceData Sheets(Analysis).Range("O10:R23") The reason why Excel is staying in the memory is because of this part, Sheets(Analysis).Range I dont know why it worked, but it...

Hi, I have written an access program, which will open Excel and create a chart. My problem though is, upon quitting excel after creating the chart. Excel stays in the windows memory. Only when I either quit access or generate an error does it remove itself. This cause a problem because, I have...

After reviewing and applying the getobject function listed in the VB help file, I was unsuccessful to open a file if Excel was already running. This is the code I used. In the module Option Compare Database Option Explicit Private Const XLT_LOCATION As String =...

up

Hi, Im designing a system that will update and create a report on a 4 month cycle using Excel. What I would like to know is, is it possible that access before updating checks whether the excel file already exists, and same for the worksheets within excel. This will be to prevent and alert...

After reviewing and applying the getobject function listed in the VB help file, I was unsuccessful to open a file if Excel was already running. This is the code I used. In the module Option Compare Database Option Explicit Private Const XLT_LOCATION As String =...

After reviewing and applying the getobject function listed in the VB help file, I was unsuccessful to open a file if Excel was already running. This is the code I used. In the module Option Compare Database Option Explicit Private Const XLT_LOCATION As String =...