Search results

Hi, I am using Access 2010 and Windows XP. I have a form named MasterForm and a subform linked into the MasterForm named history_subform I am tring to get this to work like in 2003 Set Value Item = [Forms]![MasterForm]![history_subform].[Form]![LastUser] Expression = GetUser() Gives me an...

We have recently upgraded to Access 2010 and have a DB developed in 2003. The email send object does not work anymore? Any ideas? thanks

I have been running an Access database since 2007 that emails results to users invoking the send object commend in access. I have been using access 2010 and opening the db in a 2003 version. Ever since my PC was changed to a newer pc I cannot email anything form access anymore. It states send...

We finally converted and have an Access 2003 database we use. Before, when users when into a form we restricted them to form or datasheet view and now they can go to quick access toolbar and add design view and change the DB and delete records from it... not good... any easy solutions?

We finally converted and have an Access 2003 database we still use in the old version due to the amount of macros and VBA used in it.\ We have had 2 issues. Before, when users when into a form we restricted them to form or datasheet view and now they can go to quick access toolbar and add...

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...

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 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:

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...

Hi, I have a form (parent table) and a subform (child table history recs) The subform enters the user name into a field in the subform when a field has a data entered into it. This macro works fine when you run this form stand alone. When you run the master form with the sunform embedded, the...

I have 2 databases that run the audit trail which works great. My new DB links to a table in my first DB which has the audit trail. Both DB's are shared but when one person opens the new second DB it locks out an other users? I cannot seem to figure it out!! help!:confused:

I have a converted macro that runs a query to pull out 1 record with a name that I want to use as the caption of a report for outputting to .pdf. macro 2 below converted to VBA. I want to take this result and add to the caption of my report that converts to .pdf below named email macro. I...

Hi all! I have a copy button on a patient entry screen that allows the user to copy the record in current view to a new record. When the copy is made it appears Access does append a new row and key to the table. However, when I start to edit the new record it reverts back to the original record...

I have a form with results in datasheet view that I export to excel. In the Access view standard numbers are formatted with no decimal places but 2 decimal places are added when it exports to Excel. In idea how to preserve formatting? thanks

I have a column with a full name as follows. DRISCOLL MD,EDWARD F I want to split into 2 columns. Anything to the right of the comma would be first name and anything to the left would be last name. I would not include the comma in the new columns. thanks!:confused:

I have 6 queries that are audit reports of data. I have a batch file that opens MS Access on my PC once a week and emails these 6 query results to 2 users. Many times the results of the queries are empty. What I want to do is only "send object" (email) to the user if the results have data in...

We have a shared Access DB on a shared Network drive. Can I restrict certain users to read only when they open the database? thanks

Hi, I have a form where a user enters value that gets entered into a table. I only want to allow the form to allow the user to only add one record in the table. Can tables be defined to allow one record entry? The problem is they enter the value and hit the enter key and the value goes blank so...

currently I have a form (based on table) with specialties listed with check boxes next to each label example: cardiology, check box GI, check :confused:box etc... Currently, the user clicks the Cardiology check box and then hits the command button which runs a macro that will open the report...