Search results

Hi guys, I'm sounding like a right newbie when asking this... I have a VB6 project that mail merges with MS Word 97-2003. Now we have office 2010 and the code doesn't work. I've tried googling all afternoon with no avail. The data source is a txt file with delimited data generated from the...

Hi, I know!...We have an MS Access db in Version 1.x. A word document points to this db for mailmerge data. I've upgraded the version to MS 97 and it works, but when I upgrade it to MS Access 2000/03 it raises the error message 'Unrecognised Database Format'. Error 3343. (I've tried all the...

Hi guys! I have a front-end (FE) linked to a back-end (BE) db. I have added a password to the BE, but the knock on effect is that the FE won't work now. Just says 'Invalid Password'. I'm using MS Access 2002. Any help would be appreciatted. (The password is to prevent unwanted users from...

I have looked around forum but cannot find any info on this. I'm basically upgrading from MS Access Version 2 ( . . I know!) to MS Access 2003. Here's what I'm trying to do: 1. Loop through a bunch of files (MS Access Version 2 *.mdbs) in a Sorce Folder and capture names in an Array. 2. Create...

All I am trying to do is import a Report from one MS Access db into another. When I do this I get the following error: "Path/File access error :"\VB4.tmp" Press okay and then I get this . . . "Name conflicts with existing module, project, or object librabry. Press okay and then I get this . ...

Hi there! From the forums I've seen this error occur on forms. Unfortunately this is happening in a report! Worth noting that the db was converted from Acc 97 to 2003. Steps so far I've tried: 1. Created a new Report with all new controls, then referenced the data source from the control not...

Does anyone know the dll I have to reference to use the Regular Expression object? Many Thanks

Hi Guys, I'm using this connection string below. strConnection = "Driver={Microsoft ODBC for Oracle};Server=ServerName;uid=UID;pwd=PASSWORD;" But I keep on getting this error.: [Microsoft][ODBC driver for Oracle][Oracle] Any ideas?? I have created a DSN with the same parameters and using...

Hi, I know (and use) the code for using a DSN already setup on a user's PC. But, does anyone know how do it it without the DSN alredy setup in VBA to an Oracle db? Many thanks.

Hi guys, I've had this problem before. The debug window will open and stop at a line of code even though it has no breakpoint. Any suggestions please. Thanks.

Hi, I have this bit of code that tranfers a file into my Access 97 Db: DoCmd.TransferText A_IMPORTFIXED, "ARCCAND.DAT", "CandidateIn", gstrImportDir & "\ARCCAND.DAT" The last time I ran this was under NT. It doesn't work under XP now though. Any clues? Many thanks

Hello, I am using Access 2002. I have an MDE front end that links to a db on the server. The back end db memory size is around 10MB at the start of the day. At the end of the day it gets to about 60 MB. I compact it in the morning and it goes back down to around 10MB. Would anyone have any...

Hi, Does anybody know how to import a custom Menu Bar from another db please? Thanks

Hi, Does anybody know how to import a Custom Menu Bar from another db? Thanks

Hi, Does anybody know how to call a module in a subform from a totaly different form please? Many thanks

Does anybody know how to call a module in a subform from a totaly different form please? Many thanks.

Ciao! (Access 97 Prob) Backgorund: I have a main form "Form A" with a subform "Form A1". The subform allows users to add Candidates for a certain test. I have allowed a button on "Form A" that will show a new form "Form Z" that lits all Candidates already in the db. The idea is that when a user...