Search results

That worked perfect!! thanks so much

I have a form that shows totals in several unbound text boxes. For example in my tMwvEvnt Table I only want to count records whose tEvntType =1 so I use =DCount("*","tMwvEvnt","tEvntType = 1") and it works great. But I also need to count the records where "tEvntType" = 1 and "tFacility" = 1 I...

O man... I usually am using Access, but this is excel!! So Sorry to do that! I guess I need to repost in excel.

So I often build a file name and then open the Application.Dialogue(xldialoguesaveas).show option to allow the user to make any changes to the file name that they need to make, however, I can't get the code to open the specified directory. I found a snipit of code that is supposed to work for...

Wow!! Thanks to all who helped! And I do appreciate the recommendation to remove names and extensions. You guys are the best!!

When someone accesses the DB, it checks their user name against a list in my VBA Code using Select Case. I am trying to move that list of users to a table that I can then add and remove users without having to change the code each time. I created a table "tUsrAth" with one field [UsrAthID]. I...

I would like to save an Access report to disk, but each user may save their files in a different folder, so though I create a default name for the file, I would like to open the windows standard SaveAs file dialogue window, paste the created file name as the default and then wait for the user to...

I have a query that can accomplish this process by prompting the user for input of the type and dates, but it provides no means of picking from the list of values in the EvTypes table. I guess there must be a way to filter a form by a query too. But if someone knows the syntax to pull these...

Thanks for the samples, they are great. But I would still like to know how to join these two techniques into one filter. Is it possible? Also, sorry about the pasting of the code. I wasn't aware that there was a feature to paste code.

I am not familiar with this concept. Could you expand or give an example? thanks so much! :)

So I have a form that I need to be able to filter by a range of dates and by a selected value in a multi-select list box (actually using only one value at a time) vStDate and vEndDate are unbound text boxes tied to the Date Picker in access. tEvType is a look up field that that gets its values...

Great thanks!!

I am trying to send an email to everyone on a form. When I open the form it asks for the Appointment date. The form then shows all people with that appointment date. I use this code and it sends an email to the first person in the list. The query (qApptPickTm) that uses a "Between [Start...

I have a form that is a logbook providing a consecutive sequence for tracking samples sent to an outside lab. The main table and associated "Enter Daily Send Outs" (table is tSendLog) form track the actual event. (Who what when where why and how. See attached image) The sub form embed in the...

Now I just need to figure out how to read each entry in the subform and if the tSOType is <3 and the ISNULL(tSODate) then highlight the Record Details Button red.

Was able to get the highlighting using Conditional Formatting and placing them in the following order [tSODateRet]>0 highlight color white [tSOType]<3 highlight color pink Seem like conditional formatting processes them in sequential order.

I have a form that is basically a logbook that provides a consecutive sequence for tracking samples sent to an outside lab. The main table and associated "Enter Daily Send Outs" form track the actual event. (Who what when where why and how. See attached image) The sub form embed in the...

Thanks everyone. Also I found out that you can convert a macro to VBA automatically from the tool bar. It is interesting to see the code that is auto generated. If you try this, I would suggest, make a copy of your database so you have all of your original work.

Hey team, So sorry to be so confusing for everyone. But here is the solution written in VBA instead of as a macro in the field afterevent proceedure Me.Filter = "tSpecCode = " & Nz(Me.luCode,0) Me.FilterOn = True In the main form Current event procedure to synch the two values enter...

Yes, the Table that the form uses for it's data is normalized and there are several lookup fields on the form tProvider, tpathologist, tDateSF525 and tSpecCode. Staff would like to be able to select the value L or DM or any of the specific codes that are in the tSpecCode drop down list. Once...