Search results

hi Steve - My first recourse in these situations is to change the update query to a select query just to see what records are returned. Most of the time, the records that I think should be selected are not really included. Getting the right recordset sorted out takes care of most of these. - g

hi - not exactly sure what you mean by a "record starting with a number" If you have a text field that can contain both letters and digits (0-9) then you can use a string function to test if the first character is >0 and <9. hth, g

okay, I think that I understand a little better.... I would instead then try to use a combo box (or list box) that shows all the ON/OFF dates for a unit. I would then use the AfterUpdate property for that control to modify the recordsource for a subform that shows all the appropriate records...

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"?