Search results

They are only in 1 table but each year is in seperate form. Doesnt sound like a flaw to me.

I would use a combo box with a drop down to select each form. Forms and table are already designed. All set to go I just need to add one combo box or list box to open each year.

I typically have buttons and a macro set up which will link to the original form by primary key. Anyone built it with drop down menu? For explanation when on Training Records Form for ID: 007 the admin can then open each year by a button for only ID: 007.

I found the solution after many hours if you can believe it. It was the property setting in the cmombo box which needed to be changed from 3 to 4. Thanks to arnelgp and Gizmo for the posts.

I tried it but it didnt work. Gave me Run-time error '94' Invalid use of null

Thanks so much for response. Ill give it a try in the morning - it may work. I love this forum - everyone is so helpful.!

Ive tried everything. It might have something to do with it being a date format xx/xx/xxxx but not sure how to handle it. I know it has the correct columns.

Any ideas? Ive been struggling with this as it looks like there may be a simple solution?

Yes, Column 0 is accounted for. I have the right corresponding columns. It is column 4 for a date x/xx/xxxx which is giving me a problem and I dont know why.

Im having a problem calling up the 4th column from a combo box to auto populate the field. Any restrictions, it is a date field as I can get text into the box? Here is the code added to the event on change of the SQL combo box: Private Sub Combo106_Change() Me.FName.Value =...

i figured it out anyways. thanks

sorry that was just an example. the table is more complex. thanks

Sample A: # Name Start Date Code 101 John 12/1/2012 HU 101 John 1/1/2014 BC 101 John 6/6/2016 EE Expected Result B 101 John 6/6/2016 EE

I have a query with multiple dates for the same person and ID # so it shows up several times. I have to filter by the most recent date. Tried the max and last but multiple are still showing up. Any suggestions. Thanks

I can do the import part. I'm just confused as to if the end user is uploading it. It would have to be named a certain way in order for it be imported. Then once imported run a query to strip out the last two characters. Then create a second query with the join and leave off the records from the...

I need to get through step 1 first. I would have to have an end user import the table. I suppose I would have to have them rename it? Then strip out the last (2) characters. I might be able to figure it out past that.

When running query only have results which were not in the imported table. Not delete any records from the main table.

Does anyone know a good foundation for the following?: Allow end user to import a spreadsheet with one column as a table into database Run process from a button to do the following: Strip the last two numbers in the column. The remaining characters in the column link to the main table. Take...

No problem. It just seems like there must be a way to transferspreadsheet.

i changed both . i am using 2010