Search results for query: *

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

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...

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, ...

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...

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...

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...

Can anyone help. I have the following code which loops through a recordset and emails a report covering the departments to their budget holder. Some budget holders have more than one department. The details of the departments and budget holders email address are in a table. I have the...

Can anyone help. I have the following code which loops through a recordset and emails a report covering the departments to their budget holder. Some budget holders have more than one department. The details of the departments are in a table. I have the following on the click event of a...

Can anyone help me - I need to have a formula which will add either 1 year or 3 years to the dates in a column dependant on the value in another column. I'm assuming an If statement for the first part but don't know how to do the rest

I have a report and one of the fields contains abbreviations for words. How can I make the report show the full word instead of the abbreviation. there are 3 different abbreviations in the fiels

Can anyone help? I have a report which has a field called CostCentre. I want to run a series of reports one for each cost centre each month. I can base my report on a parameter query and manually input the cost Centre and then save each one but it is quite long winded. Is it possible to...

I have a list of names which I need to split. some of the names have the title eg Mr and others just have first name and last name. eg Mr John Smith Mrs Jane Jones Janet Brown also some say REF: Joe Bloggs I just need a list of names without the Title (or the word ref) (would preferably like...

I want to extract data based on a criteria from several worksheets and copy to a blank worksheet. I have excel 2007 - I can do it using advanced filter for one sheet but not for multiple ones - can anyone help?

Help I deleted an outlook profile as there were issues opening outlook. When I created a new profile outlook opened. The inbox etc was there but all but 1 of the folders were missing. I don't know if the folders were pst files as it is not my computer but can I get them back? The exchange...

I have 2 large spreadsheets both with a list of people's names. I need to find those names which appear in both lists. Can anyone tell me how to do this - I've tried various lookup options but can't get it to work. I can think how to do it in access using find duplicates but how can i do this...

this is probably something simple but i can't see it. I have linked an excel spreadsheet to my database but when i open the table it is read only. The spreadsheet itself is not read only. - how can I change this?