Search results for query: *

I hope this question fits the category closely enough. I recently received a PDT 6846 when a friends company was consolidating their warehouse operations and closed some branches. Unfortunately I'm not any sort of DOS programmer and am at a total loss when it comes to writing a simple program...

Is this even possible? I would figure with a little VBA and RegEx it can be done, but I have no idea where to begin. Anyone that's done it before care to share a little advice, or snipets? If it helps, I'm attempting to import a Web Server log into Access for some processing, but the...

when you take a power point presentation and save it as html, the images are enhanced quite a bit compared to what they were originally in the presentation. however, due to the way the page is generated, you can't simply right click and save them. can they be extracted? I don't just want the...

I'm creating a text file, and need to set the length of a variable to 30 characters, no more no less, but since I am compiling my data from a mass of sources, and am not able to use the "transfer text" method, I can't specify a file layout. I've tried to use Format$, but have been...

I am creating a recordset with a simple select statement, which returns the desired records (with my current test data that's 3 records) I use rs.MoveLast to help me get an accurate count and then rs.MoveFirst to start examining the data. rs.MoveFirst gives me error 3021, No current...

Maybe I'm missing a reference, but I can't find an Access 97 equivalent to "Current.Project" I'm trying to convert an Access 2000 application to 97. I don't even know what Current.Project does to try to create my own function. Any direction or assistance would be greatly...

I have a text box on my form which combines First and Last name fields. Sometimes either name has extra padding which I want to remove before displaying the data. I was using the following functions in the Control Source for this field: =Nz(Trim$([firstname]),"") & " " &...

I have a query in which I use the "last" and "group by" functions to limit the results. I want to return the value of another field in the desired "last" record, but I have not been able to figure out how to return that value...I assume I need to use...

I'm attempting to adjust the header on my spreadsheet to display the value of a cell (A2 in this case). I understand that I need to use the BeforePrint command, but I am stumped as to how to call it or name it or reference it so that it sets my header. I am somewhat familiar with VBA in...

I'm sorry to post another thread about the common dialog control, but I have been rather unsucessful in finding what I'm looking for. I want to default to "Details View" when I call the common dialog control. Can I do that? TIA - -Dan

I am having a really hard time wrapping my head around how to update my status bar while I am running the transfertext command. Can any one help? I have a status bar and a pop-up form and it works when I have an incremental value to pass it, but I don't know how to get Access to either pass...

I have been working on this for quite sometime. I originally posted to Access VBA, but haven't gotten any response...so I'll link it here. There's got to be a way, I have read that this command requires the use of "send keys" but I don't even know how to do that, or to make the...

My head is spinning with ideas, but I'm having a hard time putting any of them together. My DB is something like this (acc97): 4 tables - 2 are SQL Server tables, 1 is a local table, and the last is the table I want to insert the data into (also local). I have a connection string for the SQL...

I have a bunch of DBs that are in Access 2k format. I have 2k, but use only 97 at work (where I want access to the 2k databases) I was trying to use acCmdConvertDatabase, but I can't seem to pass any variables to it. I want to set up a form in my Access 2k DB that allows me to select the...

I have a rather simple database application which has a few forms and a couple of tables. You can enter data into the main table with a form which writes the records via VBA. The main purpose of this db however is to create a file which we export from the main table to a text file and read...

I have an Access 97 database/application that was working not too long ago, then I made some sort of change just before I went to lunch and when I returned it no longer worked and I don't know what I did. Here's the error I get. " The expression On Load you entered as the event property...

Here're my issues: 1. I'm completely new to VBA programming, but I'm getting there...slowly. 2. I have a table that I want to export to an Excel spreadsheet, easy enough, but when the user clicks the "export" button, I want the default location to be on the desktop of the current...