Search results

Have you put SetWarnings = No into the macro before the action which results in the msg? If not, you could try that, as long as you're sure you are okay with ignoring the msg. Be sure to put SetWarnings = Yes afterwards.

I would do it by adding code to the Detail_Format event in the report. It would save the End Date from the previous record and use it in the calculation for the current record. I don't how you'd do it with a query. Are you running a new report for each job or are all the jobs on one report...

TFancher - I see I misunderstood your post. I thought you wanted to count the nbr of times an item was issued not the sum of the qty issued. Your post said count and the rpt showed qty. I should have caught that and asked for clarification. If you look at the attached it shows the changes to the...

Do I understand that this table has a record for a vehicle only for the days where there is a rental or repair scheduled? If there are no rental/repairs scheduled on a vehicle for a particular day then nothing exists, correct? So if the report was for a period that a car had no rentals/repairs...

What are you saying when you say mask?

How is the report set up? Do you have it grouped by press or is it one report sorted by job due date or how? The answer will depend on how the data is arranged on the report.

A couple more questions. 1. The table of invoices you're checking, is it static? I mean do you get a new table of data each week, month, whatever, to run your reports against? Or is this table continually getting new records added to it. 2. Do the records have a unique key field? 3. You say you...

I found some code and adapted it. It's not a macro but would replace it. Open the attachment and look at the code in the module modXML. This exports two tables, tblEmp and tblSales, to the desktop as XML files. You can replace the table names with your own and the destination also. To add more...

Take a look at the attached. It works by having two tables where you put the years(1999,2000,etc) and the Sectors(62----,etc). The code iterates through each table and creates the SQL to make each table using the possible variations provided by the Year and Sector table values. Right now the...

Ah, yes. I remember those tables. Now that I have them, what exactly do you want me to do? You said something about assigning a Level but the problem with that is that the same parent/child could be used in multiple BOMs and appear at a different level in each. What are you trying to accomplish...

See the attachment. It shows a query to do what I think you're asking. HTH:cool:

Yeah, that sounds right. Okay, first question. What is the purpose of identifying the levels? Are you trying to set up an inquiry ability to view the BOM for a project or print a report or what? Question two. Can you send me a copy of the two tables? You can delete all the "real data" and just...

Yeah, Macola is a little pricey:D Course it's cheaper than Oracle! Unfortunatley, I'm on an even older system now so I can't help you there. Okay, so one table has the project nbr and the other table all the components. Am I right then that in the second table the record that contains the level...

Maybe we should be looking at how you're getting the duplicates to begin with. It worries me that there are so many ways there can be a duplicate. Sounds like your table needs to be normalised. Can you give a quick explanation of where the data is coming from and what kind of dups you're...

Macola - been there both pre and post Y2K. We don't use it anymore but once upon a time I knew it very well. Sounds like you're trying to build something like a bill of material. You say you need to find the head of some series and you mention projects. I faintly remember something about...

Take a look at the attachment. Query1 returns the business info with only a 5 digit zip. Query2 joins Query1 to zipcode table and excludes the businesses with a nyc zip. Might be a simpler one query way to do this but it's late and my brain is tired.:o

I have the Microsoft DAO 3.6 Object Library referenced. Private Sub cmdDeleteExtraFields_Click() Dim db As Database Dim td As TableDef Set db = CurrentDb Set td = db.TableDefs("table name") td.Fields.Delete "Name of field to delete" End Sub Hope this helps!

Generally, I put sub reports in the detail section. But where you put them is totally dependent on the use you're trying to put them to. If you're getting duplicate info, then do you have the control source for the main report duplicated in a sub report? IMHO, avoid sub reports if you can. They...

Use DCount against the query your report is built on. =DCount("usr_origin","Your Query","usr_origin = 'Internal Software Errors'")

Take a look at this example. It does what you want.