Search results

Well that is where I started > 10 years ago. I was an instructor for MS Office and HTML. I did that for a few years becoming a relative expert. I then got a job developing Access databases and learned SQL Server on my own. I then moved to a job where both Office and SQL development skills...

Not a bug. Design, actually. To optimize performance and minimize network traffic, Access is not going to pull all of the data across for every single request. It is only going to pull pages. Ever notice when you are using the page up/down key going through a table that is cruises along for...

What comes to mind is the old question of shuffling and dealing cards. How does a computer shuffle virtual cards? Well, one solution, and what would work here (I believe if I am understanding the jist of this) is instead of dealing from the top of the deck, just pull a card out at random from...

Check out the INSTRREV function, LEN function and RIGHT function. Total length of string - position of space from right Take those number of RIGHT characters.

Try this: SELECT DISTINCT TRIM(Postcode) AS Post_Code FROM House What is your datatype for Postcode? Be sure that it is DISTINCT and not DISTINCTROW. There is a difference.

Also know that you can have table functions, too. Select * FROM fn_YourFunction('08/21/2007')

This should work (EmmIssue is your table): DECLARE @StartDate SMALLDATETIME DECLARE @EndDate SMALLDATETIME SET @StartDate = '07/01/2007' SET @EndDate = '07/15/2007' DECLARE @IncDate SMALLDATETIME DECLARE @TheResults TABLE (ResDate SMALLDATETIME, ResOrder INT) SET @IncDate = @StartDate WHILE...

Logins are part of the master db. Backing that up should be fine.

Wrong forum. Please use the Excel forum when posting Excel questions. It is listed down in the Apps and Windows forums. Use the OnClose event for the form. Cancel the event and post your messagebox. (Or, of course, just run the code that you have in your exit button macro ...)

Search the forum. This has been discussed many times.

Is this on-site, full-time during the contract?

That does not exist for SQL Server. If you are storing passwords, you must first hash or encrypt them. Do a Google search.

You can't. Go to the Disconected Edit options for that task to enter in the table name explicitly.

Does the SQL you posted work?

Patience my friend ... some of us do have real jobs to attend to ... No bug in the original program. You have not finished modifying it to work as minutes. The logic there is for 8 hour days and you want to do this in minutes ... Everywhere there is a reference to 8, you must now update this...

To suppress a CR, you need to have a semi-colon at the end of your print statement. I found an easier way to do this using the LOF instead of the LOC command: Public Sub PDX_Man_Test() Dim MyLocation, MyLine ' Open file just created. Open "c:\Table1.txt" For Binary As #1 Open "c:\Table2.txt"...

You are going to have to calculate your position using the LOC keyword to know when you are on the last row, then remove the CR/LF.

select id_case, dt_last_pay from noldba.case_rollup; where datediff("d",DT_last_pay, Date()) > 60

Just taking a quick glance at the SQL code is showing me that there is a lot of room for improvement. Nested SELECT statements in a join can be a real killer. Don't do that. ie LEFT JOIN(SELECT episode_id, date_answer AS end_date FROM episode_question_answers WHERE question_id = 35508) AS...

You must view the table objects in a form to see the contents of an OLE object. Use the Form Wizard to automatically generate one for a quick preview. You can add them by right-mouse clicking on the object and selecting Insert Object.