Recent content by hanosm

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