Search results for query: *

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

I need to have a form which displays all fields in my table but showing no records as a search form. the idea being that I can enter criteria in one or more of the fields and then search to return matching records - is this possible and if so how would I go about it = does it require vba coding?

I have a table which lists items in the left column and dates in the top row. at the intersection of each item and date the cell either says scheduled or is blank. I have another worksheet which has the items and dates in it and I would like to be able to look up both value and return either...

thanks that's great and giving me week numbers and day numbers. One thing I don't understand where the week number comes from - how to I tell it where to start numbering from - there is no set numbering that for eg it starts the year with week 1 it is just a rolling 4 week period and I would...

thanks Skip but I think I may have not explained v well I need it to do something like this Tuesday 12/06/12 week 1 day 1 wednesday 13/6/12 week 1 day 2 thursday 14/6/12 week 1 day 3 incrementing so i have the days listed as week 1 day 1 - 5 followed by week 2 day 1 - 5 and so on on a 4...

Can anyone help. I want to have a spreadsheet to have a date for every weekday and then for each of those days have a week and day number based on a 4 week rota. Is there anyway of doing this by a formula? for eg the 1st week would be week 1 day 1 to week 1 day 5 and then the subsequent weeks...