Search results

This is a table design problem (normalization). You need a third table that has atleast two fields. The table would be tblEmpProj. The fields would be ProjID and EmplID. You could add other fields here like date assigned etc... To limit 3 employees to a project, you will need to edit check...

Check back here, I will take a shot and send you the code.

Yes this can be done. You will need to import the spreadsheet into access keeping the street numbers together in one field when it gets to access in a temptable. Then you will need to write a function that creates a new table. It will read through each record in the temptable (use the...

It's probably giving you an error because the field in the table upon which Req is built on has a property of Required - Yes. Allow zero length - No. Check your table design. You have 2 choices, 1. Change the table to allow null (Allow zero length - Yes) 2. Do not add the value from Cor...

You really do not need a button on the main form if you display records in a datasheet for the subform. The user can highlight the row on the subform and hit the delete button, right from the main form.

The first form should display enough information so that you Know you have the correct record. I would suggest adding more fields/info in the results of your search to make it easier to select the correct record. Another aproach is to have a list box that has your search criteria on the same...

It may be difficult to get help on this, unless we can see the spreadsheet. My initial question is how does the Streefield and Otherdata relate to property number, especially since there is multiple properties in one cell. How are the fields related?

There is a normalization problem here. You should not have customername in both tables. Delete customer name out of your visit details table. Having the customer id in the visits table will get you all the information you need about the customer. On the form where you enter your visit...

My friend, you have a corrupted database. Try running the compact and repair utility first. After that, the data may change (all ### signs). Then, try to delete the record.

Also, try hitting the F11 key. This should bring up the database form.

I think you are missing a library in your references. Maybe an ADO library. To check, hold the alt button and hit the F11 key. Go to Tools and select references. See if any are missing. You will get this error, even if the code is the same between the 3 versions of Access.

This may be an option. If the document residents_information2.doc never changes, make this document an Access report and just run as a report based on Query1.

You can define global variables in your modules. In fact, I usually have a module called global, where I have code like this: Global db As Database Global cmb As ComboBox Global frm As Form Global LogonID As String Global g_status As String 'Security Status Global...

Make the user select the Staffid first. Make the staffid field a combo box (cmbStaffID) that has its rowsource based on tblStaff. The combobox rowsource can have 3 fields where HolidayStart and HolidayEnd are not displayed. Do this by making the columnwidths = 2;0;0 for the combobox After...

I'm a little confused here and will probably need to look at the database. That being said, you may want to organize your companies in a combobox on some new form. Let the user select the form and then open the appropriate form filtering for the specific company you want. This code could be...

You can use the openargs parameter on the DOCMD.Openforms command to pass the value the user entered. Then in the open event for the form you can see if the value passed from the user exists in the table. If it does, you can then hide (or disable) the appropriate fields.

From a business standpoint, I would pay someone a couple of hours to come resolve this issue. Your boss can weigh your time vs. entering 30 time cards vs. paying an experienced programmer a couple of hours. Just a thought.

All the trigonometric functions are available in Access. Use the store and postal codes tables like you are doing. You can then import your spreadsheet as a table or use the same formulas you used in Excel to give you the distances and then you probably want the bottom 5, being the shortest...

I use this: Function listfields(strTableName As String) As String Dim db As Database Dim rs As Recordset Dim strSQL As String Dim Field As Field Set db = CurrentDb strSQL = "SELECT * FROM " & strTableName Set rs = db.OpenRecordset(strSQL, dbOpenDynaset) For...

Sorry to tell you this, but if the field you need to change is a field that links the table (has a relationship with) then you will have to delete the relationship, change the field (probably on all related tables with the corresponding linked field) and then re-establish the relationship. If...