Search results

Fix strips off the decimal places. So using the Fix instead of Cint with 35 you would get: 35/20 = 1.75 Fix(1.75) = 1 1+1 = 2 2 * 20 = 40 Using Cint it rounds up so you would get 35/20=1.75 CINT(1.75) = 2 2+1 = 3 3 * 20 = 60

Qty = (Fix(qty/20)+1) * 20 (note - will not work with exactly 20' cuts.) If you wanted it to work with exactly 20' cuts then you would need to put an if statement in.. If Fix(Qty/20) <> (Qty/20) then Qty = (Fix(qty/20)+1) * 20 End If

Here's a weird problem I've had develop in the past couple months, before I upgraded to 2007, and now since I upgraded to 2007. I've had the same Access database since 1997, and just recently upgraded it to Access2007, but as I said the problem occurred before and after the changeover. I...

I have no clue what you are seeing, nothing happens after I enter a comma.

I don't even understand what you are asking. If you want what I think you want, make a table with a bunch of inane answers. Use the on change command and throw an Instr command in there to make sure you typed "Peter tell me I'm wasting my time:", :) if it is there, enable the second text box...

XP Home SP2 Version 5.1(Build 2600 ....gdr.050301-1519) P4 256MB RAM 2.4GHz

What if you import the existing Excel sheet into a dummy table, append the records that would go in the report to the dummy table, export the dummy table back to Excel, write over the existing Excel file, and delete the dummy table?

...you do this: There was question asked on the forum a couple weeks ago about setting an event reminder that always triggered at a certain time period. Then I got to thinking about it, because I never use the timer function in Access. So I started experimenting, at first it started out with...

I don't personally see the point of having rich text in tables and queries. Then again, with my database the only time I ever see tables and queries is when I'm modifying the design of them. Everything that is viewed has a form, subform, or report for that table or query.

Dumb question, but have you clicked the "sigma" button which allows you to show sums, averages, counts, etc?

I installed and am running Access 2007, and the only issue I had was I couldn't import a couple forms, and one report. Probably something with old coding that I never cleaned up. Some things I don't like with it. It seems to run slower, actually the entire office 07 suite seems to run...

Here's what I did for invoicing on my system: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim db As Database Dim strSQL As String Dim rs As Recordset If IsNull(Me.Customer_PO) Or IsNull(Me.Invoice_Employee_ID) Or IsNull(Me.Customer_ID) Then Exit Sub Else If...

I'm storing 10 years worth of data in our database. 33000+ invoices 50000+ invoice items 800+ customers 1300+ ship to addresses. I keep waiting for a "Sorry, you can put no more records in this table error" but considering the maximum records per table seems to be 2GB, I have a ways to go...

Well, I took two tables and made a query with them, and was unable to input any data via the query with or without the formula. With a single table, I was able to input data even with the formula. The tables were not linked however. I know that in my database I sometimes ran into recordset...

As a new field in the Query Field PriorityFormula: [Field1] + [Field2] + [Field3]... Table: Blank Sort: as you wish Show: shouldn't matter if checked or unchecked Criteria: Blank However, I think the problem is attempting to input data to two tables in one query. You said you are entering...

A new field with PriorityFormula: [Field1] + [Field2] + [Field3]....+ [Field10] Doesn't work? How many tables in the query? All one table?

Can you make your own tweaks in the database copy you have? If so, instead of printing the report use DoCmd.SendObject If you can't when you are at the print preview screen for your report (depending on the version) File...Send... In 2007, click the office button and e-mail it.

Two things to do - at least the way I would do it. #1, add a new yes/no field to your table, and then make a checkbox control on your form that the reminder is. Then #2 in code you need to just run a (oh man, I'm gonna get flamed for the way I write code) For/Next loop. strSQL = SELECT *...

I had the exact same issue with my database, where the item price was calculated based on a date when the pricing was determined vs the date of the invoice. That was abandoned a long time ago in favor of a table with the following fields: *Invoice Number *Invoice Product ID Quantity Notes Item...

Ummm...my suggestion would be a query just like was suggested. I run a distribution company with products from 20-30 vendors and over 300 customers. My inventory query is populated by 6 different tables, it's a real PITA. Trying to have a live inventory as a record in a table that you are...