Search results

We just upgraded to Office 2007 and are experiencing very slow access performance. This microsoft article addresses the problem: http://support.microsoft.com/kb/275085 It won't let me change Subdatasheet Name property to [NONE]. Even if I am able to change it, will this affect my table...

Thank you so much! It seems to be okay now. Any idea why it happened?

I have 2 copies of the corrupted table. When I deleted the fields that didn't appear to be affected then all of the other fields suddenly looked okay. So then I left the fields in there and only deleted records so that the file wasn't too big. I hope this helps and someone can tell what's...

I copied that table into a db and zipped it. Do you want me to email it to you as a copy? I'm not sure how to post it. If you give me your email address i will also work on posting it here too. Thank you!!

Does this help at all? I noticed that not all of the fields do appear messed up. Maybe I can send it as a link. LSC PROCTR CUSTNUMB CUST STORE# ########## ### ####### ################ ############ ########## ### ####### ################ ############ ########## ### ####### ################...

Thank you! I wish that were the problem. I did go in there and try it but the ###'s stay the same size when I resize the columns. This is so weird - I've never seen anything like it.

I tried searching to see if anyone else had this problem but couldn't find anything. One of the tables in my database has 24 rows with #### filling up all of the fields. I've tried compacting/repairing, deleting the rows and adding them back in from a good table but nothing seems to work...

Thank you for replying and the information. So I need to go to each computer with the missing reference and reinstall Microsoft2003, but do custom install instead of automatic, then make sure the web coponents are there? I don't even remember ever using those web components. Could I just...

Some of the computers that I have loaded Office2003 have a missing reference. The missing reference is Microsoft Office XP Web Components. I have gone in to try to set this reference but it is not there on some computers. Is this a library that I need? Why would it be on some and not others...

My computer was just upgraded to Office 2003 but not everyone in the office is upgraded yet. Only the people upgraded can use my db now. What is the best way to have them use the db until we get them all upgraded? I searched the forum and found some links and tried to set some references...

Can anyone tell me, please, why my DLookup doesn't work using the on Click of my control button? My control is on a form that is opened from a subform. This is the code I put in my form's code: If (DLookup("[drivingHolidays]", "T_miscDates", "[dateDate] = " & Me.lboDateDate)) = True Then...

Sorry, I forgot to take that out. strDriving was a boolean but now it's a string that defaults to "NO" and changes to "YES" when the date in my holiday table = [DELIVERYDATE] which is dteTemp1

Hi I have this module that Mile-O-Phile helped me with and it works great. I have made a couple of changes so that it not only skips over Sundays, but should skip over drivingHolidays. It's doesn't seem to be recognizing driving holidays. stringDriving field should be changing as dteTemp1...

Thank you, thank you , thank you!!! Mile-O-Phile you've been a ton of help! Now I'm going to work on getting that driving holiday in there.

Changing yes to true gives me an overflow error.

Thank you! I found one post that really helped. I've changed the code some to adapt to what I need and I'm getting an error message. This is the first time I've ever written a module outside of my form. I just do Access part time here so I've tried to make my db pretty simple, but they just...

Thank you very much! I changed all my !'s to .'s and removed the .Text. It seems to be copying txtSearch to txtSearchFind okay, but my queary just seems to ignore what's in txtSearchFind. Here is the criteria I'm using. Pretty straighforward, but maybe there's something wrong. I even...

Hi! I was looking at this post because it's exactly what I need. However, it's not quite working the way it should. I set up the 2 fields on my form: txtSearch and txtSearchFind, but when I try to open my query using the field txtSearchFind as my criteria, it pulls up nothing. I can see...

I'm not sure exactly where to start on this one. I've searched previous threads and haven't found anything that seemed like it would really help. I need to calculate a LoadDate from a DeliveryDate based on the number of days associated with that State that it is to be delivered to. Each of...

I'll try this. I already have all the data they need to see other than the previous loadDate. From Table B, all that is needed is the most current and second most current loadDate. Could you show me an example of the function you would used to get that value? Thanks again!!