Search results for query: *

Have you considered creating a recordset using your criteria and have storageItemsCount = RecordCount. Mike

If you are using a bound form try rs.edit instead of rs.addnew. Mike

You could add another column where deposits are positive numbers and withdrawls are negative and use that column for your running balance. Mike

If you want to make the first form visible try using Forms(0).Visible = True in the onload event in your second form. Mike

Use a list box to show your events instead of a textbox. Create a SQL string to capture your events and loop through each listbox to set the rowsource to your SQL string. Mike

Try this in your command button on click event using your report name and your id fields. Dim stDocName As String Dim strCriteria As String stDocName = "myreport" strCriteria = "myid = " & [myID] DoCmd.OpenReport stDocName, acPreview, , strCriteria Mike

Save a copy of your form as a report, then put a command button on your form to print the report. Mike

I created a calendar based on gol4's faq(thankyou) and put a listbox under each textbox. The listbox recordsouce is a sql string which pulls the companyname by date from my appointments table. I set an on click event on the listbox to open a form to show all details regarding the appointments by...

In my access handbook (Access 2000 VBA )there is some code to send info from the text boxes on your form to OutLook. I created a form called frmemail and 3 text boxes, txtemail to hold the email address and 2 to hold test info so I could test it. Create command button On Click Event Dim...

Create an unbound combo box on the form you want the data filled in and in the After Update event put in the following ' Find the record that matches the control. If CboClient <> &quot;&quot; Then Me.RecordsetClone.FindFirst &quot; [Clientid] = &quot; & Me![CboClient] ' Me.Bookmark...

Set enabled to no on your text box and use a check box to enable them. If the text box is not enabled then all records will return. Use a msgbox to warn user if the check box is yes and the text box is null. Mike

I have a form where I choose the parameters and pass them to another form in the form open where condition. Dim strcriteria As String If chklengthID Then strcriteria = strcriteria & &quot; AND lengthID = &quot; &_ cbolengthID End If If chksupplierID Then strcriteria = strcriteria &...

I am trying to export customer info from a form to bookmarks in a word doc. The first time it works fine, the next time I get run-time error 462 the remote server machine does not exist or is unavailable and the template opens with no info in the bookmarks. After I close the document and end out...

Application.FollowHyperlink &quot;mailto:&quot; & textbox Mike

Not sure if this it what you are looking for but I have a form with several checkboxes and comboboxes. If the checkbox = true then I pass the value in the combobox to the report using the where condition. Dim sWHERE As String If chklengthID Then sWHERE = sWHERE & &quot; AND lengthvalue =...

I have a main customer form with buttons to open related forms which the users go up and down like a ladder. I thought it would be better to hide the forms as they go up the ladder, then make them visible as they go back down rather than open and close the same forms constantly. Hope this makes...

I am drilling down through forms and only want the current form to be visible. In the command button on each form I am trying to call the following routine and I get a type mismatch. What am I doing wrong. Thanks Mike Public Sub formhide() Dim frmcurrent As Form Set frmcurrent =...

We have a peer to peer network with the backend mdb file on a computer running windows xp home edition and access 2000. After doing a compact and repair I get an error microsoft access can't find the file. I can open the file on the computer where the back end is stored. Did not have this...

Did you change the name in your activex control to calendar? Mike

Have you tried on your button Click() Docmd.openform&quot;formB&quot; docmd.gotorecord,,acnewrec forms!formB!nameid = forms!formA!listboxname Mike