Search results

It could be that you're missing the Microsoft Office Object Library. ([In Office 2003, sorry I haven't used Office 2010] go to Tools -> References in the VB Code window)

I'm sure I'll be corrected if I'm wrong - I'm no pro - but I think this is where you'll want an argument as part of the function name, and then use that argument in the SQL statement of the recordset. For example, you'll want the function name to be something like Public Function...

Is it because in your function you have declared an argument (ALevel) and when you're calling the function you're not providing it? I.E. When you're calling the function you need to put "ReturnAccessLevel(<somethinghere>). It doesn't look like the ALevel argument is actually used in the...

Thanks for that link, it was an interesting read - although I'm not going to pretend I understood all of it! Bookmarked for the next time I try a similar activity though. As far as my project above is concerned, after I changed that line that it didn't seem to like, the Excel process is now...

Nevermind, I think I've solved it - as least it works repeatedly now. Before I asked the question I didn't know how to get Access to step through each line of code so I could figure out what line was causing the error. But I do now, and I found the line causing the error was...

Hi ghudson - I've used your code here alongside a DoCmd.TransferSpreadsheet command to export, then format a spreadsheet - which, as Robgould put it, worked beautifully :) However, I do have a slight issue I was wondering if you'd be able to shed light upon as I'm a rubbish coder! When I run...

Yeah the holiday and sickness data are stored in their separate tables, but they're stored in a "date from," "date to" format rather than listing every day separately - so when I say calculating, I just mean figuring out if a specific day is between any of the date ranges stored in either of...

Hi smig, I downloaded the sample in the linked thread but I'm getting the same errors as the others who were trying to view it - but as far as I can tell from your description here this is pretty much what my workaround is doing; I.E. calculating the numbers first and dumping them into a table...

My very first attempt at doing this was exactly that, I had everything being calculated in a query and the form bound to that but I found that also performed badly, though not quite as terrible as described in my first post. Edit: I've just tried that again, just to be sure and yeah, the above...

Hi vbaInet, I've been doing some thinking/messing around in the stripped-down database that I uploaded and have found a kinda workaround. What I've done is create a query that does the calculations and dumps the data into a local table and bound the form to that instead. The query only takes...

I get what you mean now. I have no problem waiting, I don't really have much of a deadline for this myself anyway. One of my users requested it, but I'm mostly doing it just to figure out how - it's the only way I learn! Thanks again!

Alright, this should work stand-alone (at least it does for me). Also, please don't get mad but when I said there were only 3 text boxes set in VB I totally forgot about the "label" text boxes in the form header. I'm totally expecting you to rip this apart, as like I alluded to I'm pretty much...

Apologies, even though I edited the last post I still missed that I forgot to say that the function is in the Control Source property of the text box - not set via VBA... if that was even what you were referring to. I'm just stripping out data and adding the relevant stuff to a new database...

The form is bound to the staff table, and filtered by team number. There are 3 text boxes that are filled in using the OnLoad event which have the current month number (I did it this way as the eventual plan was to have it current month on load, but having the option to move back and forth...

I agree that 20-30 seconds is pretty awful, but for the amount of use this form will get (probably around once or twice a month), it's acceptable for it's purpose. Though I won't refuse any help for improving that! I've not used any DLookups, but my code might function in the same way (forgive...

Hello everyone. This is my first post after being a lurker for a number of years - you guys have taught me a huge amount, so huge thanks everyone :) Now I have an issue that I can't seem to find a solution on here for and would like some advice - apologies if this question has already been...