Search results for query: *

I'm trying to open my Access 2007 database app in office 2010 64bit. I get a message that tells me I need to delete all my code in order to open the app. Are we required to rewrite all our code to support 64bit Access?

Is the beforeupdate event reliable? I have the following code in it for a drop down box and sometimes it does not put the order ID in when the user clicks Yes. Private Sub Client_ID_BeforeUpdate(Cancel As Integer) If Me.Client_ID.Column(6) = "Unpaid" Then Msg = "This Client has an open order...

I moved my Access 2007 app to Access 2010 today and tried to open a code module and I get a message telling me that the module name "mymodule" is misspelled or refers to a module that doesn't exist. Any help is appreciated!

I have been given a table with a column that should have only been numbers, but people have been entering words too. So I need to move the ones with alph characters to a new column. How can I do this? Thank you,

Does anyone see why I would get this error? Object not set to an instance of an object Here is my code and I get the error on the DirectCast line. I have 5 labels on my pae Label1, label2, label3, label4, label5. Dim responseStream As Stream = theResponse.GetResponseStream()...

Does anyone know what I need to do to get past this error? The error is "Nested table 'link' which inherits its namespace cannot have multiple parent tables in different namespaces." I get the error on this line: dscte.ReadXml(xtr) view plaincopy to clipboardprint? 01.Protected Sub...

I have a table that has many rows, but some of the rows have a husband and wife in separate rows, they are at the same address. So the lastname is the same the first name is different and the address is the same for these types of rows. I need to do a make table that moves all last names...

I need to show all categories, even if the client has no points for some of them. I'm not sure how to adjust my select staement to provide this. SELECT tblLookupCateg.Category, IsNull(Sum(tblPoints.Points),0) AS TotalPoints, MONTH(tblpoints.[pDate]) pMonth FROM stblpoints left outer...

How can I check to make sure that my RAID 1 second drive is doing ok? I would hate to have an issue and it not be working. Thank you,

I have a database app that has always been used for us currency, but know they need it to handle other currency, maybe CANADA. How can I do this? Thank you,

I'm trying to get the largest payment amount and a couple of other columns the statement below will work, but if a client made multiple payments on the same max date it returns all of them and I only want one row per client. Can anyone suggest what might do this? SELECT A.clientID...

In my HAVING here I'm trying to only return a row if the max paymentdate is older than 12 months back from today. I don't seem to be able to get it. If the max paymentdate is 3/14/2010 it should not return a row. But if it was 3/14/2009 is should return a row. HAVING...

I need to get the largest payment and date of the payment for all clients. My table has clientID, AmountPaid, and PayDate fields. I have tried using max() on the amountpaid but it does not work, the max date might not be the date the largest payment was made. Any help is greatly appreciated...

I upload an excel file and view it in a gridview. If I try to upload the file again I get an error that the file is being used by another process. How can I stop this, so I can upload the file again without the wait time? The file is always the same name. Protected Sub...

Clients make payments on loans, they are inserted into tblPayments. I need to return a list of the LAST PAYMENT made by each client. I need to see clientID, PaymentDate, and PaymentAmount. client1 2/2/2007 $100 < this is the last payment they made, they may have made other payments but...