Search results for query: *

I am attempting to add a total on my report footer line containing a count that reports whether a check box on each detail line generated by the report has in fact been checked. I am trying to use the COUNT function in my Control Source, but am somewhat confused as to the syntax required to...

I am trying to open a specific .PDF file from an Access (2010) command button. Can anyone help with this? Any help would be greatly appreciated.

What I would like to do is the following: During the report exection I would like to change the font weight of a given report item, based on the value of another report item. This would be done on a line by line basis. Example: FIELD1 FIELD2 FIELD3 12345 ABCD (bold)...

My last question for today. Everybody here is so helpful. I need to sum a column of times on a report and display a grand total on the report footer. Sum hasn't worked for me so far. The times print as follows on the report: 1:00 0:30 0:15 1:30 I need to total these. As always, any help...

I am trying to determine elapsed time using the function listed below. It works fine until the time crosses over into another day. I am trying to execute this function from an Access Query. I need to pass the starting date and time and the ending date and time, however I am having a problem...

What I would like to do is display a final report total in a text box, but not one that would simply use the SUM, or COUNT functions. I have a series of line items in a report, and on each detail line is a CHECK BOX. I would like a total at the end of the report that reflected a count of only...

I am using a simple formula to keep a running total in a column. Presently, the data is displaced as follows: $150,000.00 $123,000.00 $121,000.00 $121,000.00 $121,000.00 $121,000.00 I would like to hide the duplicate values in this column. In other words, eliminate the last three references...

Is there any way to surpress the printing of blank lines in an Access report? Any help would be very appreciated. Thanks.

I am trying to total a check box table column for all rows that are in fact checked. I am using the query wizard in this way: Field: Column Name Table: Table Name Total: Sum Sort: Show: Criteria: True I am getting the correct numeric result, however the result is apprearing as a negative...

I need to set my local PC security settings to a status of LOW. Does anyone know how to do this? Thanks for any help.

I am trying to find the best way to accomplish the following: Enter a value for determining changes and deletions just once. i.e. 999 Msgbox here, no problem. Next, using the value 999 find a specific record and move null values to specified columns of a table record. Next, using the value...

I'm trying to execute MS Word and open a specific .doc file using an Access command button. If anyone has any ideas on what the VBA code looks like to accomplish this task, I sure would appreciate it. Thank you.

I have used the Like function in the past, but I can't find any format reference within Office Help, nor on the Microsoft website. If anyone can help, I sure would appreciate it.

Can someone please help me with evaluating this Excel formula? I understand what MIN does, but am confused as to how AE29:AF29 operates. I am not a big Excek user, but and trying to help a friend figure this out. Thank you in advance. Formula: =(MIN(AE29:AF29))

I had setup a MS Word doc to receive data from an Access query. Everything was fine until the other day when the Word document stopped responding. I then took the original form letter and tried to setup everything again using Mail Merge just as I had before. Everything goes fine until I try...

Is there a way to incorporate Access data fields within a MS Word document, then print out a series of documents within a loop based on the Access data. Example: Print a series of form letters, with each letter containing a different name and address from the Access table. Any help would be...

I was attempting to set a reference in VB 6 and could not access it due to the following error message: The registration database for your system has been corrupted. The reccommendation was to reinstall VB. I uninstalled, and then attempted to reinstall. The install blewup because it said...

Any help here would be appreciated! I was attempting to set a reference in VB 6 and could not access it due to the following error message: The registration database for your system has been corrupted. The reccommendation was to reinstall VB. I uninstalled, and then attempted to reinstall...

How can I hide a column in MSFlexGrid at runtime? Any help would be appreciated.

I am attempting to send myself an email with an attached Access report. I am using the folowing code: DoCmd.SendObject acSendReport, "ReportName", "SnapshotFormat(*.snp)", _ "emailaddress.com", , , _ "Test Report", , False The code...