Search results

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...

i need to have role and person in the query because thats what makes the query useful. neileg - Spot on, thats what i want. Thanks... Please explain though! How did you know that? Why is it working that way? what does first do?

Hello, i have this simple peice of code, it just wont work, i have no idea why... its to set a tab visible or invisible, ive never needed to use the isvisible method before so i think ive done something wrong, but ive looked at how to use it and it seems right. I get error code: 2455, invalid...

aggregate query is still showing repeating data. Attached is the query (pic) i want a member to be displayed once. (if they have a post then display them) Ant...

it doesnt work, ive already tried. says something about aggregate function or something.

Hello, I have a system where a person may have several posts. Ive made a query which shows everyone who has a post. The problem is that if a person has three posts, the record shows three times, how do i make tell a query to do this: Get all records, look at the name field, show only 1 record...