Search results for query: *

This is driving me nuts! I have a simple form with a two tab tab control. I have another tab control form that I need to embed in the first tab of the main tab control. I have done this successfully multiple times but for some reason I cannot create a new tab control inside the main tab...

The subject pretty much says it all. I need to be able to export a query to an Excel spreadsheet but I can't have it drop all characters above the allowed 255. Please help with either a workaround or direction to make this work. Thank you in advance! The code that I am using is as follows...

I am using the following code to rename a report when it sends the object in an email. The issue is that if there are more than two words in the VendorName field it drops the last letter of the vendor name. eg. The saved file name is "PO 15-1192-1r0 Prysmian Powe 20151120.pdf" in lieu of "PO...

I have been using the following code to email a report after changing its name. The key is that it takes the first two words in the vendor company's name and truncates the rest. The issue is that if the vendor has as a comma in their name the name violates the MS naming rules and cannot be...

This is probably the most basic question but I am stumped. I have a table for cost codes, a table for purchase orders, a table for freight costs, a table for budgets and a table for time sheets. Each of the tables has a Project Name and a Cost Area and Cost Code. I want to create one query...

Hello... I am trying to add an access report to an email using the .attachments.add method but I would prefer to not save the attachment outside of access. I am getting the "Object variable or With Block Variable not set" error. Any help is greatly appreciated. My code is currently: Private...

All, I am trying to run some code that splits a Contact Name field into two separate fields. This is what I have so far. I don't usually manipulate data this way so I am stumbling around. Your help is greatly appreciated. Excuse the table and field naming methods... This is a very old table...

I have an access database with several forms. I need the users of the database to be able to use the MS Speech Recognizer but any time that it is turned on, Access locks up. Has anyone ever ran accross this issue? I am looking for a library, reference or Add In that can fix the issue. As...

I have a project where I need to concatenate data (employee names) from a field in a table where the field for cost codes in the table match the field for costs codes an open form. I have used the following sql in a query based on a module that PHV and MRemou helped me with years ago. 'This is...

I have been trying to filter the data in a subform using multiple filters in the main form. Each of the filters work individually as I have written them but my efforts to combine the criteria of the filters has me stumped. The goal is to filter the date in the subform based on multiple combo...

Hello all... I have what I thought to be simple dcount in some VB code that is making me crazy! The code reads: strTotalMonHrs = DCount "[WEID]", "TblTimeSheetsDailyLogEmployees", [WEID] = strWEIDCode) Error that this creates is that the database "can't find the field "|" referred to in...

Ok this is what I am trying to do... I have a simple form that has the folliwing cells. [ProductQuantity] [Cost] [Margin%] [Sell] [ProductQuantity] & [Cost] are numbers entered by the user The user also needs to enter either the [margin%] or the [sell]. If they enter the [Margin%] then the...

I have form with a multi-page tab control on it. All of the tabs/pages have data-sheet subforms on them. Data on the data-sheet on the 2nd tab is a product of selections made in the data-sheet on the 1st tab. After the user makes the selections on the 1st tab, the database runs an append...

This is the code that I am using to try to change the value of a cell back to 0 if two other cell values meet specific criteria. If Forms!FrmFixtureDetailing!FrmFixtureDetailingReleases!OpenInfo < 3 And Forms!FrmFixtureDetailing!FrmFixtureDetailingReleases!RequiredInfo = 1 Then...

I have a combo box on a form that is based on "Yes/No" data type. The combo box is used to filter data in a subform that is also "yes/no" data. This code works just fine when it is based on "Text" datatypes but is erroring out when I try to apply it to the "Yes/No" data type. This is the code...

I have a form wherein I use the following language: Forms!FrmProjectPricing!FrmProjectPricingFixturesSubform.Form![Unit Cost] = Eval("IIf([Forms]![FrmProjectPricing]![FrmProjectPricingFixturesSubform]![PPFixtureLotPriceName] Is not...

I have heard of either a module or an add-in that allow re-sizes the viewable area of a database to fit multiple screen sizes without all of the scroll bar issues. Can anyone direct me to such a code or plug-in? Your help is much appreciated...

I am trying to simplify sending reports via email and rather than using the send object method and having an rtf or snp snapshot attachment I would like to know if anyone has come up with a straightforward way to embed the report directly in the body of the email. One possible hickup is that...

I am trying to create a button to filter data on a subform located in a tab control. The subform's query has a field with an expression where if certain check boxes are checked, the expression produces "1". If none of the check boxes are not checked, the expression produces a "0". This is...

I am trying to filter the data in a subform based on a combo box "Combo16" in the main form. The code that I am using is: DoCmd.ApplyFilter , "Forms!FrmBallastTracking!FrmBallastTrackingSubform![Project Name] = Forms!FrmBallastTracking![Combo16]" The error that I get is that the form is not...