Search results for query: *

It worked! Any idea why it wasn't working before? Was the database corrupt?

I've tried making the query in design view, and then File-> Save As. This doesn't work. I've also tried creating the query and then closing before saving. Then the usual prompt comes up about wanting to save, cancel, etc. This doesn't work either.

I can create queries without a problem, and they work fine. However, I can't save them. Everytime I try, I get an error message: "The changes you requested to the table were not successful because they would create values in the index, primary key or relationship. Change the data in the field...

I took your initial advice and just made the change on the form. Works fine (duh!) Thanks!

I'll give it a go and post back! Thanks

The back-end does contain just tables, and the front-end does contain only queries, forms, etc. Let me explain it again.... I have a table called tblSickLeave. In the table there is a field called SickLeaveDayOfWeek In the properties for this field, the relevant properties are as follows...

Not quite sure what you mean. I updated the row-source in the BE. The cbo is on a form in the FE. If I update the row-source for the cbo in the BE, shouldn't this be reflected in the cbo on the form in the FE (without me having to change any attributes for the cbo in the FE)? Am I making any...

That's exactly what I did. My problem is that the cbo on the form still only shows Mon-Fri. :(

The cbo is linked to a field - sickleavedayofweek In the relevant table, the follwing attributes are: Display Control - Combo Box Row Source Type - Value List Row Source - Monday;Tuesday;Wednesday; ....etc Previously the row source ran from Mon-Fri. I just went into the BE and added...

Hopefully this is an easy question! I have changed a couple of things in my BE table. However, the FE is not recognising the changes. How do I relink the data (if that's the right term)? FURTHER DETAILS I have a combo-box field that shows list values (Monday-Friday). I have updated the list to...

LittleSmudge, HUGE THANKS!!! That's cleared everything up for me (obviously!). With regards to the multiple security files, I have more than one becuase I didn't know what I was doing – see thread181-816022. I started off just creating one simple contacts database. Then I had to make a Human...

Oops, forgot one... (10) What do I do when I want to make changes to the the forms/reports/queries etc? Which file do I modify? Common sense says copy the original FE file, make changes, delete all old FE's on local machines and replace with copy of modified one. Is this correct? Thanks

Hi all, This is a follow on from thread181-843073. I have been reading up on splitting a DB into FE/BE set-up, but I have a few queries, as I am not totally sure I know what I'm doing.... (I have numbered the steps/queries to make it easy for wonderful people to help me!) (1) To practically...

Fantastic. No wonder you're tipmaster of the week!

Thanks again. I think I better do some serious reading around before I really mess things up. Would the process still work if I made a copy of the DB and then split that? Or does the splitting process leave your original intact? If I could leave the original DB still functioning while I...

It sounds like a problem I am having with some of my users. I think that the database was created in an older version of Access and you are trying to open it using a newer version. As far as I know (which isn't very far) you need to convert the DB first, but you can't do that unless you have...

Thank you very much for your help Bob. I have printed some info off from Microsoft's website on Replicating a Database. Am I on the right track?

And yes, they are stored on a server.

Unfortunately not. I'm a complete novice!

Hi, We have several access databases that are used in our office. Most people are running Access 97, while a few are running Access 2000. The databases are secured, and everytime the Access 2000 users try and open a database they get an error message telling them they don't have the necessary...