Search results for query: *

Well, nobody's replied to my message, but I think I may have an answer. I just need to test it out. The problem lies in the multi-user aspect of the database. The code works better if I am on a single user PC, but when the database is hosted on a fileshare, it works differently. I've read...

Hi there: Using Microsoft Access 2007, I have a form that has both a personal data (child) table/form component and a sub-form component that tracks a personal device (PD) that is being loaned to the child. I have 4 tables: 1. Family for the Child 2. Children (linked to Family using Family...

Hi: I need to write a formula that looks up multiple (ie: more than two) columns in a named data range. The trick is, I need to select specific rows where I know the fixed values of three to five of the columns. I know INDEX/MATCH can handle two column values when trying to locate specific...

Skip: I understand where you are coming from. What you say makes sense. But my new question becomes: How do you ASSESS and CHANGE a RANGE's values in the FROM RANGE loop? I'll do some searching in this forum and see what I can come up with. Thanks again. marcus101 Access/SQL/XML Developer...

Skip: Before I try this, just curious: Here is the code you used: For n = 1 To intcounter ' COPY the list value resultList(n).Copy ' Paste the value multiple places dest_cells.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False...

Skip: OK! I hope the copy part works. I will put this all together and try it out. Thanks, marcus101 Access/SQL/XML Developer Ottawa, Canada

Hi Skip: Thanks for the suggestion. I don't see what this does other than making my array of cells a range. If this makes the paste operation work better, then great. It's a bit problematic because in my application, I don't just have one set array of cells but multiple sets I have to...

Hello: This is a repost of my previous code. My apologies if things were unclear. I have used the indenting tool as well as cleaned things up and commented more extensively as to what I am trying to accomplish. I am running into the occasional sub-scripting error with this. I am not sure if...

Hello: I'm currently working on an Excel 2003 Spreadsheet with VBA. I'd like to do the following: 1. I have an array of data values for a range of cells. 2. I have a range of cell locations I'd like to copy the values to. 3. I'd like to check the array of data values so I can make sure that...

Hello: I'm experimenting with some Excel 2003 automation using variable ranges and selections from two different workbooks. One is a data file with about 25,000 rows, the other is a basic output file that is acting as a reporting template. Here's what I'd like it to do: I'm currently...

Hi genomon: Sorry to report, but I've already tried that - it's covered in the FAQ I mentioned. I am still getting hangups and locks. Here is what I have right now: OnNoData: On Error GoTo ErrorHandler MsgBox "No Records Available To Print For This Report.", vbOKOnly, "NO RECORDS...

Hello: An update: The error trap now seems to work, and I get the Message Box informing there is no data to populate the report.. But now the display just freezes at the form and doesn't let me use it - I have to totally exit Access because of this crash. Thanks in advance for any ideas on...

Hello: I'm really scratching my head on this one. I've been rewriting some code for my database but something that seemed to work fine before now apparently doesn't, or at least, not as I'd expect. Here's what I have: I have a form that populates certain fields in a query that is used as the...

Hello: Just a quickie this time :-) Was wondering if it is possible to manipulate the main Access database window. In particular, I'd like to be able to do the following: 1. Move the position of the Database Window to any coordinate. Not really important, but it would be a "nice to be able...

Hello: My code is pretty extensive, and I figured what I had described was fairly straightforward. I still think it's straightforward, but some people only seem to be able to work well by trying to make things more complicated than they need to be, or are....;-) So to sum up: AceMan: Yes...

AceMan: I DO understand where you're coming from, but respectfully, here's my thought: If what you say is TRUE, then WHY can I use a recordset object to PRINT my current numeric position on a form? It stands to reason that if I can get and use that value from THERE, I should just be able to...

Hello: Weird. I tried running a variation on this code and I got a total (sum) of numbers rather than 1, 2, 3, etc for my RCount customized field-that-uses-an-SQL-query-to-populate. Here's my revised SQL code: SELECT (SELECT Count(G2.[LoanFile]) AS RecNo FROM [Clients] AS G2...

Hello again: Have a bit of a strange request, more for interest than anything else. I want to know if it is possible in any way to insert a piece of code into the VBA editor that will essentially instruct Access to do things if the user clicks on the Close button of the Database Window. I...

Hi AceMan/ProgramError: Good suggestions, but perhaps I didn't quite make this clear enough in my first post, so I'll reiterate: I DON'T HAVE AN AUTONUMBER PRIMARY KEY IN MY FORM TABLES. (breath) Here's the thing: My primary Key is a client FILE number, which means it's not a nice neat...

Hello: I have a bit of a tricky dilemma, and I'm not sure how easy this is to solve... Here's what I am working with: I have a form that executes a search of Client Names and File Numbers. The form record source is based on two tables that are linked in a 1-1 relationship based on a simple...