Search results for query: *

Thanks for your replies. Yes, I totally agree. Seperate sheets for each month although easier to navigate around, is a real nightmare for any analysis. The workbook is not mine, but I've been asked to help automate it a bit. I think instead of trying to work out the poorly designed workbook...

Hello. I have a workbook that has seperate monthly sheets for customer transactions. I need to calculate the number of unique customers across those sheets. The customer reference is in the same column on each sheet. It looks straightforward to do it on a month-by-month basis, but some...

Any more suggestions on this - I'm still stuck and totally baffled by it? Philosophical and slightly witty comment to follow here....

Hello PH. Thanks for this. I tried that, but I get the same result unless it is because I'm not doing it correctly. I also tried putting that into the button that manually refreshes the form (to test if I was doing it correctly) and that refreshes the same as the requery method. The subform...

Hello. Can someone help please?! I have an Access form with 3 subforms on it. On there I have a button to add a record to a table a listing of which is shown in one of the subforms. However, when there are about 8 users logged on, it doesnt update the subform with the record after clicking...

If you just want to disable the printing, you could put Cancel=true in the beforeprint event of the workbook. This will stop the printing from the menu or CTRL 'P' Private Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True End Sub You could include a msgbox or change the status...

Thanks for your reply. I did try the Move Method and I couldnt quite get it to work with that - although I cant remember why! I reverted back to the SaveSentMessageFolder way and put it in a different place which was just before the 'With objMail'. This did the trick as it is now working. I...

Good Afternoon. I have a form in an Access 2002 database with a button on it that generates an HTML email based on the information in the current record. When the user clicks send on the email, I would like to have this mail moved to a specific folder in a shared mailbox so everyone can see...

In case after over year, you still have the problem, try a compact and repair. I had the same come up and this sorted it. Regards, mudstuffin

Hello. I hope someone can help with a query I have about a query. Here is the SQL for a query I am trying to run in an access db. It is not updateable. Can anyone tell me what I am doing wrong? I need it to be updateable. SELECT tblCRESTdata.CRESTcaseID, tblCRESTdata.[OUT-REG-NO]...

Hi. I have a form in a db where users log-in, and if they get their password wrong, the form sends an email to me using docmd.sendobject (if they havent got outlook open, it opens it up invisibly). This then leaves an email in the users sent folder in outlook. Is there a way that I can have...

Thanks for that. I thought I did try that, but had another go after you suggested it, and hey presto, its sorted it. I put:- Me.Parent.Requery Me.Parent.Refresh in the delete event of the subform, and placed it before the dcount, otherwise the delete event seems to pull data before its...

Thanks for that TheAceMan1. Tried that but still not working. Doh....! Maybe I need to change the way the dcount is getting the data i.e. its taking from the table, maybe I should run a query, then requery afterupdate event or something like that, as it seems that the data is not updating...

Hello. I am building an access xp db for my sports club which holds information about the matches, players, finances etc. Within that I have a form with a subform on it which lists each match and I add in who played in that match. On the main form, I have a textbox which counts the records in...

Hello. I have a form (Form1) in an access 97 db, and I have embedded an excel sheet in the form (OLEUnbound14). In the sheet I have a range of data (DRangeNames) I want to be able to perform a vlookup on the data range to look for the string "greg" for example, or the contents of the text0...

Anyone got any suggestions..?

Hello. I have a form (Form1) in an access 97 db, and I have embedded an excel sheet in the form (OLEUnbound14). In the sheet I have a range of data (DRangeNames) I want to be able to perform a vlookup on the data range to look for the string "greg" for example, or the contents of the text0...

I want to log changes that a user makes to a form by using the transfertext method. I see from the help on this that it refers to exporting from tables, but can I do this from the data in the text boxes on the form? I was thinking of using it with the beforeupdate and afterupdate events to log...

Thanks for the replies. I'm afraid Its gotta be in Excel, and I need to return all of the matches as I need to be able to track the history of those matches. My lookup sheet handled the 65k rows ok as I am only doing 40 lookups. The data is sourced from an external access database using the...

I have two data ranges that I need to look for up to 10 instances of the same match and return the values in the next columns. I can get the Vlookup to check through both ranges to find the first match, but I can’t get it to return the next instances of the next match. I have two data ranges as...