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

Brilliant!!! Ok, I have tried Johns code and it works perfectly!! This was a good one cause now (I think) I can also use this code to do the import, update and append of data for future imports. Thx very much!!

Thx all for the quick replies, I am going to try the sample code that was posted, I think this is exactly what I am looking for (yayy!!!!). Sorry for not explaining fully what this should be used for. I have made a dB that will store asset information that will be refreshed as they become to...

I allready have 23 queries that perform this function, in these queries I am using the Iff() function but I am becoming limited with the amount of Iff() I can run inside an Iff() function. I.e. Iff(Something Like Something, Something,Iff(Something Like Something, Something,Iff(Something Like...

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

Got it Working OK, I got it working

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

Where would I place this code if I where to have the control on a form?

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

All of it Sorry, I did not mean to be vague. I am building an sql string in vb, when I run the string I am prompted to enter values for the fields (I have marked these in red) that are supposed to be concatenated. I believe that I am using incorrect syntax and need some guidance on this. I...

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

Solution Found Well I have noticed that I have had quite a few view and no replies, is this a difficult one.... Anyway I also wanted to update on my own progress. I replaced the whole line with sCriteria = sCriteria & " AND qryMain.SPOC Like """ & cboSPOC & "*""" Where SPOC is the "As"...

Thx for a good post, I have a few questions though just to understand fully. 1. Could you write the sql without the round brackets? 2. Why use single quotes? 3. What would the syntax be if you had a field that was UserName: Form!FirstName & " " & Form!LastName (This is the way it looks if I...

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

Is it bad practise to do a "query of a query"?

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?