Search results

maybe the illustartion below would help.. Function Macro11() On Error GoTo Macro11_Err DoCmd.SendObject , "", "", "", "", "Select * from email list qry (all emails will have a comma after each line as a seperator)", "", "", False, "" Macro11_Exit: Exit Function Macro11_Err...

I want a user to be able to click send email from my switchboard and have the utility do the following. In the BCC: line I want to import all email based on a simple query first and then they can fill out the rest when the new email screen appears. We have Access 2003 and it does recognize our...

thanks but this actually makes the search slower, right now when the form is opened it opens directly to the name field and does a look in this field, match whole field and searches all, when the box is unchecked it takes about 1 second to search 55k records, with it is checked or the suggested...

is there a way to auto uncheck the search field as formatted in Access 2003? it speeds up searches ten fold when not checked and users asked for it to be auto turned off thanks all!:confused:

We have an Access DB linked to a view in SQL Sever 2005. The date in the view is formatted as 2006-09-08 00:00:00.000 I want the user to be able to use a parameter in Access to select records based on date ranges using the between statement. I have tried a bunch of different ways but nothing...

I just got it to work. It takes so much longer to run than hardcoding the dates, Anyone ele get this issue when connecting to SQL server 2005 using access? thx

I just tried that also but a pop-up box keeps coming up. The date range is in a where statement in a group by query. SQL below and date line bolded, it must be a sytnax thing?: SELECT Sum(dbo_MEDICAL_CLAIM.AMT_CAP_VALUE) AS [CAPPED AMT], dbo_PROVIDER.FIRST_NAME AS [PCP FIRST NAME]...

I have multiple queries that keep prompting for the same date range. So what I want to do is store start date and end date in a table and then call those dates in each query. How do I call the table values into a query? something like Between table date1 And table date2 thanks!:confused:

I just figured it our by multiplying the formula by 100 to get a percent - thanks for your help!

a is 6 b is 2 the total is 8 I want to divide a / total I still get 1.00?

it keeps coming back as 1.00 Sum ({report_qry_crystal.units_a})/Sum ({@total}) 6 / 8

It has been many moon since I used Crystal. I have a basic rpt. Column 1 sums unit_a in the report footer field = 6 Column 2 sums unit_b in the report footer field = 2 I gave a formula in the report footer field to get a total of 8 units I want to divide column 1 total of 6 by the total...

thanks so much I new it was a syntax thing but it has been 7 years since I did any of this stuff. thx!

towards bottom named, 13 from bottom Last_updt_user

I did that in the macro for the one I sent [Forms]![ref_form]![ref_history_subform]![Form]![USER] Am I missing something? thx

will this fix the macro issue?

1. I will fix 2. Demographivs are pre-loaded and not editable for our users

here is the DB with 1 test record - thanks again

I tried renaming the subform also see attached screen shot

it states it cannot find form [Forms]![ref_form]![ref_history]![Form]![USER] the subform is named ref_history