Search results

Re: zip code formatting - more info i attached a picture of data. Rus

i have zips that 12345- and 12345-1234 The problem is the dash is on the field of the 5 digit zips. So the shortest zip is 6 characters. When putting the data on reports we do not want the dash to show on the 5 digit zips. But do want it do show on the 9 digit zips. I am not sure how to...

Thx for the help I ended up with this: initial= left(fname,1) & mid(fname,instr(1,fname &" "," ")+1,1)

I have names in one field and I want it to be initials in a new field. Can someone gave me a push. Field Name = Tom Smith Field Initials = TS I have Name. So, I am thinking it would be: In the query it would be a new field Initials: ???? Some Function or Iff statements... THX...

Trevor - Thanks a million! I think i am up and going. At least the Word document is popping up with some of the fields getting loaded. It was a bit tricky getting the MS Word object to load - you need to do it in the right place. Which is like in the Visual Basic screen Tools not the main...

Opps - sorry. I will try again. file size

Re: Passing variables to a Word Doc. - not yet attached is the errror

Thx I will give a try and let you know how it goes. Russ

I am trying for the 1st time to pass Access variables to a Word document. I used this as a starting point http://support.microsoft.com/kb/260410 It seem fairly straight forward. I made a little db with one table - one record - and I am attempting to have it pass the data and open a Word...

Access 2003. The form as the source of a query with one table going into it. There are a few fields from another DB being displayed at the top of the form. I am using DLookup to get them. You can see the DLookup pulls in the data very slowly. I am thinking changing to an elookup based on...

Re: tried that and if fail to let me update tbl DB1 The form asks for a data source. If I use a query with the a table in DB1 linked to a table in DB2 as the source, then I am unable to update the fields in the table in DB1. Access blocks the updates. Russ

I have to pull a few fields from another DB (DB2) on to some screens where i am updating the data pulled for the display of data on a screen. I do it with a query joining the data from the other DB (DB2) with the table from the DB i am updating (DB1), the update process will not work. I...

Your example did the year alone. How much more difficult would it be to load the month and day. I would like to see: 00/00/2010 when the user goes to the field so they just enter the month and day and keep going. The set of forms has about dozen dates that will be updated for approx. 1,500...

Re: Confused on implementation Would I put this in the default value somehow for the table field or would this be on the properties of the form field? " =Now() function and then use the =Year formula " Russ

Re: default loading the year on a date form - more info needed Thank you for the code i need instructions on how to install it. I tried cut pasting it onto the default value line and it failed. A screen print of it is attached. Thank you Russ

Is the an way I could default the year on my forms. I tried the attach screen print without success. Thx Russ

Good .. wow - I was surprised the command crossed DB-s. I would think usually you want to only impact the DB you are working on. Not every DB the person opens. Thank you for your help and follow-up. Russ

I am slightly confused. When I did my code to hide the tool bars, it was effecting not just the one Database. But all the databases I open. Does this sound right? Thx Russ

Re: How to un-hide- They are back Yippe!! It was a little tricky. I am worried about turning them off. That it will effect more than just the one DB. It will effect the person's PC for all DBs. I will probably just use the max screen option and stay away from turning off the menu tool...

In making my switchboard and display screen ready for the user I hid the top menu and tool bars, with the important drop-down of compact and repair. I cannot get them back? I read this posting "Hide all Access Toolbars and Menubars"...