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

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

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...

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...

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...

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...

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...

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...

PLease can anyone help. I have a subform in which I display a load of records in datasheet view. I have a check box on the sub form but I can't for the life of me hide this. I've tried opening the form in form view and then selecting Format->Hide Column, but then as soon as I close and...

I am trying to use the backcolor or forecolor property in a field in a form that displays in datasheet but it won't work. It's fine in form view. Does anyone have any ideas as to how I can get the field to show a backcolour AND display it in datasheet view? Thanks

I am trying to do the simplest thing adn I think I must be doing something v v v silly. Dim rs as new AdoDB.recordset rs.open "SELECT * FROM qry1 WHERE TextField1 <> 'Tracy'", currentproject.connection Unfortunately it return EOF. It seems it doesn't like the <> operator, nor !=, nor 'NOT'...

Hi, Please can someone explain how to redim a dynamic array. I declare my array as follows: Dim MyArray() as Variant The brackets are empty so that it is a dynamic array. I want the array to have three columns and unsure of how many rows as yet (hence it's dynamic). So I used the following...

Hi,. I am trying to use a criteria in a query as follows: Description like "*" I want to retrieve all records where the Description contains an asterisk, but at the moment (as expected) everything is returned, because asterisk is the wildcard. There should be a charcter I can precede the...

Does anyone know how to specify how many decimal places are displayed for a decimal in a field on a form. I am currently using the round function So Round(x / y, 2) This displays x / y rounded to 2 decimal places. Muy problem is that if x divided by y is an integer (i.e. no decimal places...

Please can someone tell me why the first statement works fine, but as soon as I introduce a wildecard - * -, it won't work. Any ideas would be very much appreciated. rs.Open "SELECT * FROM Query1 WHERE Code = 'GR1'", CurrentProject.Connection rs.Open "SELECT * FROM Query1 WHERE Code like...

Does anyone know how to save a report to a .pdf format or any other format from where you can copy and paste. Currently I am using snapshot viewer but it is not possible to copy and paste from this format Thanks