Search results for query: *

Good Morning, I have been trying to figure out how to send gmail using vba in Microsoft Access. I feel like the below code is correct as it's the same on every tutorial, instructions and research blog that I've found over the past week. I feel like I'm missing something else that I should be...

Hi everyone, I have tried researching this and watching videos for a week now, but my brain hasn't been able figure this out to save me. Any help is appreciated. I have a simple program that will be designed for keeping up with documentation on employees (tardiness, verbal warnings, recognition...

Good Afternoon Everyone, I'm using a query with a lot of calculated fields. The stumper for me is how to calculate a date difference between the current record date and the previous record date within the same record set. query name: qryProjectionEventsAll record set: PROJID (Linked to Main...

Good Afternoon Everyone, I have a form which includes an image to appear behind lines that I drew for a chart (x and y coordinates). I can manually set the image behind the drawn x and y lines, but I can't figure out a way to automatically send the image to the back after an image is added. The...

RE: ACCESS FORM Is it possible to base a chart strictly on unbound form fields? I've created a form template which allows simple calculations, using (2 columns with 12 rows) equating to 24 unbound fields, that I wish to chart. The unbound field calculations work perfectly; however, I'm unable...

Hi Everyone, How do I calculate the time difference between two date/time timestamps that are in the same field, but use different codes. The fields are linked by the same event number. For example: EMS arrived at the hospital (incilog.transcode= "H") at 02/28/2017 15:00 (incilog.timestamp...

I'm trying to create a formulated field that will display the record delivery status, so that I can filter the status for reporting. This formula appears to be working as I'm creating it in the expression builder; however, when I go to the datasheet view it shows "#error". Can anyone see what I...

I found two formula's that allow you to concatenate detail records and I tried using it on group records and it works... Except it doesn't reset for new records; it just continues for ALL records. When using this to concatenate group records, does anyone know how I can reset it to start over on...

Can anyone tell me the right way to make the following loop through multiple search words. (Ex. Search1, Search2, Search3, etc.) Right now, it will only search the text using 1 search word. Shared StringVar SearchText := {@SEARCH1} ; StringVar Htm1 := "<font color=#FF0066>"; StringVar Htm2 :=...

I have received an excel spreadsheet that someone converted over from another program. It contains information for one person in multiple columns and rows. I would like to convert this to show only one persons information in one row, so that I can sort and filter the information. Does anyone...

This is just a curiosity question for anyone who has time. We have a huge database with hundreds of different available tables. For example: Incident Reports Table Arrest Table Accident Table Field Contact Table Citations Table Each table has hundreds of availabe fields to use in an...

I work for a jail and I am trying to create Superior Court List and State Court List from our Record Management System, but I can't quite figure out how to word my formula to make it pull correctly. For example: Each arrest has a unique system id (armain.armainid) that can contain multiple...

Somehow, I have removed my menu navigation bar from across the top of my program (file, edit, view, etc...). I can't figure out how to get it back. Any suggestions. Thanks, Kim

I have an OLE object in the details section of my report; the report returns all of the correct information. It filters out the last two pictures (OLE Objects) associated with the file name. The overall report returns good; however, just for appearance and space purposes. Does anyone know how...

If anyone can help with this problem, it is very appreciated. I am using 2 tables in my report: nmmain (the master name table) syinvl (system involvements) I have all of the nmmain fields in the header; this is the most current information (name, address, phone, etc..) Then I have the...

In the past, a blank report could be created by selecting "ODBC", choose the Data Source Name, click finish and you would automatically have the tables to choose from. Recently our IT Department moved all of the database information from one server to a completely new server. Now, when you...

Group 1 header: {lwmain.caseid},{lwmain.reportdate},{lwmain.casedescription} Details Section: {lwcase.status},{lwcase.statusdate} I would like to conditionally count {lwmain.caseid} based on criteria from {lwcase.status}. For example: There is only 1 Case Number {lwmain.caseid}; however, it...

I asked a previous question about highlighting search words using a parameter search word. I was able to find the following code which works perfectly for highlighting my parameter search word as a formula ({@SEARCH1}), but I have 10 parameter search words that I've converted to formula's...

I would like to know if anyone else has figured out a good way to highlight "search words" in their reports. I am using Crystal Reports XI. I had to convert my notes section into a string. The following is how I find reports with the desired information: IF INSTR (UPPERCASE({@NOTES})...

I would greatly appreciate help if anyone has suggestions to my problem. Key Word Search by Name Id (number) In my file each record may contain one or more related name id's (number). I want to search the report by name id (number); however, I want it to pull all name ids related to the same...