Search results

I succedd!!! I changed the source object and just after it I did requery :) Ben

hi :) I do have a form with listbox I do have a subform which supposed to change following listbox selection I did it by requery everything works well except the loading event of the sub form this event makes fits and changes based on the kind of the record but here, when it's loaded in the...

hi :) I have two values which are took from one table usl define as double lsl define as double in for, I have a regular text box the user type there his result I want to check if the user value in the text box is between lsl and usl I used with regular "<" ">" but I understand it doesn't...

but now i'have new problem it doesn't do what I ask in the criteria for example: it's the code strSQL = "SELECT id_event as îñôø_àéøåò, ID_fault AS îæää_ú÷ìä, name_fault as ùí_ú÷ìä, date_start_fault as úçéìú_ú÷ìä, date_repair_fault as ñéåí_ú÷ìä, production_diary1.lognum as...

I don't know how and why I did it before and it didn't success now it success I removed all the '

I really wanna cry I tried all my best but something wrong! I'm sitting already 6 hours!! :(((( Private Sub Command2070_Click() Dim varItem As Variant Dim clientmac As String Dim clientwork As String Dim lngRow As Long If IsNull(Me.stard.Value) Or IsNull(Me.findate.Value) Then MsgBox "îìà...

thanks! but it can be more then 100 is it still the right way>?

ok so it's not define in the same manner, the machinenum field of the problematic table is define: SELECT machine.IDnum, machine.namemach FROM machine; union SELECT '999', 'genral' FROM machine; while machinenum is define in all other tables as SELECT [machine].[IDnum]...

I have some tables which long field - machinenum (machine numbers). I created some recordsets for each sheet in the file I export to. I have a multi-selected listbox with values which represent machine numbers, the user select the machines , he wants to export records for. Instead select in the...

hi, I try write vba for export tables to excel - and I deal with some problems; 1. for every recordset this line works well: WHERE [machinenum]='" & macs & "'macs - it's string and in the origin tables , machinenum is long only 1 recordset "remember" it expects to long and not string and I...

hi :0 how can I compare two dates but ignore the seconds?! (just the date... hours and minutes) thanks! Ben

lol :) thanks u

I found I made it all red to text box and the setfocus move it to front thanks

because it a lot of work and calculation and its required a lot of controls now, I calculate the width and the left of any red.. and fit its size and position

I made it so textbox and set focus but I got an error the command isn't available now

no they with different size it one long green and a lot of short red on the green (so if I see red - it's fault time, If I see green - it's working time)

thanks I can't setfocus on it to make it textbox?

hi :) I do have one long box (green) and vba which creates of other red short boxes (which represent fail times) i would like to assign the red boxes on the long green box so the green is on the background i understood its problem in access i would like to hear creative ideas how to deal...

I really understood I can do replace for ' but I want to ensure, ' is the only problematic char which can be passed by textbox in sql?

yes I saw it thanks u so mach ure wonderful but i'm liitle afried use this function case I don't understand it and i'm afried I will make my sofward more slowly