Search results

Edit : nevermind beaten to it, Paul did exactly what I wrote!

I'm sorry but that is ridiculous what you get for donating, none of those options are appealing. I would much rather see one donation button where a user can select how much they wish to donate. Ads don't bother me, don't care about some stupid badge, no-one will use the private forum as...

I don't use or have any more quotes, sure you could check the internet for good ones. What about this: Success isn't handed to you, you must go and get it. I just made that up of the top of my head. :)

You like my quote. :) I have used it for many years, not sure where I came across it. I think it was after seeing a quote Don't dream your life, live your dreams and I decided to change it.

Brian I don't believe you can't have two different arrays in vba although I'm probably wrong! I tested the formula and it worked with one range/array and two lookups. Dim myrow2 As Long Dim tempnum As Long tempnum = Sheets("sheet1").Range("A1") & Sheets("sheet1").Range("B1") myrow2 =...

Ok, I'm not sure. You may need to run a query to select the records from the subform.

Can you explain a bit better what you are trying to do now? Maybe someone else knows and can help.

Try adding this after "xlApp.ActiveWorkbook = Nothing": xlApp.Quit Set xlApp = Nothing

Possibly something like: NewRow = Worksheets("Sheet1").Range("H" & i).Value I can't test it right now, may be wrong. By the way if you're in Excel you can write your code like: NewRow = Sheet1.Range("....").Value

Have you tried debugging your code going through each line at a time to see where it freezes? The main code looks perfectly fine to me, it could be your workbook.

Remove the comma's from the range eg: xlApp.Range("C5").Value = Me.EmpNo

It's probably because by default Access sets numerical fields to Long Integer which doesn't allow decimals. It needs to be set to Single or Double.

Why? I always found it easy to use and pretty straight forward.

The company I work for(a global company - not going to mention who) are currently recruiting different analyst roles, they are looking for people with advanced Excel skills and report writing. People with Business Objects and Crystal Reports knowledge are sought after. Depending on your skill...

Will different users be using the form with different usernames and passwords? It is possible to just create a pop-up asking for a password to open a form, then you don't have to create a new password form. It depends on your needs. Here is a good example posted by khawar...

This should help you: http://devcity.net/printarticle.aspx?articleid=89 I've never used grammar checks in Access only spell check and this method seems excessive but it should work.

Sorry I actually misread your post, mistook "input the data" for "input the date". It was too early in the morning. :D But it's the same sort of process, retrieve the date from the calendar control and use it in a query to select the records you want then export the query records to excel.

After the user inputs the date in a form, use that inputted value in a query and export the query records to excel.

This should do the trick: DateAdd ("m", -13, TestDate)

Where do you want the font to be bigger? On a form, table etc..