Search results

OK. I think with that detail you don't want an update query. Say you have a form to view details about a vehicle. You could open another form to add mileage information for that vehicle. You enter the gallons purchased and odometer reading. I think if you can use the DMax function (look for...

Oops! Made a change and didn't carry through. Open tblShops in design view. Go to the AreaManagerID field and go through the lookup wizard in the data type.

Here's one for you, Mile. Since my version is GREATER!:D

Polly, here is what I think. You other guys jump in if I'm off. You can go to any level of detail you like. If MetodofComplaint still applies, you probably want a table for that, i.e. tblMethods. Most of the time, I use the Lookup Wizard in the design view of the table to make my links. In...

I agree. But just to nit pick, wouldn't it be good practice to throw in an ID field in the Area Mgr table?

Check out this thread. I did something similar here. Between what dcx693 has and this, I think you'll find it.http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52859&perpage=15&pagenumber=1

What about something like this. As I understand the structure, each member of the staff would have a unique record so their individual information would be in one table. The same goes for customers. Since you want predefined complaint categories, give them a table of their own. Then you want...

Sounds like an update query based on your Date column.

How are you outputting it now? The command in VB is acFormatSNP.

How about a little more explanation. I'm not clear on the calculation part. You should be able to use an update query to get the previous miles in the current record.

It doesn't need an external viewer. It is a viewer of its own. Say you save a report in Snapshot view to your file that holds your web documents. When you link to this file it will open and show the report with your formatting. But, it wouldn't be viewed as a webpage, it would be like...

Neil, what about snapshot view? I use this for some of my reports and it retains all formating. If you are using code, use acFormatSNP. A macro will give you the choice for Snapshot view also.

Just as an update, my problem was fixed when we had Win2K SP3 installed.

That's true. I hadn't thought about that one. I suppose you could handle manually. In other words, if this is a list you were checking each day, you would have to see it. Still not exactly what you would like I guess, isn't it. One thing I have come up with is in the NxtDueDate calculation...

OK. I did some more digging and scratching and here is what I came up with. It is working great with the test situations I have thown at it. Please look it over and share any advice or possible bugs. When my form opens it looks for recurring items and adds a new task to the list if it is due...

Please comment away. And sorry to hear you've been sick. Hope you're better now. 'Expertise'? HAHAHAHAHAHA. :) Like yousaid before, duffer. Anyway, code aside, I open a recordset, run a calculation, and the run a query. This runs fine, but I wonder if I need it in code. Would a regular...

In searching on endless loops I found a post where Pat asked 'Why do you think a loop is necessary?'. So, I asked myself the same question. Then took out the loop in the code I have above and whattayaknow it worked. Still have a couple of other issues to take care of. Will be back on those...

OK, I dug in and got this far. Private Sub Form_Open(Cancel As Integer) On Error GoTo Error_Handler 'Declare and instantiate object variables Dim cnCurrent As ADODB.Connection Dim rsRecurring As ADODB.Recordset Dim N As Integer Dim NxtDueDate As Date Dim RoundN As Integer Dim N1 As Integer...

Yes, I think you're right. I was concerned with the data type with what Mile-O posted, but I set my data type as an integer. I think nthat will do it. Haven't found any errors in testing.

This is coming together in my head a bit, but have a question. I have a query that will do the calculations I want (still have an issue with the rounding part). Should I put this as an event on the form BeforeUpdate? The query helps me figure out how the calcs should go, but would like to do...