Search results

You can hit F9 to recalculate manually, or in VBA: [Sheet Object].Calculate

By the way, in my instructions to see if IIS is running: I showed you how to see if it's installed. To see if it's running, expand the node out and select 'Default Web Site'...you'll see the play and stop buttons in the toolbar area. (But I don't see why IIS would ever be stopped unless you...

Using VWD 2005 Express (2.0 framework)... I need to get a querystring from the URL as the value for a field in the INSERT Command. So far, I'm stuck. Any suggestions?

I take it you don't have broadband, Ken? I made a CD of Visual Studio 2005 Express, and I followed the directions on the MS page. It said you needed software to interpret the .ISO or .IMG file. I downloaded IsoBuster from http://www.isobuster.com/

To see if IIS is running: 1. Right-click 'MyComputer' & select 'Manage' 2. Expand the 'Services and Applications' node 3. There should be a sub-node for 'Internet Information Services' If the IIS node was not there, you need to install it: **Windows XP Home does not have native support for...

If you are talking about getting/setting the text that appears in a label: Me.MyLabel.Caption

Here's an easy way: You have a pic that corresponds to each rank, right? The text for the Rank field is on your report, right? ...rename your pics like [rankvalue].jpg to correspond to each rank. In your detail_format event, just write: me.image0.picture = "c:\MyFolder\" & me.RankField &...

Is the pic location field available to the report? This is what you need...so you can load the appropriate pic for each record (if I understand you correctly.) So, put the pic path field in the report's query and then on detail_format, apply the pic that matches each record.

The Upsizing Wizard in Access can do this for you, not sure if all versions are supported. I just installed SQL Server 2005, and it is far less compatible with Access than previous versions were. I didn't try the upsize wizard, but SQL 2005 won't let you build or alter tables from Access.

By all means... Here's an example from within an ASP page: <% Dim db_conn db_conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\wwwroot\Folder\AnotherFolder\MyAccessDB.mdb" Dim Rst Set Rst = Server.CreateObject("ADODB.Recordset") Rst.ActiveConnection = db_conn Rst.Source =...

So post your whole procedure and point out which line is getting highlighted.

do you have that wrapped in a With [object]....End With.

Yes, but as long as the first and last name are still in the table...why would you want to store their first letters in another field? You can get the initials any time you want with: =Left(FirstName,1) & Left(Surname,1)

If you are talking about the current user's Windows username, you can use Environ("UserName")

Please, anyone, correct me if I'm wrong...A combo box is a combination of a text box and a list box. If you want to take advantage of the combo box's functionality, why do you still need a list box? You can use the DropDown method of the combo box control in the form's open or current event...

Look here: http://www.mvps.org/access/api/api0038.htm The registry setting works. I don't think the LOCAL_MACHINE key change takes effect until after you log off and back on...to get it into the CURRENT_USER key. To get there, START/RUN/regedit

As you get to the bottom of the first page, starts to talk about CDO/SMTP.

Look here... http://www.access-programmers.co.uk/forums/showthread.php?t=101527 Post the code in your form's OnCurrent event. You need to add your path in front of the picture file name... Me.MyImageControl.Picture = "c:\MyFolder\MyPics\" & Me.txtPicPath)

Take a look at this post... http://www.access-programmers.co.uk/forums/showthread.php?t=28669

These intended users don't have any company email ability? Wow! Do they have computers? hehe That's a start. Do you have access to an SMTP (Simple Mail Transfer Protocol) server? If your company runs its own web server, it can be configured to handle SMTP mail. Otherwise, some ISP's allow...