Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 28
Search took 0.00 seconds.
Search: Posts Made By: Padwan
Forum: Reports 02-10-2012, 07:40 AM
Replies: 6
Views: 7,016
Posted By Padwan
Re: Hiding page header and footer on a specific page

@vbaInet No I want it to be on all pages except for the fourth I want nothing on it and i want the header not to appaear on the first page of each records report . and @boblarson I will move it to...
Forum: Reports 02-07-2012, 04:28 AM
Replies: 6
Views: 7,016
Posted By Padwan
Question Hiding page header and footer on a specific page

Hi I am ran into a snag on one my of reports. I have a batch report packet by record that I do on a daily basis. The problem I have is one of the reports in the packet will not print dual sided...
Forum: Reports 02-01-2012, 05:17 AM
Replies: 17
Views: 983
Posted By Padwan
Re: Lettering grouped records in a report

Thanks that did the trick! :D
Forum: Modules & VBA 01-31-2012, 07:51 PM
Replies: 7
Views: 2,304
Posted By Padwan
Re: Opening Query after combobox selection

This may be off, but isn't it possible to create combo box with query titles listed in it to select rather than writing code?
Forum: Reports 01-31-2012, 05:31 PM
Replies: 17
Views: 983
Posted By Padwan
Re: Lettering grouped records in a report

Done and it worked. Uploading new copy as well. Now to figure out how to get it to display aa, bb, cc, after the letter z then this young access Jedi will be happy. How may I proceed next....other...
Forum: Reports 01-31-2012, 08:07 AM
Replies: 17
Views: 983
Posted By Padwan
Re: Lettering grouped records in a report

here is the sample when you launch the report you will get 3 prompts
the first one just type in your name
the second one type in 1
third one type in 3
the last 2 have to do with the page...
Forum: Reports 01-31-2012, 06:40 AM
Replies: 17
Views: 983
Posted By Padwan
Re: Lettering grouped records in a report

working on that now It may be a while though
Forum: Reports 01-31-2012, 06:26 AM
Replies: 17
Views: 983
Posted By Padwan
Re: Lettering grouped records in a report

OK did that. Apparently you have to change its name in the property sheet and not just change the label name. Prompt went away and it sorta works now but once it it passes z it displays other weird...
Forum: Reports 01-31-2012, 06:03 AM
Replies: 17
Views: 983
Posted By Padwan
Re: Lettering grouped records in a report

I do with a contol source of "=1"but when I made the second text box with the =Chr(96 + txtCount) and ran the report it prompts me with a parameter with txtCount as its name and if I don't enter a...
Forum: Reports 01-31-2012, 05:42 AM
Replies: 17
Views: 983
Posted By Padwan
Re: Lettering grouped records in a report

Did that but all I get is a through out the report when i enter 1 in the prompt
Forum: Reports 01-31-2012, 05:16 AM
Replies: 17
Views: 983
Posted By Padwan
Re: Lettering grouped records in a report

Yes,
I need it to reset at the beginning of a each group. If it goes past z then it should start as aa, bb cc dd etc. Each group is going to have 40ish records in it.
Forum: Reports 01-31-2012, 04:59 AM
Replies: 17
Views: 983
Posted By Padwan
Lettering grouped records in a report

Hi,
I am attempting to "letter" records on a grouped report to look like this
a. house
b. car
d. tree
I tried tweaking the numbering version of it but it was a fail. I attempted this and only...
Forum: Macros 01-26-2012, 04:45 AM
Replies: 14
Views: 90,943
Posted By Padwan
Re: Run Yes/No MessageBox from MACRO

Mine uses vba but when you click yes it opens a form and when you click no it just closes. my issue is when it opens the form it opens it in normal view which is cool but I would like it to open in...
Forum: Reports 01-20-2012, 12:23 PM
Replies: 1
Views: 1,732
Posted By Padwan
Re: Grouped Report: Page (n of n) and Page Headers

I don't know if you are checking this thread anymore or have found the same solution
but here is the code i used and i will include the link to where i found it with step by step instructions on...
Forum: Modules & VBA 01-19-2012, 12:49 PM
Replies: 21
Views: 6,347
Posted By Padwan
Re: If and Then statement to return a null or blank field value

WOOOOOOOOOHOOOOO this did it!!!!!!

CLEARED BY NM1: IIf([REMARKS TX]=True,Null,[CLEARED BY NM])

Thanks for ALL your help :)
Forum: Modules & VBA 01-19-2012, 12:41 PM
Replies: 21
Views: 6,347
Posted By Padwan
Forum: Modules & VBA 01-19-2012, 12:38 PM
Replies: 21
Views: 6,347
Posted By Padwan
Re: If and Then statement to return a null or blank field value

it works but I need to display the value in the [CLEARED BY NM] not [REMARKS TX]

CLEARED BY NM1: IIf([REMARKS TX]=Null,Null,[CLEARED BY NM])

Kinda like that. I had to name the expression that ...
Forum: Modules & VBA 01-19-2012, 05:07 AM
Replies: 21
Views: 6,347
Posted By Padwan
Re: If and Then statement to return a null or blank field value

nope it doesn't. I get a blank screen return on my query. This is getting frustrating.
Forum: Modules & VBA 01-19-2012, 05:02 AM
Replies: 21
Views: 6,347
Posted By Padwan
Re: If and Then statement to return a null or blank field value

Thanks, say I do an IIF statement like this

IIf([REMARKS TX]="NotNull","","")

and place it in the criteria portion of the [CLEARED BY NM] column in that query will it work or is "NotNull"...
Forum: Modules & VBA 01-18-2012, 09:10 AM
Replies: 21
Views: 6,347
Posted By Padwan
Re: If and Then statement to return a null or blank field value

Its record source is a query. Now you got me intrigued I am going to dump in the sql of that query under this text. I never touched sql before so your guidance will be needed on this. If you don't...
Forum: Modules & VBA 01-18-2012, 07:24 AM
Replies: 21
Views: 6,347
Posted By Padwan
Re: If and Then statement to return a null or blank field value

ok I got a temporary solution since I can't touch those fields in access with VBA since they are Bound fields I resorted to deleting the data in [CLEARED BY NM] that has data in the [REMARKS TX]...
Forum: Modules & VBA 01-17-2012, 12:15 PM
Replies: 21
Views: 6,347
Posted By Padwan
Re: If and Then statement to return a null or blank field value

So it only works on unbound fields. Ok i will keep trying to rig it but if it doesn't work It was worth a try thanks anyway for your help
Forum: Modules & VBA 01-17-2012, 11:45 AM
Replies: 21
Views: 6,347
Posted By Padwan
Re: If and Then statement to return a null or blank field value

Nope the fields value is still there and the actual field I wanted to change is [CLEARED BY NM] my mistake. The code runs with no compile error but nothing happens. I feel we are getting closer...
Forum: Modules & VBA 01-17-2012, 11:36 AM
Replies: 21
Views: 6,347
Posted By Padwan
Re: If and Then statement to return a null or blank field value

thanks I will give it a shot. i actually want it to display it as an empty field though :)
Forum: Modules & VBA 01-17-2012, 10:54 AM
Replies: 21
Views: 6,347
Posted By Padwan
Re: If and Then statement to return a null or blank field value

here is the revised code it runs with now errors but nothing happens
Private Sub Report_Load()
Dim AnyText As String
If [REMARKS TX] = "AnyText" Then
[IWC WC NM1] = Null
End If
End Sub

It...
Showing results 1 to 25 of 28

 
Forum Jump



All times are GMT -8. The time now is 09:11 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World