Search results for query: *

DerickD, Have you tried using a reigistry file? The below example is for SQL Server but am sure you can modify for use with MS Access. Let me know if you are able to adapt this to MS Access. Make sure to save as .reg. Hope this helps. REGEDIT4...

drewby1, I think this will work out just fine. I'll just need to do some modifications. I really do appreciate the help. Will let you know how this works out and thanks again. kupz

I am trying to automate a daily process. Basically, accounting does a manual release of a batch of invoices in the order-entry system which ultimately updates the SQL server tables. The manual release is done at different times by accounting. An email is sent out to an analyst by the DBA once...

I am trying to automate a daily process. Basically, accounting does a manual release of a batch of invoices in the order-entry system which ultimately updates the SQL server tables. The manual release is done at different times by accounting. An email is sent out to an analyst by the DBA once...

I am trying to find a website where I can download the ODA driver. Does anyone have a siggestion? Thanks.

Paul, I really appreciate your help. I'll try it out. Thanks, myniguez

Bryan, I am not a VBA prgrammer expert but have used Access and Excel for a while now. Do the users need to use Excel as an interface? Can't this all be done in Access? Unless the user needs to do some data manipulation I think Excel is needed but I think in your case wouldn't Access be your...

Hi there, I've tried using the RunApp method to run a vbscript app and can't get it to work in Access. I might have to use VBA to accomplish this. Do you have any sample code on how I might begin to do this? Thanks in advance.

fengshui_1998, You're a saviour. I will try doing this and add to what I already have. I actually just posted another message in the message board and I was just thinking of doing a DSN connection and getting the value from a period table since it contains the current month-end value. But I...

Hi there, I am trying to obtain values of from a table in a database and write the values to a text file. I am pretty new to VBSript and do not have the slightest clue to go about this but do know that I have to extablish a connection to the database. If you have a sample code, that would...

fengshui_1998, I have a small problem here. I've done all the coding to automate my tasks but I just realized that every month-end I will still have to change the second and third line of text. Is there a way around this? Thanks for the help again!

fengshui_1998, This is great!! I can't thank you enough. I've automated all my tasks at work. Maybe I can sit back now and relax at month-end....don't think so. Thanks again!

fengshui_1998, Thanks for the advice. That's a good idea. Do you think you can give me some sample code so I can do this? Thanks for your help!

fengshui_1998, Thanks for the advice. I think that is a good idea. Do you think you can be me some sample code on how to go about this? Thanks again! myniguez

I am new to VB scripting but know that this problem of mine can be solved using this languauge but just can't figure it out. I am using VBA to export text files from more than one Access database to a directory. These files are used to load another application since it is a file-based system...

Yes, that's correct. The Switchboard database will be the main interface and a means for adminstering these databases.

Yes, I think I should elaborate on this. These databases are located on a network and each database contains small and large amounts of data. These tables could all be linked in just one database but I want to run these databases in from just one database since a database represents a specific...

I'll play with it some more and see what kind of solution I can come up with.

I am needing some help. I am currently thinking of building a database that will be my main switchboard for all other databases. I can probably do this in VB but wanted to have flexibility checking numbers in the Switchboard database. There are macros and some code that updates these...

kenhamady, I did try this method and basically would not work. What happened was it would let me choose the underlying data, you would be able to choose the data, for example, dimension is Period and you have under that Level 2, this would contain the months. So if I pick Oct then it would...