Search results for query: *

I wanted to automate determining when holidays occur. Looked on the internet and found an example for Labor Day posted on www.chandoo.org illustrating a good use for the CHOOSE instruction. Following are formulas that work for the holidays indicated Enter the year of interest in cell D3 of a...

I have this PC (the one I'm entering this message with) connected to a Motorola cable modem. The modem should be current - it's used by Time Warner to provide All in One - internet, cable TV and phone service. At the moment, this is the only operational PC and I don't want to keep it in the...

I've already been assisted with most of my automation project, but ... When I "Save As" to create a tab-delimited text file to be imported into G/L, the end of the file is often after the last actual data. That causes a problem with the G/L program when imported, so now I have to manually...

I CAN figure this out ... I think ... but maybe someone has a clean and easy way. Our pay periods (multiple locations) end on Sundays. Accounting staff presently post G/L entries related to payrolls by manually typing from a payroll report. I've developed a spreadsheet with a bit of VBA that...

Hello, Thread thread707-1169212 got me started in the right direction, but ... The worksheet is used to tally survey results. It's working well and I want to make it better. Each row corresponds to a question number. In use, the code locks cursor positioning into B and the User types the number...

Greetings! Since the letters are on the screen, I'm connected ... for now. Full story is long, but in case someone recognizes the problem and has a solution... Using wireless MS kit (MN-610, MN-500 router and MN-510 USB wireless adapter) for 802.11b connection to Time-Warner cable modem. Worked...

Merry Christmas to all of the helpful folks who contribute to the usefulness of this site! I want to react to a keystroke in a specific cell and add to a counter in another cell based on the keystroke entered. For example: A1 = the target cell. If 1 is typed, add 1 to C1 If 2 is typed, add 1...

I need a macro to help me with a tally task. I want to react to a keystroke in a specific cell and add to a counter in another cell based on the keystroke entered. For example: A1 = the target cell. If 1 is typed, add 1 to C1 If 2 is typed, add 1 to D1 etc Freeze selection to A1 so I can zip...

I need to be pointed in the right direction. If someone has done this, sample VBA code might get me going. (I used VBA several years ago with Access. And have a failing memory. If there are differences between using VBA with Access and using it with Excel, advising of those would also be...

I need to be pointed in the right direction. Question: How can I take an initial selection in Excel and use that to trigger unlocking other cells which need to be filled in based on that initial selection? We are using an Excel-based form to document employee changes for entry into the...

The answer may be somewhere in the Microsoft site, but... I'm wanting to learn more about SQL and plan to install the desktop engine. The MSDE implementation of SQL 2000 is stated to run using Win XP Home Edition, whereas its successor, SQL Server 2005 Express is stated to require Win XP...

I may not have posted in the correct forum... Apologies and please point me in the direction. I need to temporarily connect a Win 98SE PC to a Win XP so I can transfer data files. (My wireless network is 802.11B, so is a bit slow for the graphic files.) I have a crossover cable and did this in...

I've searched, read and scratched my head ... NOTHING has helped! In an Access Project I identify Users by their NT (2000 actually) logon. I want to pass that logon to a Stored Procedure so that a form is populated by members of that employees team, only. Is is possible? Thanks! Bob

Hi! My answer is probably here already ... somewhere ... I have a Form + Subform that is used to view existing data AND enter new subform records. Not that it is important, but the Form is proloaded with no entry/editing allowed. When the >* button (custom) is selected to enter a new form...

I'd like to be able to create a msgbox that does not have an X... The reason is that an update is run after the User selects OK. If they select the X, the update doesn't run - and problems result. Is that possible?

Hello! I previously posted - thread958-733421 - but still have the problem that Users can use navigation buttons (standard) to advance to a new record repeatedly with no subform records created. This leaves orphans in the "one" table. Environment = Access 2000 Project with SQL 7 engine...

The following link is to a web page authored by Allen Browne. It contains a comprehensive explanation of NULL as used by Microsoft Access. It includes common mistakes AND how to correct them. http://members.iinet.net.au/~allenbrowne/casu-12.html HTH, Bob [morning]

Thanks for assisting! I used Advanced Search and didn't find any useful threads. I'd like to see examples and/or blank forms that professionals use to document their databases. My question arises because an important table was deleted and it occurred to me that it is very shortsighted that we...

Goal is to pass dates from Access form controls through to SQL 7 backend for use within a stored procedure. First, I want to get the SQL end working, and have one stored procedure executing a second dynamic dynamic stored procedure. Executing the following results in error message: Must...

TIA, I'll probably figure out a workaround, but am posting for feedback and because this may be annoying others. I have a drop-down combo box that is populated by a Select statement. If I enter a record and then try to duplicate an entry in a subsequent record using the shortcut key of...