Search results

you could run a check on what's being deleted using the 'before delete confirm' setting in the form's properties, and then cancel the delete if it is the one you're trying to protect. Also, you could add a 'do not delete' field flag on the base table that you set yourself and this way you could...

I think you've forgotten something ...................!!!!!!!!!!!!!!!

Yikes !!!! Can you zip it up and attach it for me to have a look !!! Thanks Steve

Hi Sasha, You're getting that error message because you're trying to update a field in a recordset from a query with many linked tables. The best thing to do is keep your combo boxes but structure them so that the result is unique - and then have an update query pull the data off this form...

up to you, I'd put it in the existing one.

just put the following into the macro: Macro name: Open pop-up Action: Openform (hit F6 and set form name to 'art num pop-up') Then in the on-close setting of the 'parts list mainform', reference this new macro.

Not really sure what's happening there - but if you go into the design of the 'artnum pop-up' form , double click on the combo box to get the properties up, click in the 'row source' line, then click on the box with the 3 dots on it to open up the SQL query on the ' row source' line. Run this...

The form works fine !!! I've changed your text box to a combo box - just click on the pull-down arrow on the right of the box and all product codes will appear. Choose the one you want and the supplier name will appear in the text box below. Double click on the supplier name and the inventory...

Go back to the base Access window and click on the button on the tooolbar that looks like 3 boxes joined with lines. This is the relationships window. Now click on the link between 'art no' and 'top id' - it should go bold - then just press delete. You can now change the data type.

My pleasure ! It looks like you're going to have to change the data type from number to text as you're not allowed to put dashes in a number field. Just go into the design of the table and change the type by using the pull down list next to the appropriate field name.

Try this Richard:

don't right click the macro tab, just left click the macro tab then look for the 3 options which, if youre in XP will be on the top of the window saying 'run', 'design' and 'new'. 'New' is the one you want, just left click on this.

Just click on the Macro tab on the base window, then click on 'NEW'. This opens the macro window. The macro can be built from here. Click on the 'macro names' button in the toolbar to show the names column. This the button with 'xyz' and some boxes on it. Call the macro 'open form' or whatever...

sorry - forgot to tell you anything about it !!! If you open the 'art num pop-up' form, it give sthe choice of article number. Choose the number and click 'OK' and it shows the details for this number and the parts list. I had to separate your data into 2 tables with a cross ref ID using the...

here's a quick database I've knocked up for you - it just needs tarting up a bit.

I think you've forgotten the attachment !!!

yeh - I was just gonna say that (!!)

I think I understand what you mean - I would simply include all of the tables in a query . If you put criteria in the same row of a query it means 'and' If you put criteria in different rows it means 'or' I'd just put your criteria in the query and use the 'IsNull' and 'Is Not Null' criteria...

it can be difficult to highlight the relationships link sometimes - just click on the table in the relationships window that has the link you want to remove, before clicking on the link - this usually helps me. Then when the link goes thicker than the rest, it's highlighted, just press delete then

Instead of using 'like' in the criteria of your query, try using Left$ - something like this: Left$([control name],3)="A" Use the build function to build it up and you shouldn't have any problems.