Search results

:confused: I can now open the report in print preview, but there is no information on it i.e. a blank report, though the results do seem to have bee filtered. Any ideas on why this might be happening?

Is it possible to create a yes/no field to a query? This field does not exist in any of the database tables. If anyone knows how to do this could they show me how?

That simple huh? Thanks - think I'm starting to make things more complicated than they really need to be!!

Thanks - I'll give it a shot tonight :)

I have two tables - programs and sessions. Each table contains a date field. What I now want to do is create an invoice that will contain relevant costs contained in these two tables during a given period - much like a phone bill. Is this possible? and if so, how might you go about it...

This is probably a most basic of basic question for a lot of you, but how do you back-up your database? :confused:

Thanks for the help. It now all works fine - relief:D

Selecting the records isn't the problem - perhaps I should have been more clear - It's getting the thing to open in print preview

Is it possible to have a form open and display records to be printed based on the date a report was printed? I have created an invoice that has an unbound field to display the date it was printed - DateSent: =date() However, I want to create a form, probably with a list box, to display the...

Anyone know the code to open selected report records in print preview based on the highlighted fields in an unbound, multi-select list box? I have managed to automatically print the selected records, by passing the print-preview section, but this is not what I want to achieve. Any help would...

Got two problems. First. I have an unbound text box that I want to calculate the sum of values in a subform. I have entered the expression as follows: =Sum([SubTotal]) [SubTotal] being the field to be totaled. However, the result keeps coming up #Name. Anyone know how to sort this? I...

got it sorted. had the wrong Id typed in - idiot!!! Still cant say I really understand all the code though

thanks guys

got it now - thanks

I've now got a text box that is rounding the values copied to it up e.g. £9.50 copied in, value displayed and fed to underlying table as £10.00 Heeeeelllllpp!!!

I'm having the same problem as someone else on this forum did earlier this year. I just don't get what the advice means!! I want to use percentages, and am using the decimal place method - i.e. 0.1= 10%. the problem is that when I enter the decimal into the field, the percentage value remains...

I've got yet another question. I have a query that has counted the number of customers related to a session. I want to display this value in a text box on a form for the session as it will form part of a calculation to cost the session for each customer. I realise I can source the query...

I ended up using code from an example in the microsoft access handbook. I have posted it on the forms forum under "list box search forms". I'd appreciate it if you'd have a look at it. Thanks

form type The problem seems to be related to the fact that the form I want to open is a tabulated form. The other forms (that I have got to work) have been columnar. does this make a difference? And if so is there any way to get it to work on a tabulated form?

I posted this question on one of the other forums, but haven't had much luck - was wondering if anyone here had any ideas. I have build a form containing a multi-select list box and a command button. Attached to the on click event of the command button is the following code: Dim strWhere As...