Search results for query: *

I want to create a do loop in a recordset where I want to change the field that is being updated from Field01 to Field02, Field03 etc. on each loop. rst2.Edit rst2!Field01 = intUpdate rst2.Update I've tried a few things like setting a variable to replace the Field01 so that the code would...

I have several inventory items such as Tshirts that have various sizes and colors. Instead of creating a separate item code for each one, I would like to create only one item, identify it as a matrix item and be able to track the quantity on hand by size and color. I know a lot of programs...

I found out that the problem was that I had MS Office XP installed in some of the computers and that this is why it wouldn't open the list in datasheet view. You need to have Office 2003 and run SP2. After that IE will properly prompt you to run the ActiveX control needed to open up the...

I have seen several questions on the sharepoint site regarding an inability to view a list in datasheet view. Since I have several computers I have been able through a process of elimination to identify the problem. On the computers where I am able to open up the datasheet view correctly I...

I just don't understand this, but I thought the whole point of being able to publish these forms onto sharepoint was that other users would only need their web browser to enter the data in the forms. I've been playing around with infopath too and found they worked beautifully on my machine...

I hadn't used Safari before I read this post, it is excellent, and they also have a complete video instructions for a sharepoint administrator, I found it even better than the pilothouse series.

Pilothouse consulting has a pretty good training DVD on sharepoint 2007 for Administration and Development

I have a routine built in to my Access application to send an email using Outlook, does anyone know first hand if this routine will also work with Outlook Express?

I understand all of that, however I come back to my origial question I just need the code in my front end A to be able to shut down front end B in case it is open before the backup process begins of the back end. This is an application that is in 30 locations and the backup process is working...

The back end is a third database. I have 2 different front end applications that link to the backend. When I do a backup of the backend I want to make sure that the other front end application isn't open.

I need to make sure another frontend application is closed before commencing to do a compact and backup of my database backend data. The front end where I have my backup routine is called VC.mdb and the front end that I want to make sure is closed is called SMP.mdb. So how do I close SMP.mdb...

I want to create a paper cut on a EPSON T88 thermal printer in code. The printer manual has the following code for doing this in Visual Basic, however when I try to run this in Access VBA I get an error that the variable "Printer" is not defined. Printer.FontSize = 10 Printer.FontName =...

If you are having blank pages print in between pages I have usually found this to be a result of the report being too wide for the specified paper and margins. If you are building the report with a wizard try to fit the report within the established format. My reports on portrait type paper...

Jakhan: From where (or what program ) do I run the script Cscript synciwam.vbs, this is obviously a program that won't run from the command line. I

Thanks littlesmudge that worked pretty good. I'm always amazed by how many smart people are out there. Have a nice day.

I need to copy a table from one backend database (Source) to another (Destination) from my frontend. I tried using CopyObject but it only allows me to set the destination database and not the source database. Since the table that I'm copying is a linked table to the front end when I ran the...

I have an application that has 2 backend databases that I would like to consolidate into one. Basically I'd like to know how I can copy the tables from one of the backends to the other. I tried using the CopyObject command from the front end but this only allowed me to set the destination...

Thanks so much to both of you. I never knew there was a FileDateTime function in Access.

I have a backup routine that compacts and zips the backend before opening an application. This process can take anywhere from 2-5 minutes. I would like to be able to check the zip drive file to see if a backup was already done today and if so skip the compact and backup routine, however I do...

There are also several third party applications built in Access to integrate with Qbooks. Look in the intuit website.