Search results
-
O
Import and export data
Look up the help on this: DoCmd.TransferSpreadsheet You can code this so it will export a spreadsheet of the data from DB1 - just use the query you made as the source. You can specify the file location where to put it or have the user choose by using a dialog box, but that is more involved... -
O
E-mail warning message
Ahh....well bmail is a great little command line tool for emailing without much hassle. Works great for simpler stuff like sending logs or error alerts. -
O
Test to determine if cell contains a number?
In mine, it returns false when the format of the cell is set to text. -
O
Test to determine if cell contains a number?
No, no I was trying in VBA. I used IsNumeric and it actually works fine without converting the text cells to number cells. -
O
Test to determine if cell contains a number?
Well...I'm guessing that would normally work. Since it's a number stored as text, isnumber returns false. oops...was typing something wrong. Okay I think I can get it to work but I'll have to convert each cell to a number first. -
O
E-mail warning message
Check this out: http://www.beyondlogic.org/solutions/cmdlinemail/cmdlinemail.htm -
O
Test to determine if cell contains a number?
I have a spreadsheet, and I have some formatting which is done to remove text lines after a certain point, etc. Anyway I want a test to count how many rows start with a cell that contains a number. This is to be used as a control so as to compare the number before and after the program is run... -
O
How To run Access database without having to install Access on user PC's
You can either use the Access runtime or you can write a VB program. -
O
changing UPPER CASE letters to lower case doable?
I don't think you can use that in a query...not positive. But that will work in VBA I know. Ahh - jfgambit is right - have to use the number, not text. -
O
changing UPPER CASE letters to lower case doable?
Put this in the field name for the query: FName: UCase(Left((LCase([FIRST_NAME])),1)) & Right((LCase([FIRST_NAME])),(Len([FIRST_NAME])-1)) Repeat with the other field. -
O
Access to Excel and back again
Well honestly you should do the calculations in Access because coding Access to control Excel in this manner may end up being just as cumbersome as converting the worksheet. -
O
Help Plz!
Do you have an ID field? If you do, then you can do a pretty simple totals query to do this. Design a new query, click on the Sigma ("E" looking greek character) button - this will give you a totals query. Drag the PO# and select "Group By" under the Totals area. Then drag the ID (or any... -
O
Removing multiple duplicates from a worksheet.
Yeah it's just that this particular sheet is extremely important and if something was removed that shouldn't be it can be a HUGE issue - we're talking compliance with federal laws and stuff so yeah I'm being a bit over paranoid with this project. Thanks for the help - it's working now. And in... -
O
Removing multiple duplicates from a worksheet.
Yeah I saw that...I was mistakenly thinking I needed to search the whole range from the top, but I see what you did :) -
O
Removing multiple duplicates from a worksheet.
Never know. I prefer a manual method. -
O
Removing multiple duplicates from a worksheet.
Oh I see what I did....oops. I was thinking incorrectly. -
O
Removing multiple duplicates from a worksheet.
Well....I did a search for an account number - it only found 2 of them. This is the code I have in the corresponding cells to the left of these duplicate account numbers: =COUNTIF($B$8:$B$1898, B46) and =COUNTIF($B$8:$B$1898, B47) Both A46 and A47 have a value of "2" in them. -
O
Removing multiple duplicates from a worksheet.
Because it's doing the work itself, and I'd rather have a program do only exactly what I instruct it to do. -
O
Removing multiple duplicates from a worksheet.
Okay that would work to identify the rows that need attention, but after that then what? If I filtered anything > 1 and then deleted it, I would delete the duplicates, but I would also delete the ALL of those account numbers. Both the first instance and the next instance will have numbers > 1...