Search results for query: *

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?

I have a database where I open frmFirst at startup, then do a username lookup, then open frmBegin. This all works just fine. My problem is I want frmFirst to stay open, but either be minimized or invisible, and I want frmBegin to open maximized. If I put docmd.maximize on frmBegin's open...

Thanks for the responses! Yes, it works fine as an attachment...I just didn't want to do it that way. (getting fussy in my old age!!) Yes, I am using word as the email editor. I get what you are saying about translating to HTML. I think I will just use text boxes and deal with it. I just...

I have created a simple form in word 2003. It contains a handful of text boxes, a few check boxes and a dropdown list. I have protected the form. I now what to 'Send to mail recipient', which works....somewhat. The form is sent (not as an attachment) but the check boxes and drpodown lists...

Many thanks for your advise! I think I will take your suggestion and skip the wizards. I thought I was saving time, but I can see that is really not the case! Have a great day!

First, I am a newbie to visual studio, so forgive me if I ask basic questions... I am trying to create a simple form with 3 text boxes on it. I want to be able to enter data into the 3 boxes and then insert the new record to the SQL table. I have a button to click to save the data. Seems...