Search results for query: *

Thanks PHV/Lespaul your suggestions appear to have worked as I have not heard back from the person using the program. Ascent

I'll give this ago and report back. Thanks!

Thanks PHV that worked. Let me ask this. Would it be possible to only list records where the customer bought from more than one place? CusterID Location SMITH1 LC1 SMITH1 LC1 SMITH1 LC3 JONES LC1 MILLER LC1 MILLER LC3 MILLER...

I had originally posted a topic at the following thread for assistance however this won't work. http://www.tek-tips.com/viewthread.cfm?qid=1202945&page=2 To me the same concept applies however, I am only working with one table now. I have a ticket table that contains ticket information for...

Thank you. I will research and implement as needed. I will let you know how it turns out.

Does anyone think that this would work? lblSaveinProgress.Visible = True Do While rs.EditMode = dbEditInProgress DoEvents Loop lblSaveinProgress.Visible = False Ascent

Sorry for the length. Background I have a ticketing database that contains all of my forms, queries and a couple of non-linked tables and many linked tables. The primary tables are in a separate database. The "forms" database is compiled into MDE's and placed on two workstations, where the...

Well, as much as I would have liked to have done it entirely in the program, I used the following link: http://support.microsoft.com/?kbid=278379 Make sure to follow the directions to the T. Ascent

Do you have a link for this? Ascent

I am working with FAQ http://www.tek-tips.com/faqs.cfm?fid=5263 to override wheelmouse movement so it does not add blank records to my tables. The program I am working on is driven by Switchboards. How can I incorporate this by placing the ENUM statement in a module? Ascent

Do the properties your forms/subforms allow edits?

jkl0, Thank you for the easy fix. Ascent

I tried that, but when my form loads I get a blank detail section. (bound form) Ascent

When controls are tabbed all the way through a form with bound controls it automatically adds the record to the table. Is there a way to prevent this? It is placing an invalid record in a table and I would like to prevent this from happening. Ascent

Andy, your post should be in a new thread, since it is a separate issue. However, your statements suggests that you might need to look at the .requery method. Ascent

Thanks for the feedback everyone. If this had been a normal table, the issue would be moot. I will look at each suggestion and see what I come up with. Ascent

So what you are saying is create a query that excepts parameters. The parameters that are pass is the Material-Code-#, and the Qty-Ship-#? How would I extract the SumOfQty-Ship-# from the query once it was executed? Ascent

to make things work faster. I need some assistance to see if I can make this bit of code faster with another approach. 'Recalc reorder levels. Dim intTotPreviousTwelveMonths As Integer Dim rs As DAO.Recordset Dim db As DAO.Database Set db = CurrentDb Set rs =...

Esaias, Your post should be in a new thread as it does not relate to the current topic. Please repost and provide some additional detail with a better layout of your sample data. (It's hard to read and follow.) Ascent

I ended up using PHV's code. Thanks! With a couple of tweaks to fit a for next statement, it gives me exactly what I need. Ascent