Recent content by Superock

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