Search results

Hi, I have a form that has been working for me without problems for a long time and now it has stopped working! When I try to open it, this pops up: Run-time error '2427': You entered an expression that has no value. The code that generates the error is in the Form_Current event and this...

How can i get a value from a snapshot query and put that value into a field in another table? The snapshot query is like this (qrySnapshot): DocID NewReference And the table has fields like this (tblDocs): DocID Reference. ... I want to press a button and through VBA put the (text) value...

Thanx Mstef! So the basic procedure is to create a global variable that is on when you want read only and check for it on every form that you open. Looks like a good way to do it without having to do to much work. Thanx alot

Hi, I have a (.mdb) database and I want users to be able to choose when they enter the database whether they want to use/work with the database or whether they want to just browse through it without them being able to change (or destroy) anything. I need to put this feature in because people...

Thanks, Ken I had the code to control this in the Form Open event only. Forgot about the Form Current event. Works fine now. Thanks

Yes there are two option boxes that control the visibility of several forms and I store the values of the option boxes in the underlying table for the main form. That's it. I'm hoping that that is enough to accomplish this.

Do you mean that I need to create fields in the underlying table of the main form that store the visibility settings for each subfrom? There must be an easier way to accomplish this. There must be a workaround so that I don't have to change the structure of my tables. Atleast I would think so...

Hi all, I have a form in my .mdb that has several subforms that I control the visibility of by pushbuttons. The pushbuttons (and the visibility of my subforms) should be remembered in some way for every record so that when I go between records, the pushbuttons and visibility should change...

Yeah I figured it out. Tools > Startup and also Tools > Customize to remove everything you want. And if you have locked everything and want to bypass it then when you open the database, hold down the shift-key. All pretty simple...

Hi I want to make my database more robust and user friendly by restricting the access my users have to various resources in my database. E.g. I do not want the users to be able to see the database window, no matter what. Also I would like to remove most of the options in the Microsoft Access...

I have the following problem: I use a filter in my form to filter continuous records and while the filter is on I want to be able to duplicate a record but Im having trouble with that. the following code is my filter and the error happens on the line: Me.Filter = strFilter When I try to...

I found the solution. The code is just getting uglier by the minute but it works so Im happy... Anyway here is the solution: Private Sub butStoreDrawings_Click() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Dim TransNo As Long Dim DrawNo As String Dim...

Is this something that I could use and then how? http://www.access-programmers.co.uk/forums/showthread.php?t=26698 Any help greatly appreciated...

Hi I have a .mdb FE running on a SQL server BE. When I run the following code I get the 3021 error: No current record in the line: rst.FindFirst ("DrawNo = '" & DrawNo & "'") Does anyone have advice for me. Do I have to convert the code to ADO to be able to do this or is there some workaround...