Search results

Good luck, Nessa! :-)

Hi Nessa - There are a couple of things going on, but the biggest is your use of primary keys / foreign keys. Normally the primary key is a number (integer) that refers to a unique record. The primary key is the record identifier in the original table. E.g. tblAutos (a table about...

Hi Stacey - The message that you are getting is because of the relationships between two tables. The "enforce referential integrity" option has been set. For example, suppose you have the following tables tblAutos: AutoID (primary key), AutoName, ColorID (foreign key) tblColors: ColorID...

Hi Nessa - The blank query means that you are either specifying some condition for which there are no records, or that the relationship among the tables is not correct. 1. Go to Tools / Relationships and look at the relationships table. Verify that the relationships between tables are on the...

Hi - welcome! If you can ennumerate all the potential lookups, then you can use the InStr function. You can also use the LIKE clause of SQL for matching. My concern would be whether or not you can uniquely search the payer/payee without hitting duplicates. E.g. what about "Auto Ease Mini...

hi - First thing that comes to my mind: use a query that determines the most recent "fit date" (probably the maximum of the date field). Use that query to filter the records where the information > max "fit date" Build your form on the 2nd query. Let me know if that isn't helpful.

Hi Gary - See attached db. My basic approach is as follows - 1. Having your routing table set up with each of the fields 2. Make a query for each of the following: OriginStates, ConsigneeStates and ServiceLevel. These are each essentially just summaries of the available options. I used...

Hi Don - I took a look at your data, but I guess I am still confused at what you are looking for in the end result. If I have a policy with a premium of $120, do you just want a list of months and $10 per month? Do you want a list of months from the start of each policy and the amounts in...

Hi - What you describe is certainly doable - with a little VBA and patience. The approach that I am most familiar with is to use the boxes to build a SQL statement. If you only search when you hit the search button, then the code for the OnClick event will examine the status of each of the...

Hi - welcome. Sounds like a odd problem. First, try to compact/repair the database. Tools / Database Utilities / Compact and Repair Database If this doesn't work, then you might try to post your database (only if it is small and you can zip before posting). - g

Hi Gary - First of all, how would *you* go about determining the correct carrier? If you can think about how you would do it, it can make it easier to figure the best implementation. If you have a combination of look ups, then one of the methods that comes to my mind would be to have a field...

Good luck!

Sorry for the delays - dodging the metaphorical alligators... 1. Are you trying to duplicate the table or write code that will create the csv file? (I think I'm getting a little lost in the posts). 2. Probably some of the trouble with the description is that it is "non-standard" property of...

Hi - See this for a sample - Dim dbs As DAO.Database Dim tbl As DAO.TableDef Dim fld As DAO.Field Set dbs = DBEngine(0)(0) Set tbl = dbs.TableDefs("tblOfficers") Set fld = tbl("Name") Debug.Print fld.Name Debug.Print "*" & fld.Properties("Description") & "*" dbs.Close Set dbs = Nothing Set...

Nope, that's not quite right... I'll have to see if I can find that again. [Had it figured out somewhere once]

I think it is a property of the field, e.g. Dim fld as Field debug.print fld.property.description See if that works, otherwise I'll have to dig a little....

Not sure that I understand your question.... can you clarify what you mean by using the "output to function"?

Glad that you got it sorted out. Sometimes two queries in sequence just make things work better (or more easily?). There may be some way to combine them into one, but it often isn't worth it. The message "you tried to execute a query that does not include the specified expression <name> as...

Hi - Welcome! I think that I am a little confused - how does the number of videos affect the due date? [Seems like you can have multiple videos, each with its own due date.] The DateAdd function just adds the given time interval to a date (to save you the trouble of figuring what 23 days past...

Hi - Welcome! You need to use the Totals / Aggregate Functions so that you can GROUP BY date and body type. Look for the Summation Sign (Sigma, Sort of a odd looking 'E' on the tool bars when you are in the query design view.) Clicking this will toggle the Totals on and off for the query...