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 included the required references in the package wizard I believe. I will take another look.

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 got it. It was a typo. Thanks for the quick reaponse and the links. I am going to keep that one around.

So i looked at the link you posted and found this Forms!Mainform!Subform1.Form!Subform2.Form!ControlName Which equals this Me.AHJ = Forms![Project Details]![BLDG subform].Form![submittal requirements subform].Form![ASMPRE Submit to] Which gives me this error Run-Time Error '2465'...

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

OK, I changed the lookup in the table to a text field. Now when I change the value in the combobox on the form, I get a number in the field in the table instead of the bound column data in the combobox.

My combobox is on a form and it is from a lookup column in a table(which is bad, bad, bad I guess)

When I create a query, how do I specify which column it returns?

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

Thanks to all. That will help me out alot. The last programming I have done is in VB6.0, but I am able recreate almost everthing so far in access. Cheers,

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 do not. I do have a subform that is loading. I am not making a copy of it first. I wonder if that is it.

I have read these articles and that is not what I wnat to do. That is whay I am making a copy of the main form and then opening the copy. I am just curious why the other copies close when nothing told them to.

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

The word "Left" is what gets highlighted. I think I found the fix. Option Explicit at teh top of the module.