Search results

the event is on a subform field but it doies run when the user is using the main form I tried this with no luck [Forms]![ref_form]![Form]![ref_history]![USER] It cannot fiend the field form. My subform is named ref_history thanks!

The subform field named speciality calls out a macrolibrary item after the field speciality is updated set value command item - [Forms]![ref_history]![USER] expression - Environ("username") this subform is embedded on a main form

it does not like ME? confused

thanks dont really follow, my subform has a field named approve, when it is clicked the user name fills into the user field so if I am on the main form and want to create this macro for a subform a refer to the fields as ME.name? thanks

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 am using a new access DB to link to the tables but the linked tables keep getting stuck in exclusive mode.

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:

hi, maybe the attached screenshot helps?

no luck with the text box either, I will keep plugging away

I tried in the caption box on the report because that is where the file name comes form when exporting and it did not work? =DLookup("PHYSICIAN", "selected_specialist") I just lists this formula in the name of the report??

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

actually this works DoCmd.GoToRecord acForm, "pho_dir_qry_form_view", acPrevious, 1 DoCmd.GoToRecord acForm, "pho_dir_qry_form_view", acNext, 1

thanks I actually figured that out just now I understand normalization but this feature is a copy to next feature that is available in many health systems now and our users demand it. Plus, the DB is only 300 records

it does create a new primary key and we like to copy the same info over and just edit it as most of it is the same. It is not really a patient DB just trying not to divulge to much. If I perform this process now and then scroll back one record and then up one it works fine.

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

thanks it did the trick, I could not remember for the life of me as I don't really use Access anymore