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

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

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

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

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

Hi, It will be highly appreciated if someone can advice me on the following; I’m an industrial and do the daily production planning for a company that is making use of about 100 machines, 20 key ones, and four main divisions. Currently I do most of the planning with intermediate excel VBA...

Access beginner! Good day, i have the follwing problem. In a form i have a ComboBox that allows you to type a numeric value in it. The moment you exit the box the value gets updated in a table...everything works perfectly What i would like to do is to assign a password to the box so that the...

TheunsGoosen (TechnicalUser) 17 Jan 07 7:41 Access beginner! Good Day, can someone help! In the 1st table I have the following two fields: BussinessPartner and Bill-to City In the 2de table the following to fields BusinessPartner and City If you select BusinessPartner in the second table...

Access beginner! Good Day, can someone help! In the 1st table I have the following two fields: BussinessPartner and Bill-to City In the 2de table the following to fields BusinessPartner and City If you select BusinessPartner in the second table a 2 column dropdown combo box appears...

Access beginner! Good Day, can someone help! In the 1st table I have the following two fields: BussinessPartner and Bill-to City In the 2de table the following to fields BusinessPartner and City If you select BusinessPartner in the second table a 2 column dropdown combo box appears...