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

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

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

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

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

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

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

Hi, 2 hopefully quick problems. I am trying to open an excel spreadsheet using Access whereby the user indicates the location in a text box. Currently my text box named test uses this string ... " "&me!test&" " When I add this to this function Set myXL = getobject(...

Hi, I understand Access has an inbuilt Progress bar function using sys cmd, but I would quite like to design my own. Can any one help me with the code needed to do this. As its custom build i only need it to count upto 20, using boxes as the measurement. thx

Hi, I am new to linking access to excel. I have a solution to a tedius task of rearranging unsorted data stored on an excel spreadsheet. As this report produces identical data placement, I want to use access to delete unwanted columns and rows with the touch of one button. Could someone pls...

Hi, After creating an aging report, ive learnt that to update the whole table, I need to use an update query. Could someone pls explain to me how I could use this query to do the following. I have a text field that calculates the no. of days from transaction creation to transaction close. If...

Hi, After creating an aging report, ive learnt that to update the whole table, I need to use an update query. Could someone pls explain to me how I could use this query to do the following. I have a text field that calculates the no. of days from transaction creation to transaction close. If...

Hi, After creating an aging report, ive learnt that to update the whole table, I need to use an update query. Could someone pls explain to me how I could use this query to do the following. I have a text field that calculates the no. of days from transaction creation to transaction close. If...

Ive created an aging report inwhich all the coding is done using VB on a form. When a record is over one day old the status text box changes from "open" to "overdue and highlighted red. when creating a record and skipping a head one day, I have a problem where, when viewing as a...