Search results

Hello I have written a function that allows a "/" to be entered automatically in to a text box at the required point. The format of teh text box is set to "Short Date" If I type the date in by hand eg "12/12/2003" then i get no problems however if i set the function so that thee "/" is entered...

Thats great. Thanks Chris

Hello Is it possible to write a query that will search for data that is not a date? I am trying to change a fields data type to 'Date' however there a four fields that are not in the correct format (#dd/mm/yyyy#). I am tiold this when i try to change the tyope and save the table. I was...

Thanks for the reply Harry I wasnt actually having any problems with the code i was just wonndering if there was a more elegant way of catching the nulls that was all. Thanks anyway tho Chris

Hi this is just a general question about updating tables from code. I have a class which updates a table. The class gets its values from a function which gathers the values from a form. If I leave one of the fields in the form blank i get an error message in the function to warn me of an...

Thnaks for the replies. I think my best best bet was to load the values in to a variable and check them from there. Thanks for the help Chris

Thanks for the reply rich I was aware of the event i need something to put in an if statement if possible. Eg If the textbox has been changed then is this possible? Cheers Chris

Hi is there a way of determining whether or not a textboxes value has been changed. I am aware of the dirty property but this only determines weather or not a form has been changd - i needed to know weather a specifi text box has been changed Any advice is greatly recieved Chris

Hi I created some ASCII code that only allows a backslash (\) and numeric chartacters to be entered in to a text box. This works fin in the keypress event. However if i create the code in a module as a public function and try to call it from the key press function then the code fails (all...

Spot on once again. Thanks.

thanks for the reply. Is there a way to do it without using code? Just using queries? I will use code if i have to but i was hoping there was an easier way. Chris

Hello again.. I need to select three fields from a table however i need to select only the fields where two of the fields are DISTINCT. The final collum is a collum of unique values. I have written a query to selct the fields I require. The problem i am having is when I make the query and Set...

Hell try WHITE and BLACK box testing. They are pretty standard testing methods I think. White tests the staructure black tests the functionalitly of the software. Not too sure if this is what you need or not Hope it helps tho Chris

Cheers mate, Worked a treat.

Hello Is it possible to write a query that will compare two tables. This is hard to explain - i dont know the name of this kind of query so i cant do a search. I would be gratefull if someone could point me in the right direction.. Example. Table1 Field1 Field2 Field3 Table2 Field1...

Cheers

I have managed to find what im looking for using Dim Report As Report Set Report = "rptName" With Report Thanks anyway Chris

Thanks for the reply I have Four report all of which are the same apart from their recordsource Data property. I was trying to find a way that this could be changed at run time to prevent the need of having seperate forms. Is this kind of thing possible? Chris

Hello Is it possible to alter a reports property settings at run time using VBA. I cant seem to find the code i need to change the form. Cheers Chris

Thanks everyone got it sorted now. Still dont know whay the dates mess up tho. If anyone has any idea id wouldnt mind some adice on it. Cheers anyway chris