Hi John, Can I use DCOUNT for this on my form? I've created a text box on my form with the following ControlSOurce: =DCount("[Skidid]","SHIPPINGDETAIL","[SO#]...
Mike- If you fix the syntax, that should give you a total count, but it won't number each row. Is SkidID unique? If so, you might be able to generate the...
Yes, Skidid is unique. I've actually decided to just have a text box on the form that displays the count of skidid's related to the SO# entered on the form....
Mike- Easy to do if you make the subform a Continuous Form view. You can line up the controls to look like a datasheet if that's what you prefer. Open up the...
Thanks John, I will give that a try tonight :) ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com] On Behalf Of John Viescas Sent: Tuesday,...
Hi john, Your query is working fine in ms-access, but if you use the same query in VB6.0 programming is returning few records compared to that of ms-access. In...
Mahesh- Are you using ADO from VB6? If so, you need to change the wildcard: SELECT * FROM T1 WHERE F2 LIKE "45,%" OR F2 LIKE "%,45,%" OR F2 LIKE "%,45" OR F2...
Hi John, As usual, works perfectly! Thanks so much :) ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com] On Behalf Of John Viescas Sent:...
Yeah.. thank you John. Yes Iam using ADO2.5 and as per your suggestion I have changed the wildcard char to %, and Its really working. Thank you very much. ...
hellooo............ I am trying to develop an employee information system wich saves the info about the employee and his family that have a medical care Can...
Hi, I am a librarian, and I have a database that someone else has programming in 1997 by using MS Access '97. It has 7 tables. Three of them are the point of...
Mahesh- Yes. ADO accepts ANSI-Standard SQL. Access uses the old DOS * and ? wildcards, but the ANSI wildcards for LIKE are % and _ -- the same as SQL ...
Do you mean that the report is blank when you open it in Print Preview? If so, then the query must be filtered in some way so that it returns no rows. What...
I'm having an issue with VBA not running properly and simply hanging for some reason on a delivered product. I've created an application that is working just...
I have a form which calculates a labor cost(laborcost) and adds a hardware cost(HWCost) to generate the total amount due(Cost). The values to calculate...
Chad- It's generally not a good idea to store calculated values in a table. If one of the variables in the calculations changes later, the stored value will...
That worked....now for one more question...I need to separate flights out by time every quarter of any hour. 07:00 07:15 07:30 07:45 08:00 I have a field...
P.S. Thank you for the first reply...how rude of me not to say so. dave ... From: ms_access@yahoogroups.com on behalf of Dave Moreau Sent: Sat 11/5/2005 5:10...
Dave- Take a look at the Partition function to segment your data by 15 minute intervals. John Viescas, author "Building Microsoft Access Applications" ...
I am trying to make a database simple for other users, I have the switchboard set up nicely with full screen, but the user can click minimize and see the...
Carl- Set Control Box to No and Close Button to No. You can get rid of the Menu Bar by setting the Menu Bar property to =1. To hide the toolbar, execute: ...
Will do. Thanks. ... From: ms_access@yahoogroups.com on behalf of John Viescas Sent: Sun 11/6/2005 8:11 AM To: ms_access@yahoogroups.com Cc: Subject: RE: RE:...
Hello Experts, I have this membership database i am working on which has an option of active/expired field in it i use that field to filter the active memebrs...
I would guess that you defined member types as a lookup, but the data type is a number. If the lookup is to another table, simply include that table in your...
John, Thanks that does the trick, one more I still have that pesky minimize box in the upper left corner can that go away too?? thanks for your help Carl ... ...
Carl- Set Min Max Buttons to None. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft...
John, Had that set to none,,, also tried to use Max only but the min box (box box thing )appears no matter what,, Maybe it is because I force full screen for...
Thanks John for a quick reply, yuo are almost right data type is set as text. In the main properties of my report i have this command which sees only active...
I see MemberType is text, but in the one sample row, you have the number 1 in that field. If 1 = Yearly Member, then change MemberType to Number, Long ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
