Search results

Not sure if this is what you meant but: Result: iif([Condition 1] = [AAA],[Show Result],iif([Condition2] = [BBB],[Show Result],0))

Try this Creat an Unmatch query and then use this in a DOCMD.OPENQUERY function. This will then display the current information.

Presuming that you have linked the Query to the Form, the process should be easy. Try adding a Combo Box for the Username so that when you select the Username, the relevant details are populated. :D

Can anyone please help. I am lazily trying to open multiple files from 1 Hyperlink. Each file has similar file name i.e Sales File 1.doc, Sales File 2.doc, Sales File 3.doc I can get it to open 1 file, but if the button says 'Open Sales File' and there is more then 1 then I need it to open...

In the text field for the search, try putting ?R?1?2 should bring back HRS112. Or you can use the * wild card. *112 will bring back HRS112 and everything els that ends with 112. * Matches any number of characters. It can be used as the first or last character in the character string. wh* finds...

Thanks Pat. That worked. Why do they make things difficult for us all? :D

Trying to import a .dat file and getting 'Cannot update. Database or Object is read-only' Does anyone know how 2 correct this? This is happening on all my databases. :confused:

The best solution that I can give is that you split the database so all the data tables are kept on the Server. Keep this as an MDB file. With the NEW front end database (just forms, table links, queries, reports and code) create a MDE file. This way, if your users crash the database again...

It fails manually. The only error that I get is Invalid Argument. I would have put a copy of the database on here for you to look at, but it's important pricing information for the company. I will try and get you a copy with some dummy data in. This just seems to be a problem when exporting...

Is the .mde file connected to a MDB file on a server. If so, you should be compacting the server database not the client. If you only have a .mde file database (A Standalone database as apposed to a client / server database) then there is no way you can repair. Try getting another copy of the...

Trying to export either a query result or table and keep getting Invalid Argument. Can someone help please. It's in a 2000 database.

Try this nice little tool from Microsoft. It's the Jet Compactor. I have been able to repair and compact databases that had lost their system tables.

The best one so far is the WAF Lines by Audrey. When's the closing date.

You need to repair and then compact the database. It looks as though the database crashed whilst someone was in it updating a record. You will however lose this one record.

Unfortunately the database was inherited by me when I started. The variables are Globally defined. Can't understand why Access looks at them in different ways. Who's idea was it to go from DAO to ADO and make it complicated for us all.

I have looked at this and it is currently checked. Like I have mentioned previously, it has happened in the 97 Test DB we had. Don't know how we sorted it though.

All the references are there and it compiles without a problem.

This is the code it uses. Public Function CalcUnitPrice(pdblPrice As Double, pstrSize As String, plngSectionCode As Long, pintErrorMessage As Integer, pintEquivalentTo As Integer) As String Dim dbProm As Database, recSectionException As Recordset Dim fdbPromOpen As Integer...

The query will run but will cause the error whilst trying to calculate the problem field. It even comes up when trying to view the results. The sum I am using is :- RSP_PB01_UnitPrice: CalcUnitPrice([RSP_PB01],[ActualSize],[SectionCode],False,True) As I mentioned, this works OK but not in the...

I have converted a 97 database to 2000 and am now getting the error Subscript out of Range. The 97 database worked fine with the calculation but 2000 has a problem. How can I sort it out.:confused: