Recent content by MattThat

JeremyNYC, your idea has some merits. Darrylles, yeah kind of. The user may or maynot add the result to the estimate (what the DB generates) but some result will need to be stored. I could, in theory, create a form that is almost an indipendant program that allows the user to fill out the...

I have a form that reprisents a table [costchart], (it has a many to one relationship with shop and product). The "chart" allows the user to select a product and a shop and assign a price. in this way a record of every price of the product and who sells at that price is created as...

I follow what is meant. It would be darn usefull to be able to call a query pass some variables to it have the answers displayed on a custom form... although the query could be displayed on a form but the search would need to display the message or get a value before the form was displayed...

(Rasses eyebrows at totally new thought).... I'm note sure you can. I would have built a quary containing every field on the table and use that to build my forms as they can be used in the same way. Help any? -Matt

I would always try to resume next when error trapping but report the error (nicely formated). You may be getting more than one error but only the first is reported. I try to include 2 levels of error catching on EVERY sub with dodgy code. Thus if the sub gets more than two errors it stops and...

If I understand correctly you may want to do as I often have. I place a textbox bound to Whatever_ID and then hide it. when the do.cmd gotorecord,,acnewrec (or what ever the exact code is) is carried out - the box holding the ID number and the data in the other boxes are bound to the record...

I am creating A DB for a client who runs a large gardening company. I have a smooth set-up for the entities and atributes but am at a loss for one particular part. A service they offer is removle of top soil/rubble etc and leveling of garden prior to work. They measure the garden and get a...

I know that to meet to the fullest degree user needs accross all departments I should use sugestion 1 (randysmid) but I know that No. 2 (Darrylles) is the easier to do. Further, due to the itrative process of generating a final plan, (for the client), it would require the storage of up to 20...

I have two entities in an other wise fantastic DB plan: Task and Estimate. One task may have many estimates. One of those estimate must double as the selected task_to_do_list. The others become history at that point. The problem is the users require the ability to set up the estimate, change...

Try something like dim mystring as string dim myval as long dim sizer as long sizer=47 myval = Len(mystring) if my val>sizer then call SomeMoreCode From the Access help file: Len Function Returns a Long containing the number of characters in a string or the number of bytes required to...

I can see vast ammounts of data repetition in those tables. I think perhaps the problem is the disign of your relationships (ERD). If I say "Normalisation" would you follow what I was saying? If so I would re-normalise bacause something went astray. If not then I would have to...

Required: No, Indexed: Yes (Duplicates OK), Unicode Expression: Yes... ...Gives us all the information we need to crack this problem. A primery Key is a unique handle by which we can identify the record. Think of it like your National Insurance number which is used to identify references to...

I am creating a database for a client to use. in it I have an entity called JOB with a one to many relationship to Estimate. The spec goes like this: The client will produce an estimate for a client (Est 1). The client will want changes (Est 2) and some more changes (Est 3, Est 4, Est 5)...