There are a few ways really, and as you work through the reporting features of Access, you'll find that they aren't the best, but using them is fairly easy.
The first thing you should do is to start thinking vertically instead of laterally.
Reports are based on Groupings. For records such as personnel records, you could create maybe 5 or 6 separate groupings of your data. Each grouping would have its own Group heading,...
JConsulting
Joined: Apr 30 '07
Location: Houston
-
Outside the box...
create an unbound textbox or just a box that matches your background and large enough to cover up the Textbox in question. Make IT visible or invisible on top of your Textbox to "hide" it....Leave a comment:
-
You have a corrupt database.
Make a backup before you do anything else.
1) Try using the Compact and Repair option from the Tools menu
2) You can try to decompile your database, it works sometimes.
3) You can open a new empty database, and import all of your objects into it then open your VBA window and compile and save.
J...Leave a comment:
-
look at the docmd.openform help section in Access. You can pass criteria to the opening form telling it what to filter on.
example:
DoCmd.OpenForm "Employees" , , ,"LastName = 'King'"...Leave a comment:
-
have you tried using the report's filter option?
wherecondition = A string expression that's a valid SQL WHERE clause without the word WHERE.Code:DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]
Code:DOCMD.OpenReport stDocName, acPreview,,"[somefield] = " & Forms!FormName!TextBox
Leave a comment:
-
In your command string
DoCmd.OpenForm "frm_DiarySearc hResults", , "qry_DiaryD OL", , acFormReadOnly
remove the "Qry_DiaryD OL". IF that's meant to be the recordsource for the form, then that's not applied correctly. That's where criteria would go. Example
"[myfield] = 0"
Give that a go and hopefully that clears up the mystery.
J...Leave a comment:
-
I'm sure its much better in person :)
I'm looking at your query, seeing as though that's where the problem seems to be stemming from..
SELECT tbl_Claim.Txt_I nsuredName, tbl_Claim.Date_ DOL, tbl_Claim.Mem_P olNo, tbl_Diary.Num_C laimNo, tbl_Diary.Date_ FUpDate, tbl_Diary.Txt_D escription, tbl_Diary.Num_D ocNo, tbl_Diary.Date_ Final, tbl_Diary.Txt_R ecieved
FROM tbl_Diary INNER JOIN tbl_Claim ON tbl_Diary.Num_C laimNo =...Leave a comment:
-
Hi VJ,
I'm kind of having a Blonde Moment reading through this.
We need to know how you're running your query. You mention that you can run it from the query list. That's fine. But you say it doesn't run from the search form.
Do you have it coded? Can you show us that?
sSQL = "Select * from table1 inner join table2.id = table1.id where somefield = '" me.somefield & "';"...Leave a comment:
-
Isn't this more of a Go To Record situation, vs a filter situation? Seeing as how your customer is already selected and all. If I understand this right, you may or may not be on the customer record where the Order Number exists? For the sake of arguement, let's say its not. You would first have to use the Order number and pull the CustomerID foreign key number from it. Then you set your main form's recordsource to that customer. Easy enough. Now...Leave a comment:
-
that's not possible. What you should do though, is put that on a form, and have your user select from the combo box then run the query. The criteria in the query would then change to forms!Yourform! YourCombo
As long as the bound field for the combo box contins the ID number, you're golden.
J...Leave a comment:
-
since this is already VBA, and you apply a filter using some mechanism, why don't you continue to use VBA and capture the filter being applied, and use that as a criteria agains the recordset in a dcount to populate your count field....Leave a comment:
-
Your question isn't really clear. Are there more than one fields that you're counting?
You can try using your form's On_Current event to put a value in your count field
If me.MyTextbox = 'somevalue' Then me.MyFooterText box = 1
also, wouldn't your syntax be a bit different with the IIF function anyway?
=IIf([mytextbox]="Home",1,0)
But again, if you have a single...Leave a comment:
-
Well if you haven't managed to disable the Shift keys, you can hold down the <shift> key when you open your database. You should go back into the Setup and choose your selections a bit more carefully.
<ctrl><shift> M will also bring back your menu so you get get to Tools/Options.
Luck!
JLeave a comment:
-
you can set warnings to false before you run them, then back to true when they are done....but how are you running them now?
Currentdb.Execu te "YourQuery" will do the same without having to deal with warnings, but again, that requires an interface and a click on a button or some other event to launch them.
J...Leave a comment:
-
If its one to one, then put it into the same table....Leave a comment:
-
you said you're using this in a query, how are you using it?
select FunctionName([yourfield]) as something, [field2], [field3]
from sometable
??...Leave a comment:
-
Happy to help. And Thanks for the kudos!
J...Leave a comment:
-
Mine is prettier Dez :o)...Leave a comment:
-
Check your list width. Make it 5"
Make sure autoexpand is set to yes...Leave a comment:
-
Use your proposed statement in the On_Format event of the report for the appropriate section.
[code=vb]
me.mytextbox = nz(DCount("[Status]","ROA_Imaging_ QueWeb_LINKED_Q uery","[Status] Like 'Closed' "),0)
[/code]
J...Leave a comment:
No activity results to display
Leave a comment: