Search results

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.

namliam, i was just showing the symbols.... Thanks spaddhu, i'll give it a try, looks scary :o

I have a query for which I need to be able to search using less-than (>), greater-than (<), not-equal to (<>). It is a simple query so the criteria is [Enter]. I want to be able to use the symbols in the pop-up window but when I enter something like this (view untitled.JPG) I get this pop-up...

Well, I know you have to use code but I dont know how. What you're saying is impractical because I would have to make a million queries to satisfy all possibilities, I dont see another way around it.

Ok, I'll try to make all this clear. Im not very good at access so pls explain as fully as u can. I have 4 tables. From them i want to make a query. However, I want to be able to use a form to select which tables will be in the query results and also select the fields that the query uses. E.g...