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?

I have other things going on in the after update and thought this was best to ask before the update.

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...

Ok, that worked, but I think that the issue started when I compacted and repaired under Access 2010 64 bit. Moving on, Thank you for the help!

No, I have not. How can I do that?

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,

Jason, I'm requesting a response from a third party API. I'm parsing out the email addresses from that respone. Then I'm trying to count the number of emails and display them in a label with that also includes the type of emails they are. There are 5 types of emails, hence the label1 - 5...

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()...

Is it possible to use the online validator in my code? Is there another way to get the xml from the response? I have only used datasets to read the xml response. Thank you,

Can anyone shead any light on the meaning of this error? Nested table 'link' which inherits its namespace cannot have multiple parent tables in different namespaces.

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...

George, Just woundering if you have any experience with Fusion Chart? My reson for needing the previous select was for a stored procedure that I want to use in s chart. I have posted the code below that I use for the chart and here is the problem. The chart shows each of the categories and...

George, Yes, please tell me more...

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,

So does this mean that no changes other than the regional setting in Windows would be needed to be made?

Ok, Access has a money datatype, can this handle only US currency?

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,