Search results

Hi, I have a replica database in Access 2000. I changed a form in the design master that had nothing to do with the date or a date field. Everything appeared fine. Now I updated the replicas, and an error is happening on all replicas as well as the design master. Any reference to Date() or...

With this code, I can open Word and Excel files, but not PDF. Please let me know what I'm doing wrong. (I tried changing strProg = "C:\Acrobat.lnk" including to a .exe file but nothing happens when I click the Open button) --------------------------------------------------- Private Sub...

Love this forum! It orginally helped me build a database to manage customers back in 2002 (using Access 2002). Becuase of our slow server, I was forced to spilt the database and it's been great for years (some glitches). Recently one of the users upgraded to Access 2003. When he sync's to the...

When users logon, sometimes they see a Popup Error Meesage: "This member of the replica set has conflicts from synchronizing with other members. Do you want to resolve the conflicts now?" I need them to click NO. I resolve the errors on the Master, when they update the briefcase, the conflicts...

Easy Questions? I created a button that runs a Macro to do the following: 1. OpenForm (Form Name: Business) 2. ApplyFilter (Where Condition: [Business]![City]="Columbus") It works fine, BUT I want to get away from Macros and write the code. So I assume I write the code using the On Load...

Here's an alternative solution if you can't build it in Access: http://www.zipcodelocators.com/

I have a button on a form that allows users to preview a report. I added "Anaylze with Excel Button" to the menu bar so users can open it with Excel after they view it in print preview. How do I write the code for the button on the form to Open directly to Excel? THANKS!

Greetings All..... I'm still new but doing OK. Thanks to a big part of this forum. I would like to add a drop-down date. I read on this forum to use ActiveX Microsoft Date and Time Picker. I selected Tools from the Top Menu bar, then clicked ActiveX. I scrolled through the ActiveX Controls...

I have an Address Field I want to seperate into two fields. So I created two more fields and populated it with the Address field. 1) StreetNo 2) StreetName Then I did an Update Query to remove the street numbers. I used the following in the Update to...

Pat, This is a simple & awesome solution. Thanks!!!

Can you help a Rookie? Where do I place this code? I have a contact table with names. I use these names on a form. Thanks

Try putting the Code on AfterUpdate

Post the code in the event procedure and hopefully we could offer a quick solution.

Easy Fix Ok, I'm a Rookie, the answer to my question is...... Date DESC

I'm using Access 2002. I have a subform that has a "Date" field. In the Form Properties, in the "Order By" box, I put the word "Date" It now sorts by "Date" - Ascending Order. 1) June 1st 2) July 10th 3) August 5th I want the sorting order to show the newest entry first. Such as: 1) August...

Thanks. Both ideas worked!

I'm using Access 2002. How do I disable the F1 - F12 Keys? Thanks

Another Rookie needs help! I'm using Access 2002. I have a MAIN table with 100 records. The field names are "ID", "Name", "Status" The "ID" field contains numbers 1 through 5. Therefore each "Name" has an ID of 1, 2, 3, 4 or 5. Their "Status" is either Customer or Non Customer. Through a...

Another Rookie Question... My forms are built from the tables. 1) My mian form is "Companies" with 2 subforms 2) One subform is "Equipment" Single Form View 3) The other subform is "Financial" Single Form View "Equipment" is related to the "Company" by DunsNumber "Financial" is related to the...

I don't know if this is a Form or Query question, maybe neither? a) My database had 7,000 records. b) Performance was acceptable when I used a form to review/edit records. The form source is a Query. c) I added 80,000 records. e) The performance dramactically decreased. It now takes 4...