Search results

bigalpha, The Default Value for the Child table should be --> frmMain!PkField Wayne

Michael, Also, my gut instinct is that: [p].[stocktypeid] <> 1 AND [jim].[stktyp] <> 'O' Wayne

Michael, How did it run ??? Unbalanced parentheses: [code] WHERE [proj].[id] = @projid -- All Parts associated with this Project AND (([p].

jw, Try: ' ' ' ws.Cells(1,1) = ObjRs.Fields(0) OR ws.Cells(1,1) = ObjRs.Fields("Column1") ' ' ' ws.Cells(1,1) = ObjRs.Fields(1) OR ws.Cells(1,1) = ObjRs.Fields("Column2") Reference like: ObjRs.Fields(0) ObjRs.Fields("Name") ObjRs!FieldName hth, Wayne

SQL_Hell, Thanks, DTS was definitely the answer. Sorry that it took 1 MONTH to respond. Thanks, Wayne

Michael, Thanks for responding. I think you're correct that Access keeps requesting more buffer space, but never gives any of it back. Even appending several tables doesn't change a thing. It never returns the memory and eventually dies. This process might take place once-a-month. So, the...

I have a coworker with a Local Access 2007 table and an identical table linked to SQL Server 2000. The SQL Server table is empty and the Access table has 1,500,000 rows. If he opens Windows Task Manager and watches while this executes: CurrentDb.Execute "Insert Into SqlServerTable Select *...

Oops ... How did not see that you had solved it. Wayne

Michael, IF (@sintInput >= 0) AND (@sintInput <= 99) The initial formatting made this very hard for me to read. I hate the Structure of If-Then-Else blocks in T-SQL. :setvar SPNAME sprevconv_ConvN2A USE [Fandango] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- Check if the STORED...

It is called Deferred Name Resolution. It appears that using the SP --> sp_dbcmptlevel 60 http://msdn.microsoft.com/en-us/library/aa259649(v=sql.80).aspx From Web-Site: "When a batch or procedure contains invalid object names, a warning is returned when the batch is parsed or compiled, and...

Hello, I have a SQL Server 2000 instance that has started behaving differently when saving Stored Procedures. In the past, when saving an SP, it had to be correct in both syntax and references to objects. If there was a syntax error, or an object did not exist, the SP wouldn't save. That was...

Jas, Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("Select * From YourTable") While Not rst.EOF And Not rst.BOF Close #1 Open "C:\SomeDir\" & RTrim(rst!Title) & ".txt" For Output As #1 Print #1, RTrim(rst!Transcript) Close #1 rst.MoveNext Wend hth, Wayne

Main, Over an ADO connection, use single-quotes as a delimiter instead of the "#". Also, use "%" instead of "*" as the wildcard. hth, Wayne

Erneye, You can put the following code on the OnClick event of a command button. If you use the Debugger and single-step through and observe the action, it should be pretty easy to get your data into your table. Dim varArray As Variant Dim intRecord As Long Dim strBuffer As String Dim...

THE MAN MY MOTHER THINKS I AM By Will S. Alkin Whilst walking down a crowded city street the other day I heard a little urchin to a comrade turn and say: “hi chimie, lemme tell youse i’d be happy as a clam if i only was the feller that...

Maybe this? http://www.learn-america.com/the-man-my-mother-thinks-i-am/ hth, Wayne

t, Just add something like this to your where clause: " And Forms!YourForm!XNAC2 Is Not Null" hth, Wayne

Shaunk, You need to have I loop from --> 0 To Listcount - 1 The ListBox entries are "0" based. Also, the ListBox items are not numeric. They are stored as text. I don't readily see where your mismatch error is if it isn't that. What line throws the error? I'd think it'd be easier to use...

tegb, In the SQL marked in red, you reference [XNAC2], but at the start you say you have (XNAC & XNAC1). Also, your logic you may need parentheses in your Where clause. You have --> A or B and C and D. I think you should have --> (A or B) and C and D As it currently is, you'll return all...

n, Try: .Fields(strName) = strInfo hth, Wayne