Search results for query: *

Hi, I want to call data from a table so I can manipulate the data. I am sure I need to use the openrecordset command. I can manipulate data how I want it, but can't work out how to call the field in the table. For example I have a table called "assetreport" and a field in the tabe is called...

Hi, I want to split text from a table feild into 3 query fields for manipulation later. The text looks something like: 1234 southside project X 1324 South bank Project Y And \i want it to look something like this: Site ID site name project ---------------------------------- 1234...

Hi All, I want users to import an excel file to a table. I want the user to be able to select the file they import because every file will not have the same name. Everyfile will have the same format. I have tried the Transferspreadsheet cmd but i get an error because I don't have the file name...

Hi I'm sure this is simple but I just can't get me head around it. I have a combobox on a spreadsheet which is linked to a cell (B9) and when the user selects the item from the list I want to update cells on the same sheet based on a table. I can update the cells with the below code...

Hi all I have a spreadsheet set up as a form where the user selects a site location and the other fields (i.e Address) auto populate based on a table I have on a back sheet. This works fine. But if the user needs to add a new site and details I want to have a user form where the data is entered...

Hi All, I have a label in my word doco that I want the users to click on and this fills in a textfield with the date. It odes works with in reason, when I lock the form I get a message telling me it is a protected area of the document. what do I need to change so it works while the form is...

Hi all, I have a word doco with checkboxes and thanks to help I have received I have been able count if the checkboxes are checked. But because I have about 50 check boxes on my form and my form is broken up into sections I want to be able to count the checkboxes by a range, so from checkbox1 -...

Hi All, It has been a few years since I worked with MS Access, so please be gentle. I want to create a DB for Telco projects, but I would like to be able to export the data to MS Project. Does anyone know if this is possible Some people make things happen, some watch while things happen, and...

Is it possible to export data from access to MS Project? Have a Merry Christmas Guy's Some people make things happen, some watch while things happen, and some wonder 'What happened?'

I lost my database due to a virus and I wnated to load a backup copy I have. The backup is a MDB file, but when I try to open it I get told 'Unrecognised database format D:\Implementation backup.mdb' I have tried to import the table etc to a new db but no joy. Any suggestions? Thank you in...

Hi All, I have a table I want to export to excel but i want to transpose the data and remove the field names from this: field1 field2 field3 john tim bob ----------------------- to this: ----------------------- John Tim bob any help would much be appreciated Thanks Some people...

I have a excel workbook that I want to open from Access and copy and paste cell data to a new word document, but I want to paste the data in to a table. Any ideas? Thank you an advance Some people make things happen, some watch while things happen, and some wonder 'What happened?'

I am exporting data to a new excel workbook but the dates are just numeric. how can I change the formatting of column A to a date when I export the table? Also the same with currency. I get the decimal places but I also want the dollar sign ---------------------------------- Dim sRecon As...

I want to specify a cell range in excel to paste a query too. I currently have code that I am using to add text to the spreadsheet such as formulas and labels. Can anyone please help. Thanks in advance ----------------------------------- Dim mySheet As Object Dim myBook As Object Dim xlapp...

I am importing data from a spreadsheet and using a update query to oput the data into its correct table. What I want to do is if the data is changed during the update, I want to change the color of the text. Is this possible? Thanks in advance Some people make things happen, some watch while...

I have a spreadsheet that I import into my db, using the data from the spreadsheet I over write the data in the corresponding table with an update query. What I want to do is if the data changes in the table to change the colour of either the data or the background of the field. I am assuming...

Ok The following code works for one record but when there is multiple records in the query I get and error saying: Item has been moved or deleted. help please. ---------------------------------------- Dim rst As DAO.Recordset Dim qdf As QueryDef Dim prm As DAO.Parameter Dim objword As...

I have a word doco I am using bookmarks with. When the doco is email to someone they are asked if they want to update the data. Is there a way to stop this? Some people make things happen, some watch while things happen, and some wonder 'What happened?'

OK. I'm sure this can be done . I just can't get my head around it. I have a query I want to export to excel. But I want to export each individual query record to a new workbook called after on of the field names. Some people make things happen, some watch while things happen, and some wonder...

OK I'm sure this is very easy. I want to open an excel workbook and export data from a query to a new worksheet. I have been able to work out how to add a new worksheet to the workbook but can not work out how to name the worksheet. ----------------------------------------...