Search results

Is there any way to easily scramble the data in there so that it is not exposed? :S

My head is exploding trying to work out how to get a query to update. It is based on a many to many relationship, from a database that someone else designed. So already, it hurts! Is it possible to upload the database here, so someone could take a peek and tell me why I can't add a record...

How do you do a virtual machine? Is that extra software I need?

I've already got Office 2007 installed on my PC, but also want to have Access 2003 on there too. Is this possible? Thanks, Dave

By the way, there is something else related to these queries I would like to do. On my Switchboard, I would like it to display the record count for this queries output. How would I do that?

Oh dear! Don't worry, you helped me out big time. :)

I never knew that before. That helps a lot, with this problem and many other queries! Thanks. :)

Thanks Brian. I think the problem I have is that I am not quite sure how I do the filter Criteria, because if it is a field I just want to filter by, what do I put in the Total row? Do I just leave it as Group by? If I do that, won't it group by just a filtering field?

I have two tables: 1. ActivityLog: ID, Customer, Date, Activity, Details, ContactSuccess ( 2. Contacts: ID, Company, ContactFirstName, ContactLastName I want to create a Query that filters records on only the last Date in the ActivityLog table for each Customer where Date>45 days ago AND...

I am thinking of creating some Microsoft Access databases for commercial sale. I have some concerns though. 1. Do I need any special license from Microsoft to sell Access databases as a stand alone unit, without the customer needing to purchases a license or have Office installed on their PC...

Thanks for the max/min explanation. That really helped. It has let me show the correct first 3 columns. However, I am having a problem with the last column, Odds. I want to show the first 2 columns grouped, the next column showing the max date (all working up to this point). But how do I display...

I have 3 fields: EventID, Selection, LatestTaken, Odds - all sorted in that order in Query1. Then, I have a totals query called Query2. This is based on Query1. It contains EventID (Group By), Selection (Group BY), LatestTaken (First), Odds (First). Am I correct in thinking that this will...

Cool, thank you! :)

Would I just add i=DoEvents between each section where i is an undeclared variable?

Would this work? Private Sub cmdSave_Click() Dim strFile As String Dim strA As String Dim strB As String Dim strB As String strA = A strB = B strC = C strFile = "C:\Documents and Settings\Dave\Desktop\" & "A-Data" & DefaultID & "-" & Replace(Time, ":", "-") &...

I have 3 memo fields and want to output 3 seperate text files with the contents of each memo field. It will always be the same memo fields. Currently, it works fine for just one of my memo fields but I want to expand it to 3.

I have some code that outputs a single file but I want to modify this so it outputs multiple files. Currently, my code is: Private Sub cmdSave_Click() Dim strFile As String Dim strA As String strFile = "C:\Documents and Settings\Dave\Desktop\" & "A-Data" & DefaultID & "-" &...

Is there a difference in the max character storage capacity of an Access 2007 memo field compared to Access 2003? Thanks, Dave

Thanks, I will play around with that.

Sorted now. Thanks for tips!