Search results

Here's another question similar to my previous. Is it possible to have a macro prompt me for the path to a specific file/table I want to import? Thanks, SKK

I have a macro that imports a table from a network drive. I have hard coded in the path. However, each year file location changes. Is there a way in a Macro to adjust the code based on some other parameter? Under the "TransferDatabase" action, for the "Database Name", I hard coded...

Thanks Chris, I will use Length1 and Width1. Is there a listing of "reserved words"? Thanks again, SKK

I've notice a situation in a few database's we have. One is where we track sidewalk construction. There are two called fields LENGTH and WIDTH. In my report I have text box with the control source =[Length]*[Width]. However it returns some bogus number. If I change the field names to...

I've been reading all the post regarding this. However, I have not found a solution to my problem short of rebooting, which except under extreme circumstances is probably not an option. I did look at the ldb file using Notepad. I says I'm the culprit. However, I had truly closed the app...

We have a couple Access 2000 database's that are updated from Oracle data each night. There is a routine that opens Access, updates, then closes. However, on numerous occations, when it closes, the ldb file is still there. I can not delete the file without rebooting the server which I do not...

Disregard - I used an SQL command vs. wizard. SKK

Is it possible to have more than 9 OR criteria in an update query? Thanks, SKK

I understand and for the most part this works fine. However, I need this table for a GIS project we're working on. Thanks, SKK

I have a Select Query that counts the number of occurance. I would like to update a field in the table (or a different table) with the numbers returned by the count. I have attached a snapshot of my select query (query.jpg). Is this possible? Thanks, SKK

Thanks for the advice... SKK

That did it. Thank you very much... SKK

I have a module called GetFile() that verifies a network connection. Public Function GetFile() If Dir("\\city_server\engr_files\sidewalks\2005\swk_05.mdb") = "" Then MsgBox "Could not locate file - please verify network connection..." Else DoCmd.RunMacro ("macImport")...

I have two databases with similar sidewalk reconstruction data in them. One is on a laptop in the field where data is modified/updated, the other on the server in the office. I'd like to update the office data from the laptop data. I want to Export the laptop table (SWK) to the office...

Excellent ghudson.... Exactly what I wanted. Thanks again, SKK

I will try and let you know how successful I am. Thanks all, SKK

I have a DB with a form based on a query where we keyin a parcel identification number (PIN). If there is a corresponding PIN the form opens. If there is no PIN available, a blank form appears. Is there a way that if no corresponding PIN is found, a different form or message box would open...

No, but I believe I found a workaround. I added a command button and reduced it's size to almost nothing with a GoToControl that starts with the very small command button. I know, pretty sloppy but it works. Is there a way to create a form with buttons but no focus? Thanks, SKK

I have a startup form with three buttons. All three buttons have Tab Stop set to No. However, when I open the form, there is a highlighted box around what would have been the first button set in the tab order had Tab Stop been set to Yes. Is there a way to not display the light green box...

That did it. Thank you very much. SKK