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

All users have permissions to create and delete files and can do so unless I have the database open. Miss Fred Garner

The database is located on the network. I already know that it is not possible for one of the other users to open the database when I have it open and would like to know how to change their permissions. Miss Fred Garner

dhookom, I am not quite sure what you are saying- I wish for all users to be able to use the database at once. Best wishes, Fred 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 now substituted the following code but still the combo box is not doing anything! The code is obviously not faulty- why on earth is the combo box not finding my record? Any ideas would be gratefully received! Private Sub Combo176_AfterUpdate() 'Moves Record Selector to record in...

i nowhave the following code and although no error message is coming up, nothing happens when I make a selection in the combo box. Private Sub Combo176_AfterUpdate() 'Moves Record Selector to record in subform that corresponds to the 'selection in this combo box. Dim varName As Integer...

Hi AceMan! The same error is still showing up. The code in the line you mention probably was wrong and should be correct now I have altered it as you suggested, but I still need to get the shareholders line correct. PH, I am not sure what you mean by the 'control name'? The subform's name is...

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...

Many thanks for your posts, Remou. Unfortunately I am still not able to do what I wanted. I think this may be because each of my main forms is linked to a different part of the subform by a shareholder number (so that only the accuotn designation relevant to the currently diplated contact are...

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...