Search results

I have form that has a combobox to select which record to use as current It works fine in except in my runtime version which creates a runtime error which I cannot debug do to the runtime environment.. Here is the code. Private Sub Project_Filter_Click() web8 = Me.Local...

I have a database that I have packaged using the package wizard. I have added the frontend folder location as a trusted site registry key to the package. I have installed this package on several computers with out any runtime errors. I have one satellite office location that gets a runtime error...

I have a form. This form has a subform. The subform has a subform. I am trying to write some code that gets a field value on the subforms subform. Me.AHJ = Forms![Project Details]![BLDG subform].[submittal requirements subform].Form![ASMPRE Submit to] I get an error Cant find the specified...

I am having trouble with report grouping with totals Please see the attached fscreenshots of what I have setup. Total is 52 Report shows 136 Any help would be greatly appreciated.

I have a report grouped by employee and in the detail section I have a field called [Work Code] what I want is If any records for a particular employee has "PTO" in the [work code] field in detail section, then omit the other records from the report for that employee except the one that says...

I have a report with some code in the Section "Detail_Format" of the many items in the code, one of them is to do a sum of some unbound textboxes in the detail section of the report. The problem is that the number always comes out doubled because the records are cycled throught twice. My...

So, I used acess 2007 to download the the Project Management Template Database. I then open the database in access 2010 and modified it quite a bit to meet my specific needs. I have access setup to save in 2007 format. However, I now cannot open the databse on a 2007 machine. It says I have an...

I am trying to create a query using the following code. Them problem is the joined field on one query is a 4 column combobox that is bound to column 1. Can't seem to make it work. Anywhere you see DPM1 in my code below is actually trying to pull the information of DPM1.Column(1) Can this be...

I have some code that builds an SQL string from data on a form. I now want to save this data as a query and open another form based on it. What is the code to save the string sSQL which is a select statement as a query? I have searched ans searched and can not find it. Thanks Rob Here is...

I have a master form. I have some code which copies the master form to a unique name and opens it. I do this becuase I want to have the form open more then once with different records loaded. Here is the code On Error Resume Next 'Delete the form in case it already exists...

OK, I have the following code Dim joblen Dim jobroot As String Dim activeRoot As String Dim lclRoot As String joblen = Len(Me.Enhanced) joblen = joblen - 11 activeRoot = Me.Enhanced activeRoot = Left(activeRoot, joblen) Sometimes when the code is...

I am using a web browser activex control on a form to display the files and folders of a given path like windows explorer. Is there a way to get the filename of the the user selected file in the control? Thanks in Advance for any help.

I have a combobox with the which is a lookup and the rowsource is as follows: SELECT [Contacts Extended].ID, [Contacts Extended].[Contact Name] , [Contacts Extended].[Business Phone], [Contacts Extended].[E-Mail Address]FROM [Contacts Extended] WHERE (([Contacts Extended]![Category]="DPM"))...