Search results for query: *

I was helped in another thread in relation to this problem, but ive tweaked my needs and now im not sure how to resolve... I currently have two tables. The MASTER TABLE has a list of accounts and quantities. The SECOND table has additional quantities that need to be merged in by account #...

I currently have two tables. The MASTER TABLE has a list of accounts and quantities ordered by effective date. The SECOND table has additional quantities that need to be merged in by account #, however,the quantities need to be merged on where the earliest dated account row is. For example...

I have an access table that is over 2 million records. I can't chage the data type on one of my fields because i am getting an error message stating that there isnt enough space or memory... 1 - Is there a work around? 2 - If not, can an update query be written so that I can update the data...

The below code exports information for me from Access to Excel, and this works perfectly, however, I need for the export to properly format my excel sheets before the export (bolding, column sizes,etc.). Based on the coding below, what would I need to add to this in order for this to work...

I've recently received feedback from thread701-1198915 (thanks to BoxHead) on how to export an Access table to excel using a command button. Is there also a way, with VB script, to not only place the excel file in a designated directory on a PC, but also, when exported, it opens a new outlook...

Sorry if this is a repost, I think I posted in wrong forum... I currently have an Access table that I am trying to use the field data as a means of exporting. For example, I have a table with a field labeled [VENDORS]. There are different vendors within the [VENDORS] table. I would like to...

I currently have an Access table that I am trying to use the field data as a means of exporting. For example, I have a table with a field labeled [VENDORS]. There are different vendors within the [VENDORS] table. I would like to export so that it groups the same vendor names together and...

I need to create a template that allows you to plug in someone’s annual salary and then it breaks it down monthly and applies the appropriate taxes…. But I am not sure this can be done. So you would plug in an annual salary somewhere and then the next 12 columns (Jan-Dec) would plug in the...

I am trying to extract items in Field 1 based on a criteria in Field 2. For Example, I want the query to only pull back data on the record 1234 since that record has no "Y". However, if I dont want record 123 and 12345 to appear since if you group those numbers, there is a "Y" and an "N", I...

Currently trying to fix an Active X error on a friends PC. Even after changing the IE settings so that all Active X settings are Enabled, still cannot download things that require active x. I get an error msg asking to turn on Active X. Windows update website requires it to make installs...

I'm trying to create a nested if this is giving me a "#VALUE". If you break up the IF statements, they work fine by themselves, but when combined, I get the #VALUE. Any thoughts? =IF(H65<F67,0),IF(H62<(H65-F67),(H65-F67),SUM(H60,H61,H62,H63))

I have a form that is linked to table information. When I click on new record it submits a blank record on the form. I want to be able to type into a box that is NOT null, however, once a form has text in it, I want it locked so noone can go in and change it accidently. Any help? Thanks

I'm trying to produce a time period on a report,however, I'm not sure how I need to go about it. For instance I have a field called "Date". In that fields are random dates. I want a query that will produce a field that results in something like this: 1/1/2004 - 3/5/2004 I don't know if it...

I've been adding new variables to my IF then statement as I need to, however, when I went to add my 15th nested IF THEN statement, I got an error msg stating "Expression Too Complex"?! Is there a way for me to avoid getting this? Or away around this? And does Access have a limit?

I have two (2) Text Fields on my report, for instance, Text1: Control Source: IIF([A]=0,B) Text2:=Sum[Text1] When I run the report it cannot find the Text1 field. Is it because im referencing a text field that contains a formula? Any help would be great. Thanks in advance.

I have a query with the following code: Expr1: IIf(([A]=0,([F]-[B])),IIf([B]=0,([C]-[A]-[D]+[E]))) I can only get the query to work if i used of the IIF statements, it wont allow me to use both in the same expression, not sure why? Anyone have any thoughts? Thanks in advance!

Is there a way to hide certain objects on the OBJECTS tab database window? I only want users to see the FORMS and REPORTS TAB. I do not want them to have access to the TABLES, QUERIES and MACROS tab. Any help? thanks

I've built a form then incorporates a CMD BUTTON, that when click runs a MACRO, which then runs a couple update queries. Is there a way so that when I click the CMD BUTTON it automatically does the update without being prompted everytime?

I'm trying to write an update query that has nested IF's, however, when I run the update I get 0's and -1's instead of the values Im asking, my query logic is below: IIf([LEAD]=&quot;CHRISTINE&quot;,1) Or IIf([LEAD]=&quot;KEVIN&quot;,2) Or IIf([LEAD]=&quot;LYNNE&quot;,3) Or...

How would i go about removing negative values that I have in a table? I only care about the actual whole number. Is there some type update or criteria I can use?