Search results

What am I missing here????? As an example - I have a table called tblMatters in my Access backend. My Access front end links to it and it is used by lots of queries etc in the front end and all works perfectly. Now, if I upsize using the SSMA then the table name is shown as dbo.tblMatters in...

Namliam - your code could be used to change the table names in Access but I don't see how that would help me. Unless I can stop the problem happening in the first place then I would need to change the table names on the SQL server back end, not on the Access front end.

Apologies if this has been covered before, but I can't find the answer, so here goes:- I have a large A2010 multiuser application with a standard front end/back end split. I need to upsize the data to SQL Server, mainly due to database size. I've run the MS Server Migration tool and it works...

Thanks for reply. I tried cobbling together a little code, which appears to work without error but does nothing. Any thoughts? Function FixAllForms() Dim accobj As AccessObject For Each accobj In CurrentProject.AllForms Call FixDatePicker(accobj.name) Next End Function...

I can't find the defintive answer to this - is there a smart way to disable the data picker for every field on every form in my application - without doing it the long winded way of manually turning it off for every field? Thanks Dave

No. If it was then the error would be "can't find file etc"

Yes, I created a .dotx for the purpose of this experiment. We have hundreds of existing templates in Word 2003 and they are all .dot and when opened they create a .doc. I'm trying to do the same, using the same code, but trying to create a .docx from a .dotx template, and it fails.

I have used Automation a lot to programmatically create documents from word templates. This worked fine in Office 2003. It was still fine using A2010 plus Word 2003. Now I'm trying to upgrade to Word 2010 and I'm getting an issue I don't understand. Here's a simplified code fragment: Dim...

I recently upgraded a largish A2003 system to A2010. The conversion to .accdb has gone very well. Now I want to tackle word templates and documents. Part of the system creates Word documents based on templates and using Automation. In A2003 this has worked perfectly for years and still works now...

Thanks Mihail - I was looking for something that would be fully automatic for the customer, so perhaps something that would work with a command line. I will keep looking Dave

I know it's a long shot, but, in A2010 I'm trying to convert a series of Word doc files into pdf, BUT then assemble them into one large PDF. It's for a sort of archiving system. Can anyone think of a way I can do this, preferably just using the PDF capabilities within Access and without...

When the database is locked down there are no ribbons or menus visible. When it is unlocked they all appear. When it's unlocked I can right click on forms and tables etc, I can rename them, I can export them and so on. I can even select copy - but nothing happens And that's the problem

Not sure what you mean in your first sentence. The object browser is only visible once I have provided a backdoor password which takes me into what I believe to be full design mode, but turns out not to be quite right. And that's the problem. Yes I can copy it away and fetch it back it just...

In A2010 I maintain a database originally created in A2003. The original version was locked down tight. In A2010 I struggled to do the same but got there in the end, as well as allowing me a back door way in. Now I have an unexpected problem - in the object browser (or whatever it's called) on...

Thanks Pat - all done. Completely removed Office 2003 Pro, rebooted, installed Office 2003 standard followed by Access 2010 32 bit full version. All errors gone, and my machine now mirrors my client's set-up except that they have Access 2010 32 bit runtime. The reason they have this lop-sided...

Pat, when you emphasize the word COMPLETELY what do you mean. Is there something over and above just removing a program in the normal way that I should be aware of?

On a Win 7 64 bit machine I recently upgraded Office 2003 32 bit to 2010 32 bit. But I then had to downgrade it back to 2003 - long story. Today something suddenly triggered an error condition suddenly such that if I start any Access program on my desktop I immediately get the famous error...

Thanks Gina I'm checking out late binding but I'm encountering a few issues. My program probably contains 50 or so references to early binding and I'm just working my way through. In the meantime if anyone can suggest another way I'd be only too happy to listen. My current favourite strategy...

Until yesterday - I maintain a client database created in Office 2003 Pro but the client machines have Office 2003 standard but with Access 2010 runtime. This worked fine. Yesterday I took the plunge and upgraded my machine to Office 2010 Pro. I gave my client a new version of the front end...

A thousand thanks CJ - worked a treat. I tend to use the "long" way of writing dates as it saves confusion with the old American month/day/year issue, and Access understands it perfectly