Search results

Can anyone explain to me what I'm doing wrong with this? I've been at this problem for over a week and its driving me mad. Nothing I try works. I have a subform within a form. This code lies in the main form on a command button cmdQC9 in an on_Click procedure. If a value greater than 0 is...

The records are derived directly from the table I only use queries for reports. I was hoping that maybe an IF statement could be used to filter the recordset if I used it before the WHILE loop. I am not having much luck though.

what server are ya on?

It is fine the way it is, your data is more organized this way. I was taught that even if a field is blank, access still looks at it when it runs a report, query, or the field is called on in an event procedure and once your database gets large, having too many blank fields can adversely affect...

Set your tab index properly. Be sure to start at 0 with the initial control and increase by 1 with your control flow down the form.

With the 1 to Many relationship you have established between Orders and Order Details, having more than 1 item on the order should not be an issue.

Unfortunately, They have to be in excel, part of our ISO 9000 compliance requires controlled forms and they chose excel as the medium in which to store them so my hands are somewhat tied there. Thanks for pointing out that I didn't close the excel spreadsheet. I was so absorbed into getting...

Can you post a sample of your DB, as long as its not 2007 I can look at it.

What, if any event procedures are running under your combo box? Where is your combo box getting its information? Is it bound to a table, a query, or is it unbound?

I need some advice. In my database I have a form. The form holds a subform. The form is tied to tblPurchaseOrders. The subform is tied to tblInventoryTransactions Inventory transactions captures specific information related to each purchase order such as quantity ordered, quantity received...

What events are running under the control?

I can't get it to write anything. Private Sub btnXL_Click() Dim objXL As Excel.Application Dim objWB As Excel.Workbook Dim objWS As Excel.Worksheet Set objXL = Excel.Application Set objWB = objXL.Workbooks.Open("L:\New L Drive\05, Supply Folders\02, PUR-1E\Requisitions\2007\PUR-1E.xls") Set...

Is this possible and if so, can someone please post me a walkthough?

Converted to Access97 format.

Updated Check it out. From this point, I think you have something to work with. Browse around for information on how to import spreadsheet data into tables. Its really not that hard once you do it a couple times. There are some really smart people here who can help you with VBA to add...

Converted it to 97 format, not sure if it will work, I got a dll error. Is this going to work for you?

Maybe this is what you're looking for? Updated to access97 for you, see my next post.

=DSum([Purchase Orders Subform].Form!UnitsOrdered*[Purchase Orders Subform].Form!UnitPrice,[InventoryTransactions],[Purchase Orders Subform].Form!PurchaseOrderID=[Me.PurchaseOrderID]) What am I doing wrong? It seems that the expression is built properly, but it returns a "#Name?" error. :( Ive...

what version of access is this? it is appearing corrupt and won't open because of a switchboard error

datasheet view I think