Search results

Hi, I desperately need to use Access but don't have a PC at home and am not working at the mo. Does anyone know of an internet cafe anywhere in London that has Access for customers to use? Thanks

So if ADO still use JET I presume?

i have been programming in both these object models for ages, but could not explain to someone what exactly the difference is. Can anyone explain this in a few simple sentences? Thanks very much

Thanks Len and Rich, Rich, I have exactly your code, but it just formats sooooo bizarrely. WHen I put breakpoints in the code, it formats for branch1, then branch2, branch3, then branch3 again. My code wants to hide fields for Branch 3 only, but because it formats for branch 3 before it...

I've probably not explained very well. My data is normalised no problem. WHy do you think it isn't? I just have a report which is grouped on Branch, but when I hide the fields for the first grouping, say Branch 1, it only hides those fields which I choose to hide the fifth time round when...

I have a report with a group header of Branch. In here I have a load of fields (obviously), but depending on various criteria, I want to hide some of the fields for a particular branch but show them for others. I've tried to do this on the GroupHeader_Format event, but it just hides whatever...

Why is it that, at the time of running a report it formats every single page in the report, and then once it's displayed on the screen, and I scroll to the next page on screen, it goes through the same code to format the next section on the next page? My report is so complex and detailed, that...

Thanks FoFa, that's done it! I was surprise though that it didn't then force a new page before the first section! Cheers Tracy

Hello, I have a report grouped on Branch, and after each separate Branch I want to force a new page. So I have set the Force New Page property of the section to "After Section". ALl works fine and dandily. However, I also have a report footer, which is pushed onto a new page after the last...

Nope, I put everything here, much easier. How about an answer to the question? Maybe?

Hi, Does anyone know if you can order on anything other than a field in a report. Basically I want to order by a calculated field, but it won't work. Instead I have to order by a field that is in the record source of the report. This is no good because the thing I sort on changes and has 20...

OK Hacker, what are you on about?

I am wanting to check if a number divided by say 4 turns out as a whole number/integer - so no decimal places. Any ideas how I can do this? Thanks Tracy

Hello, I have just upgraded to Windows XP and my forms look a mess. I have had to change the back colour of many existing controls to fit in with standard new colour. However when I put a new control on the form the back colour defaults to a different colour than the standard form colour...

Thanks for your help all sorted now.

In my database I have people who are members of clubs. In a report I want to display "unique" people. So I want to run the report and say: give me all the people who are a member of club1 or club 2 or club3. So if Fred is a member of all three clubs I want his name to appear once, and so on...

There is no Round function in Access 97 (thank god there is in Access 2000). WIthout having to write a function does anyone know how I can sum what is DISPLAYED in a text box on a report? At the moment I sum a textbox in the report footer, but rather than summing what the textbox DISPLAYS, it...

Has anyone else noticed that the round function rounds up and then down in sequence? So... 0.5 is rounded to 0 1.5 is rounded to 2 2.5 is rounded to 2 3.5 is rounded to 4 4.5 is rounded to 4 Is there a way to specify whether the number is rounded up or down? I can write my own function, but...

If I don't use Nz and Me.txtPrice = null, then it will error. mission2java_78 : the code you give makes sense, but this is the job the Nz function should do. In the help it gives the same example, but says that you can then use Nz to simplify it. It's a bit of a risky funtion to use if you...

Heeeelp, my Nz function won't work as I expected with enormous consequences for all my work! I have a field on a report called txtPrice. THen in my report code I have the following If Nz(Me!txtPrice,0) > 0 then msgbox "hello End If 0 is not greater than 0, so I was not expecting a...