Search results

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

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

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

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

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

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

Hello, thanks for all your help up to now. How do i get a value from a subform to use in the main form? Heres what im working on: I want access to look at the value in a combobox in the subform, see what it is then if its "blahblah" then do this, if its "blahblah2", do that, etc. So how do i...

Hello everyone. Here is a picture of one of my forms. The idea is that, if the family tariff is selected the people subform will allow many records, else i want it to allow just one record. Is there some VB code i can use which will allow one record and wont let anymore be created if...

Hello, im making a database for a charity as part of my work experience and id just like someone to check over it for me. If you see any issues please let me know. Im already aware of changing text PK's to autonumber, this is a prototype so im not going to change the PK's at the min. Any ideas...

Hello, This forum is a great idea by the way, its so helpful having a an array of experts who are willing to help! Its really cool, thanks for the forum. Anyway, here is my ER-D: OK, My problem is specifically in this area of the ER-D: Getting down to the actual problem: Notice that...

Hello, Firstly, heres my ER-D thing: The problem, is with the relationship between: stakeholders and bookings. stakeholders and stakeholders letters. when i join stakeholders and bookings it says one to one, i want a stakeholder to have many bookings not just one, however, i havent tested...

Hello, Im creating a database for a charity. Im in work based learning at the minute as part of my degree course. Basically, I have my ER-D which im going to use in a few days to produce the database. Please have a look at this and criticise it! Here it is: Well, basically, i want to know...

Hello dear experts! Will this table structure work? - Please help! I need to be able to see if certain members have paid subscription, see if stakeholders have paid for their room bookings, etc. Will it work, does it look ok to you? Im trying to brush up my normalisation skills and logic...

Does my ER-D look right? A stakeholder can hire a room and they have to pay for it. A stakeholder who is a member has to pay a subscription fee which varies depending on their tariff and the year. Does it look right? Ant...

Hello, Im creating a database for a charity just to get some experience and im stuck on something - my table structure. I know you might find it a bit difficult because you dont know the background info but i need the database to be able to let customers and members make bookings. Ive thought...