Search results

Oh, because as i had it it was actually reading the line as: Eval (""ExportPLA"()")?

Thanks, DJKarl. I changed the red line to: Eval ("strCallSubName(Counter)()") Yet, now i am getting an error box saying 'The Expression you entered has a function name that (the database) can't find. I have the subprocedure defined as follows: Sub ExportPLA() (export code removed to conserve...

I'm attempting to call a subprocedure from within a FOR statement. Which procedure is called depends on which iteration of the loop it's currently on. the chkPLA/PM/CAM are check boxes. If its checked, then it would call the sub procedure related to that category. The Call portion is what is...

I've got a summary form that counts/sums up amounts in several tables to display on a single, printable form. The method I've used for pulling/displaying this information is via 90 text boxes, each one using DSum and DCount. Here's an example of one of the text box values...

Thanks both of you, that does it! The Balance field has an associated sign field because thats the way we receive it. Its a daily extract we get from IT and thats just how they decided to do it :D

I'm attempting to do a complex DSum calculation to be used on a summary form. What i'm attempting to do is Sum the balance field of an existing table, however the balance has a sign indicator field (Cur-Bal-S) which is a text field that is either null or "-" for negative. Naturally, the...

thanks for the further explanation, it does make sense now. I will be chceking tomorrow to see which results both sets exclude, thanks for pointing out they were doing two different things

I changed it to: IIf([Net Principal Balance]=0,"No",IIf([System]="CL",IIf([Import - Daily CL Raw]![Non-Accr-Flag]="Y","NonAccrual",IIf([Import - Daily CL Raw]![Non-Accr-Flag]="N","No")),IIf([System]="MSP",IIf([Import - Daily MSP Raw]![Accrual Status]=2,"NonAccrual",IIf([Import - Daily MSP...

I'm sure there's something simple that I'm overlooking in this, but I'm getting Null values when the query runs. IIf([Net Principal Balance]=0,"No",IIf([System]="CL",IIf([Import - Daily CL Raw]![Non-Accr-Flag]="Y","NonAccrual",IIf([Import - Daily CL...

Thanks, great reply! What about certifications or education? Are there any that any self respecting DB admin should pursue?

Robert, Here is one solution I came up with, this is my FIRST time helping someone in this community so pardon any response faux pas :) ... Create a table (in this example named 'ReportDate') with fields 'CurrentMonth' and 'PreviousMonth'. You can create a Subreport within your Report and...

Hi Robert, I'm working on this right now, i'll have something for you soon. Sorry i couldnt reply last night, our internet was down at the house. Guy

Hey Guys, Looking for a bit of advice from some of you old hands. I've been working with access for about a year now and have come to a great working knowledge including programming functions with VBA, integrating advanced techniques into my database far beyond what I ever though i'd be capable...

Try to be a bit more clear in your question... Are you using the word 'Report' in a specific Access-related sense or as just a set of data you'll present to someone (using an export to excel, etc). Specifically what date context and format are you looking for (time & date report is run...

YES!! Exactly what i envisioned. Thanks so much! Now to replicate in my db! :)

Reposting this here to maybe better suit the question to proper forum, since this involves more vba than form. Hope this isnt a faux pas! I've got a daily process VBA code that runs several commands, queries, and macros every morning. I'd like to have a form that pops up when it runs to show...

I've got a daily process VBA code that runs several commands, queries, and macros every morning. I'd like to have a form that pops up when it runs to show the status of the process. This is important for me to show if it doesnt complete, that the user would be able to see the last process...

I think i found a solution, Here it is in case anyone is curious: SELECT [Daily Report Data Pool].[Account-Number], [Daily Report Data Pool].[Date of Data] AS Date1, [Daily Report Data Pool].[Non-Accr-Flag] AS NA1, [Daily Report Data Pool_1].[Date of Data] AS Date2, [Daily Report Data...

The individual record doesnt actually change, but new information is appended daily, for instance you'd have 3 days of data Acct# AccrualStatus Date 123456 N 20101028 123456 Y 20101027 123456 N 20101026 User needs to...

I'm trying to fulfill a user's request to track a particular field. In this situation, a cumulative dailiy log table is appended to every day along and includes a datestamp. (i.e. acct#, accrualstatus, otherstuff, datestamp) The accrualstatus is a text field that can only be an 'N' or 'Y'. The...