Search results for query: *

Can someone please tell me what I'm doing wrong? I'm getting "Object Variable or With Block Variable not set" Thanks!! Dim db As Database Dim rs As DAO.Recordset Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem Set db = CurrentDb Set rs =...

Hello group! I have created a query that allows me to calculate how long it takes for me receive payments from my suppliers (via a crosstab query). Now I want to use the following w/o hardcoding the 7/31/2007. How do I make the year a variable without using the DateSerial() function? Take a...

Does anyone know if this can be done? Just one of those little light-bulbs going off over here? Thanks!

Okay: Lets say that I have a contact record stored in a table called "tblContact" and the field names are as follows: Last Name First Name Title Categories This record can have multiple categories assigned to it such as: Cat1 Cat2 Cat3 Cat4 My question is, what is the best way to store this...

Group: How would I disable a command button based on what page I'm on within a tab control? I have a series of cmd buttons across the bottom of the form (below the tab control). Which event would I use on the Tab Control? Thanks!

Group: I have an A/R database that has a front end (5) users and one back end on a local server. I have created MDE's and placed one on each users machine. I have disabled the f11 key and prevented my users from gaining access to the Access container on their desktops. One additional point...

Group: I have a table that has two fields 1. Field Name "Factor" which can either have "$" or "%" 2. Field Name "Value" which is a Data Type = Double I have a form that the user 1st selects the "$" or "%". Based on the selection in the cmboFactor, I want the "Value text box" to be masked...

Group: How do I sequentially number my rows in a query used on a continuous form? I’d Like some thing like the Row() Function used in Excel? End result would be 1,2,3,4, ect. Regards! Itch

Group: I have a form that has a text box that has the year. I want to pass it as a variable into the following: Me!txtFileAvg = DateDiff("d", #1/30/2007#, [txtFileDate]) How do I do this? This is on the after update event of a check-box. Thanks! Itch

Hi Group: I know their is an easy answer to this but I can't seem to figure this out. Main Form Name = "frmPostVoucher Sub Form Name = "frmPostVoucherSubPrint" **I want to test if there are no records or null **I can sucessfully test if there is more than 1 record **I have tried the...

Hi Group: I have a custom function that I want to call from a query that will convert a short date to the following "2006 - 01". The code below is used to open a fiscal calandar within a static table called tblCalandar. Based on the accounting calandar, it will sort to the current fiscal...

Hi all! I have an accounting application where I want to produce a a query that feeds a report where I can show total receipts by month comparing year and month this year versus last year. When I run the query, I want to break the date down to two different fields Year "2005" and "Jan". I...

Hi group: A really dumb question here. I know that I can place my cursor over a function and click. At this point, what is the keystroke needed to automatically go to the fuction called?

Hi Group: I'm trying to enable/disable a command button called cmdSelect in a subform. I'm getting object doesn't suport this property or method. Any ideas? If [txtCurrentPeriod] <> [txtPeriodHeader] Then Me!lblUnlock.Visible = False Me!lblLocked.Visible =...

Hi Group! "I've been standing too close to a tree to see the forest" Here is what I’ve got. I’m building an A/R application and I have a form that does not have a Header/Footer. The top half of the form has been designed to show payment header information. The usual stuff is in this area...

Hi Group: I'd like to highlight the current controls label on the got focus event without putting code into each controls got focus event. Any ideas?? I'm currently using the following for the data input fields but I don't think this logic will apply to labels Dim ctl2 As Control...

Hi Group: I've got an Access 2000 application that I'm building and everytime I turn around the db is corrupt. It seems to be happening when I copy and paste onto my thumb drive to bring home. At work, I'm developing on an 2000 version, when I get home I'm on an XP version. I've been carful...

Hi group: I've got a little problem below. As I'm not very strong in ADO, can someone please point out my mistake! I'm trying to run this SQL statement and post the result into a bound fieled on a form. When I run this code, I get "Method "open of Object" Recordset failed. Private Sub...

Hi group! It's been quite some time since I've seriously dabbled with programming in Access. At one time, I did a lot of programming in Access 97 and I became reasonably familiar with DAO during that time (enough to get by.) Now a few years later and a new job (department manager . ...

Hi Group! I could use a little help here. I'm trying to attach an Access 2000 Database to Outlook. I would normally use the File/Get External Data/ Link feature within Access. When I do this, I'm able to go to the public folder and link to it. However, when I do this, I'm not able to get...