Search results

Thanks for the help. However, i do not quiet understand how to get it done. The table i want to export resides in the navigationpane. how can i manually save this datatable in another folder ?

In my Access database i arranged an export of a datatable to a textfile. I forgot to specify that the first row in the textfile had to be reserved for the fieldnames. Now i want to fix that, but by no mean i can find out how to do that. i first tried the following : Clicking on the saved...

In my program for booking orders,i have a special table "tblSpecPrices" with three fields: KlntID, Artnr, SpecPrice If for a client a special price is foreseen for a particular article, then there's a record with these data saved in this table. When such a client put an order, the program is...

Yes,it helped me out of trouble Thank you

Thank you for the help

I want to have the possibility to undo some changes on a subform by clicking a button . I know that moving the focus from the subform to the mainform has as consequence the the change in the subform is saved and cannot be undo. Is it possible to have a button on a subform that ,when clicked...

In a mainform i have a combobox to let the user choose a compagnyname. Based on this choice , a combobox situated on a subform has to display the articles that can be delivered from this compagny . The combobox on the main form has as dependent column, the LevID which is unique for each...

thank you very much for the advice greetings from Brugge - Belgium

On a form with a few columns, i have on top of each column a textbox where the user can fill in a value that will serve as filter for the recordsource of the form. The tag of each of these textboxes has as value the name of the controlsource of the field of that column. In the afterupdate event...

Thanks for the usefull advice

Depending on the fact that a report has been printed or just viewed in preview, the data for the report has to be saved or not for later use. In this context i would like to know how by mean of vba code can be checked that the report has been printed or not?

Thank you very much for the help

In a form "frmAankoopArtikelen" i have a combobox ' cboLev' to let the user choose a delivery agent. After making a selection, the value of "LEVID" is stored in the textbox "LevID" On the same form i have a listbox "lstAvailableItems" with a recordsource based on the following query. SELECT...

I like to thank you for the help

For backingup purposes i use the following code that's works fine. However, after running the code, the new table isn't display in the navigation pane. I have to press the functonkey F5 to get it done. I added the code : SendKeys "{F5}" but that didn't help. What can i do to see the table in the...

I have a report that can be called from a form by clicking a button. When this report after opening is closed again, the following procedure is attached to the closing event of the report takes place:: Private Sub Report_Close() Forms!frmPrijslijsten.Visible = True...

that's the code behind the event of the CmdNew button: Private Sub CmdNieuw_Click() On Error GoTo ErrorHandler Bladwijzer = Me.Bookmark DoCmd.GoToRecord Record:=acNewRec Call LockControls(False) Me!cboAgent.SetFocus Me!cboZoekViaKlntNr.Locked = True 'Bij invoeren van...

In a form to manage clients i have a button CmdNew to enter a new client. I have no button to save the new record, because it seems that Acces makes that possible without any other intervence. After entering the new record, when i want to go to the first or another record by means of the...

Thanks for the help

On a site i found the following vba code to compact a ms access database . This code is written for Access 97 = 4 and Access 2000 = 5 . My question now: is it possible to use the same code for compacting a ms access 2007 database and what number is to be used as enginenumber? Public Sub...