Search results

Hello, I'm trying to add a new record to a different database than I'm in when a button is pushed. The following code is this: Dim db As database Dim rs As Recordset Set db = OpenDatabase("P:\BU Regeneration\XRF Laboratory\chemistry.mdb") Set rs = db.OpenRecordset("chemistry"...

Ah, yes. Seems that works good. Will use if it comes up again! Thanks guys. P.S. Buildcriteria can be a very useful function

I have a SendObject function on a report that will convert the report to a PDF and attach it to an email. However when a co-worker obtained a new computer with Windows 7 on it, (everyone else is using XP), the SendObject function doesn't recognize 'AdobePDF' as a format type anymore. I'm not...

It's alright, turns out I can change the name of the control without too much of a fuss. Thanks for tryin

Buildcriteria() is a built in function and not a function I created, so it's not calling a public function. The variables used are the ones listed in the function. An example of me calling on Function projectyear() is Private Sub AIG_Click() If Me.AIG = False Then Me.all = False End If...

Not sure what you are getting at... The control name that is having problems is "RND". I have other controls named "SCR, REG, ENG..." It works fine for them. Doesn't work for RND. It definitely is within the BuildCriteria() function because everything else works. What I get when it runs "RND"...

Here it is: Public Function projectyear() 'for rptProjectYear sWhereClause1 = "Where " ssql1 = "SELECT * From qryprojectyear " For Each ctrl1 In Screen.ActiveForm 'this function will loop through each control that is a checkbox except for me.all If...

I'm using the BuildCriteria function to develop an sql to filter a query on a subform: for each ctrl1 in Screen.ActiveForm .... sWhereClause1 = sWhereClause1 & " or " & BuildCriteria("Project_Scope", dbText, ctrl1.Name) .... This will produce "Projectscope = 'REG' or Projectscope=...

Nobody knows how to change a picture ??

Yes possibly, but there should be a way to change the picture using "mycommand.picture = " easily. Just not sure where the picture is saved at in Access or how to call on it.

I have a button that has the picture "Sort Ascending" which was chosen from the given list of pictures in Picture Builder. When the button is clicked, I want to change the picture to "Sort Descending", but I'm not sure how to call on this in VBA... Any ideas?? Thanks

Yes, works fine. Thanks.

Ah, yes Bob. I've thought I've tried that before and but it wouldn't let meformat an unbound textbox.... Oh well. Thanks.

No, it's just the textbox is in the header, which has a small height, and adding the calendar would expand the area, which I don't want.

That would be a way to do it, but there's no physical room for it on my form, visible or not. That's why I need some sort of pop-up.

How do you guys address this problem.... There's no room to keep the calendar on the form at all forms. Anyway to create the activeX calendar object on the fly when you enter into a textbox?? And then once changed/updated the calendar will be deleted/closed/invisible??

Is it possible to attach a calendar to a unbound text box, like there is for a bound text box, where when you click on the textbox a calendar will pop up?? Seems like there should be... I also created a new pop up form with just the ActiveX calendar object on it but can't get the "On Update"...

I have posted this at the end of my last thread but I wanted to ask it formally to better a response. I want to retrieve the full name of the user when they enter my database to greet them and to use else where. Assuming Microsoft Outlook is open, is there anyway to retrieve their name?? I...

like... Dim olapp As Outlook.Application Dim mailoutlook As Outlook.MailItem Dim msg As String Set olapp = CreateObject("outlook.application") Set mailoutlook = olapp.CreateItem(olMailItem) mailoutlook.sendername .. or some other property..

Yes that works. I also found this that finds it also. But I want to retrieve the full name of the person. When Outlook is opened, it automatically opens to the username of the user logged in (as in most cases). Anyway to pull the full name from Contacts or other area in outlook with knowing the...