Search results

Mat_J If you go to table1 and enter another field (field5), then... when you open the associated form in design view, field5 will be in the 'field list'. (from the view menu>>field list) I understand you to say this is not happening. Mmmm.... Try associating your form to another table, or...

Candice Tripp has an example download here... http://www.candace-tripp.com/_pages/access_downloads.asp Tom

Mat_J If you have the field added to your table, you should be able to refer to it with code. Maybe try compacting your db. Tom

For 1. try Me!Refresh HTH Tom

You guys are the best! Thanks DB7 and Wayne. I used this and it works great. If DSum("[StraightTime]", "tblInvoiceSub", "[Date] = Forms![frmInvoice]![frmInvoiceSub].form![date] ") > 8 Then MsgBox "You Have Exceded 8 Hours Of Straight Time." End If Tom

DB7 Thanks for the reply! That almost did it, but... I want to be able to enter all my tickets one day at the end of the week. So ticket dates will not be todays date. If I enter five tickets for Aug 11/04 (for instance), each worth 2 hours, I would like to check to make sure the last ticket...

phat al It sounds to me like you need a table "Customer" Where you enter the kids names. And you also need a table "Snacks" Where you enter the type of snacks. The first combo is linked to customer and the second combo can be linked to snacks. HTH Tom

Hi As I enter tickets into my invoice, I enter the ticket date and the straight time hours. I would like to have access check to make sure I do not enter more than 8 hours on any one day. I think it should be something like this.... If straighttimehours < 8 (for this date) then msgbox "You...

Perfect! Thanks Paul. Tom

Hello I have an option gruop on my employee form. I select what type of employee from the option group. eg: Practitioner or Therapist The Practitioners need an Association number, Therapists do not. I want my form to display the Association text box only when 'Practitioner' is elected in the...

Thanks everyone. Tom

I have made a query that does what I want. I have coppied it from the SQL window. SELECT *, [CustomerLast] & ", " & [Title] & " " & [CustomerFirst] AS SoldToCustomer FROM Customers; When I insert it into my code it doesn't work. I think I am haveing some trouble with the " and the , Dim...

Perfect! Thanks Andy Tom

Thanks for the reply Andy. I would rather not have any message. If there is no record the code is supposed to put "No Data" in the textbox that the code normally fills with a date. (LastInventoryDate) Tom

I can't get rid of the "No Current Record" message. My form runs this code in the 'On Current' event to get the last stock take date. If there has not been a stocktake done for this record I get the above error message box. Dim db As DAO.Database 'Type of reference Tools>>References...

Coddfish I'm not too sure. But there is a way to find out. Copy the master db and then open it to make sure it works. There may be a problem with syncronizing though. Normally when I have a trouble with a db I try to repair it by importing the problem componets form an archived db. I seldom...

Codfish This may not be the best way, but what I do is... open windows explorer, copy the db then... paste it into my archive folder. I rename the db with a date extension so I can keep track. eg. "MyDb 031904" If your db is split make sure to copy the back end too. HTH Tom

Ken Sounds like you will want to add a table with your questionare info, plus the user ID. Then relate the user ID to the Address book table. HTH Tom

I'm not sure what you are asking, but I think a DCount function may work for you Tom

I have a bit of code that calculates the InStockQuantity of a part. This works okay in my parts form. On my Invoice form I have a PartNo combo box that is fired by a query that looks up the part information. The pull down list has several columns, PartNo, StoreNo and Description. I would like...