Recent content by sirantonycartwr

Ahhh, upon taking a second look, I see what I did wrong, for some reason I was passing it two arguments instead of concatenating the row and col into one argument! Thanks again!

Omg, something so stupid! Thanks so much! I appreciate that! I'd spent about an hour continually going through the code trying to find out what I'd done. I figured that since the argument was a string that it would naturally want a string passed to it!

Hi Guys, Hope you are ok! I'm getting this error: "Application-Defined or Object-Defined error". On this line: "Set rng1 = .Range("A", CStr(i))". I don't know what the hell it is talking about! It all looks fine to me and this is driving me mad! The code should simply iterate through all...

Thank-you! :) Thats it! Ant...

I want this expression to form a value of a field on a query... I know that what I want is something like this: arrangedActivityName: [activityDate]+", "+[activityTime]+", "+[activityId]+", "+[venueName] When I do it though, its shows "#Error" in the field. I'm guessing that its something to...

Hiya, Im going to make a database which has a table of different talks (or presentations) and a table of staff. One staff can have many talks. One talk can only have one staff. When I press a button on the form, I want Access to allocate the talks randomly to the staff. So, for example, lets...

So this code is for a button called command12 which opens a form with specific data to display? Ant...

Yeah, thats what i thought too. I dont have a button for it, and as far as i know i havent had a button for this. Is it deffinately code for a button? It does say command click which is for a button. If the button is never clicked because its not there then this method is never going to be...

This code has been put into my database a few times, i dont know what it is. It never seems to be called, ever. I commented it out and put a messagebox there to tell me when its called. My buttons are always called btnDoThis, etc not command 12. I dont know why its in there but obviously it...

if anyone is struggling with this, your code should be similar to this: Private Sub SubscriptionType_GotFocus() If Me.Parent.StakeholderType = "member (corp)" Or Me.Parent.StakeholderType = "customer (corp)" Or Me.Parent.StakeholderType = "external agency (corp)" Then...

ok, ive sorted it out, Access put incorrect SQL code in the vba code!!!! Ant...

Oooo, I didnt know that. I can think of lots of uses for that facility. Thanks for sparing your time to help guys.

ha ha, youde be right to think that too! i typed: If Forms!frmRoomYearTariffs.tab.Pages("Rooms").Visible Then instead of: If Forms!frmRoomYearTariffs.tabs.Pages("Rooms").Visible Then Thanks, Ant...

i know, you must think im a complete moron!

no. still doesnt work, its saying that this line is incorrect: If Forms!frmRoomYearTariffs!Rooms.IsVisible Then Ant...