Search results for query: *

At my firm -we are trying to onboard thousands of accounts from an old system to a new system. A "traditional" conversion would be very timely and costly. One suggestion was to enter the accounts into our existing system - using the present WebBased interface. However, instead of people typing...

You, sir or madam, are a genius! I was wasting time and banging my head for hours yesterday. This will save a lot of manual work!! Thank you VERY Much!! :-)

I have a series (over 800) pdf files I need to take down from server site and save locally. I think I am 1/2 the way there with code below - just need to know a quick way I can Save the document as a pdf once it loads in the Browser window (I had assumed there would be a reference for the SaveAs...

Skins -- Did you get a resolution to this problem We are having exact same problem since migrating to XP o/s and Access 2003.

Good Morning In updating our users from Access 2000 to Access 2003 and W2k o/s to XP o/s we find some users do not have access to all objects within the existing MDBs This seems to be regardless of how the security level settings and Macro settings are set. In fact a user signed into their own...

You can use docmd.Quit This will Close the Application. In order to do this - make sure the Form Modal property is set to true - I.e. they can not set the focus to any other object. Before closing that window. Hope this helps

Thanks I will have to install the software as the file types can not be changed. The database form is used to view first page of a scanend image to assign indexing values before it is posted to our data warehouse. As it was a test amchine - it must not have the imaging software on it as yet --...

Good Afternoon We are preparing to update from Access 2000 to Access 2003 I am testing an Access FOrm with an image control that works fine in Access2000. The user selects a file name from a drop down box. Clciking a command button sets the Image picture property to that TIF file. However- I am...

That will work for my purposes. I added a new command button that will change between Zoom and Clip properties. THANKS!!

I am using an image control to view tifs to great effect. The utility allows users to add indexing criteria for scanned images.The user controls which picture to display with a drop down box (pointed to a specified directory) and a command button (used to set the picture property). However -...

Try adding this line of code: Call Shell(strPathtoViewer & " " & strPathtoFile, 1) Where strPathtoFile = <<full path and file name to your viewer, eg. c:\program files\Adobe\adobeviewer.exe AND strPathto File = full path and filename of the file to open.

We recently converted to Access2000. My Database runs queries and emails reports. Ran well 3 times - today I get this error when attempting to send email using the Docmd.SendObject command 2455 - You entered an expression that has an invalid reference to the property HyperLinkSubAddress. The...

I have Null values that I want to skip if the field is Null I have tried the following to no avail: If Recordset!Fieldname Is Null then ... ..aslo.. If Recordset!Fieldname = Null then ... Any thoughts? Thanks Tim

Thanks LittleSmudge -- just what I needed!!

This is perfect -- I thought I needed the ! character in there - but I don't -- you saved me much aggravation! Thanks Ken!!! -Tim RBC Dominion Securities

I have code as follows Dim strField as string, dbT as Database, rsT as RecordSet strField = &quot;something&quot; Set dbT = CurrentDb Set rsT = dbT.OpenRecordset(&quot;table&quot;) if rsT!strField = &quot;na&quot; then .... I WANT to use a variable to reference the field name in a recordset -...

Thanks Paul - this was perfect!!

I know Access extremely well - but not Perl or CGI. I have been given a last minute project where I must make a series of reports based off data given to me from a .cgi page.The web developer gives me a text file (pipe character delimited) - problem is it is 474 fields and Access is limited to...

No I did not -- I tried creating an email template - but had no luck with that. What I ended up doing was have the &quot;Alert&quot; message appear in Capital letters and three times in a row!! I used the vbCrLf constant to separate the alert message so it appears on 3 separate lines. Thanks Tim

I am using &quot;CreateItem&quot; to make an email object to send programamtically. I want to change the font to bold and RED. Is this possible using the Object references for the Outlook Object library? Any help would be greatly appreciated. Thanks Chett