Search results

MS documentation states that space is not reserved for unused characters in a text field. Does this mean that there is no storage penaly for having a text field 255 as opposed to 80. On a more general note are there any tools to help calculate the size of a table?

If you delete all tables and all relationships then anything else like a query or form will fail so you would be just as well opening a new clean database. If there is something in the old one which you want just copy it across.

I have not programmed a bar code system but it appears that no one else is going to answer this one. I assume from your question that the bar code contains the name of the company amongst other data. You need an algorithm to breakdown and extract the constituent parts of the bar code. Then...

The actual resumes don't seem to feature in the design so far. I would keep them all as word documents. One folder per resume with file names smithYMMDD.doc. These would be referenced by by hyperlink fields to specific proposals/projects as each resume should be personalised for each project...

The major consideration here is that the existing spreadsheet is your business. If you create a database which is poorly designed then it is going to limit your business. It is easy to think that you will just start somewhere and redesign it later. The truth is that it will be just too much...

Nick, A lot of work must have been done to get to the database which you attached. Trouble is we don't see any of it and the answer to your database design is in that work. Look at your input forms (I mean the bits of paper filled out and signed off in the warehouse). If they are actually...

OK so I was just being lazy. I will do the whole 9 yards including a text box to add a new record to the source. Thanks to the messenger if not to the message.

I have a book which gives code for using multipick listboxes but it seems extremely complex and still lacks the "Notinlist" functionality of combo boxes. A search of this forum fails to find any references. Does anyone have experience using these controls? My current design is putting in the...

The attached zip file shows the VBA code needed to manipulate the test file. I have put the test data into a table and created a form with two buttons. One runs the calculation and puts the answers in the boxes, the other resets the data and the boxes. Clearly I have not understood the carton...

A Carton is a box for storing products in. Cartons come in different sizes but are always a rectalinear box Styles are products which require a rectalinear amount of space (your wooden block) The object is to pack the carton as efficiently as possible. There must be other constraints. Are...

May be I just don't understand the basic warehouse system being used but a look at your db gives me no understanding of what you are trying to do. If someone else has specific experience of this type of operation then ignore this message. If not and you would like me to look at it then please...

I can not see anything immediate which needs VBA. Import or link your spreadsheet. It then IS an Access Table. Standard Access data entry/editing forms will probably do most of the rest. If you just link and there are no password/protections in place then you don't even need to export it...

Store the expiry date and filter on that. Date less than event date +1 should do it.

My thought is that the disclosure is almost a specific one time thing (if most events are annual). It depends on who gets to see the disclosures. It could be unfortunare to release an expired disclosure. If there is an issue here then I would be tempted to make disclosures one time and accept...

These things are always very difficult at the analysis stage. It seems to me that you may have your focus wrong. The first thing I would create is the facilities availability - there is no point in two events moving into the same space at the same time. Once you have this and can populate it...

Is a disclosure (or the conflicting interest causing it) time limited? In other words does it have a possible expiry date or is it for ever once disclosed?

I have been looking at something similar. Access stores the time in the decimal part of a number. This goes down to seconds. To be useful and accurate the time must be converted to an integer. If you need the seconds then this must be a long integer. I favour losing the seconds which allows...

Court tables Hi Arc, Here is a mockup of the tables you asked about. The relationship diagram is generated by Access (tools - relationships). I have assumed that while a case may have many crimes, a crime is only tried in one case. It is also likely that you will need a defending barrister...

An Access form has a record source. This is either a single table or a query if the data comes from more than one table. This will work for many requirements and is the easiest solution because Access looks after the data for you. Only use Recordsets where the simple way is not doing what you...

If the data is in tabular form then copy and paste will work into Excel. An Excel table can be linked/imported to Access. This is a manual route which is quick and easy. Clearly it is not an answer if you want to rerun the process automatically but I think it worth playing with as it gives a...