User Profile

awojciehowski · Apr 23 '09, 10:42 PM

NeoPa-

I am sorry to offend you...it appears that you are quite upset about my last post. I am not well versed in SQL or Access thus the posting for help. I was reviewing the queries that were associated with the form that I posted a screen shot of. I found that the "Print Current Form" had a seperate query and that is what I posted since the error as described above occurred when I clicked on the "Print Current Record"...

awojciehowski · Apr 23 '09, 10:17 PM

Maybe this will help...I have multiple queries working on this form.

Code:

SELECT [Add New Inventory Entry and Inventory Details].LedgerNumber, [Add New Inventory Entry and Inventory Details].SPDCaseNumber, [Add New Inventory Entry and Inventory Details].OfficerID, [Add New Inventory Entry and Inventory Details].ReceivedDate, [Add New Inventory Entry and Inventory Details].Location, Entrys.Comment, [Add New Inventory Entry and Inventory Details].ItemNumber,

...

awojciehowski · Apr 23 '09, 09:29 PM

NeoPa-

I copied and pasted what you suggested into my query...now when I view the record it still is not sorted correctly and when I click on a button to print the current record is comes up with an missing parameter value of "Entry Details.Evidenc e Name".

I am attaching a screen shot for you to understand what I am looking at.

...

awojciehowski · Apr 23 '09, 06:14 PM

It would be the Item Number field that I would want to be organized as A, B, C then AA, BB, CC then AAA, BBB, CCC and so on.

awojciehowski · Apr 23 '09, 03:36 AM

Thanks for the explanation...h ere is the SQL info that I was able to recover:

Code:

SELECT   Entrys.SPDCaseNumber,
         Entrys.Location,
         Entrys.LedgerNumber,
         Entrys.OfficerID,
         Entrys.ReceivedDate,
         Entrys.[EvidenceDisposed?],
         Entrys.EvidenceTypeID,
         [Entry Details].LedgerID,
         [Entry Details].EvidenceName,
         [Entry

...

awojciehowski · Apr 10 '09, 06:07 AM

FishVal-

I appreciate the help but this does me no good. I have no idea what you are trying to explain, even though I have read through it a few times. I attempted to modify my query with sort example but all I got was a bunch of errors.

Anyone else wanna take a stab at helping out?

Thanks
Adam

awojciehowski · Apr 9 '09, 08:21 AM

Sorry, I am working in MS Access and am not that familiar with VB Coding. Could you provide a bit more detail on how to complete your suggestion?

Thanks!

awojciehowski · Apr 9 '09, 02:40 AM

PERFECT!!!

Thanks for your help!

awojciehowski · Apr 9 '09, 02:01 AM

RuralGuy-

Thanks for the script but I am a novice at Access...I am not sure where to place the OnLoad command? I want to click a button from my Switchboard...w here would you recommend me placing the script?

And yes, this would be all the time that the form would open to the last record.

Thanks!

awojciehowski · Apr 15 '08, 08:31 AM

Thanks much for your help...I did look at the Sort/Group option however I found a much easier solution...

In the Properties Sheet I just selected the option of "Hide Duplicates" to Yes instead of the default of No.

Thanks again...

awojciehowski · Feb 25 '08, 05:23 AM

missinglinq-

Thanks so much for your help! What a quick response. I copied your first set of VB code and it worked perfect. I was looking for 90 days, not 3 months so the 90 day date was perfect.

I really appreciate your help!

Adam

awojciehowski · Feb 25 '08, 03:18 AM

I was able to figure out the correct coding:

=DateSerial(Yea r([CaseResolvedDat e]),Month([CaseResolvedDat e]),Day([CaseResolvedDat e])+90)

However, I still need help...when there is no date entered into the CaseResolvedDat e field "#error" is displayed. How can I hide that error message and only allow a date message to be displayed?

awojciehowski · Feb 25 '08, 01:20 AM

Thanks everyone for your help...I chose NeoPa's suggestion on just adding a zero before the numbers. That was the easiest fix...so common sense.

Thanks again!

awojciehowski · Feb 12 '08, 11:43 PM

Thanks everyone for your input. However, after some more research I found my solution in the conditional formatting option.

I chose the "Expression Is" option and then used the following code for the each text box I wanted changed when the specific text box was checked.

[NameofCheckBox]=True

Then all I had to do is choose the background color...

Good to go.

I hope...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Sorting with letters

Leave a comment:

Leave a comment:

Open form to last record

Macro Error 2950

Leave a comment:

DateAdd result to show only once in report

Leave a comment:

Leave a comment:

Auto Calculate and Populate Date Field

Leave a comment:

Specific Sorting Requirements

Leave a comment: