Recent content by EnforcerPSU7

This problem is driving me insane. I have ONE user who can no longer connect to the exchange server. Outlook 2003 simply keeps saying "Trying to connect". Sometimes it will connect for a split second then again say "Trying to Connect". I have tried her profile on a different computer and it...

IN case anyone checks here, I found that even though the numbers in excel were defined as "text", visio imports them as Number. You have to deine the custom property of each field you want to be text as string, even if it WAS text in excel.

Hello, When I imported some information from excel it changed the format of one of my fields to "number". I want it to be string so it wont truncate 0s. I am building an org chart. It seems I can only change the definition of each custom property on each shape individually!! This will take...

Hello all, maybe someone has the solution to my problem. I am creating an org chart in visio. The wizard builds everything correctly but my employee numbers are always missing their leading 0. I need this 0 to appear. Example: In the source spread sheet the number is: 034567. BUT in visio...

One more Error: All my position numbers which are 6 digits long only show up as 5 digits when I build using the wizard. If I add choose a record manually the position number shows as the full 6. Why is it removing the last digit when I build using the wizard?

I am using the wizard to create an org chart from an SQL server view. I choose Last Name, Reports To, and First Name. Everything goes fine, with one small problem. There are 2 people with the same last names in my query, and I get an error when I try to create the org chart. it says...

This is my open criteria, but it returns all records. What is wrong with it?? DoCmd.OpenReport "Review", acViewPreview, , Forms!GetOrg!Org And Forms!GetOrg!txtOrgDate

Hello, I am working in a database where the user insists on having a drop down menu for our ORG numbers and an text box for the date. I have created a form that allows the user to choose from a drop down menu an ORG number and allows them to input a date. I would like to bring up the report...

Wait, NVM. I got it, I just edited the print area. My bad. Thanks a lot!

Good ideas guys, I am trying the group command now and it seems to be working just fine. SkipVought, you are right...I know the table is non-normalized. BUt I didn't make it and now I have to deal with it. :( Anyway, GlennUK...i was playing with the group command but when I look at the print...

UPDATE: The most important column is the last column. She would like to make all the other columns disappear except the last date column. This wouldn't be bad if it was a static # of columns, but if she makes a new date column every 2 weeks how do I suppress all the columns except the last one?

Hello, I am new here, but my teacher who posts on these forums a lot recommended this place :) I have a spread sheet that contains the columns: ClassCode, LastName, FirstName, MI, 1/24/2003, 2/7/2003, ...the date columns continue. The user adds a new date column every 2 weeks. She would like...