Search results

hmm, Do you need to do this in code or in a query? Have you looked at the "Between" function. ShadeZ

Only thing i can suggest is use the date format "DD/MMM/YYYY" then regardless on the format used in the system the date will be correct.

Hmmmmmm Different character sets mabey?? Ie both have the same character code but because its a differnt chr set you get a different chr displayed.

Msgboxs are easy, VBA if msgbox("Are you sure?",vbyesno,"EXIT") = vbyes then 'close form end if I suggest you look in the help its very informative. :cool:ShadeZ:cool:

you have answed the question your self. USE A DELETE QUERY. DELETE SelectedItems.SelectionID, SelectedItems.EquipRef, SelectedItems.ItemNo FROM SelectedItems WHERE (((SelectedItems.ItemNo)<>"1")) and selecteditems.selectionid=[forms]![SomeForm]![SelectionID]; now it will only effect...

1) this is posible, and not very difficult. 2,3)If you dont know VBA then i would give up now

No problem mate!

The only way a break point is not triggered is if the code isn't run. Are you are using error handling, have you turned it off? you could try outputting to the immediate window to test the execution of the code. try adding this line to your code and running a test. debug.print "Test" if...

The most comprehensive way of counting the difference between 2 dates (That i know of) is to use the VBA function DateDiff. DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) eg days = datediff("d",txtSomeDate,"6 Jun 2004") :cool:ShadeZ:cool:

all you have to do, is reset the form making all the buttons visible. add a new button (BtnReset) to your form and place then code in the click event. sub BtnReset_click() button1.visible = true button2.visible = true button3.visible = true button4.visible =...

you will need to change the Button name to your button name. oh and i made a mistake the example i gave you would hide the buttons as defualt use button2.visible= getsetting(currentproject.name,"FormSetup",button2.name,"1") instead, this will set the buttons visible by default. ( its the...

What you need to do is store the status of the user, in this case we use the registry. use the code below to store info. Best place to put it is on button_click. SaveSetting CurrentProject.Name, "FormSetup", button1.Name,button1.visible 'Note you need to repeat this for all the buttons...

2 options 1) edit the design of the form, making the change permanent 2) save the progress of the user, then when the form is loaded use the saved info to hide the appropriate buttons. ShadeZ

y cant i edit my posts............................ i can now just to make things clear instr returns 0 - string is not present 0> - location of string

There is another way....... instr does return true and false for a string search try (IT WORKS) if instr(1,SomeString,SomeTestString,,,vbtextcompare) then 'sometesthing is contained within something end if if not instr(1,SomeString,SomeTestString,,,vbtextcompare) then...

hmm that seems like a lot of work, its not going to be very efficient. ur table will end up looking like this Test1,test2,test3,test4,test5, 1 1 1 1 1 1 1 1 1 1...

I think it only suports the bitmap format. Just convert your graphics to bmp.

they easiest way to do this is with a sub form.

Sorry, i didnt notice you were using spaces in your field names. I prefer not to use spaces, they are just to much hassle. anyway nice to c you sorted out. :cool:ShadeZ:cool:

You have been beaten to it by a good 3 hours, Oh and nice infiate loop.:rolleyes: