Search results

Thanks again for your answer. But could you please define what you mean with strSQLname and strSQLdef? Where do I put my sqlstring etc?

Thanks for your answer! It works... But how do I filter the query before I export it?

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...

example Here is an example for how I would have solve the problem

create a query with all the fields from the table with the books. then for title you have a condition where it must be the same as your textbox where you fill in the title. the same for the rest... i have an example but it doesn't seem to work to attach it. do you have another way to get it...

Right way? Wouldn't it be easier if you used a ordinary query with the textboxes as conditions in the query?

:-( I did not get any more info about "latest record other than the current one". My sql code looks like this: SELECT SUM(tblArrend.EstTime) AS SumForPeriod WHERE tblArrend.CompanyID = tblInvoice.CompanyID AND tblArrend.Finished<tblInvoice.Until My table tblInvoice looks like this: InvoiceID...

Thanks Thanks, I will try this. About naming the fields, I don't think it would be a problem beacuse the database will be in swedish not english, but thanks for the comments, that was new and good information. Best regardz, Spikemannen

Yes I have already done that, just a mistake when I wrote it down here.

Solution? Hi, here is some code that I have been using before, and it works fine for me. tblUser pkeyID strUserName strUserID strPW frmLogIn Use this code for your LogIn button: Private Sub cmdLog_In_Click() Dim intLogonAttempts As Integer If IsNull(cboUserID) = True Then...

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...