Search results

Hello, A subform has 4 fields, State, Location ID, Total and District. For the first 3 fields ( State, LocationID, Total ) the data is obtained using a query 1. This is set up in the design mode For the last field, District, data needs to be obtained by passing locationID to Table 2. E.g...

JHB, That did not work.. Any other suggestions.:)

Hello, I am using Access 2007. There are multiple tabs on the Main page Tab 1, has a subform where "Table A" data is to be displayed. Tab 2, has a subform where "Table B" data is displayed Tab 3, I have a button which executes these commands DoCmd.RunSQL ("DELETE * FROM Table A")...

pbaldy - you are the boss, thanks that ( If Not (IsNumeric() ) helped. I had tried NZ and it did not work.. Spike, I will try your solution too.. Thanks again

There is simple function to check if the variable has a value and if not set then set it to zero, Function nulltozero(anyValue As Variant) As Variant If IsNull(anyValue) Or anyValue = "" Then nulltozero = 0 Else nulltozero = anyValue End If exit_NulltoZero: Exit Function...

Hello, I am able to bind the Form to a simple select query ( Thanks Bob Larson ). Then the textboxes control sources are set to some of the fields from the query. I am also able to traverse the Next and Prev (DoCmd.RunCommand acCmdRecordsGoToPrevious) records using the buttons. The question...

Bob, I had tried ReQuery and it did not work bu I tried SetFocus and it worked. When Next button is clicked, the New item is getting displayed correctly. Thanks a lot, the issues have been resolved

Row Source type is set as Value List and the items are added in the code behind

Clarifying, when the next button is clicked, the next items ( item b ) text is displayed in the combo box but the previous items ( item a ) text is shown selected and when I select the ( item b ) data, item a is not in the combo box. I hope this explanation makes sense.

Bob, binding the form to the query worked.. Well I am new to Access programming and did not know this could be achieved in this manner. Hence in my first post requested if there was a better approach. One quick clarification, there is a combobox in the form where the item is being added...

No, the query is constructed in the Form_Load by using a time period obtained from Previous form..

The button is on the same form

Bob, Thanks for the reply, The scenario is when the form loads, I run a query to get the list of records and display the First records value. I use the recordset for this operation. After that to traverse the records there are Next and Previous buttons, I used the above command...

Sorry correction on the Next button Click, subINdex is removed. Dim mvrs As Variant Set mvrs = Me.Form.RecordsetClone mvrs.Bookmark = Me.Form.Bookmark mvrs.MoveNext Me.Form.Bookmark = mvrs.Bookmark mvrs.Close Set mvrs = Nothing

Hello, On Form Load I get the data using the recordset Private Sub Form_Load() Dim rsErrors As DAO.Recordset Set rsErrors = CurrentDb.OpenRecordset(" SELECT * FROM EMPLOYEES ") --- code here to load the first record in the text box -- End Sub Now to navigate the records, there is a...

Thanks, the update idea worked perfect.

Adding to the above post, I am able to get the FileName

Hello, I have multiple text files for which the import works fine. I am able to read the contents and insert data into the access database. My question is, if I need to maintain the file name in the same table as the imported data, how can I achieve this. So, FileA has 5 columns, 10 rows...