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...
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...
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
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 = "something"
Set dbT = CurrentDb
Set rsT = dbT.OpenRecordset("table")
if rsT!strField = "na" then ....
I WANT to use a variable to reference the field name in a recordset -...
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 "Alert" 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 "CreateItem" 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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.