Recent content by Sewagerat

I have made a database and installed a User Level Security wizard on it. It works fine on my computer but I need to transport it to another one. When I did this it did not even ask me to enter User and Password but just rejected me. Can anyone help me please?

Anyone help please?

So I have a database with a series of connected forms. One of them adds information and one of the fields is a OLE object field. The problem is that I have disabled right-click in the forms so I don't know how to add objects because usually its Right Click --> Insert etc. Is there possible a...

Thanks guys, im slowly learning :)

Is it possible for you to write me the script to do that boblarson? Because I made a simply delete query but its not working: DELETE Table2.*, Table1.gid FROM Table2 INNER JOIN Table1 ON Table2.tid = Table1.tid WHERE (((Table1.gid)=[enter])); (it features 2 tables with the criteria from only...

I see, thanks very much guys, hope it works.

:( Thats the problem cause the criteria is in only 1 table and is joined to other table by the relationships.

But is there a way to make a delete query for several tables based on criteria from one of them only?

Un-normalised? Oo

I dont plan to delete columns, only records. I have only mentioned columns because when you make a Look-up field, it makes a list of options and that list can have a number of columns. P.S. The database is split and the query is in the front-end, not sure if that makes a difference. I'd...

I have done delete queries before but this one is not working. Ill just paste the script and see if you guys can point out the mistake, btw I did it in design view but seeing as though you all use script more. What it is, is all my 4 tables. I need to have the records with 'None' for...

Ty :) 10char

Ok, thanks guys, everything worked well. I don't see how MStef had the ORDER BY clause after WHERE because on my one (the VBA which namliam gave), I try to insert it but a pop-up comes up saying there is text underneath the WHERE clause.

I find the SQL one a bit odd namliam, I don't understand it haha, I tried using it but Access says it does not recognise the SELECT, or something along those lines :P. The first one you posted looks very neat, I'll probably end up using that one. I would like to include an ORDER BY clause but...

Thanks it worked, I think im getting the hang of SQL. Thanks MStef for replying as well, I will make good use of that file.