Search results for query: *

When I go into the relationships window, all the relationship connecting lines have disappeared, though the tables and queries are still there. The rest of the database is behaing as normal, so the relationships obviously sitll exist- how do I show them again? Miss Fred Garner

When another netawork user tries to use my database created in Access 2003, the following messaage displays. The database has been placed in a state by user admin on machine DG02DC1J. This prevents it from being opened or locked'. Clicking 'Help' brings up the following: Error 3734: This...

Is it possible to make a calculated control blank if the total is zero? It is straightforward to do this if the field is Null. The calculation is =Sum([No of shares bought/sold]*[Current Price]) Miss Fred Garner

Is it possible to password protect only a couple of the forms, plus the reports and macros on my database? I would like the rest of the database to be easy to modify by others. Miss Fred Garner

I have entered the following code in order to move to a record in my subform based on a selection in a combo box. The subform is called 'Shareholders' and the field name it is looking up is 'Account Designation'. Private Sub Combo176_AfterUpdate() 'Moves Record Selector to record in subform...

From my form I am trying to use a combo box to find a specific name in my subform (called 'shareholders subform') within the 'account designation' field. Can anyone identify why the code below does not work? Private Sub Combo174_AfterUpdate() DoCmd.GoToControl "Shareholders subform" ' Find...

I have a form of investors and within that, a subform of all their different accounts. Is it possible to put a combo box in the main body of the form that looks up a field in the subform and navigates to it?

On my switcboard I have a command button that allows the user to enter a new transaction on the 'Transactions (by contact)' form. The code reads thus: Private Sub Command13_Click() On Error GoTo Err_Command13_Click Dim stDocName As String Dim stLinkCriteria As String stDocName =...

Does anyone know why this code is making my reports print rather than preview? It is choosing from 3 reports, which are selected by option buttons. Option Compare Database ' Use database order for string comparisons. Option Explicit ' Requires variables to be declared before they are used...

Does anyone know why this is returning the error message 'Compile error: Variable not defined'? Option Compare Database ' Use database order for string comparisons. Option Explicit ' Requires variables to be declared before they are used. Private Sub Detail_Click() End Sub Private Sub...

I would like to deisgn a form which gives the option of printing or previewing (ie 2 choices = 2 command buttons)a choice of 3 reports (ie 3 choices). I would like to be able to highlight the report I want to print by using 3 option buttons - I know how to create a command button that either...

How can I make a command button that sends the user to the database window? I do not want to rely on F11 as some of the users will not be very computer-literate.

I would like to deisgn a form which gives the option of printing or previewing (ie 2 choices = 2 command buttons)a choice of 3 reports (ie 3 choices). I would like to be able to highlight the report I want to print by using 3 option buttons - I know how to create a command button that either...

Does anyone know how I can get a command button that will allow someone to add a new record to a particular form? It is possible to do this by using the switchboard manager but I cannot find a command button that will do this in design view.

I am making a switchboard in form design view and cannot find a command button that will return me to the database window. Does anyone know how I can make one? (There is one on the Northwind sample database).

I work for an investment management firm and have a report that lists investors by the intermediary who introduced them. It lists only investors who have come to us through an intermediary. I have made a duplicate of it and made it sort by investor - however, the report still only lists those...

I have shareholders who buy shares in 3 currencies-£,$ and €. At the moment my report is doing totals per shareholder (in the Summary section), but how can I make it refine this further and sort the data into 3 areas- £,$ and €?

I am trying to use the 'IIf' function to do the following: display $ if a share class is a $ share class; £ if it is a £ share class; and € if it is a € share class. at hte moment I can make it display a $ sign if it is a $ share class, by using the formula: =IIf([Class]="Class A (USD)","$")...

I have chosen 2 decimal places for the fields in my report but when previewed, more than 2 decimal places are showing.