Search results

An alternative to the Docmd.Transfertext This is VBA code that gives you total control of the import. Click "New" on the Forms and select Design View Let us assume your table (for data import) is called MyComments and it has 3 fields: ID Number (Property - Number/ Long Integer), Comment...

This is how you do it... STICK with what I told you to do : In the control, set the Input mask as - 999999 or 000000 or ###### where: 0 Digit (0 to 9, entry required, plus [+] and minus [–] signs not allowed). 9 Digit or space (entry not required, plus and minus signs not allowed). # Digit...

Error in Open Statement Your statement should read DoCmd.OpenReport "rptOverview", acViewPreview, , "[CarID] = " & Me.cboCar 1. You can't use word "WHERE" , just use the qualifier [CarID] = and the value 2. I presume cboCar is a Combo box and it is bound to one of the column. Its value is...

Use an Input Mask on the control in a Form like 999999 or 000000 or ###### where: 0 Digit (0 to 9, entry required, plus [+] and minus [–] signs not allowed). 9 Digit or space (entry not required, plus and minus signs not allowed). # Digit or space (entry not required; spaces are displayed as...

A Tale of 2 Tables? Hi I believe the problem is all in the table design and what relational links you have set up. I don't fully understand your problem so I am showing below what I think your table structures should be and how the link should work TABLE A CompanyID / AutoIncrement key Field...

I presume you have in some way linked the 3 tables in the query such that all 3 date fields are "visible" to your query and your query has 3 dates for each row. If this is so, then what you need to do is convert each of the dates in each row, to its date serial number and select for each...