Search results

Why recreate the same table? Why not simply delete the contents of the old and import the new data to an empty table with it's original structure intact? Of course you would have to set the format property of the currency field. [This message has been edited by David Mack (edited 08-01-2001).]

Before I started using custom filter forms, I had the same problem as you. My solution was to create a macro which applied a filter and added a button to the toolbar with that macro assigned to it. Worked just fine. Your right click pop up menu on the FBF screen also has all the filter action...

I have been developing a "survey wizard" for use in my company. There are three sections needed in each custom form as follows: 1) The form header contains general information for each survey. 2) The form detail holds the questions and answers for each survey 3) The form footer holds the...

I have developed the need to operate a third party app late at night. In order to do this, I am using SendKeys. Seems the app opens fine. Once I get through the intro screens which are all dialog boxes, I need to be able to get into some utilities via the third party app menu bar. All I...

Problem solved but you could use the import spec if you imported the excel sheet as a .csv file.

Any reason we can't rename them via a user defined import specification file?

boblarson, Thank you very much. I still cannot find it in the help files. My interim solution was to create a new procedure via code which is very messy to implement, though it works...Got the idea from Susann Novalis' "Access 97 Macro and VBA Handbook" Dim frm As Form Set frm =...

Hi, I have spent the past few days working on a form on-the-fly which is a questionaire. I have been able to add labels, option groups, (what a challenge that was) and other controls with a little sweat. Now I'm stuck. I have been trying to assign a function or subprocedure contained in a...

How about setting up a form with an unbound text box (which your code would populate)-use the "on activate" or "on load" event of the form. Then, set up your form to be the start up form in your database. Also, in the "on timer" event of the form you could wait for say 2000 ms (two seconds)...

You are probably not getting any replies because this is an Access forum. People stick to Access questions here. You can learn all you need about the Excel automation by examining the Excel Object Model. You will have to open the code window and add the references to the Excel Object Library...

I am trying to run through the tabledefs in a remote Access 2000 database. While experimenting, I had no trouble looking at the tables. I then Jet password protected the target db. I have fumbled with the help facility and as a loss how to code the connect parameter. My code so far: Sub...

I have the DAO 3.6 library checked off. You are right, it's somewhere in References. Thanks, Dave

Happy New Years everyone!!! I wrote following procedure (with the help of The Access '97 developer handbook) in Access 97 and is only a small part of the app. I converted the db to Access 2000 and it runs fine. Then I wanted to make things work a little different so I figured I would rewrite...

Your theory is correct. Works like a charm! I guess the name of the column really is confusing Access. I tried all kinds of quotes and pics to no avail. I could not understand what the heck was happening. The reason I named all the question columns with a number is because I use several...

Hello all! I have a form with 58 question option boxes. I test whether the data entry person has filled out all the required information in the form header prior to allowing them to answer the questions. If the required info is not entered, I want to disable the question controls. If...

'Me' is a special object. It always refers to the current object. For example, if it is used from within the code in a form, it refers to the current form. From Professional Access 2000 Programming (various authors) page 61. HTH Dave Mack [This message has been edited by David Mack (edited...

Found it in the developer's handbook. If the form "frmSurvey" is open, IsOpen returns a -1. Then close it. Dim IsOpen As Integer IsOpen = SysCmd(acSysCmdGetObjectState, acForm, "frmSurvey") If IsOpen <> 0 Then DoCmd.Close acForm, "frmSurvey", acSaveYes End If Dave Mack

We tackled the same problem using the same idea as BillP. The idea to speed up dial in user updates to a main db seemed pretty simple--minimize the size of the transferred file. Keep it text. Avoid sending an Access app. You will minimize size by a factor of at least 100. Output the data to...

I know I've seen this somewhere before... What I need to do is test if a form is open (which could be true or false depending on the user's circumstances) and close programically it if a true is returned. I know how to test if a table exists in the tabledefs collection and then delete the...

Good point Richie! If you are performing a grand total of a column of numbers in a report (we are talking a report), the text control needs to be in the footer of the report not in the detail. Dave Mack