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

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

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

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

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