Search results

How would I get the numbers of the rows to delete though? I would need to delete all but one instance of the account number.

chergh - I need to do this all in VBA as it will have to be done multiple times.

I have a file which has account numbers. There are duplicate account numbers throughout the sheet - 2000-3000 rows of information. I want to write a program which will find all the duplicates, mark them for deletion, and then remove the rows. I can do everything except find the duplicates. I...

Okay - nevermind. I deleted the query and recreated it exactly the same way and it works perfect now. :confused:

Here is the code that I have so far: Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim strVar As String strVar = [Forms]![frmDateSelection3].[QueryDate].[Value] strSQL = "SELECT * FROM qryCustInfo WHERE ((qryCustInfo.[Date Entered System])=#" & strVar & "#);" Set db =...

Yeah I could create a combobox with distinct values of initials that accounts are assigned to, plus a "*" option so if needed they could open all records - otherwise they would be working with just theirs. I think that might work out better - just use that combobox to set the recordsource.

Accounts are usually assigned to associates who work them, and then if they finish their part, they assign to another associate. They usually bring up a form filtered for accounts assigned for them. Though they do sometimes need to look through all accounts to answer customer questions if an...

I'm not sure how to go about that. You would have to have a recordsource setup at some point, whether it be in code or the form.... For one process we have about 650 records which are open (many more that are in archived state). They need to have access to all of them and be able to filter by...

I'm not sure what you mean by using unbound forms. How would I do something like this?

I pretty much always use queries for form recordsources. Most forms are pretty basic. There are only a few which are more complex. Users will only have access to the forms which are for their processes, so they can't just open anything.

We have about 170 employees here. Currently we have probably 10 or so databases - they are Access based. I am working on a project to combine the 10 into one - there will be some duplication which is removed due to having them all centralized (date entered/completed fields, user initials...

You will have to delete all of the links to the talbes, then manually link them again to update the password.

Probably because you get in a habit with a With statement of doing: .Blah .Blah .Blah .Blah .Blah etc. :P

CountR = .RecordCount You're trying to assign a value to RecordCount, and you can't.

You shouldn't store that information. You can get it through a query, which will always be up to date, no matter what changes are made to the main table. Storing that information is redundant because it is already stored. Do a search for access totals query on Google, I am sure you will find...

Create a totals query. Put the Team Name field twice. In one, for the Totals option do a Group By and in the other do a Count. That will show you the Team Name once, along with the count of how many times it appears. Why would you want to store this information?

How are you doing the export? In a query or SQL you could do soemthing like: IIf([fieldname] = "TRUE", "YES", "NO")

Custom built. Intel 3GHz Quad-Core CPU 8GB RAM 150GB Raptor Main HD (OS) 2 x 500GB HD's in RAID 1 (Data) 2 x 300GB External HD's RAID 1 (Backup) Vista

haha...yeah I should have counted backwards there eh? Just wanted to quickly put in a smartass reply here though :P

Private Sub RevString() Dim intLen As Integer Dim strBuild As String Dim txtString As String Dim i As Integer Dim x As Integer txtString = "This is a string." intLen = Len(txtString) x = intLen For i = 1 To intLen strBuild = strBuild & Mid(txtString, x, 1) x = x - 1...