Search results

Simply as a means of taking a horrible flat, text file and putting it somewhere I'm familiar with. The text file was not csv or delineated in any way, so I had to use an accompanying document to manually specify field beginning positions and lengths. Then I imported it in all of its glory and...

Is there a way to match these up based on row number? This flat file contains 234 fields, so if I could say 'APPEND where record number 1 from Table A = record number 1 from Table B' it would save me a ton of time.

Oh, man. One of those days. Thanks for helping me past this low point in my week :banghead: :D

I tried, but I believe the field names need to be the same?

Using the attached image, I want to either update all of the field names on the right table to those on the left or append the records from the table on the right to the table on the left. The fields from both tables are in the same order, but have different names. What can I do? Thanks.

Where are the Excel gurus! My usual excel forums can't even answer this one. I don't know what I did but it's working now...

So, if a change is made on the second form, the main form checkboxes update, but that update doesn't trigger the on current code to display the label? Or the checkboxes don't update?

In the attached image I have two graphs that are based on pivot tables from the same dataset, use the exact same pivot fields, and also are based on the exact same custom chart template. In one graph, if the series for the horizontal line is all zeroes, the line will not appear - this is what i...

Hi CJ. The Not in List event only works when Limit to List is set to Yes. I think I will need to go about this a different way.

I must not have it configured right then. I will take another look.

I don't think this will work as I don't want to limit to list I just want a warning to display if something isn't in the list.

Is there a built-in property to check if the value in a combobox is in the RowSource or not? I want to show a label on my form if the value entered in the combobox isn't in the "list".

Genius! I was just trying to reconcile how I would even create the join.. I was thinking about using a subquery in lieu of a join - that should work as well provided I can figure out the syntax, correct? I should have no overlap issues in this case, but I do appreciate you mentioning it. In...

I don't really know how to solve your #Error, but I think you could create a separate query that summed the form values and then import that into the footer. You may need to requery the form after the calculated fields...calculate. If that doesn't work let us know.

Wow, what a horrible title.. I have this cross reference table that says: For (text) codes 10021-69900 Use multiplier .15 70010-79999 use .20 0001M-0004M use .50 I want to write a query that can then reference the text codes and apply the correct multiplier. I'd like to do this without...

You're welcome. If it's urgent I would recommend to create a new thread with a link to this one and explain it's urgency. This thread has a possibility of being buried.

Keep your original code, and ONLY place the AltPrintScreen portion in the On Click sub. Beyond that, I'm not sure how much help I can be, but I'm sure someone else on here can.

Did you try to copy and paste the AltPrintScreen sub into the On Click sub you just created? Replace the "MsgBox" code with that and see if it works or returns errors.

Sorry about my wording, just a Public sub is what I meant. Instead of using the "Expression Builder" click on "Code Builder" when selecting the on click event property. From there type something simple like MsgBox "It works!?" in the sub and see what happens when you click your button.

Create a Public function that does something simple and see if you can run it using the On Click Event of the button. If so, then it's possible that your Private function can't be called or it could be something else. Try moving your code into a Public function if possible.