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

Ah I see what you mean now. We already have an in house accounting package and are redeveloping it to make it more secure,user friendly and to add functionality. Feedback from all the accountants I have worked with is that our system is much more flexible and user friendly than all the...

?? Which tool/package/language...

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

I have two tables which I want to compare to see where data has changed, but it could have changed in any one of a number of fields, except the ID (perhaps 20 fields). It is a check to make sure historical data has not changed. There is one Float field and the rest are Ints or VarChars. What...

hey fellas - sorry for the delay Thanks for all your suggestions and code. I decided that moving the tables over to SQL Server and linking them back to Access was the smartest move for now. Now it runs so quickly. Yah! I am learning more about SQL everyday and it's brilliant. [2thumbsup] Can't...

Hi tb I have already set up the DTS packages for both importing the data to SQL Server and exporting from. I have also written the Stored Procedures for running the SQL that needs to be run. I just need to know how to kick them off from Access (VBA), and have Access wait til they finish to...

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

Me too... surely someone knows how to fix this... please help if you can. thanks

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

I think I got this working successfully when I got this response. Now I am trying to do it and am getting an error: Run Time Error (13) - Type Mismatch at line: strSource = pt.SourceData When this error occurs I have strSource declared as a string. If I don't declare it, vba makes it a...

I want to use this FileDateTime function on each file in a particular directory to return dates and do certain things dependent on the date. Can anyone help me with the code to do this? Cheers Jo

downwitchyobadself thanks so much for your code. it is very helpful, however I am not sure how to use the file name code. I tried running it in a sub using: strfilename = GetFullFileName("C:\") but I get an error 7955 - there is no current Code Context Object I don't know what a...

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

Where can I get an icon editor. I am currently doing them in Paint which, as I am sure you can imagine, does not create very nice icons. Also, when I try to load the icon into my form it says "Invalid Property Value".... help - I have never done this before with VB.

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

Further to this. I have a form which has several controls and each control has several event procedures etc... can I hadle errors for EVERY Sub () without putting: On Error GoTo ErrorHandler: ErrorHandler: ' do whatever I want in ALL of my Subs? Does this make sense? Can...

thanks a bunch. was no familiar with the unload form method. Jo

Oh. I have gone through my code and commented out lots of things. It seems that even without making the form visible, it hangs when I add the items to the listbox. Is there something I have to do other than add the items? I read somewhere about having to set the List, ListCount and ListItem...