Search results

Hi If I open a query in Access and uses the "Export to Excel" button everything works out just fine. But when I want to make the export with a button using the code: DoCmd.OutputTo acOutputQuery, "qryToExcel", acFormatXLS I only get 255 chars from the PM-fields to excel. Can anyone help me...

Hi When I click a button I want to make sure that the post hasn't been edited in anyway. If it has been edited I wan't a msgbox to ask the user if he/she want to save the changes made. Anyone here who can help me with this?

Hi, I have a problem with a listbox that uses a querie to show posts. In the header of the listbox the fieldnames is showed like: tblTable.Object instead of only Object. In the querie there are two fields that has the same name. Object from tblTable and Object from tblObjects, I think thats...

Hi! I have a table with x columns. In a form I can choose 4 different columns to define my search. Now, I have this SQL-statement, that strangely doesn't work. Can someone help me with this? SELECT a.Nr, a.Objekt, a.Applikation, a.Modul, a.Datum, a.Anmalare, a.Onskemal, a.Klart, a.Prio...

Hi! I have developed an application with MS Access 2000 and made a setup file with Access Runtime. The problem we get is that Access built-in menues and dialogs in the distributed application is in english (I wan't Swedish). I know that in some cases it is in swedish but I can't recon where and...

Hi! I have five tables: tblCompany CompanyID CompanyName tblSubject SubjectID Subject tblHandler HandlerId Handler tblArrend ArrendID Company Arrived Subject Arrend Handler Prio Description Status Finished Time tblInvoice InvoiceID Company InvoiceDate Until Time For the function I'm after...