Search results

Hi, I want to update the column qtyOpen from the table InventoryComponent in a condition that the ComponentNumber from InventoryTable and OrderNumber from the CompanyPurchasesDetailsComponents and PackageItem from the CompanyPurchasesDetailsComponents tables meet. I think I am getting there but...

Why am I ignored in all of my aid request? Have my name reputation became horrible? I appreciate it please if someone can help me?

I have a report that displays invoice number with first name, last name, data and owed. An example illustrated below: Invoice # First Name Last Name Date Owed --------------------------------------------------- Invoice # First Name Last Name Date Owed...

It worked finally!!!! Thank you so much :D One final please, if I have unbound box (it have to be unbound) can I set the control source to link to another column in entirely different table or form? I have done thins =[Invoice-Address]!InvoiceID but I get ?#Name as an error instead of the value...

Thank yooooooooooooooooooooooouu!!! * gives you a very tight kisss on the cheeks * I have not tried it yet I will tell you right away the result but that is exactly I wanted!!! :o :o :o :o :o :o :o

@RuralGuy May I ask why you went crazy at me at MSN? Said things that are hurtful and mean are not truthful and the event that occured did not needed it? If you did not want to help me anymore live, then please say so. I even wanted to pay you for your help as a sign of appreciation. You are a...

But what I am looking for here is a great example: I have Table A, with three columns. Insert Into Table A (Column1, Column2, Colum3) VALUES (X, Y,Z) I already know what is Y and Z let us say Y and Z is 1 and 2, but I want to get the value X if a certain condition is met. Say that condition is...

I know you guys are trying very hard to help, but this is not a helpful answer. I guess I have to figure it out on my own. Thanks for the help though.

Oh my GOD! That is it!!? All of this description and revision and all of this and all I get as an answer "I don't see clientID in your SQL statement!!?"??! That my friend is a real example of a "frustration pill"!!!

When the SQL is executed I created a msgbox strSQL to see what is entered in the strSQL and I get this message: INSERT INTO [Invoice-Order] ([Number], [Your Order #], [Sales Rep], [Job Number], [Terms]) VALUES (SELECT invoiceID FROM Invoice-Address WHERE CustomerNumber = 11, '333', '0'...

I have entered the following code below, but when I run it it doesn't work I a get an error: Public Sub ExportOrderDestination(TableName As String, intNumber As String, YourOrderNumber As String, SalesRep As String, JobNumber As String, Terms As String, inNumber As Integer, valueOrderNumber As...

I have entered the following code below, but when I run it it doesn't work I a get an error: Public Sub ExportOrderDestination(TableName As String, intNumber As String, YourOrderNumber As String, SalesRep As String, JobNumber As String, Terms As String, inNumber As Integer, valueOrderNumber As...

I have a question I need help for, below is a very strict detailed explination of the current scenario I am in and I need assistance for it: 1) I have a percentage of Commission I need to calculate, the percentage of commission constitudes of the following information: a) Date, b)...

Please any help would be greatly appreciate it!!?

No you misunderstood me Rovers and I am always afraid that this might happen. OK here let me do it in a better scenario, this is how the report is chunked into pieces. (A) Bill To Fahed Al Daye...

This is the scenario I am in: NewClient have one to many relationship with estimate. There is one new client for as many estimates. The new client table holds information of the client, name, address and so on, the estimate table ONLY holds information about the estimate, what evre the case be...

I am having problem specifying App.path in VB using Access, here is the line: DoCmd.TransferDatabase acExport, "Microsoft Access", Path & "MarbleExport.mdb", acTable, "Estimate-Address", "Estimate-Address", False DoCmd.TransferDatabase acExport, "Microsoft Access", Path & "MarbleExport.mdb"...

I have a little problem I need help with. I have two subforms one is called "Estimate" the other one is called "Internal/Invoice". In the estimate subform there is a button called "Export to invoice" when that is clicked the approriate information from Estimate (using SQL statement) is then...

Here is the other screenshot

There you go, I hope that helps. I also posted the important part of the form, to give you the general idea of what I mean by it.