Dave- How about: SELECT Hour(OpsTime) As OpsHour, Count(OpsTime) FROM MyTable GROUP BY Hour(OpsTime) I thought the Partition function might also work to give...
Yep, I tried partition because it seemed the best solution for what I am trying to accomplish. I was even trying to think about returning whole numbers for...
You're incredible John....first time....and voila...exactly what I needed. Thanks John! I spent all day yesterday trying to figure this one out....geez I hate...
Unfortunately, my switchboard is kind of a mix. I've used both the switchboard manager on it and I've done some stuff in design view. It was originally...
One last question....I have tried to do this...is there a way to break down from hours into 15 minute increments? Dave ... From: ms_access@yahoogroups.com...
Garry - I was the one who helped you a while ago. You have code behind the following forms: Switchboard. frmSelectArtist and Artist Form The one I helped you...
OK. What is in the On Click property of the command button that you want to investigate? John Viescas, author Building Microsoft Access Applications Microsoft...
Thanks again, Dawn. That tot my new report going. Now, for some reason, the command button for the Artist report that you helped me with is not working. I...
Which button? The one on the switchboard? Or the one associated with the combo box? Did you happen to rename the report? Dawn Crosier "Education Lasts a...
I'm trying to import just under 420K records and am receiving a "Database has reached maximum size" error. How can I import this file? Thanks, Jeanette~ ...
Go into the Switchboard Manager. Select the Reports switchboard. Click the Edit button. Highlight Comics by Artist. Click the Edit button. Text should say...
How many fields are you importing at one time? If more than 255 then you are exceeding the capabilities of the Table Design, not the number of records. Dawn...
That info was already there. I redid it anyway. It still doesn't work. I created a new button with the same stuff, and this one seems to work. ... I...
Glad to hear you got it working. Dawn Crosier "Education Lasts a Lifetime" This message is posted to a newsgroup. Please post replies and questions to the...
I don't know. It seems like everytime I do something, comething else gets disabled. Now my new button doesn't work. Maybe I should make a new switchboard....
I'm not sure I would go that far. Do you want to zip it up and send it directly to me? I won't fix it for you, but I can tell you where the problem is, and...
I don't think it's more than 30 fields. Not where near the 255 limit. ... How many fields are you importing at one time? If more than 255 then you are...
What kind of file are you importing? This could be a case of specifying the wrong delimiter during the import. ... management software Database software...
It's a basic text file. I'm doing what I've always done with no problem. Did one just last week perfectly. I don't think it's the delimitation that's wrong....
Jeanette- How big is your mdb file before you start the import? How big are the records you're importing? That sounds like a lot of rows, but even rows as ...
Hi everyone! I recently upsized my Access database to SQL Server (MSDE sp4). I now have an .adp file which I use to manage the database (an interface to the...
John - I feel really stupid for asking this, but I'm not certain where this code is to go. My first thought was a module and my second was in the SQL window...
Mike- It's SQL. Start a new Query, switch to SQL view, and paste in my code. In my example, I used your "sample" table. You'll need to change the table name...
Thank you John - That's what I thought! ... code. In ... table ... On Behalf ... relational ... is ... rows ... & ... date ... that ... only ... know ... ...
John, The update didn't work quite like I had hoped. No fault of yours. For those records with a missing date value, the update successfully assigned a value....
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.
