I have 2 tables that I am putting into 1 query. I have tblCabBank Date - formatted as short date tblManHours month - formatted as mm\/yyyy with an input mask...
What is the data type of tblManHours.month? John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running...
Vishwa- So, the answer you gave me below is wrong. Vish should NOT be selected because you asked for task "Survay" but employee 3333 is competent only in ...
thanks Linda. I tried something like this (see my follow up posting) but it did not work. Wonder what I am missing. ... first ... Lets say ... field I ... name...
It's Date/Time data type. Mandy Jo ... From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas...
Thank you, Beth. I have downloaded and unzipped the file, so you can delete it at your convenience. I'll study it today and may have more questions later -...
I need to distibute the reports I have created internally to folks via email and typically when these reports in the past were created in Word or ppt, they...
Mandy Jo- Your input mask is forcing the user to enter a month and year only. That *should* end up storing the first day of the month, but you'll need to ...
You can send the report in Snapshot format, but your recipients will need the free snapshot viewer downloadable from Microsoft. Or, you can wait for V12 -...
Why wait? Download a free pdf writer and set it up as the default printer. Send the report to the printer and you have a pdf. Regards, Beth M PS Neil Squires...
John, Thank you. It worked great. The only thing I changed was taking out the Date column. Then I got it to sum the Isuzu Cabs Produced for the whole month...
Thank you, John. I have put this into two of the three reports already and it works perfectly. F_Pump also includes the specific input format and a request...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Feb 1, 2006 4:38 pm
33516
I uploaded my _db5.mdb_ (http://f5.grp.yahoofs.com/v1/ANvgQ9GZDugZ5NhXYkOhmxxWv-ELu9KUZz94oQCr34xa-LyND3y4lmFe85sX1EbzL1ynmLrDrLRbSzu0IvAku8BHks3WsnI/db5.mdb) ...
Mandy Jo- I would think you would create an Expression in your Totals query using SUM for all three parts. John Viescas, author "Building Microsoft Access...
Beth Thanks a bunch for taking the time to mark all the problem databases for deletion! Everyone - Please upload any files to the appropriate folder. It will ...
Rene- Looks OK. You might need to turn on Referential Integrity between tblArea and tblPlanting and tblPlant and tblPlanting. You need a Primary Key for ...
Exactement. A term of endearment. Equivalent to "my little honey". John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access...
Um, you're welcome Bill. But I don't think that's all of the 'problem' files. Just the ones I had time to identify at midnight Saturday night, since I didn't...
I receive a daily "feed" of data as an mdb file (feed.mdb). I have a second database (importer.mdb) which is linked to the first and which queries the data,...
John, I am using the query as you stated, which has the Isuzu Cabs Produced summed. The cab standard hours are inputted in the data entry as a monthly number,...
Then thanks for the ones you did mark. I'll try to get to the rest, but my workload seems to be increasing exponentially by the hour. Bill ... midnight ... be ...
"Those French! They have a different word for EVERYTHING!" - Steve Martin That's cute. I call my kids "Sweetpea". ... honey". ... Mosca ... specific ... good ...
One solution would be to create a local table to hold the problem data, but define the key as a number. You should be able to run an Append query to the local...
That is *really* good news! That completely answers the problem of not being able to save a native Access report (including formatting) as anything other than...
You are right, Beth. And that's what is fascinating. I have your message printout and a print of all the VB code from ReportWithCriteria, and will go through...
John and Beth, thanks very much for the tips. I will try and see if this works. On a partly related note (and I will start a new thread on this), I am trying...
I have a listbox displaying the result of a saved query. What is the best way to filter records? For e.g. I have a textbox just right above the listbox for...
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.
