Search results

I was just thinking, is it possible to have my main query with all the data that needs filtering and counting and have my report do the filtering and counting? Rather than have my other 3 queries? Is this possible? Cheers Phill PS just noticed the spelling in the header! Oops! :D

Hi, I've not done many reports in the past so Im a bit of a novice. Im having problems getting fields from 3 differnt queries into my report. Now the first problem Im having I think is something to do with the fact that these 3 queries are created from one other query. Basically I have a main...

That worked perfectly! Everything works again, panic over! Cheers for your help! Phill

Invisible?? oh dear! Any way I can get excel to show these characters?

Hi gemma, welcome to my problem :) I have now done both SQL and query design view. None seem to work. I have attached an example of the data im working with and the query that I cant get working so you can see what my problem is. Thanks for all your help! Cheers Phill

Hi, I used you code, looked like this UPDATE Bankpayments SET Bankpayments.Description = Trim([bankpayments]![description]); It says its going to update the 7000+ records but when I the two spaces are still on the end of the description? Any ideas?

I learnt that one the hard way :) thanks for that piece of code, just one question before I go forth, is that for a query in SQL view?

Hi Everyone! Is was all going well till this morning and now its all gone wrong!! I have a table full of bank payments. This table is updated from a spreadsheet, which is made from an Internet banking statement. So basically every month I import the spreadsheet into the database updating...

Works a treat! Cheers!

Hi, This one sounds really simle but Im not sure of hte best step forward. I have a membership database. Everytime we have a new member we enter the date the member joined in a simple short format. So for example Joined Date 1/1/2008 4/1/2008 10/1/2008 3/2/2008 6/2/2008 I would like a query...

Im trying to attach the database but its to big. Any alternative ways of sending it?

When I use that line of code I get a 'syntax error'?

Hi! Ok i did as you said and it kind of works. The only problem is it doesnt filter the form, just comes up with a blank form. Could the error be in this line? Forms("frmMainForm")("MembersSub").Form.Filter = [MemNumber] = "" & Me.MemNumber & """" At the end of the code was an error on the...

Here is the code with all the references updated: Private Sub MemNumber_DblClick(Cancel As Integer) 'Set a Filter to the Members subform. 'It is assumed that [MemNumber] is the name of the Member Number field in te Table 'that is bound to the Member Subform...

Great reply thank you very much! I have put the code into my database but I have a two problems. When I try to run the code it comes up with the error 'cant find the field 'members' which to me seems that its looking for a field not a subform??? Also at the end of the code...

Hi Guys, Not quite sure where to start with this one so I need a little help. I have a main form which is split up with tabs which all contain subforms of various different forms and queries. I have attached pictures for clarity. On Pic1 there are two subqueries. Pic2 shows the subform of...

Wazz, thank you for the help! The queries you sent me all worked after a little playing around over the weekend to fit my tables how ever there is still a little problem. The third query even though it does work does not do what I need it to do. At the moment it gives me a list of who HAS paid...

Good morning! in answer to your questions yes there is an ID in the bankpayments. Missed that one out :o Yes well spotted I will also need a year. There are about 3 years worth of payments currently in the database. I would like the query to show everyone who has not paid with in the 5 days...

Thanks for the reply! To clarify the points you mentioned, we download a statement from the bank containing all the payments from our members which is then used to update the table 'bankpayments'. This table is set out: Datepaid/Description/Amount Datepaid being the actual date we received...

Hi everyone, I have a very confusing problem that im not sure where to start with. I have table that contains members payments. This table is updated once or twice a month with all the new payments that we recieve from the bank. This table contains the date of the payment 'datepaid'. I have...