Search results

Hi All, Well I'm getting quite into vba now...not any good, but its addictive :D I'm trying to write a little procedure that checks for the existance of various files in a directory. The files will be stored in different named folders dependant on month i.e. jan, feb, mar, etc. What I want...

Hi Guys, Well I'm bumbling along with my vba and have had some success (mainly due to the patience and indulgance of fellow members:p ). However I have a hit a problem with the Dir function, I know I must be wrong but I would really appreciate somebody showing me the error of my ways. I'm...

Hi Guys, Here's my problem...well the IT related one anyway :D I have 10 text files that I want to append into one file before I import into my database. I think a batch file is the best option for achieving this, so how do I create one? I know this is a bit wide of the mark in terms of...

Hi Guys, Just getting into vba and I have the following problem: I have written the following code whose purpose is to look in a directory for specific text files and import them if found, if they aren't there I want a msgbox to appear telling the user which files are missing. This works fine...

Hi Guys, I have a table full of names and address's that I want to de-dupe. How do I find instances where Name, Addressline, Town, County, Postcode are identical. Not duplicates individually but the as if all were concatinated together. Any idea's? Cheers, Tommy B:p

Hi Guys, I am soon to start a new job (hurray!) and my first task will be to look at their marketing/leads database. Basically what it does is take a list of address's from mail-outs and promotions and match those address's to the actual sales, thus enabling them to measure the relative success...

Hi All, Been a while since I posted Things have been going well...but am now stuck Here is what I need to do... I have a table with circa 400k telephone numbers in it. These numbers have an analysis code next to them which is the first 6 digits of the number, thus enabling me to group...

Am trying to use above function to return a list of CallID numbers but when I enter the following in my select query it keeps putting the expr: in front of it? How do I add this as a selection criteria? InStr([CallID seperated by commas,Blank=All],[CallID]) Help me please!!!

Hi Guys, Been a while since I posted so I hope you are all well Here's what I am trying to achieve: I work in telcoms and need to design a report that shows me the minutes for a set of telephone numbers over the last nine weeks for trend analysis. So basically it looks something like this...

Hi Guys, Hope you can help me out What I am trying to do is identify duplicate records and delete them from my master table. I used the wizard to create a duplicates query, it returns the two duplicate records side by side (in actual jfact about 45,000 records side by side!!!)Now what I...

Hi Guys, I am just moving into the realm of vba and could do with some help! What I am trying to achieve is this: I have a form called onenumberformtest, this form displays a table called "Rates Table". The field [Client Name] is a combo box and feeds from a table called "client standard...

Hi Guys! Hope someone can give me a clue on this one I want to design an update query that references a set list for its update options. What I have is a list of telephone numbers, I am using Between [] and [] to grab the range to update, but what I need is for the next few fields to have...

Hi Guys! Its a while since I had a post...life has been quite ;-) But that never lasts long at work does it! So here is what I am trying to do: I work in telcoms and need an automated system for provisioning new numbers. What I need is a two table system, the first table uses an autonumber ID...

Hello All! I really hope someone can point me in the right direction here!!! Basically I have a report that has various summed footers and then a report footer that gives grand total. When I exported this into Excel it appears as a subtotalled spreadsheet with the footer cells as sum...

Hi Guys, Hope you are all well! Here's a funny glitch I have noticed with Access 2k. I have just convereted my '97 database to 2k and when I export an access report into Excel 5-7 format the calculated cells are lost!? The subtotalled breakdown appears as normal...but as I said...no totals...

Hi Guys, This is probably really ez but I am a relative novice at report design! Basically what I want to do is produce a report that has no spaces between fields e.g. value1 ,value2 ,value3 etc. to appear as: value1,value2,value3 etc. As always any pearls of wisdom are greatfully...