Search results

Hi, I am trying to figure out how to tell Macro tools builder to grab, the "RecordId" of the record that i clicked on, so that i can validate it, and then open form with that id in edit mode. Been googling that for past 3 hours and nothing.

hi, I have the following code: Private Sub uiFindByIDComboBox_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[sdutentId] = " & Str(Nz(Me![uiFindByIDComboBox], 0)) If Not rs.EOF Then Me.Bookmark =...

Hi, I have added error handling code to my combo box. Private Sub searchName_AfterUpdate() ' Find the record that matches the control. Dim rs As Object On Error GoTo ERR_Handler Set rs = Me.Recordset.Clone rs.FindFirst "[sdutentId] = " & Str(Nz(Me![searchName], 0)) Exit Sub ERR_Handler...

I have been trying to found out why it isn't allowed to link .mdb file though odbc with another .mdb file. I tried Google an answer but could not find it.

Hi, I have an on click event which adds selected items into a string Private Sub lstMailTo_Click() Dim varItem As Variant Dim strList As String With Me!lstMailTo If .MultiSelect = 0 Then Me!txtSelected = .Value Else For Each varItem In .ItemsSelected...

I have a form with a list of ids(that shows one id at a time and the description of that id). I have a combo box that shows me list of the ids and it allows me to go to the id that I select. I have a subform that shows records(one at a time) based on the id that was selected in the from. I have...

When I look under my name, I get a red rectangle that indicates "Shameless Behaviour" what does that mean and how can I remove it?

I have a script that changes country codes into numbers. The issue that I am having at the moment is when I have a cell that contains other words other than the country it changes it too. Also I cannot specify the name of the colum since every excell spreadsheet is different. Example: cell 1...

when I create an mde file, is there a way to disable it to save any changes to db. For example when users opened an mde file, he can do what ever he needs to do, but when he closes the mde all of the changes done to the database are reverted back to zero.

I would like to work on the form with more than one table without having to use a subform. I remember there was an option to have field list of more than one table. Because I need to add a field to a form that has 'one to many' relationship between two tables so that I dont want to modify...

I have a form that has a sub-form, -if I use "Forms![formUsers]![id]" to get the hold of the id value of the form. then for the sub form "Forms![formUsersSubForm]![id]" would that work? -I would like to make a continues form for product list, to make it easier to go though products. If I add a...

I would like to add a button, that on click it would open a mini calendar with current date, where if I need to change the date I could and then I could click ok and it would set the date in the proper field.

edit: I found out that I cannot have a form and a report accessing the table at the same time, what can I do about it if I want to preview current selected record? I have been having trouble to create a form with a subform, which after you click a button and it would load up the data of that...

I have created a form, and added a button that would display the current record. When I click on the button I get "database engine could not lock table..." When I launch the report by it self, it open, but doesnt want to open through form button.

I have a from that loads student information, like name adress and other contact info. And then I have a subform of all of the cources that the student have taken and if the student has passed them or not. I would like to have a button, that on click event would load the information on the form...

Is it possible, I have created an application in ms access 2k3 a while back, now I have to redu and implement more features, the thing is I pretty much forgot about ms access, and ms visial studio has more features.

Sorry if this question is a little bit off topic. here is the xml file. <entry> <content type="xhtml" xml:lang="en" xml:base="http://diveintomark.org/"> <div xmlns="http://www.w3.org/1999/xhtml"> <p><i>[Update: The Atom draft is finished.]</i></p> </div> </content>...

I have created an access application for student registration, fee paymnets dues and reminders. Access does not give me much flexibility, so I wanted to switch to vb.net 2005. I build form with frames, got all of that to work, except when I make a connection in visual studio 2005 to .mdb file...

when I have created my table I have created a field called name that stored both last and first name. Right now I need to extract the the last name from the the field name and store it in another field "lastName". Any ways to do that?

how do I show the data from a table that has the check box check on, on the report.????:confused: