Search results

I am running a query linked to a mainframe database. The Entered Date field is formatted like this: 2/14/2007 1:14:00 AM. I want to run my query to show all data greater than an entered date at 5AM. So I tried using this for a query criteria >[ENTER START DATE]+#5:00:00 AM# , but Access says...

Thanks for the help. The only problem with this is counting sub codes for major codes. For example, lets say in one cell I have (P2a, H4b, P3t, A2b). On my counts tab, in the cell that counts "P" (a major code), it also counts P2a and P3t as just P. This is because of the wild cards. I need...

On Tab 1 In column A I have a list of Event Codes that are exported from a mainframe database for plant events. Each row representes an event and may have several different event codes separated by a comma. For example in cell A1, I may have "A2b, C1c, P3f", cell A2 may have "V3n, E3d". Some...

Just reposting in hopes that someone can help.

That's kind of what I am looking for. One thing I don't like is that it appears you use a subform that looks like a table. I don't have a lot of experience with subforms, but can it look like the original form? Also, once you filter on a particular sequence, how do you get back to an...

I have a form frmIssues. This form is based on a Query qryIssues which is based on tblIssues. On the form, I would like to provide a means to filter what the form displays. The fields I would like to filter on incude cmbSite, cmbGroup, cmbStatus and cmbConsultant. These are all combo boxes...

The criteria field is [Forms]![frm_Main]![Mode_ComboBox]. So the critera looks to see what is in the combo box. I can add Like "*" to the combo box and it will not work. However add this directly to the critera field manually (instead of the code to look for what is in the combo box) and it...

Using Not won't work becasue that would exclude 1-5 and in the All I want to see them in addition to the other stuff. I am just confused why * will work in a query criteria field but not when called from a combo box. Jim

I have a report that is based on a query. In the query, I have a field called "Mode". In the criteria section for the Mode field, I am calling the selection from a combo box on a form called "frm_main". So the criteria for the Mode field is "[Forms]![frm_Main]![Mode_ComboBox]". This combo...

Sorry if I was not clear. I am building a query that looks at a table. Well actually it's a linked table. The name of the query I am building is qry_Committment. The linked table that the query is based on is called dbo_Committment. If the linked table is a problem, I could use a separate...

I am just getting back to work on this. What I have done is to create a Macro within Access. It's commands are 1. Open Report in Print Preview 2. Run Command: Export To RTF 3. Save 4. Close This works but my only problem is the default location for saving is "My Documents" It would be...

I appreciate your reply, but I am confused. Am I supposed to put this code into the Criteria field in my query for the field commitment_user_group_cd? This does not seem like the place to me but that's where I have been trying to make it work. I even opened Expression Builder for this field...

I have a query based on a table that has the fields as shown below. When I run the query, I will get a separate record for each group as shown below. prb_no | seq_no | commitment_user_group_cd 602 | 3 | ERC 602 | 3 | MCE 602 | 3 | SRG...

Thanks. I was able to get it working properly. Jim

Thank you for the help. I really appreciate it and your comments / suggestions. I was able to finish this project. Thanks again, Jim

Just posting a reply to see if anyone can help. Jim

Attached is a project I am working on. It's a personal reminder program. The problem I am having is that when I enter the actual completion date at the bottom and click on the "Complete Task" button, I want the record to be copied to the History table, then the Start Date and Due Dates reset...

Attached is a project I am working on. It's a personal reminder program. The problem I am having is that when I enter the actual completion date at the bottom and click on the "Task Completed" button, I want the record to be copied to the History table, then the Start Date and Due Dates reset...

When I move "=aadHandleButtons([Form])" to the VB window and use "Event Procedure" in the On Current event, I get error messages. Is there any other place I could put "Me.Combo135 = Me.ID" so that my combo box keeps up with the records as I navigate them? Thanks, Jim

I have several reports in my Access database and I have a LAN that I export these reports to so other groups at my site can have access to them. My question: Is there a way to automate this process? Specifically is there a way to automatically on a daily frequency, export specific reports...