I have a form in datasheet view that has a user directory with a list of each person. On each row you can click to open another form that contains the users details using the below VBA:
But once you open to that specific record, no other records are available to navigate to.
I want to be able to stay on that detail form that was opened and go to another record.
How do I continue to pull up that specific user in my detail form, but also load the others so I can navigate to them from the detail form without having to go back out to the datasheet form?
I have read various answers on how to open a form in Datasheet view from VBA code, but I can't get my syntax correct.
Here is one of my 50 attempts to guess at the format. Removing different components, separators, variables only gets me a syntax error of missing separator or "expected =".
DoCmd.OpenForm ("frm_OrdersHOTHeadersOnlyWORKSHEET", [View as acFormView=acFormDS], , , , ,[acFormEdit])
I have a Project form, which holds StockArtProduction_Subform in datasheet view. I need for them to be able to click on the ID in the StockArtProduction_Subform datasheet and it open a single view form (StockArtProduction) with the correlating ID.
Ideally, it would also work for new entries in the StockArtProduction_Subform, but the StockArtProduction form would have to "auto populate" (did I use it right?) with the ID of the currently open Project form.
Hi, this problem is probably very simple to solve but I can't seem to find an answer to it.I have created a search form that returns all records meeting the criteria back into the search form. What I want to be able to do is to display the records in a datasheet view. This is what I currently have and it works ok but how do I convert?Private Sub cmdSearch_Click() Dim LSQL As String Dim LSearchString As String Dim LTownString As String Dim LActive As Integer Set LSQL = Me.RecordsetClone If (Len(txtSearchString) = 0 Or IsNull(txtSearchString) = True) And (Len(txtsearchTown) = 0 Or IsNull(txtsearchTown) = True) Then 'MsgBox "You must enter a search string." Else LSearchString = txtSearchString LTownString = txtsearchTown Select Case Me.Frame99.Value Case Is = 1 stActive = " AND Active = -1" Case Is = 2 stActive = " AND Active = 0" Case Is = 3 stActive = "" End Select 'Filter results based on search string LSQL = "select * from tblContacts" 'LSQL = LSQL & " where LastName LIKE '*" & LSearchString & "*' AND Town LIKE '*" & LTownString & "*'" & stActive If Form_frmMain2.RecordsetClone.RecordCount = 0 Then MsgBox "No records found" Else Form_frmMain2.RecordSource = LSQL End If 'Clear search string txtSearchString = "" txtsearchTown = "" End IfEnd Sub
I have a question on number of records displaying in datasheet view on a form. Is there a way to limit the number of records showing on open.I have a command button on a Navigation form that opens a frmEnterPartsOrder using a Macro.
I have set the Macro to OpenForm, View Datasheet then GoToRecord, Record New..Works perfectly, but it does open the form and fill the screen with records, putting focus on the "new" record at the bottom of the form. Is there a way to set it to open this form, but only display say last 10 records and then focus on "new" record.
I am using the following code to check for duplicate tickets when importing multiple records into a datasheet view form by using the paste append function.
Code: Private Sub Ticket_Number_BeforeUpdate(Cancel As Integer) DoCmd.SetWarnings False If DLookup("Ticket_Number", "Record_Store", "Ticket_Number= '" & Me.Ticket_Number.Value & "'") > 0 Then Cancel = True MsgBox "There were import errors, please open View Import Errors above." End If End Sub
The form is used to insert multiple records into the database at a single time.
That codes works to check for duplicates. And if there are none there are no popup messages.
If there are duplicates though it gives a popup for every single Ticket_Number that is a duplicate.
I am wondering if there is a way for it to give only a single popup once it completes checking all the records to be imported for duplicates.
I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.
Maybe someone can help me with this, probably very simple(?), question?
I want to "zoom" to the underliyng data from pivot view. When in excel someone doubleclicks a field in a pivot table, it automatically creates a table containing all the lines that field were made up from. I want to achieve the same behaviour in Access.I started to think towards a VBA coda, that could be initiated from the form's double click event. It should go to datasheet view with the prpoer filter criterias.
I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it to be in datasheet view because i want to show multiple records at the same time.
If u kno how i could resolve this please offer ur help
Hi I am running Access 97 and I was wondering if it was possible to change the colour(background or text) of a single record based on an attribute
I was hoping that my subform viewing all of the records (datasheet) would look like this based on Task Des column eg Condition = red, Awaiting = Blue (Below is ment to look like an access datasheet view)
Property No | Task Des | MCU/ROL PN1234/DA1 | Condtion | MCU PN1235/DA2 | Condtion | ROL PN1994/DA1 | Awaiting | MCU
I have read you can do this quiet easy in access 2007 but was wondering if possible in 97
Hi I am running Access 97 and I was wondering if it was possible to change the colour(background or text) of a single record based on an attribute
I was hoping that my subform, viewing all of the records (datasheet) would look like this based on Task Des column eg Condition = red, Awaiting = Blue (Below is ment to look like an access datasheet view)
Property No | Task Des | MCU/ROL PN1234/DA1 | Condtion | MCU PN1235/DA2 | Condtion | ROL PN1994/DA1 | Awaiting | MCU
Is it possible to switch the view of a subform to datasheet when a command button on the mainform is selected?
I know it is something involving acFormDS...but I cant figure out the rest of the code! I appreciate your help in advance!
(P.S. I know you can right click the form and select datasheet. Unfortunately there are not many people here that are familiar with MS Access and I dont trust that they will know this)
I am reviewing a program that in datasheet view has '+' signs in the left-hand column -- it displays rows of companies. When I select a '+' another 'sub-datasheet view' of employees of that company appears, partially covering the original datasheet view of companies. Is this the way sub-forms look in datasheet view or is something else involved? Thanks
i have created subforms and set the Default View to Datasheet Now i have a form where i am adding command buttons on it to load those subforms but They are not Loading it as DATASHEET VIEW. Any Clue?
I have two Access files. One is just forms which I use as a front end app. The other is the database that I store all my tables/data/etc...
I want to run a query to display data from these tables and display it in like a datasheet view. I know how to do this if it was all the same Access file, but not how to do it with two separate files.
I created some forms in datasheet view. Now I want to change the datasheet properties (background color, text color...): the problem is that the forms I create with the new properties are displayed as I want, but the old forms are displayed with the old properties. Does it exist a command to open the old forms/subforms with the new properties or do I have to re-create all the old forms?
