Search results for query: *

Hi guys; First my expertise is data and report analysis using Access and Excel so building a web app is totally new to me. I am building a data driven web app in Access. I have been using Access desktop apps for a decade but this has never come up. The access web app will allow users to view a...

Hi all; I have an Access DB that I have copied from my workstation to a network drive for others to view the data. The tables in the DB are linked to a SQL DB. Users trying to open the data from the network get an ODBC--Connection to 'xxxx' failed. I have created the ODBC connection for...

Hi all; My Access DB is linked to a number of workbooks on a shared drive. I have reports generated by Access which summarize the Excel data however just discovered that if the source Excel worksheet is open, Access generates a blank report. Is there any way around this? THanks Rob

Hi all; Just wondering if I can link data in AD to an Access DB. This would be used for querying and reporting only not changing or adding any data within AD. I have linked to SQL databases and Excel sheets before - is it as straight forward as that? Thanks!

Hi all; I have linked an excel spreadsheet to my Access DB. I have created a query that runs properly however when I run the query or modify the design of the query, the excel sheet I am getting my result from also opens. Am I missing a setting somewhere? Thanks, Robert

Hi all; Here's the challenge I am facing. I need to use two aggregate values in relation to a form. One is to identify which records to display based on an AVG value of the Pass/Fail/Not tested choices using 1,2,3 as the numerical value. If the AVG value is 0 then the form can be...

Hi all; I am trying to retrieve an aggregate value from a query into a form. I initially tried to use the aggregate (count) in the query that the form is based on however it made the form fields uneditable. I have a table of users and apps. The count qry is to calculate how many users are...

Hi all; Just can't wrap my head around this so I could use some direction. Working on a Win7 deployment projet app test status report. I have a table with the "Master" App name (ie. Adobe Design Suite CS3) that has multiple modules (ie. photoshop, illustrator, design etc.) which are in a...

Hi all; Created a simple query from two tables. In trying to normalize the data I created two tables: One table has 17944 records - created by someone else with 12 fields. From that table I created another table with 17,944 records using only 3 of the 12 fields from the original table. When...

Hi all; Trying to display a variety of bitmap images depending on content of a field on the form. I have started with a green "go" light - if the field text is "Pass" I want the image to display - if the field is "Fail" or "Testing" I want another image to be displayed. Here is the code I...

Hi everyone; I am sending emails to about 3000 users asking them to choose a date for a software push where their machine needs to be logged on but idle to accept the software. They will have a selection of 5 possible date/times for their computer to be updated and must select one. I will be...

Sending emails from Access. Message body text is taken from a table as it is merged with data specific to the recipient. I cannot get a handle on the message formatting. The formatting I need is not complex, just need page breaks (although I would like to bold, change font etc). I used "text...

Hi guys - I sourced a send email form and code from BlueClaw on the net. I have had real problems getting the emails to send - it seems hit and miss - a couple times it worked perfectly but now it is saying there is an error in my code - .Send is highlighted when I go to the debugging screen...

Hello all; I am looking for experiences moving from XP to Windows 7 for 20,000+ devices. Can anyone offer some information or direct me to a discussion board so that I get some 1st hand accounts regarding processes and challenges? Thanks Robert

Hi all; I have read through a bunch of posts here and on the web however none seem to fit what I am wanting to do. I have built an email form that sends emails via outlook (thanks to a sample posting that got me started). Each email has information pertaining only to the recipient it is...

Yesterday I asked for help regarding how to achieve a carriage return when running an update query of text and merged data fields to a memo field in my table to use as the message body of an email. I used the & Chr(13) & Chr(10) & code and succeeded in having the text display propery in my...

I have a number of emails I need to send however I need to use OWA to send them out as I am not in the office which means I can't sign into MS Exchange. Is there a way to adust the MS Access default coding which appears when I create a "SEND TO" button on my form that will direct Access to use...

Hi guys; I have about 3000 emails I need to send via outlook (through exchange)using Access. I am wanting to use Access to populate the fields for To, Subject and Message personalized to the recipient and giving them specific information about their device serial number. No problem with...

Hi all; We are rolling out SEP to devices within a medical organization. The rollout has gone seamlessly until today. We have reports of SEP taking forever to allow devices to open images on CD or other removalbe media (diagnostic imaging is the department). I have googled this to death and...

Hi all; I have created a dozen thermometer charts displayed side by side in a single worksheet (if anyone knows how to put multiple thermometer style bars into a single chart PLEASE tell me). Anyway, I am trying to eyeball the width of the verticle bar but it just isn't precise enough. I have...