Search results for query: *

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

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

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

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

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

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

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

hello. I have a large word document that has a lot of pictures in it, and I wish to delete them from the document. Has anyone got a sub that will do this (or can quickly whip one up)? I've got one that I use to remove headers and footers but I cannot figure it out for pictures. Many Thanks...

Hello. Sorry for the waffle you're about to read, but here goes... I am trying to perform a lookup on a range of data, looking at 2 sets of criteria. I have a list of client reference numbers on sheet1, and on sheet2, I have a list of all the transactions for the clients with a transaction...

Hello. I am trying to figure out how the stock level in the products table can be updated when a quantity is entered for a product in the order form. I am playing around with the Northwind database trying to figure it out. Can someone give some code to do this using the details below...? The...

I know this one has been asked here and there, but I jst cant figure it out, so perhaps somebody can answer it tailored to my situation. I have a combobox where I want to choose a caetgory, and then have a second combobox update with only the items under the chosen category. For example:-...

Hello. I use a sub to take out all the headers and footers of large documents (to reduce file sizes), but I want to be able to do run this on all word docs in a particular folder. Or maybe on all open documents. Can this be done with VBA....? This is what I use to strip the headers and...

Can anyone help with this...? I want to run a sub to delete all the headers and footers in a word document. Each header has a logo and text in it, and each footer has text. Thanks in anticipation. mudstuffin

I have a powerpoint slide, which has 9 bullet points on it. I want it to bring up a relevant comment (about 30 words) to each point when the mouse is dragged over it. I also want the comment to hide when the mouse is moved off. I was thinking about popping up a userform, but I cant figure out...

I am building a ‘quiz’ game in excel, which asks 20 randomly chosen questions from the list, and is run from a userform. It all seems to work ok, but now I want to store the players high scores in Sheet2, which are to be updated at the end of the game. How can I do this so that it adds the...

can anyone help with this one. I have a workbook that has a hidden sheet with a large amount of data in it. The user inputs data into a sheet, which pulls the neccarsary data via the vlookup (thanks xlbo). What I want to be able to do, is when the user clicks a command button when they have...

I am trying to use VLOOKUP to return data from a different sheet. However, the data I need to look through takes up more than the 65,000 lines in in one sheet. Can I put part of the data in one sheet, and the rest in another (or maybe another two columns in same sheet) and then use the VLOOKUP...