Howdy,
Need some help on this one.... need to get access to count the number of records have a value of "Completed" in field1 and repeat on with other values...
Marks
Last Activity: Jul 23 '08, 04:59 PM
Joined: Dec 18 '07
Location:
-
Access Reports count();
-
One Record displayed at a time... basically when viewing a record in the "customers table" there is a section which will try and find a business plan "business plan" table via the Customer Name....
if that makes sense.... -
Help on something else....
Hello...
Was wondering what the best way to do this is.
I have a form which display's numerous records.... somewhere on that form i want some sort of query which will search and output either
"There is a entry with this company name in table 2 would you like to view this record in table 2?" otherwise
"There is no entry for this company in table 2 would you like to create this record... -
Thanks Carl,
However wouldn't this still show still as a Report?
Cheers...Leave a comment:
-
Hide Checkbox if textbox is null
Hi There,
Need some help, on Access Reports if the text box is null is there a code which will hide the checkbox? -
I've generated this code and used a Query to help filter through 2 combo boxes.If I want to insert a "All" option which would display All in the combobox? Is there a way i can load the query which does the filtering if the dropdown value is now all or remove the query if the value is all.
Cheers.Leave a comment:
-
Many Thanks for your help.Leave a comment:
-
Access Forms - Large Text Boxes
Need some help here, is there any way when you press return in large text boxes that it inserts a new paragraph/line, for some reason it tends just to go to the previous text box.
I would prefer not to keep pressing ctrl and enter everytime.
Many Thanks! -
Finally got there in the end =)Leave a comment:
-
Cheers for that. I've got 2 drop down's to do filters however how do I get it to link to go to that specific record?
Cheers.Leave a comment:
-
Help with Filters
Ok Guys,
Was hoping if you could help me. I want to create a drop down filter in Access Forms.
This names and fields are just examples.
I basically want drop down menu 1 to show the field name "city" for all the records in that table. This will filter drop down menu 2 to show all customers who are based in the city that drop down menu 1 shows. Drop down menu 2 can then open up the record... -
Found solution to this just had to modify the code a littleLeave a comment:
-
Here's my code how would I go about changing it?
...Code:rnd.today=new Date(); rnd.seed=rnd.today.getTime(); function rnd() { rnd.seed = (rnd.seed*9301+49297) % 233280; return rnd.seed/(233280.0); }; function rand(number) { var result = Math.ceil(rnd()*number); if (!result)result++; return result }; var ad_cnt2 = 3;Leave a comment:
-
REF: e-mail Current Form Record as a Report
I've deleted the code because it was just being way to messy so if anyone has a code from scratch that would be fantastic :)Leave a comment:
-
How about another way for it to work with XHTML? =)Leave a comment:
-
document.write alternatives
I have a Javascript code which is in a .js file, I'm aware that document.write doesn't work with XHTML/Firefox however does in I.E
Is there an alternative that does work? -
Formatting Text under different values.
Still playing around with Access.
Is there a way to format in my case changing the colour of a piece of text in Form/Report View under different values. A random example would be "Access Denied" would show in Red and "Access Granted" would be in Green.
Thanks and Merry XMas to All! -
Thanks Nathan, I stuck it it as onEnter instead of a Command Button and it works like a charm :) Many thanks and Merry Christmas :D...Leave a comment:
-
e-mail Current Form Record as a Report & Menu Solutions
Right I'm don't feel so nervous tackling VB as much now but basic stuff I'm great with so the next part of my script is:
1. Having a Front Menu. When you enter the number 1 in a textfield it selects formA, number 2 selects formB etc how would I do this?
2. E-mail Current Form Record. I found a similar thread to this but I used its code and it didn't work anyone got any ideas, I've managed to create one for Printing but... -
Thanks worked like a charm. Just preparing for the next part of my script :)Leave a comment:
No activity results to display
Leave a comment: