I have a column in MS access that contains whole numbers and decimals. How do I filter out the rows that cotain decimals and just keep the entries with just whole numbers. RawData 1 2.5 5 6.5 1.3 7 I want the query output to show: 1 5 7

Hi EE, I have a product inventory database built in Access 2007. It consists of a single table with a barcode, destination and a date sent. I scan barcodes into a continuous form and execute a SQL query that populates the inventory list with a destination I enter in a text box and the current date where...

I have taken over an MS Access project so am not 100% familiar with all the settings etc. When I add a new record using the new record button at the bottom of my Form it appears that the record gets added OK. I can click to the next (i.e. blank) record, then click back and my record is there. After this...

I would lke to determine how many spaces are in a field and then add them to the beginning of the field if it does not equal 35.

Hello! I have a parent form and a sub form embedded in it. I would like to be able to display (as read-only), selected fields from the recordsource of the parent form, on the subform. Sounds easy, but I've not been able to make it happen. Parent form and sub form have different record sources. Parent...

Hi All, I have several fields on an MS Access Form. I would like all my 'read-only' fields to update AS SOON AS I fill in the first field. For example, I have a field called 'employeename'. When I enter the employee name, I want all the fields related to this employee (i.e. age, address...

Good Day Experts This should be simple! I'm looking at something wrong. I have two If-Else-Then statements on the "AfterUpdate" event of a control. Only the first one executes. Is there something wrong with the way I have written the statements. Private Sub cboBusinessType_AfterUpdate(...

I have an Access where I import Word data into a table. One of the key fields [MatterID] is not present in the Word file, but the user knows what the data is. On import, I want to prompt the user to fill-in the [MatterID], and have this data put into the table, with the rest of the Word data. This is...

I have an Access where I import Word data into a table. One of the key fields [MatterID] is not present in the Word file, but the user knows what the data is. On import, I want to prompt the user to fill-in the [MatterID], and have this data put into the table, with the rest of the Word data. This is...

I am importing data from a Word file into Access. I want the user to be able to select the file name to imprt off of a list of files that show up in the set folder. I am getting an error on this line: strFilter = ahtAddFilterItem(strFilter, _ "Word Files (*.doc)", "*.doc") Here is...