Recent content by tizwaz

no it's unbound with no control source

no nothing - it doesn't let you select another item in the combo - it moves to it but doesn't select it

boundcolumn is 1 and there is only 1 column which has the ID in - actually have just noticed it now works the 1st time you search but if you try again it does nothing

Can anyone help. I have a combo box in a form header which searches for a particular record based on the ID in the combo. This was working previously and I don't know what has changed to stop it working but now when I select something in the combo box nothing happens. Dim rs As DAO.Recordset...

In Access 2007 can you create security groups with logins/passwords? I want to keep the tables hidden from the users once I have split the database

thanks but that seems to create an error when I open the form frmIncidentsNew (probably because it is at that stage a form with no data) - error is that a value cannot be assigned to this object

Hi there I need to update a field on my main form using the value of a field on my sub-form. I have created a text box on the subform called txtcountitems which counts the item_id field of that form. This seems to work ok. However I have tried putting the following code on the after update...

It's a single form with 4 tabs. The button is in the detail section. It's ok think I've solved it - issue seemed to be with my relationships in the underlying query - thanks for your help anyway

Hello again Sorry I have another problem now. I have a report and want to be able to click a button on my form to print the report details for just the current record. I added a command button with the following code on the onclick event DoCmd.OpenReport "rptIncidentReport", acViewReport, ...

thanks that works great

Thanks very much this works fine and I have my form auto complete with this when a new record is created. One more thing - I need to set the ID to the next number (for reasons (data imported with existing numbers) I have been unable to have an auto number.) I'm guessing I need some sort of...

I have a form to add records and would like the field loggedby to auto complete with the name of the person currently logged in. I have a table (TblStaff which has 2 fields FullName and login). I believe you can get the logged in username with a function (something to do with Environs?) but...

I have data which was exported from a Filemaker Pro database and the table in question has an ID field. The ID relates to an incident number and needs to stay the same in my new Access database. I tried sorting it ascending and then adding a new ID field as an auto number but it through the...

I have several option groups and want to limit the choices on one based on the the selection in another - can this be done say on the after update event of the 1st one? If so how would I do it? for example the 1st option group has 2 choices and the 2nd option group has 6 choices which relate...

thanks a lot I'll give it a go