Search results

I'm building a macro to pull information from multiple worksheets. The source of the data for each sheet is a csv file. I will be building a form where the user can browse and import the csv files. How can I write the VBA to pull File1.csv file into Worksheet1, File2.csv file into Worksheet2...

I hope someone can help me with this. I am using sql server 2005 report services, report builder for ad-hoc reporting. I only am able to use some views and i am not able to get to the fields, tables etc., just views.....At itself this might not be a problem. When making a new field i have a...

I know; unfortunately, the installation of access is not done on workspaces. Access is on the network, and people start-up ms-access by a novell application launcher. And (as i have seen today) on other workspaces libraries are missing (also relevant ones which uses functions like mentioned -...

Thanks in advance, it could be helpfull..registering could be a problem though, while the company which are going to use my access application has a very (x 10) secured network policy, no member of the network can install anything at their workspace...

Thanks in advance, it could be helpfull..registering could be a problem though, while the company which are going to use my access application has a very (x 10) secured network policy, no member of the network can install anything at their workspace...

Thanks...that worked indeed! at least on my workspace.. I Have appearantly another problem though.....because access is not locally on the workspace, but distribuated by Novell when clicking on it, on most workspaces i get the error saying "project or library not found' (compile error); is...

Hellow world, A little question, but driving me crazy.... i have a module: Randomizer This module has the following code: dim nID as string _______________ function nRandom() as String If nID = "" Then nID = Round(Rnd(Now()) + Rnd(Right(1, 3)) * 100000) ' Rnd(Now()) + Rnd(Right(1, 3)) *...

hi, Thanks for both the api solutions...both work great on my pc... But... rivate Declare Function apiGetComputerName Lib "kernel32" Alias _ "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSMachineName() As String 'Returns the computername Dim lngLen As...

I am using the textvalue (in my case that would be for instance tjs01 as my username). Windows versions are the same on every pc.

may is ask for the code of retreiving the username? i cannot seem to get it correct. Like i mentioned in one of my threads, i DO have code to retreive the username, however on most pc's its retreived correctly but on some pc's the username is nog getting retreived and i get an error...

sharks....it doesn't work.. also this code doesn't work....anyone familiair with the problem that access causes problems when retreivnig the username? I tried four sets of different code to retreive it, none of it works in all workspaces...

Quite a simple question (but the answer may rather be large i suppose) I use ms-access 2000 db is access based on oracle a user works with the db in access for viewing reports and so on. during the day access is open as application and the user is going to do something else. After returning to...

Just for interest: Why does the person has to be in the New York area, because working from home ( by VPN connection for instance) is of course possible, also when it comes to accesssing db-ses and programs (remote desktop)

Thanks I have found a set of code searching this forum which accordingly to the notes, retrieves the username (and computername if applicable). ' Thanks for all the help!

Function fOSUserName() As String On Error GoTo fOSUserName_Err fOSUserName = Environ("Username") ' of vba.environ("Username") Environ ("Username") fOSUserName_Exit: Exit Function fOSUserName_Err: MsgBox Error$ Resume fOSUserName_Exit End Function Above mentioned code i use to...

Do Until rst.EOF Set tbl = db.TableDefs(rst!TableName) tbl.Connect = rst!PathToBe tbl.RefreshLink rst.MoveNext Loop Above code is one of the options for me to change the connection string of a linked table. I have made a table in which i have put the PathToBe and the PathAsIs...

Hellow, Little question, hopefully not a big answer :) i have four oracle db'ses mydb_db_test, mydb_db_production, mydb_db_develop within access i have linked tables from the first one; let's say: mydb_db_test.tblOne, mydb_db_test.tblTwo What i want to do is: 1) import the same tables from...

thanks! That was quick! Thanks! I used the same method to make a select all button.

Hellow, I searched for a proper thread which could help me, but unfortunately the thread i think it could help me no longer exists. i'm searching for a way to deselect items in a listbox (or deselect all items at once by pushing a button); cannot find a way to do this. Could anyone please...

problem solved! Did the trick. Unfortunately i couldn't use the 2002 access db; because i have access2000 and of course it wouldn't open the 2002 version... Thanks to all for the help