Search results

Hi all sorry about the long lack of reply. I have trying to teach myself before annoying anymore of you. Those links that have been posted were massively useful thanks. I went with using a query as suggested and have made one that should suit my needs (after some trying) however when it comes...

Thanks for the info im reading up on it and making a little headway but I've not managed to get a query that can be shown in a report yet only one using the totals button in datasheet view Im having trouble making a query in the Criteria box, when I enter Count("1") I keep getting an error...

Hi all you Report wizards :D im trying to learn more about reports. Specifically the expression builder. *Context I have a database for Waste removal (bins and stuff) and I want a report that tells me how many bins of a particular size we have out currently. The database I have has a "Bin...

Yes I agree you make excellent points and queries are how I have been generating my lists so far. But the people I am around are so... "paper centric" they don't even know how to make a fairly simple query. Simply up my initial approach was: Once a year (on a set month) admin press...

Mark, We only write contracts to the end of the financial year, so if you were to contact me half way thought I would write you a 6 month contract with and adjusted price. keeps it simple. Minty SELECT CustID , Address, PostCode, CreationDate FROM tblCustomers WHERE CreationDate Between...

Sounds simple enough :rolleyes: Ill see about working something in. I still need to update my knowledge on how to select a date or a range of dates using VBA as it seems to come up often. Have you got any recommended reading?

We do keep track of all the start dates and returns etc, this box is intended to give me a field to sue as a variable come the start of each financial year so that I can use the database to generate a list of non returns and chase them up. To give you an idea (and this is simplified as I have...

Me. prefix to indicate it's a current form control; Good to know thanks. I went from a different angle as what I am simply after unchecking this specific checkbox access all my entries at once with this button. Not sure if its the right way but I seem to be getting somewhere. (For context...

Thanks for all the advice, I have only just got a chance to look them over. From what you have said I have been thinking about using a button to uncheck everything in the checkbox on click. To prevent miskicks through the year I have added an error command should the click fall on a month...

Evening All, I have ben working on this for a little while now trying a few iterations and this is what I have so far. Sub Yearly_WTN() Dim Day As Integer, Month As Integer Dim CurrentDate As String Day = Day(Date) Month = Month(Date) CurrentDate = Format(DateSerial, dd.mm.yyyy)...

Right I think its home time again. Thanks again for all the help. Now that this is good and sorted maybe I can get some sleep without thinking about VBA and getting this thing working for one night. If I can ever give you a hand with anything (somehow) just let me know. I hope one day to...

Im a god damn retard :o Ive just corrected it and it seems to work now in the primary version :( Seems like spelling is important when it comes down to this sort of thing. This is just like me accidentally putting a space in after July :banghead:

I'm thinking that I need to define the variable (if that's the right term). In simple speak as you defined the intyear as the Date I need to define each IntMonth 1 -12 as something like: intMonth 1 = ("January")

That's a neat trick :eek: I see clearly now :D its expecting the sheet name to correspond with the intMonth in this case intMonth = 2 yet they are all named not numbered.

I'm working from a existing table of data, (not even my own this is all for a co-worker) and it looks like it was never properly formatted. :confused: As for this error I'm thinking that it is definitely related to the line Sheets(MonthName(intMonth)).Range("A1").PasteSpecial For some...

Spoke to soon, put the code in to a copy of the live sheet bound it to a button and now I get an out of Range error :banghead: Gonna try solve this one myself, see if I haven't learned something. Is it always this easy :confused:

Right I've been though all the code you posted, line by line, googled what I didn't understand and its been a big help. Learned a lot about loops, which is bound to come in handy and VBA in general. Think I just need to get in to the VBA mind-set as its like a whole new language. :eek: To get...

Now I see what you have done it makes sense. I'm goanna need to study it and Google some (most) of what you have done to build my understanding. I think at the moment it my lack of understanding of VBA terminology that is holding me back, but that should come with time. Thanks again. :D

Hey dude, I wasn't snubbing you I work in different departments depending on the day and need etc. not good for continuation of my projects but what can you do :( I'm giving what you put on a look over now but thanks in advance :rolleyes:

Hi again, I went home for the night. So that we are both on the same page I have also attached a copy of the file I am working with so you can see for yourself and stop hearing my bad explanations. I have removed all the personal info for obvious reasons but you should be able to see more...