Search results

Thanks, much appreciated Andy

Is it possible to print the design view of a table?? If so how do you do it?? When Im the in design view and go go to file the print button is greyed out. Thanks in advance. Andy

yep, got it working. Thanks for the help. Andy

thanks for the help, I have looked into the missing reference problem and not yet solved it, I am still working on it. Could it be any other problem do you know? Cheers Andy

Got it working, thanks for the help. Cheers Andy

After solving my last problem quickly, Ive decided to fire another one at you. Again I have a report that displays certain data and has labels saying what each bit of data is. Is it possible to set up the report so that if no data is displayed then the label for that data does not show up. For...

I have created a report that displays the Current Month and Current Year at the top using the following code -: =MonthName(Month(Date())) & " " & (Year(Date())) This works fine on my machine, and if I put it on the server and run the report it works fine, however if the other 2 users who need...

Problem Solved Have solved the problem with a little bit of advice, all I did was set the dates chosen by the user as one variable, then in the sql statement i set the date to equal this one variable. DateString= Upday+"/"+UpMonth+"/"+UpYear Sql Statement Reads -: .....DOB = #"& DateString...

I have a table which contains dates in the format (mm/dd/yyyy) as well as other information, I am trying to get an ASP website to update the date with values chosen by the user. The problem is that when using the UPDATE command it returns an error, saying the syntax is wrong. Here is my SQL...

I have a problem with an SQL query that is used to create a report, the query itself works fine, however I need to get it to do something extra. Basically we have a column that contains 1-3 letters. The letters are A, B and C. The query searches the database and returns result depending on which...

Problem solved, just needed to use the VAL function. All I did was set the column that needed to be changed from Text to number by using VAL -: AreaNum:Val([Area.Code]) Then in the criteria line, I just put VAL infront of the input box code, so the criteria line reads as-: BETWEEN VAL([Please...

Hi, Following on from my previous post regarding reports I now have another problem with the report I am creating. the intial problem I had was that I could not order a report properly as the column was a text field not a number field. I solved this problem with help from your good selves by...

Thanks for all the help, I have managed to solve the problem using the following function that Rich had also suggested -: Expr1:Val([FieldNameGoesHere]) Thanks once again. Andy

Yeah I was beginning to think that as the code is set as text then it will always be sorted this way. I just wondered if there was any other setting that could be changed or if there was another way round it. At least I can tell my colleague that it can not be done without making changes to the...

Could anybody help with this problem that I have been given by one of my colleagues. We have a report that groups contacts together depending on the code that we have given them, the problem is that they are not ordered correctly. They are ordered as 1,10,12,13....,2,20,21 and so on, where as...