Search results

This problem has plagued me for years and search as I might, I haven't come up with the perfect solution. I'm in Canada and work for clients in the US, the UK etc. While I'm not a programmer, sometimes, I use Access to help them solve relatively simple business problems. Sometimes these are...

I'm not sure I totally get pivot charts yet but I have one that I want to change an axis scale via VBA. On the X (horizontal category) axis, I have a range of dates. The chart is based on the entire recordset but I want the user to be able to look at a subset. When I try a manual filter on...

I didn't do the AND with shiftid and productid. That makes more sense now. But I have abandoned the idea. I came to the same conclusion and am writing a function. So that I have access to the resulting data, I'm using the function to create a temp table to work with. Thanks for your help. ML!

Oh I figured out what you were saying about the renumbering. While I'm not contemplating deleting records (the test would just fail if the record didn't exist) what I didn't consider was what happens if data was entered out of order. You're right as usual, I can't use the ShiftID in the...

I'm confused (again). I'm not contemplating deleting any records. I just need to know if ProductID 1 is in tblShiftProduction where Shift = (ShiftID-1). If not possible to do with DLOOKUP in an expression, is there another way to accomplish it in a query?

Autonumber

Been working on this for a bit...I think I know how I would do this in code but I really need to accomplish it in a query because I need to use the results in several other queries. In simple terms (left out unnecessary fields etc), I have a shift table and a another table with a one to many...

OK, that makes sense to me now Simon, thanks. I am using combo boxes for a similar item (Project Outcomes) and will absolutely incorporate your code into that process. However, with the analyses, from a usability perspective, I'd really like the user to be able to select mulitple items from...

Thanks for the reply Simon. I'm not sure I understand... A checkbox has no RowSource which is why I'm having trouble with the 'multiple' idea. Are you suggesting the CodeContextObject is the subform or the control is the subform? What does the ListDisplay function do?

I have a client table with a one to many relationship to a client project table. Each project can require multiple analyses. tblClient ClientID (pk) ClientFirst ClientLast ...etc tblProject ProjectID (pk) ClientID (fk) ProjectType ...etc tblProjectAnalysis ProjectAnalysisID (pk)...

Thanks RG, you've been very helpful. Whether onsite or remote, I'll followup with a post on what I find.

I've used lots of products/services like it...RDP, VNC and I use DellRemoteAccess for my own network when I'm out of my home office but haven't used LogMeIn. But you raise a good point, I should ask their network admin if their firewalls would allow it...especially since they're an hour away. I...

I'll give that a try and let you know what happens. I'll have to do that onsite which will be sometime this coming week. I use recordset and database references throughout the app and haven't explicitly referenced DAO at all. I've been careful not to use any code that references ADO either to...

Hi RuralGuy Same version of Access, OS is different. I'm on Windows 2007, they are on XP. There is a highlighted line and before I posted here, I did ask but am waiting on the user to tell me what it is. It might be this code that refreshes the backend table links because it is the only...

Database opens in break mode I can't recreate this on my local copy but my db launches in break mode on another workstation. The debug window opens which of course confuses the user. The db is split with the tables on a shared network drive. Error trapping is set to break on all unhandled...

Thanks Trevor, I came to the same conclusion last night. I am guilty again of trying to make Access work like Excel. I have already restructured the table as you suggested. I appreciate your input.

Hi Trevor, That's precisely my problem. The 'transaction' table captures values described by parameters for each transaction. In this case, the transid = 174. In this transaction, there are 2 parameters...A & B. I want to use those 2 values in a calculated control on a report. A is the...

Hi all, It seems like this should be easy but my sleep deprived brain isn't operating at full capacity. See the image for a representation of query results isolating 2 records that make up transaction #174. I want to be able to use the 2 parameters for the same transaction in a calculation...

Hey Graham! Thanks so much. I do remember changing that now. You've saved me a whack of time! ML

Why would error trapping not be working in my app? I'm using Access 2007. To try to track the problem down, I created a dummy form and wrote some simple code on a cmd button and forced a div by 0 error. The standard VBA msg box is displayed with run-time error 11. The Error function seems to...