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!!
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...
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!
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.