Recent content by jsimo01

Sample DB Have you tried the Northwind Sample DB under the Help>Sample Database Menu, it covers everything you need plus you can import the forms, tables and queries into your own database to modify to your own ends. i found it the best place to start and learn about various features.

Sample Db Attached, ManyThanks John

Word Yeah, in so much as there is set information in each file, however this is where its gets complicated. Under one entry there is information that needs to be split into two different fields (on the db) on the same line and there may be more than one subentry (example attached). This is...

Hello All, I would like some initial guidance on a problem involving insanely large numbers of word files (can be converted if necessary!). I have 60,000 word files (unfortunately) and I would like to extract a little information from these into Access like Site Number, Location, Date (in...

Progress made - Thanks! Hi, Thanks again, I have attached a first draft, if you have the opportunity to review and comment it would be extremely helpful. (I apologise it is a little crude). I am having an error message appear 'Overflow Error No.6' or something which I haven't yet solved. I...

Thanks, The code I have is Private Sub Form_Current() Dim oItem As Variant Dim bFound As Boolean Dim sTemp As String Dim sValue As String Dim sChar As String Dim iCount As Integer Dim iListItemsCount As Integer sTemp = Nz(Me![Find Type].Value, " ")...

In brief: I would like to use a multi-select listbox on a pop-up form to set values on a text box control on my main form. As I have more than one multi-select list box the main is becoming a little bit busy with all the additional list boxes and command buttons that are needed for the only...