Search results for query: *

I want to use the Multi Select function in the list box for a filter in a query, But as soon as I select Simple or Extended my query comes back blank. If I leave it at None, I can select a value as use it in my filter to run a query. I know I have data in the table I am trying to query against...

I have a pivot table built in Excel that is built from an access DB. I need to find a way to Update the Data tab, but not the Pivot tbl tab. I have logic that deletes all tabs and creates new work sheets, but I can't get it to only update the worksheet I want and leave the other work sheets...

I have VB that allows me to email a valid email eddress like jsmith@xxxxx.com, But when I enter a DL group it doesn't find it in my address book. Do I need to put some code in that tells it that it is a DL and not a simple Email address? Has anyone ever done this?

I have a form that lets the user pick their selection from valid fields in a database from a qry that runs behind the form (basic Combo Stuff). But I want to allow the user to be able to select Multiple values at the same time by using the Ctrl button. I am working in 2007. I thought it was just...

I have two fields that I want to put into one in a date format. I have a number that looks like this 20080404 and string that looks like this 201535. I want to combine the two create a data time field that looks like "4/4/2008 20:15 PM" can anyone help me with this. Thanks

We are currently converting from Lotus Notes to Outlook express for our Email program. I have logic in place that uses Lotus notes to email reports out of Access, But does anyone have logic for outlook express? I will attach my Lotus Notes logic. Also has anyone else ever used any Mapi logic to...

Our client wanted a huge report, one that involved us creating 12 to 14 subquerys. The only way to get that many into a report would be to have it span more than 1 page, But I can't get the overflow reports to go onto page two? Is there a way to do this with Cognos 7.3?

I have Main Qry with overall Customers data that is linked to a sub qry with detail information about the same Customer. The main qry is set up to be able to scroll through all my customers using the VCR buttons, but when I scroll through the Customers in the main qry nothing changes in my Sub...

I have a report that opens a from with prompts as soon as the user opens the database. My problem is sometime I need to look at two differnt inputs and sometime I need to look at only one.I use the form to input the users request into a query to run their report. I can get it to work If I enter...

How can I restore a main query once it has been deleted, but still has sub queries that are now not updating?

I need help with formating text field like 0800 to a date field like 08:00:00 AM in a access qry. Can anyone help me with this?

I have a Access database that is auto updated with a text in a date field.I need to run a query off of this data, but I need to change the field in a query and not the table itself. If I change it in the table, I will have to change it again anytime I want to run it. The table is updated...

Is there a way in a crosstab report to get the Blank (Null) values to be populated with a 0 instead? Here is an example of what I mean. OArea EAST SE MW WI IL/PL SW EAST 10 4 3 75 20 SE 18 10 5 MW 4 12 2 WI 4 14 5 IL/PL 44 20 10 25 SW 15 5 15 I have tried the...