Search results

All, I've got a Continuous form that has all the fields Enabled = No and Locked = Yes. I'm attempting to make this form "itunes like" in the sense that any row can be double clicked and that row will take the focus and also open another form. I tried using a transparent rectangle as a "hot...

Bob, I think that was what I was looking for. Now would I have any issues using this for the call: Call SetQDF(MonthName(Month(Date()),True))

Unless I'm completely missing the big picture, the 12 arguments ending with "_ACC" are all columns in my tabular data that I need numbers from depending on the current month. My current problem is that the following creates a string and doesn't simply use the argument that is passed into the...

Right now, the following is what I have. Public Function RemMonth(Month_REQ As Variant, Qtr_REQ As Variant, SemiAnnual_REQ As Variant, Jan_ACC As Variant, Feb_ACC As Variant, Mar_ACC As Variant, Apr_ACC As Variant, May_ACC As Variant, Jun_ACC As Variant, Jul_ACC As Variant, Aug_ACC As...

Thanks for the info thus far. The issue I'm running into is that the data that is given to me is in a text file, and unfortunately has 12 columns names Jan_ACC through Dec_ACC and I can't do anything really to change that. So what I'm really trying to do is somehow determine which column of...

Awesome. Thanks for that info.

Can an argument for a function start with a number? Every time I try it i get a Compile Error, Expected: identifier. Any work arounds for this?

All, I have a function that pulls in 12 arguments named Jan_ACC through Dec_ACC as variants. I want my VBA to be able to build and reference the argument in an If/Else statement. Basically I want to be able to reference the argument by doing something similar to below: MonthName(Month(Date)...

All, I've got the following IIF monster in a field in a select query. Can someone give me some advice on how to make this more manageable? I'm hoping to convert it to VBA as it's just a monster to try and manage or make changes to this. I'd like to convert this to VBA and then reference the...

I am looking for suggestions on how to accomplish this: Brief Overview: The database allows me to assign x number of people to a task. The task is built specifying a certain number of people with special qualifications. I then have a list of all our personnel with a column dealing with...

All, I have a block on a report that I want to essentially contain some conditional formatting (will probably require VBA, but would like to keep it to a minimum). The stumbling block is how to go about generating the query and the content of this block. This database essentially tracks...

Use result of Expression to retrieve Value of a Field name(Generated by Expression) All, I've got an expression that identifies which column I want to reference in a query. I have field names called Jan_ACC, Feb_ACC, Mar_ACC, etc. I then have an expression that determines which month it is...

Amazing as always. Thanks for the help. The finished product for the archives: GeneratedDue: IIf(DatePart("q",[ACC_DT])<3, CDate("6/30/" & Year([ACC_DT])), CDate("12/31/"& Year([ACC_DT])))

No I feel like I should say "Here's my Sign". I really do love to make things harder for myself than I need to sometimes. So I guess the following should work: IIf(DatePart("q",[ACC_DATE])<3, "6/30/" & DatePart("yyyy", [ACC_DATE]), "12/31/"& DatePart("yyyy", [ACC_DATE])) But is there a...

All, I'm trying to create an expression that evaluates the date in the ACC_DATE field and then displays the last day of either the 2nd or 4th quarter of the year based on whether or not the date in ACC_DATE is in the 1st or 2nd quarter (Would display last day in 2nd quarter) or 3rd or 4th...

Alright. Thanks for that help. I ended up using 3 Or Statements. If anyone has a better solution please let me know. <6 And <>2 >6 And <>2 =6 And [Fixed_ACC_DT] Is Not Null I can't say I'm 100% positive why this works ... but it seems that it does.

The other piece to it is that some of the other records with a SectionID of 5 as an example needs to have records included if the Fixed_ACC_DT Is Null

Well that generates 109 records and my "=6 And [Fixed_ACC_DT] Is Null" statement only generates 14 records and with no criteria at all I get 143 records. I'm thinking I might have found the culprit. Maybe not. I've got a second set of records I need to exclude as well (Anything with a...

I have a large query that I'm attempting to narrow down the results based on the SectionID and a IsNull. I've got this in the Query criteria that shows me all of the records I want to exclude from the query. How do I include all of the other records and exclude these? =6 And [Fixed_ACC_DT]...

I've got a Select Query that looks like: SELECT IIf(IsNull([ARMS_Due_DT]) And [SemiAnnual_REQ]>0,"Yes",Null) AS GeneratedDue, IIf(DatePart("q",Date())>2,[ITS_Current_Events_Fixed]![2SemiAnnual_ACC],[ITS_Current_Events_Fixed]![1SemiAnnual_ACC]) AS Accomplished...