Search results for query: *

MajP, This one "Last = "SPEC = " & SpecNo" did the job. Many thanks for help... It's always a pleasure to have you and the AceMan provide direction. Thanks to the both of you...

Hi, Could I please have some advice on how to approach this? I have a form called Delivery with a field named "SpecNo" and "Haz" based on a table called Delivery. I have another table called GCAS with the following fields "SPEC" and "HAZ". Both fields "Haz" in table Delivery and "HAZ" in table...

Duane, Jsteph, Thanks for the feedback - it was valuable information I did not find specifically relating to ODBC call fails with Access and SQL server. I will try both methods and see what the outcome presents. Please excuse my ignorance as I am fairly new to the Access FE and SQL Server BE...

Since upgrading our backend from Access to SQL Server (Windows Server 2000)with Access frontend for the past 2 years we currently experience a constant amount of ODBC call fail errors. We are currently setup using Windows XP for each workstation (12-15 users).I was just curious as we never had...

As usual Remou, You make it so easy.... Your code did the job!!! Many thanks once again.....

Using 1 table called BOM with the following fields: Parent Text Parts Text Qty Number Ref Memo Need to add/append Parts, Qty, Reference from one record to a another record in the same table (BOM). Add the Part, Qty, Ref from this record 1 Parent Part Qty Ref...

Try this thread: Thread181-1427903

Understand now, best of luck on your solution.

I must be blind as I did not see how the calculated value is determined from your SQL query above. At any rate I tried to duplicate your Tables & Fields and ran your code. I had no problem appending tbl.Invoice.ProjectNbr field value into tblProjects.ProjectNbr field. But this was only working...

Have you tried using the Me.FilterOn = False in your combo?

ProjectNbr is a calculated value. I don't believe this calculated value is stored in your tbl.Invoice.ProjectNbr field, hence reason it is not appended to tblProjects.ProjectNbr field.

Hello AceMan, Irishjoe and Jerry, Thanks very much for your expert inputs. I opted for the cheap way out and decided to use the Append query method, joining both tables and appending to Company Transaction table. Very much appreciated - I now have other options based on your inputs to get the...

Newbie to recordset: I have a form called Products and subform called Product Details. Both recordsource from tables called Products and Product Details. I need help inserting data from field name Location in the Products Subform into a field named Location1 in a table called “Company...

Thanks Remou, I decided to use your suggestion using a subform with query as the method I was trying to do was not working even with added expression you suggested above. Thanks again for your help and direction...

Thanks Remou, I am getting a invalid syntax expression error. "You have entered a comma without a preceding value or identifier

Thanks Remou, But the report is already based on a query. This field is a calculated field I have in my ID footer section of the report. The field in question is calculated based on 3 other fields I have on the detail section of the report using...

I created a report in access 2003 to show Supplier Transaction Analysis. In one of my fields I have in the control source the following: Name:SumBalance Format: Euro Decimal Places: 2 Control Source: =([OBTot]-([SumPurchase]+[SumBicInvoice]))+([SumPurchaseCredit]+[SumPayment]) Currently the...

Thanks Denny, I'll try it out and let you know...

Getting this error: ODBC call failed [Microsoft][ODBC SQL Server Driver]Timeout expired (#0)on other network computers SQL Server 2000 BE Access 2003 FE I have command button that runs 56 update queries which opens a Trial Balance Report. I have tried changing the ODBC Timeout setting on each...

Try this: FoundConsigneeID = Nz(DLookup("CENTRE", "CodeLook", strFilter)) If Trim(FoundConsigneeID & "") = "" Then MsgBox "Match Not Found. Keep current Cost Centre?", vbOKOnly + vbInformation, "Default Consignee" Else MsgBox "Match Found", vbInformation, "Default Consignee" Me!ConsigneeID =...