Search results

Re: 2 Problems Hello Eran, 1-i can fill only the first line in the form That's because your fields in the form are not bound to a table. You must have a table that stores the data entered in the form. Set the "Control Source" property of your fields to the desired fields in the desired table...

Hello everyone, I have office 2003 Professional, and I work in Access's Visual Basic Editor. Sometimes after opening the "Microsoft Visual Basic Help" window by standing on a function in the code and pressing F1, the help window refuses to close - I click the X but it does nothing, and I'm...

Hey all, I'm using vb 6.3 and access 2003. I have a wide access form which has a horizental scrollbar. I want to scroll the form sideways using VB code. I've searched around and it seems that the scrollwindow API function is a good way to do so. I call it thus: dim i as rect GetClientRect...

Hi everyone, I have a form with a combo box, whose afterupdate code is: Private Sub CustomerName_AfterUpdate() Dim rs As Recordset Dim person As String {This will contain the SQL Statement} person = "select people.department from people where people.name='" & CustomerName.Value & "'" Set...

Hello everybody, I'm an Access novice, so maybe my questions will be a bit foolish... I have a query that says: SELECT people.name FROM people WHERE people.ID=[TheID]![ID]; And I have a query called TheID which has a field named "ID". But alas! When I run the first query, Access (2003 btw)...