Search results

I found some partial solutions to automate the import process of an XLS spreadsheet to the database as a table. They involve the retrieval of the path to the XLS file via "file control" and using the retrieved path of the file using some code: DoCmd.TransferSpreadsheet acImport, , tblName...

AH! microsoft actually considers this a problem/bug! i think i'll be using the code you suggested instead. thanks for the tip... are you ready for my next question? :)

Yes, I can tell it is slightly faster by the refresh of the list box. You know what else works? (And probably the fastest of all...) Me!lstbox.Requery (I just discovered that, but I appreciate the technique of your code.)

yeah and I think I just realized that if you hold down Ctrl while clicking on the (last) highlighted selection, it will no longer be selected. But how about a Command button that performs a "deselect all" operation? Is that possible?

Very nice. Thanks. One more question regarding the list box. Once an option has been selected in the list box, it stays selected even if you click somewhere other than the list box. Is it possible to get rid of the highlighted selections in the list box with some code?

I would like to include a way for the user to be able to delete multiple tables simultaneously from the database. I've got a (scrolling) list box where the user could select an available table from the database, along with a command button that would take the selected table from the list box...

What do you mean, like in the header of the report open procedure?: Private Sub Report_Open(Cancel As Integer) Or do you mean in the call to open the report from the switchboard?: DoCmd.OpenReport "My Report", acViewPreview, , ""

I've got the following process: -Switchboard opens, allowing the user to run a report -there's some conditional checking in the report_open procedure to see if the report should really be run: -if the report should be run, it continues past the conditional checking -if the report should not...

F11 did work, but not by itself. I had to hold F11 down while clicking either the X (close window symbol) on the window itself or while clicking my "Quit" command button. Thanks.

one more question: unfortunately, i had my database display a form that doesn't allow a right-click menu (to access the design view) and it doesn't allow selection of any other part of the window until it's done... and i also unchecked the display database window button so when the form is...

word.

How can I have a form opened automatically when the Access database is opened?

Is it possible to automate the process of importing a MS Excel table into the database? All of the answers to the choices given during the import process would be the same. Example: (Import) Excel File (browsing to select file would be the only selectable option) First Row always contains column...

I've discovered a workaround (even though I don't like workarounds): What I'm trying to do is set the value of a text box in an object (report) other than the active one (form). What I did was set the .Caption value of a label in the report from the form. That has the same effect of changing...

I've got a report that, upon opening, opens a form: Private Sub Report_Open(Cancel As Integer) DoCmd.OpenForm "TableChooser", acNormal, , , acFormPropertySettings, acDialog, "" End Sub In the form are 2 combo boxes (one that chooses the record source for the report, the other sets a value...

What I'm trying to do is take the value of a control, compare it to a specific string, like "New York" and if the strings match (preferably not case-sensitive), change the value of the control to the state's abbreviation. So you're saying this will work: If Me!EPState="New York" Then...

If StrComp(Me!EPState, "New York") < 1 Then Me!EPState = "NY" End If

Wait, wait wait. Craziest thing- It works now. Seems that any time you chage some code, the 1st time you try to run it, the error I previously described comes up. But after that 1st run, the program works fine. It's like Access needs to flush its memory in between the compilation and the 1st run...

Well, actually, the report is already open. The report opens up the form (with the combo box in it) by using a DoCmd.OpenForm command. And yes, I'm trying to populate the combo box with available tables names (to use as the RecordSource in the report), so Type should remain =1, I believe. It...

OK, I think I'm getting some of the SQL syntax. I did not, however, realize you could create an SQL right in a procedure by creating it as a variable- that's good to know. I've placed the code in the Form_Open procedure. Mile-O-Phile: When I put Sconly's code in (with your variable...