Recent content by sjdk

Hi Gruuuu! This is a one-time deal....it is a spreadsheet of courses that employees have taken. There is no real partition that I could use. The dates/courses/institutins are all over the place. I'm thinking that this would be a manual process, but thought I'd check to see if someone had some...

I have an excel spreadsheet with 150,000+ rows, (20 columns) of data. I need to break that sheet down into spreadsheets with about 15,000 rows in each spreadsheet. (the database I am trying to load these spreadsheets into has limitations) What is the easiest way to do this? Thanks!

UUUUGGGGGHHHH! I am such a dork! That true/false test is cool! Naturally, it came up False....I neglected to convert my numbers to text before I started this little excercise! I got it (using my original lookup). Many many thanks for your time and assistance!!

Thanks for the response! I put that in and received the same result, #N/A in cell L2.

Hello! Thanks in advance for any assistance... I am working on moving data from one database to another. Right now I have my data in 2 excel spreadsheets. One is EvalsFinal.xls, the other is ElmPosition.xls. In EvalsFinal, I have (among other things) an employee id(text(6)) in ascending...

oh...ok...didn't realize that! Thanks for the good info!

Actually, that did the trick! Thanks! I know, it probably isn't the best fix....but it worked and the customer is happy. Thanks!!

Greetings! I am helping a customer with a rather large mail merge project. We have an access front end, and sql backend. I have the document set up, and we are in the process of placing the merge fields on the document. Here's the problem...there are multiple columns of data on the word doc...

Ok...got a temporary solution...I converted it in a query and then joined. It 'aint pretty, and it 'aint right...but it worked until changes can be made. Thank you for your time and wisdom!

Hi Skip... I get what you are saying (LOUD and CLEAR!)....however....I didn't design or create the database...I inherited it. Right now changing the database isn't an option. I guess I am just looking for a work-around until making a change is an option. Thanks!

Good morning, and thanks in advance for any assistance... I have a linked table in SQL (tblSupervisor) that contains an employee number and a supervisor name. I want to join that table with an access table (tblEmpview) that contains employee number and name. Simple...right? Here's the...

Thank you all so much for your help. What I ended up doing is changing the flow of things so the first form could close and the next one could open. Again..thanks for the help!

This is the code from frmFirst Private Sub Form_Open(Cancel As Integer) UserName = fOSUserName Usr = UserName DoCmd.OpenForm "frmBegin", acNormal End Sub ----------- This is the code for frmBegin Private Sub Form_Open(Cancel As Integer) Forms("frmFirst").Visible = False Me.Combo9.SetFocus...

Ok, great! I moved it to frmBegin and same result....frmBegin is visible and frmFirst is open on top of it. Hmmmm....... This seems like it should be so simple...I must be missing something obvious! Thanks for your help thus far!

Thanks for the response...I put that code in the open event on frmFirst and frmFirst was visible.....did I put it in the wrong place?