Search results

well i would suggest inserting through DAO in case of Nulls or special chars you might have a problem later on

well although i found the anwser to another forum thank you for replying the problem is that this is the company database that i work on and i wasn't the one to design it also you need () or it propubly won't work select A.ID...

well i can't do that so what im trying to do is a multiple inner join with the same table

Hello yet again here is my problem i have two tables one is Clients the other is Destinations in Clients i have ID , name and DEST1,DEST2,DEST3 in Destinations i have to fields DESTID and description now the thing i want to do is is after each DEST to get the maching description something...

then isted of macro try tis code DoCmd.PrintOut acPrintAll, 1, , acMedium, 1 it will print the whole report in medium quality if you don't know how to use it just create a new button right clik choose build event code builder and paste it there Private Sub Command13_Click()...

well that strikes me a bit weird it just gets printed without confirmation its not even asking for which printer to use?

well that is a weird question one table one column well if you want the whole set of the table the sql query you want is this SELECT * FROM table_name now if you want some criteria you want this one SELECT * FROM table_name where field_name = value if its a char or string you will...

well Gasman i did some ting like that sqlrest = Left(sqlrest, Len(sqlrest) - 1) sqltotal = sqlsum + sqlrest + " where " + filter2 MsgBox sqltotal strQry = "TempQueryName" If test <> "" Then Set db = CurrentDb Set Qdf = db.CreateQueryDef(strQry, sqltotal) 'DoCmd.Close acQuery...

lets make an update what i have done so far after i choose the columns i make an sql query and i save it with the name TempQueryName then i get the filter as a string filter2 = me.filter then i replace the part of the filter with tha name of tha table and from...

So here is what i want to do I have a report created by two tables no problem so far i what the user to be able to select the columns that he wants to export and also filter them what i have done so far is that i created check buttons and each check button contains on part of the sql...

the problem is that i have the report ready and on top of that report i want to choose some of the fields and export them to excel my problem is how do i get the name of the fields so that i can create the query that will get me the results that i want for example my report has the fields...

hello this is my problem i have a report that brings to many fields and i want to export some of them to an excel file does anyone has an idea of how to do that ? is thinking of something like a second report that by clicking the label of the field s you could get the names of the fields to an...