Search results for query: *

Hi there, I have exchange 2010 but I also have two or three POP email accounts that I use. The POP mail has it's own SMTP address, and mail is delivered to a different store. However, when it tries to send my pop mail says that the Exchange Server is offline and therefore cannot send... Very...

Hi everyone, I have a small/medium business that specialises in IT Training as well as training room hire. This means that we run our own training courses but we also hire out our facilities to outside clients. Some of these clients run their own online courses, requiring very fast, reliable...

Hi there, I am trying to retrieve information from Business Objects into an Excel spreadsheet, using VBA. I'm aware of (and am currently using) the export option. But ideally I'd like to use an ADODB Recordset, or something similar to grab the results of a report in Business Objects into a...

Hi guys, I'm trying to write code to retrieve a file from my clients ftp server. If I do it manually, I do the following: 1. Open up the command prompt 2. Type FTP proxyserver 3. Enter my username and password 4. Connect to client site by entering "user username@clientFTPSite.com" 5...

Hi there, I have an application of hundreds of Excel macro files that all reference one central excel file. This central excel file acts like an add-in. If I make changes to this main file it could have knock on effects on the individual macros using it. I would like to be able to run some...

Hi there, I am using Access 2002 ADP and SQL Server 2000. I am using a disconnected recordset which is being used as the recordset of a form. Through code if I write to the RS then on occasion it doesn't display this change unless I use the RS.update feature. Under normal circumstances this...

Hi there, I'm having quite a big issue with my ADP at the moment. I have a disconnected recordset that is created when the form opens. The form's recordset is set to the disconnected recordset. The user starts adding a new record. For my date fields I don't allow manual entry because of...

Hi there, Do you know if it's possible to have a recordset (perhap a disconnected one) and be able to create another recordset based on a select of the first one? i.e. dim FirstRS as new adodb.recordset firstrs.open "Select string",connection etc etc Then I'd want to do something like this...

Hi there, I've read a couple of posts about disconnecting recordsets and then running the batchupdate method of a recordset. Only trouble is this doesn't work for me! If I do the inserting and editing through code it seems to work, but this is what I want to do: 1. Set a forms recordset to...

Hi there, I have got my adp database working perfectly with the AllowBypassKey property. I have a main form that opens automatically, and when it closes it sets the property to false for when the user next opens the db. Here's the problem though. If the db is taking a little longer to open...

Hi there, I've experimented using CDO programming in Access, but it doesn't seem to work in an ADO Project. Using someone's name I need to access the details stored in the Outlook Global Address List for my contact. Namely, the Alias, as that stores the users login name. I am able to display...

Hi there, In Access I am wanting to create a spreadsheet and save it over an existing spreadsheet kept on the server. But I'd first like to check if someone else has this original file open! Cos I don't see the point in going through the creation of the spreadsheet and only afterwards finding...

Hi there, I am using a disconnected ADO recordset. It opens as Dynamic, and I add records to it through code. Once it's done that I would like to make the recordset read only if it has been marked as locked in the data. Does anyone know how to change the CursorType of a recordset AFTER it's...

Hehe... Does my subject make sense? ;0) I need an adodb.recordset to grab data from two separate tables using a typical join. But when this recordset is created it refuses to allow additions to it (although I am able to edit existing records). I'm not interested in the unique table property...

Hi guys, I'm hoping someone can help me out here. I've been working on a particular form for a few days now making changes to the how the form grabs the data. I've been changing it to be disconnected - a public adodb.recordset that feeds the form. This has all been working a charm until...

Hey, Does anyone know how to view/modify the connection string connecting a project to a sql server database? When I first set it up the wizard asked me a few questions and connected up, but I'd like to perhaps change servers, or modify the connection a bit. Any help would be appreciated...

Hi there, I am working with an example stored procedure (will type it out below). The procedure inserts a record into a table and then theoretically returns the ID number that it created when it inserted the new record. I can get this to work just fine in the Query Analyser screen - it runs...

Hi there, Does anyone know how to grab what the @@Identity value is once you've run an append query and use it in VBA? I'm guessing at this point I'd have to use a function to do the append and return the @@IDentity? Thanks, Leanne

Hi there, I'm trying to figure out how to make my ADP faster. In access you had to set the row source of a combo box at runtime so as to prevent the mdb from taking up precious time populating the combo boxes when you first opened a form. i was wondering whether it was the same with ADP...

Anyone have any clues about what this is talking about? I have an access database with an access backend using a security file situated on the server. Each user gets their own frontend and they all link to the backend file and the security file. Everyone else is working fine, but one PC is...