Recent content by octatyan

Paul, thanks for the response. This works, except I had to use GETDATE instead of DATE. When I tried to use DATE it gave me an error saying that it's not a correct function. :confused: I'm using SQL in Access 2002. Just wondering where the mix up is?

Bob, Paul, thanks for the help. Your first responses were perfect. But if you're tired of "catching the fish for people" then all you have to do is just stop. Or just point people in the right direction. Which is exactly what you did in your first post Bob. So looks like your gripe is...

Hi all, I need help in writing an Access SQL query that selects today's MONTH and shows all records that have fall on or between todays month and the past 12 months. The records have dates in the format of mmddyyyy. I'm stuck and can't find anything on the internet. I probably I just need...

Hi, I'm not very good with Access so here's another (probably easy) question: I want to create a report that asks you to choose a MONTH and YEAR. Here's my SQL in the query: WHERE (EnteredDate = @Enter_month_year) When I open up the report, it asks "Enter_month_year". So if I type in...

Hi, I have a parameter query that asks for a "start date and end date". All records within that date (ie 1/1/03-1/1/04) will show up on the report. How do I get the choosen start and end date to show up at the top of the report on the first page?

a simple question When users enter a new record and click the SAVE button, I want access to only save if lastname has been entered. What is the code to check is the lastname field has any info in it? *** i solved my 2nd question, so I only have 1 question now.

Yay, that works. Sorry for my lame questions, but I don't have any good sources for proper syntax. 2 questions though... 1. When I do this, I would like the "amendment number" field to be unchangeable by the user. Previously I unenabled and locked that field, but i had to enable and unlock...

ok, i've tried the dmax function but cant seem to get it to work. This is the code i'm using in the VBA section: EmpSalary = dmax (SalaryAmendmentNum, tblSalaryAmendments) where: - EmpSalary is the field name in the form - SalaryAmendmentNum is the set of records in the table -...

I'm not sure if this topic has been posted yet, and I couldn't find any on this forum. Here's my situation. I have a form that displays information about employee salaries. When an employee gets a raise we enter this info into this form. so if an employee recieves his first raise the...

I have a label that appears when the mouse cursor moves over a button by adding code to the On Mouse Move property. How do I make that label disappear when the mouse cursor moves off the button?

I tried this and it's not working for me. Am I doing something wrong here? I have a main form and a subform. After entering a new record and clicking the SAVE button, I want the subform to requery. I inserted the code in the VBA section underneath where the SAVE button code is. I keep...

I have a problem with sorting. My form displays memos one at a time. Each Memo has unique # which uses the following forumula : IS(yr)-1285-(memo #) ex. IS98-1285-001 IS98-1285-002 IS98-1285-003 I have memos from 97 to today. The memos are all sorted by the above unique #...

ok, but now what if i have 10 text boxes on that form? How would I go about accomplishing the desired task now?

Hi, I have a form that 1 budget record at a time (budget for marketing, HR, payroll, etc...). Each budget can be amended (ie add more money to the budget). Each amendment is given a code such as mktg1 (for marketing budgets first amendment), mktg2, mktg3, etc... I would like the form to show...

Hi, I have a form that displays a person's name and their account balance. But not all people have an account (so their balance is null). How do I make the text field so a zero if the data is a null value? I guess I would need to insert some vb code??? but how would I write the code and...