Search results for query: *

Access beginner, Hi, I would like to develop a simple stock program for a small company, with fair amount of access experience I find that the size of the file grows significantly with every form/subform I add. I would like to buy the book, Visual basic.net 2003, and the software visual...

Access beginner, Hi I have 3 tables and a query that totals them; table1 table2 table3 Total 0 2 0 2 0 1 1 2 1 0 2 3 0 0 0 0 To make it more userfriendly, visually, i...

Access beginner, Hi I have down loaded an access template and all the buttons on the form got a round soft touch look to it…even if I copy the buttons to my access form or create new ones they don’t have the soft touch look? How do i change it?

Access beginner Hi, i have a command button on my form that uses the following code to go to the next record and to call a "Check_afterupdate" procedure. Private Sub Command220_Click() DoCmd.GoToRecord , , acNext Call Check125_Afterupdate End Sub I would like to do away with the...

Access beginner Hi, I have a Command button on my form that works perfectly. It refreshes the form and all the sub-forms with the following code: DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 ..but I need one of the sub-forms that was created from a query to refresh the form...

Access beginner Hi, At the moment my text box is set to unlock with a fix password, but i would like to allow the user to determine his own password that he enters in "textbox1" and then the MsgBox will respond to his personal password, at the moment my code looks like this. Thanks Theuns...

Thanks

Access beginner, Im using code ="" to display all data cells with nothing in them, what code do i use to display data cells containing something or any thing in them. Thanks Theuns

Access beginner, Hi, Im using code to unlock information so the user can change the information. I also need the input mask to change from "password" to "text", but im struggling with that specific part of the code. Thanks Theuns Private Sub EmployeeCode_Enter() Dim strInput As String, strMsg...

Access beginner, Hi, What must my code look like when i select a form in the startup procedure to open full screen(Maximize). At the moment the form opens but then i have to click on the maximize button first to full screen the form for viewing. Thanks Theuns

Thanks for the help! TC

(Access beginner) I'm using the following code to call a form from a switchboard, can someone help me with the code to call access page with the same name. Private Sub Label78_Click() On Error GoTo Err_Command116_Click Dim stDocName As String stDocName = "R001ComponentPriceT001"...

(Access beginner) I have a query that is displaying a answer in form view as a guide line, if the user is happy with the answer he can press the command button so to allow the query values to display in the combo box for further use or type in his own vallues, but im strugglig with the vb code...

Sorry my mistake, i see now that the detail_mousemove is taking care of it. Thanks for the help regards TC

Thanks for the help it works, The label is changing when I’m mouse move over the label but I’m struggling to get the label color back to its original color once the mouse moves away from the label.

(Access beginner) Hi, I assigned an event procedure to a label and its working perfectly. The label appears on a switchboard and it would be nice if the label back color could change on mouse moving over it. But I’m unsure about the VB code. Private Sub Label82_MouseMove(Button As Integer...

Got it, works perfectly. Thanks

Sounds like the remember password checkbox can help, but i don't seem to find or see that checkbox?

No, no changes to the tables, i just linked(import) two tables from the ODBC and in access i wrote a query that is making use of the two tables, and the query works perfectly...but the moment i close and reopen the data base and click on the query or the linked tables a microsoft message diplays...

Hi, I linked a table to an ODBC and it works perfectly but the moment I close Access and click on the table to display the info- the following message appears “The ODBC connection to SQL server failed” To reestablish the connection I click on the table and the “Link table manger” ….this cannot...