Search results

Hello You could try the on keypress event of the combobox. This will tell you which key (in ascii code) has been pressed so you can handle them i.e set it to null or another value. Chris

Hello Can any one tell me how i can display the field headings in the page header of a subreport in the detail of a main report. Cheers Chris

HELLO Nice one cheers! Chris

Hello Does anyone know how to find out all the reports currently open? Chris

Hello I got rid of the link to the look up in the query and that fixed it. Cheers Chris

Hello (fizzio again!) Tried that and it still remained huge so i've used the movesize method and that seems to work. Cheers for the help

Hello That is exactly what i've tried to do. The field was set to required and i got one set of messages saying cannot save record required field missing etc. However my users are not clude up on microsoft error messaging so i was trying to be as bit more user friendly and do the validation...

Hello I am trying to a get a form into dialog mode. I have set the border style to dialog and modal to yes removed all of the record navigators, scrolls, min max etc but when i open the form it's maximised, an acre of form and my controls in the top left corner. I've set the form in design...

Hello I am trying ( in vain ) to create a password admin form for a database. Background: I have one table Tbl_LOGIN with USER_ID (AUTONUMBER) PK USER_NAME(TEXT) USER_PASSWORD(TEXT) USER_LEVEL (INT) A SECOND TABLE TBL_USER_LEVEL LEVEL_ID (AUTONUMBER) PK LEVEL_DESCRIPTION (TEXT)...

Ok call me Mr Thicky Pants. I can see exactly what you mean, as for a solution. Well... i'll have a think this evening if you come up with something good luck! Chris

Hello Please forgive my ignorance of your predicament. I've run your code and would appear to work fine. I've tried doing a sort on the week in your table it looks happier then. See your fixtures table. If this isn't what you expected please provide more detail. Chris

Hello You have a potententially serious problem here. I'll firstly explain the query. In the query design view you can link the two tables using the names and then include the Id field in the query. Run as a make table query it will combine the excel table with the IDs in a new table, or...

Hello Try the DB below(ACCESS 2000). It is just an start. Chris

Hello As far as i am aware ( and i've tested this) any date selected as a crtieria will work equally as well with date fields and date and time fields i.e if you had two data points written as 09/06/2002 and 09/07/2002 10:35 a statement of between#09/06/2002# and #09/07/2002# would...

Hello With just enough hair left for a comb over while i wait for it to grow back the problem was solved with. Public Function ENDOFMONTHDATED(WAITDATED As Date, MONTHED As Integer) As Date Dim classopt As New MSOWCFLib.OCATP ENDOFMONTHDATED = classopt.EOMONTH(WAITDATED, MONTHED) End Function...

Hello I am trying to use the spreadsheet function EOMONTH(DATE,month) in a module. The help says i need msowcf.dll installed which i have found in \Microsoft Office\office\ but the function isn't recognised. Is there a library i also need or is it something else? Cheers Chris

Hello Try Like("*") in the criteria. Chris

Hello One side effect of said sleep depravation is the tendancy to talk crap. The answer is you need to create the sub form again(i.e make a copy give it a new name) then you get the wizard asking you for the link when you enter insert into the tab. I must have done this for the first subform...

Hello I've been up all night creating a wonderful set of forms when i suddenly spy the tab control. What is this i wonder, wouldn't it be just the thing to tidy up the 5 subforms i have in my main form ( that work perfectly by the way). Rather than mess up my forms i make a copy of the main...

the watercooler?