Search results

Can I see the code you use to delete. vba is right and there is no reason why you cannot delete a record.

Programming is: Phase 1 Design Coding Testing, Testing, Testing Find what does not work Phase 2 More Design More Coding More Testing, Testing, Testing Find what does not work now repeat Phase 2 until you do not find an more issues. Phase 3 Give the app to the end users End...

If Dirty Then Me.Dirty = False You could simplify this with. Me.Dirty = False

Open the query in datasheet view. Select a record by clicking on the record selector on the left. Then press the delete key on the keyboard. If this works then you know that the query is correct. If not then you have a problem elsewhere. Please advise.

A space is not wrong it is simply not smart. You will discover why as your experience grows. For now I suggest using CamelHump. The first letter of each part is a cap with the balance lower case. Personally I would use AutoNumber for IDMagazine. JDraw is correct in what he wrote.

The fact that this is split does not matter at all. You have everything on the front end. The only difference is that the tables are linked to the back end. They behave in the same way as if the database was not split.

For some reason when I opened my computer tonight every thing was working the way it should. However I checked the Folder Options as you suggested. "make sure to uncheck ALWAYS SHOW ICONS, NEVER THUMBNAILS" was never checked however "display file icon on thumbnails" was checked so I...

JPG Files show incorrect photo. These JPGs should show the actual pic and not be all the same. If I change the size to something bigger then they show correctly. This is in Windows Explorer. How to I bring these back to normal...

Success at last, Thanks VBA. My SQL Server knowledge is very limited. I don't think I would have come up with that solution. Best wishes for the balance of the project.

So the Text Box is linked to the same table as everything else on that form. Therefore it should be saved at the same time as every thing else is saved. Also it is saved to the same table. Am I correct.

Thanks VBA It certainly looks like too much code being used for a simple task which is not to have this Text Box go blank. I feel that the Record Source is wrong. Why would only one text box go blank and not the others. VBA please hang in there.

There is a lot of code here. Can you put some remarks so that I can follow what is going on. Can you supply the details of the Record Source and also the name of the "Text Box" Where and when does the text box get its value and where does it loose it. Put some remarks in the...

CJ You approach is different to mind. not wrong just different. I like to see a page with the full relationships including lookups. This gives me a pictorial view of what is happening. The use of "name" was within a full name only it had a space. eg "My Name". I was mislead by...

Also have you tested the Backup I posted.

Can you post the code behind the form here. please post all of it not just part and don't forger to enclose it in tags. [CODE]This is a sample of something enclosed in Code tags

Cj Are you in agreement with the way the relationships are done. I believe that there are some serious problems.

-------------------------------------------------------------------- Just to confirm. users have all the same front end Users should have their own front end which is a copy of the Master. Users must never share front ends. Record source is always the same select query based on the...

Do all the users have the latest version of the front end. They should. What is the record source this text box. It should be part of the Record source for all the others. I do not see a need to save. Save is done by Access when you exit the Record.

A quick fix will not solve your problems here. You are going to have one problem after another. Fix your relationships first and you will be much better off. PS Please do not use reserved words like "Name". This will also get you into trouble. PSS It is likely that the previous...

The attached will do backups for you. Just schedule it to run as required. Delete the stuff I left behind once you figure out how to use it.