Search results for query: *

Hi All First off, let me say thanks for any advice or help you can provide with this problem. So I’m a bit confused with whats going on right now. I have two sets of tables that I need to run a DCOUNT routine (VBA) on and I am at a loss why the second one isn’t working programmatically. The...

Hi All, first off let me preface this posting by saying I am an Access guy who is still learning how to do some things in Oracle.. and therein lies my issue. Any help or suggestions would be greatly appreciated. I’m assuming something along these lines is possible, right?? I have a table...

Hi All First off let me state that any assistance that could be assistance/suggestions with this would be greatly appreciated… And I’ll give you the disclaimer to start. I’m an Access guy who is learning painfully that Access SQL isn’t quite the same as is required for Oracle.. But this works...

Okay guys and help/advice/suggestion would be greatly appreciated. I hope this explanation I sufficient I have a user form which requires the user to dictate a STARTDATE and ENDDATE,I also have the user have the option to dictate a STARTSTEPDATE and ENDSTEPDATE field. I need to be able to...

Summarize By Day/Week/Month/Quarter etc. I have a table which has various values, but the two important fields are DATE and CATCH. I need to be able to summarize the CATCH field by day, week, month, quarter and year. This table was generated from an input form which provides start and end date...

I appreciate any help that could be given with this problem. I really feel I should know but my brain isn’t working.. So I’m throwing myself on the mercy of Tek-Tips and hope some body can help. Any help/guidance would be greatly appreciated. I have a three field table which corresponds to...

Hello All I have hopefully a simple question that someone can help me out with. I've created an MDB. That has several VB functions involving the Date() command. They seem to be working fine on Windows NT and Win 2k. They are however blowing up on Win 98 machines. For what its worth all the...

Hi All Standard Comment to Start with any help and or guidance would be greatly appreciated... I need to take a text file/spreadsheet load it into a collection and take certain values from that to populate a text file. One the first run there will be about 2000 records (many more to follow...

Ok This one should hopefully be an easy one. My brain just isn’t working well this morning. And any help and/or suggestions would be greatly appreciated. I have a variable (CurPath) which is a file path and generated from a module. And all I want to do is update a field in a table with that...

Hey All Any help would be greatly appreciated. I have a series of tables that are formatted correctly in Access. When I batch export them (or do them one at a time) to a dbf They come in with decimal places. Anyone know how to remove them? I'm somewhat at a loss since they are defined as...

Ok here's My scenario. And I'll state the standard disclaimer Any Help and/or suggestions would be greatly appreciated. I have numerous DBF's up to 100 at a time in various folders. I need to import them all, change some field types and definitions and then export them to a precise dbf format...

I always have problems explaining my issues. But anyways, here goes... I have a make table query that takes a table that the user imports and collapses (totals : group by) on an ID, There are three fields that also gets added in on the query and calculated out to zero. (i.e. Thickness : 0...

Please bear with this explanation/question, I've recently been reintroduced to Access after a year absence and my brain is sorta fuzzy with some of the stuff I used to do... And any help/advice that can be provided would be greatly appreciated. So I have a table (go figure) that sort of...

Here's the situation, and I'll just state ahead of time any help or guidance is greatly appreciated. I have a query that pulls out a date and a number (FLOW for whats its worth), and I need to calculate a rolling 3 month (and 12 month, but once if figure out how to do thethree tehthe 12 should...

To Whom It May Concern. First off, anay help or guidance that could be given would be GREATLY appreciated. Ok here is the situation. I'm working on something for a public utilities department. I have a query which pulls in flow numbers (monthly) for a certain facility between two date spans...

I have a table which I'm incorporating into a query. There are numerous fields in a date format. I want to get a field in the query that groups the dates to just a month and year. I.E. Records with 12/01/97, 12/11/97 and 12/27/97 all will come across with December 1997. I used the following...

I should know this, but my brain isn't functioning well this morning. And as such I feel like quite a dumbass for asking. So I have a query that I want to add a COUNT field to the end which autonumbers for all the values in that query. Any help would be appreciated. Thanks Eric

So I was given an old MDB that really should be redesigned, but I don't have the time. Anyways there are several forms on there with loads of text boxes and comboboxes. But the order on them is off. I have to move from box to box via the mouse. Hitting TAB seems to jump from control to control...

I have a split database, and the replica on April 2 was 19 meg Then was merged May 2 was 19 meg 3 months have passed, not a significant amount of data has been added (realistically 1-2 meg) and the replica has spiraled out of control (up to 300meg). I have tried to compact and repair the...

Well my query seemed to work perfect well on a couple of machines, but not on others. My situation is the following, I have a query in which it pulls in a date field (mm/dd/yy) and I want to turn in into a field that just says something like Sept 99. So my code is Format$([DATE], "mmmm...