Search results

I just renamed the field name, and all references to the "old" field name, and still can't get the function to work. Do I have my query setup correctly? I am only average when it come to this VBA stuff.

The field names are derived from the export from the originating DB. Are you saying that I just need to rename the field to make the function work properly? have you managed to get the function to work with a rename field? Thanks,

Here is a sample DB to explain my problem better. you will see a table, a query, and a module within the MDB. Any assistance will be greatly appreciated.:confused:

Here is a sample DB to explain my problem better.:confused: you will see a table, a query, and a module within the MDB. Any assistance will be greatly appreciated.

Found part of the problem, but still need assistance. I realized that I had the module & function named the same, and needed to modify my Qry string. The function runs, but doesn't perform the concatenation. Please help.:confused:

I need to merge several fields across a table into one field. The table was created from a XtabQry that has several blanks across, that I would like excluded. I found some function code on the net, but can't seem to get it to work. Can someone please provide some assistance?:confused: Here...

I have tried this code with & without modifications, and it isn't working. Just to be clear. I am trying to do the following: I have a switchboard item that queues a report. On the report's "On Focus" event, I want to export the report. I want the exports to go into specific folders based on...

I have attempted to apply your logic, and don't think I'm doing it right. Let me explain what my code was doing, and see if we are on the same page. Please keep in mind that I am a beginner. Private Sub Report_GotFocus() 'Takes value from Combo6 to determine which folder to create new dated...

Thanks for your reply, and I am looking into the ASP.NET 2.0 All-In-One Desk Reference For Dummies. Do you think this will guide me in the right direction, or do you recommend another series?

Thanks, but I don't quite understand what you are saying. Can you explain a little further? I'm kind of a newby, and need a little more info.

I am only a beginner... I have the following code running on a report, and am wondering how I can auto increment the exports (Example: : 001, 002, etc.). Any help is appreciated. Private Sub Report_GotFocus() If Forms!SelectReportType!Combo6 = "Normal" Then MkDir "C:\Documents and...

I think I understood your explanation as follows; Create Log table for importing. Create splash screen with 1 sec timer. During 1 sec, log current date, check date against logged dates in Log table. If date exists, stop macro; otherwise, import current date data. I'm not sure that will work...

Hello, I am curious to know how difficult it is to create a access DB, and convert it to HTML for use on an intranet. I have been told that the best way is to create a SQL DB, and write some ASP code to link the HTML file to it. I don't know ASP, nor SQL. I am very intelligent, and have...

Thanks for the info. This project has been changed a little, as to I will be getting just 1 export with everything I need. Can your logic be applied to an On Open Timer event of the DB? Let's say a user logs in to the DB after 7AM, and the DB triggers your code to process the import. I have...

Dynamic Linking Of Workbook In regards to your linking suggestion... Is it possible to create a dynamic link to the workbooks? Meaning that it will import the workbook that applies to that day. The example below is for importing, but i assume there is a way to link in the same manner. In my...

Daily CSV Exports Thanks DCrake, That would work, but the exports work like this: For a given date (05/01/2008), at midnight the DB will export all activity for the current month. Friday morning I will have a CSV that has all data for the month of May. The export is programatically named...

Hello All, I am average when it comes to VBA, and I am mostly self taught. What I need to do is automate a daily import process from daily DB exports. Here is what currently happens: I receive daily exports of several different DB grids (3 total). These exports are in CSV format, with...