Search results for query: *

Hi there I have designed a form in Outlook and I want the command buttons on the form to perform different tasks. I have NO IDEA how to assign code to these forms despite trying very hard lots of times.... do I have to use the VB Script window? If so, what code do I need to use. The object...

Hi all I am trying to decide on which app to use to develop the front end for a new system I am building. It is an in-house Accounting package so will be used by Accounts team for GL entry, journalling, data import, reconciliation etc... It will have SQL Server 2000 back end. I am very...

Here's the deal... I have an entire system set up in Access at the moment and am slowly moving it over to SQL. Unfortunately I have just started this and need to keep the current system running until I can get the whole thing working. So, until then... I have one task which I would like to run...

We have a "system" which is very large and unstable. I think this is due to the sheer size of what we are trying to do in Access 97. Would very much appreciate feedback/thoughts on what I should do. This is my situation: We extract about 900MB of data from an AS400 and 50MB of data...

Hi I have some data which I need to parse out as follows: the data will be something like this 0001 Jo Jones 0002 Water Margin I need to put 0001 in Column A and the rest(minus the space at the start) into Column B. Normally I would either use Text to Columns, or if more than one instance...

Hi there I have a table (tbl1) which is stored in database A (dbA). I have several other databases which have links to tbl1. I have added a couple of fields in tbl1 and want to use these fields in queries in the databases which have a linked tbl1, but as there are loads of them, I am not sure...

Hi there I have several pivot tables linked to access dbs. Is there anyway to retrieve the path of the db each of the pivot tables are linked to using VBA? Thanks in advance Jo

Not sure if I have done this exactly right. I have a form with a list box which I populate with data. I then show the form so the user can select from the listbox. The user will then click OK and a process will run using the selections from the listbox. After the process is finished, VB seems...

Hi I am trying to run some prodecures in Access databases but have the following dilemma: We have a user workgroup set so a username and password have to be entered before getting into Access. By using a Connection object (in VB) I can get past this security by putting the username and...

I have the following code to connect to an Access db, but I am getting "Run time error 3706: Provider cannot be found. It may not be properly installed." My code is: mydB = "C:\Financial_Reporting\Data_Sources\Replicable\" & _ "Variables_Data.mdb" myPwd =...

I have the following in VB... Public Sub Main() Dim myAccess As Access.Application Set myAccess = New Access.Application myAccess.OpenCurrentDatabase ("C:\Test.mdb") myAccess.Run "myProcedure" myAccess.Quit Set myAccess = Nothing End Sub It work just fine, however we have...

Hi there I have an error handling procedure which gets various data (err.number, some variables, currentdb.name etc..) and puts it into a db using ADO. My problem is that I have several databases that use this same procedure. I currently have the error handling code in each database, so if I...

I currently have a Make-table Query (qryMake) which outputs the result to a table in a seperate database. It takes anywhere from 2 minutes to 10 minutes to run and I would like to make this quicker by using recordsets if possible. I have also set qryMake as a querydef and executed it which does...

I have two tables in an Access db which, after a lot of processing has been done, should be exactly the same. By this I mean that there should be the same number of records in each table, and each record should exist in both tables with exactly the same values in each field. The tables are...

I wonder if it is possible to get the name/number of the computer that a database is open/processing on. ie.. my PC on the network is number 544. I want to identify the number of the computer and then write data to another database, but the path of the database will depend on which PC the...

Good morning. I have a pivot table which gets data from an Access db. It sums amount by certain parameters and returns totals. Where that total is = 0 I do not want to see it in my pivot table, but I cannot seem to find how to hide it, as the total is not a column or row field, but derived from...

I need to be able to kick off batch jobs to process on a colleagues PC. Currently his drive is shared and I have Read/Write permissions. We run batch jobs which open various databases and process stuff, but all the resulting datasets are placed into databases on the c:\, hence if I run the...

I want to go through every cell on the current worksheet, or every cell on all worksheets to find where a given string exists. Where a cell contains this string I want to analyse the entire string to determine what is in that cell and return a new value to that cell. I was thinking of using...

I have a whole bunch of dbs with linked data which I want to move from my C drive to my D drive for space reasons. I need to be able to change the links in the dbs so they look for the sources on my D drive not my C drive. Is there some way of doing this using code rather than linking tables...

I have a few queries which I run using come code... .RunSQL "Delete * FROM tblOS" .OpenQuery "qryAppendOS" 'appends data to tblOS .RunSQL "Delete * FROM tblOutstandingsMovements" .OpenQuery "qryOSMovements" 'appends data to...