Search results

Could someone please point me in the direction of some websites where people share their databases? I have searched on the web and have not seen any other websites where there are just databases for download. I am looking specifically for a Incident/Problem/Change mgmt database that conforms...

I have been working on a dB that helps us track and replace assets. Our current process has been to create xls spreadsheets, send a spreadsheet to a specific client co-ordinator for a group and this person would validate all the data on the spreadsheet, making changes where needed and also...

Hi I have this expression that I built and it does not seem to do what I want. IIf(Not ([ImportConsolidated]![Comment]=[tblAsset]![Comment]),[ImportConsolidated]![Comment]) Also tried: IIf([ImportConsolidated]![Comment] Not Like [tblAsset]![Comment],[ImportConsolidated]![Comment]) What I want...

Hi all, wonder if you can help out with the code to update table data. I have a table with multipule columns, what I have to do is go through each Field row by row edit the data based on the value inside. I have a rough idea of pieces of code that I have to use to achieve this, I just do not...

I have a form with various fields, two of these fields are "Date Purchased" and "Lease End Date". When there is no value entered originally, I have made a default value of 12/30/9999. The problem is that when you open the form and these two fields are next to each other, the user says it...

I have been asked to add a button to a form that will be an "Update" button or add the functionality to the form that when a change to the record (On the form) or any data on the subs has been made that the user is prompted to either except the change or not. The form I am using has multipule...

Hi all, I am building a dB where I will need to export to excel, then send the spreadsheet to a client who may or may not make changes to the data and/or add completely new data. The spreadsheet will then be sent back to me to be imported back into the database. I know for changes to the...

I am creating an sql string, so far all is good except for this part, If Me![cboSPOC] <> "" Then sCriteria = sCriteria & " AND qryMain.tblSPOC!PrimeFirstName & ' ' & tblSPOC!PrimeLastName AS [SPOC (Single Point of Contact)] Like """ & cboSPOC & "*""" End If It is supposed to utelize the...

When you export a qry to Excel, is there a way to make the Column heading the same as your caption. When I export now I get colum heading FirstName, Lastname where I would like to have First Name, Last Name

I have created a form with two sub forms on it. On the main form I have 4 combo boxes which I use to pass params to the first subform, the first sub is then updated with the appropriate records (This is done to minimise the records the user woul see) and then the second subform would be used to...

I have created a dB with a Front End and a Back End. The front end only holds forms and reports, the weird thing is that when a user uses the forms and then closes the dB later the size of the front end increases. (Significantly) Any thoughts?

I have created a relational dB (picture included of layout). When I try and create a query and include tblAssets and two or more tables that is in a one-many relationship with tblAssets linked by the AssetId field I can not update any records in the query, wheter it is through a form or query...

I have a table with a AssetTag field, this has to be split into two fields. ServiceTag and NewAssetTag The current format of an old assettag looks something like this: XX11111111 or XXXX1111 or 11111111 or 11111111XX Where X=ServiceTag and 1=AssetTag I would use Left, Right but the lenght...

I have created an update query, there is a "Floor" field that in the original table lists the building and the floor as a single value (SCC 1st Floor). I can easily remove the building code with a left function, the problem I have though is that the spaces between the building code and...

Hi all, I have created a dB to track assets and the implementation of new assets. The data is located in a flat .xls file which i have imported into my dB as a flat table. I want to move the data from that table into the respective relational tables and keep the relation. Aaargh, how do I do...

Ok, so I now know how to import data from a spreadsheet to access. Private Sub Command0_Click() DoCmd.TransferSpreadsheet acImport, _ acSpreadsheetTypeExcel9, "Sheet1", "C:\Temp\Table1.xls", True, "A1:C11" End Sub 1. Can I add to this code to append the data to a existing table? 2. Is there a...

Hi all, I have been asked to create a simple database for tracking assets. This would have been a fairly simple task if not for the data that I have to import into the dB that I still have to create. Before I create the dB I need to figure out how to get the data into it. So far I have 2...

Hi all, I have a table with field Username, the format for the Username is Smith, John A. Not all names have a middle name and some even have a Title. What I would like to do is split these names into separate fields. FirstName, MiddleName, LastName, Title I have used the Left and Mid...