Search results

Awesome. Sample 1 did the trick. That escaping and what not really confuses me. Thanks.

I need to figure out how to use multiple criteria on a DCount function to check two colums based on a query. The function is your typical: If DCount("MemberID", "tblEnrollment", _ "MemberID='" & MemberID & "'" ) I need to set in the Criteria basically: Form Control = MemberID (In...

I think it has to do with my criteria. My query is based on several tables and MemberID shows up twice; in the tblMembers table and tblEnrollment table. I think if I can define it somehow I can correct the situation. I've been trying : MemberIDTable = rsc![tblEnrollment].[MemberID] And no...

Well it almost did the trick. It won't let me add new records either, even if they aren't duplicates. I've posted below what I'm using and a screenshot of the query. Private Sub cboSelectMember_AfterUpdate() Dim db As Database Dim MemberID As String Dim MemberIDSearch As String...

Try this: Private Sub CopyToSpreadSheet() Dim objExcel As Excel.Application Dim objWB As Excel.Application Dim objWS As Excel.Worksheet Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("YourQueryNameHere") Set objExcel = CreateObject("Excel.Application")...

With environ("Username") are you using the text or are you using the Numerical value? Also, are you going across Windows versions?

Haha, airforceruss is always glad for airforcedad's help! I'l mess around with the string. Right now I'm just collecting the information in an unbound form using text fields. I'm just seeing about moving that data that is collected to a nicely formatted email.

Yeah, I just found that. Messing around with it now, so I'll probably create a report and send it that way. Thanks!

I am looking to create a command button that will email both the username and computer name to a specified email address so that I can send a small database to each person and they can email me back with their username and computer name so there is no error and I can then input that information...

I might add that I am able to now select a starting point when printing on a sheet of labels and also specifiy how many individuals I actually want to print on a sheet. This allows for not all of labels to be printed on each time.

The number of labels wasn't the issue. It was that I basically had several columns in a table and I only wanted certain columns to print. I ended up just creating a label and then creating a fair number of Switch and IIf statements on the fields in the label and it ended up doing just what I...

Turns out if I use the following syntax it works correctly: .Slides(index).Shapes.AddTextbox(msoTextOrientationHorizontal, 10, 10, 700, 40).Apply

Along with the help of Alan Cossey, I was able to successfully integrate the vPPC security method which essentially allows for Group Level permissions on a database in the accdb/r/e formats. Really cool little application. It has a Security application (Access DB) that allows for permissions...

Turned out I needed to use: DLookup("OptionValueTxt", "tblOptions", "OptionType = 'CurrentFEVersion'")

Good EVening - I need to set the criteria in a DCount to make a column = "CurrentFEVersion" in my options table but I'm not sure how to reference it. Does anyone have any suggestions? Thanks! strFEMaster = DLookup("OptionValueTxt", "tblOptions", [OptionType] = "CurrentFEVersion")

Awesome. This snippet did the trick. Thanks!

Adam - Thanks a ton. That did exactly what I was looking for. I appreciate it.

All - I'm attempting to validate data being entered by using a DCount to check if a record exists that matches data and I would then like to check each entry that matches for a value in a particular column. I have sample code that checks if there is a number of records that match which are...

All - Just as the title describes, I can't seem to find a solution to be able to link the front-end to the back-end tables through the common file dialog when the backend is an accdb file that is password encrypted. See the example attached. Here it should work just fine per the Article at ...

I need to convert the following string of code into a Public function to place in a module and integrate with I believe Bob Larson's Front-End/Back-End Common Dialog Database Table Linker sample. Apparently the Office 12.0 objects reference in 2007 allows for the open dialog to be used a lot...