... Have you checked your page margins (and possibly the paper size for the selected printer)? If you are printing on standard 8.5x11 and your left + right...
Why do you want to change the file extension? John Viescas, author "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for...
David- Boy, black pages must be using up a lot of ink! <s> Seriously, have you checked the report margins? With the report open in Design view, choose Page...
Neeta- You can get "too complex" sometimes when you add a filter (WhereCondition) in the OpenReport that the report can't handle - such as a filter on a field ...
Between the two of you, I figured it out. David aka dvdtolson ... open in ... left ... there ... if the ... but I think ... inches wide ... the engine ... no ...
Tracy- Neither. You should not store any calculated value. You can create an expression in any query you build on the table to display the value and use it...
Hi all, I have a form used to edit existing records. The desired record is selected using a combo box. Problem: in the midst of editing, if the scroll wheel...
Hey folks- I've an problem properly formatting LF/CRs in an 2000 access db linked to SQL Server 2000. The problem is that on the form they display as those...
Thanks a lot John One other thing that has been a challenge is I have a date input mask as 99-99-0000;0;_ (which keeps my dates as 01-01-2004 for example). ...
Hello all, I am completely baffled by ADO at the moment. I can do things so easily with DAO now and I am pulling my hair out trying to make the transition to...
Dear all, Is there any function to substitue Vlookup function(in Microsoft Excel) in Access? Following are the examples of my tables: Table A: ...
Diory Paulus Damanik
DioryPD@...
Nov 1, 2004 3:15 pm
20357
Rick - Here is a link to the fix you want: http://www.lebans.com/mousewheelonoff.htm By the way, this link is in our Links section. Bill Mosca Founder ... is ...
Tracy Don't worry about how the date appears. There are several formats for dates, but the real value is a number no matter what you see. Bill Mosca Founder ...
Thanks Bill. The reason I was concerned was the end users dont want to enter the date in this way in the form but instead the way they are used to. Thanks so...
Rick- You need Stephen Leban's MouseHook solution: http://www.lebans.com/mousewheelonoff.htm John Viescas, author "Microsoft Office Access 2003 Inside Out" ...
Don't beat yourself up over ADO. There are some thngs that just work better in DAO. Your example is one of them. Since a form's recordset is always a DAO...
Eric- If you use vbCrLf (Chr(13) & Chr(10)), the Cr part can generate the funky boxes. If you're setting data in the field from code, use just vbLf. If the...
Tracy- How you display the data has nothing to do with what is actually stored. Both JET (mdb) and SQL Server internally store a date/time value as a double -...
Amy- rst.Open strRecordsetSQL, CurrentProject.Connection But that's the hard way. You're passing the form object, so why not just get a copy of the form's...
The reason why this is so tough is because you do not have a normalized set of tables. That start and end column is killing you. What you need is a security...
Oh, CurrentPROJECT! Thanks, John. I knew there was a way. I like your simplified method of determining the recordset as well. I think I tried that when I...
I have a database where I have 6 different tables that use the same type of filter process. Hospital Directory (1), Physicians Directory (2), Hospitals in...
I have a database where I have 6 different tables that use the same type of filter process. Hospital Directory (1), Physicians Directory (2), Hospitals in...
Kevin- Trying to use a binary map isn't a bad idea, but you'll end up processing a ga-zillion combinations. You started out OK, but then your logic falls ...
The person to whom I am sending file on email is not able to open up the file as .mdb doesnt open due to security reasons in the company. Can we change the...
The best solution is to either zip the file before you e-mail it, or temporarily rename the extension and then instruct the recipient to rename it back. I...
Tarun- The usual solution is to put the mdb inside a Zip file and email that. If he's using Microsoft Outlook, Outlook will block .mdb files but not .zip ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
