Search results

Ok either I didn't explain myself properly and know has no idea what I'm going on about or it's not possible. Any nudges in the right direction? SELECT tblTypeOfStatus.TypeOfStatus FROM tblTypeOfStatus WHERE tblTypeOfStatus.TypeOfStatus <> cboStatus.Value Is the line of thinking I'm on...

I have a form (frmStatus). It’s in continuous forms view. It pulls information from tblTypeOfStatus. I have a total of 15 statuses, but for the sake of making stuff easy lets say 5. What current happens: I select one of the five, and that value is stored fine, and the form creates a new combo...

You have defined a field as a PK, which requires to be filled in when another other field on the form is edited and at the same time you are leaving the PK field blank. Which is not allowed. I'd go back and visit your table design and relationship.

Ahhh I've seen what you've done there. Nice idea. Having a little trouble implementing this at this moment. Think I've been staring at it too long and I'm just stuck in the same line of thought! Probably be back later today to pick your brains if I don't have any luck. Thanks for all the help...

So what fields would my junction table contain? I already have tblBookings and tblStatus linked via fldBookingNo. Gah, who thought given a booking a status would be so complicated! Blimey, then I would go crazy if I had to do that, thank god the option groups work fine as they are.

Just had this happen to me. I had just added a label to my main form (frmBookings) and gave it a hyperlink to another form in the same database. I then tried to go into form view, but it wouldn’t. It was just ignoring my command. So I saved, closed the design view and tried to re-open the form...

Yeah I've already done it, not gone down the combi root though. Just sticking with option groups.

I'm probably wrong (and this kind of topic, is wayyyy over my head), but why don't you just create a new DB and import the old DB into it. And tell it just to copy tables, queries and relationship etc, but no data.

I’m guessing by the unanimous silence, this can’t be done and I’m talking poppycock. So I guess I have to make a status field for each status and do something fancy with a sub form. If anyone else has any other ideas, I’d be happy to hear them. Just list of status that can apply to any one...

Agree with JANR the .requery method is much easier to use and maintain/update. If you still can't get it to work, upload the db here and I'm sure we can help :)

Right click on *.mdb file, select Properties and make sure "Read Only" is not checked.

Just been playing about with this. Trying an option group and dropping several check boxes in there. Just trying to enable multiple selection within the option group. Just can't figure out how :confused: Driving me nutty, I swear I've done it before. Any ideas? We have too much important...

We create a new database every finanical year, so that shouldn't be a problem.

There are plenty of topics on this. Please use the search function.

You are misssing out mate. I run the same sort of setup, minus the Zune. They don't sell them in the UK yet for some reason :( All my computers and data is stored and backed up using my Windows Home Server. Life is much easier. Only got 4 computers + 2 laptops though :D

Looks like I'll be creating a new status field then. Cheers lads/ladettes.

Currently we only use the database to store information about bookings that have actually been booked. And anything that has yet to be booked remains on paper and in a folder. Ideally we want to move to a paperless system, so as soon as we get the booking (via email/fax/telephone) it goes onto...

Ahhh nice idea Yeah not sure if the IT Dept is willing to do that.

FYI This wasn't designed by me, already in place when I started Ah I see. We use the reports to easily view the information in a nice manner, instead of staring at a datasheet query. It's never printed off. In that case I'll leave it as is, and do something in the new DB. Cheers Rabbie.

Check the underlying parameter query?