Search:

Thank you. I will try that. I have used this technique in the past but not in the context of buttons.

I use the following code in a menu button to open a report.
The boss wants to see zero data even if the data does not exist.
Thus, I use an update query to reset “Dummy Product” date values to a...

The problem accessing the VB code window has reoccurred. I tried uninstalling software that had been installed recently.

When I uninstalled Directory Opus, a file manager, and rebooted, the VB...

I just checked with our computer service people and they have not done anything to my computer.

Must be magic! Huh?

I took a couple of vacation days. Now that I am back I can get into the VB editor. I had emailed our computer service group the messages in this thread.
Maybe they made some changes while I was...

Thank you very much for your input Hans.
I will check with our IT people again with this information and will post the results back to the message board.

On my machine I can access the Visual Basic editor in the Office 97 products, but not any of the Office XP products.

I have been using both Office versions for quite some time now on the same...

Yes, I have administrator rights on this PC.

I have had IT reinstall Access XP.

I still can not get to the code window.

When we first installed access yesterday afternoon, logged on under the technician's ID, we created a new database...

Yes, it also happens in a new database. I will try reinstalling Access 2002. Thanks.

Recently I lost the ability to view the code in my Access XP databases.

I also use A97 and am still able to view/edit code.

When I try to create code, open the code window or view code of an...

Thank you Hans. Your help is appreciated. I will look into the system tables. I forgot about them.

No, I am not trying to work with XML data. I am reading a book on SQL and they refer to the property Schema.
Evidently DB2, Oracle, MySQL, & SQL server have a Schema property.
So, I thought that...

How do I determine the Schema name of a database? Is it the name of the database?

Also how do I find the properties of a Schema.

I searched Access help.

I need it on three network drives as the drives are located in different cities and the response time over the networks is quite slow.

I was planning on using just an Access backend, but since all...

Thank you for your input.

I am abandoning replication in light of new events. The other editors are physically moving to my plant site so that keeping records synchronized is not the issue that...

This is my first replication project. I chose trying replication for the following reasons. The users are spread over three plant locations and the response time connecting to a drive that is...

Thank you Hans. That is what I was afraid of.

I want to view multiple pages of a word document in the Slide Show.

If I insert a Word Document only the first page is inserted. I would like to have all pages inserted.

How do I do that. ...

Oh boy! The only thing that may save this is that there are infrequent updates to the data, only by 2 or 3 people. The database will be used mostly by users searching the data and the number of...

I read some of the articles on replication on trigeminal.com.

My application is to use an Access97 backend for the data (all the tables) and Access 97, 2000, & XP frontends.

I plan on using a...

Thank you for your response. I have bookmarked the page and will check it out.
The problem was that I had typos in the address.

Yes, that works. All I needed was another "" in the first address. I also found an error in the second address, the file extension was "md" instead of "mdb.

I tested it and it worked!

Thank...

I am creating a button to replicate backend databases from the frontend. Since users may map to the drive with different letter assignments I have tried using the network addresses.
Access thinks...

Thank you once again Hans. I had forgotton that I had put that invisible text box in the header.