Search results

Is the form tied to a table/query, or is it a dummy form? If the form is tied to a table/query, then the data should automatic update the table when you are finished entering. As for closing the form. DoCmd.Close

How about do it in code instead of an IIF statement?

Make the relationship 1 to many from the DVD collection --> Borrow and just have a single primary key on the borrow table. Then you should be able to delete from the borrow table w/o it coming off the collection table.

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.