Search results

And the code.... ' ***************************** ' **** BUILD SQL SEARCH STRING **** ' ***************************** ' Select fields and join supporting tables... strSQLFields = "SELECT tbl_Initiative.InitiativeID, tbl_Initiative.FutureFundingPriorityID, tbl_Initiative.JurisdictionID...

Alright, I don't want to hear any laughing about this one ;) I realize that this query isn't likely the most efficient way of achieving my desired results, however it is the only way I can get it to work the way I need it to. Modifying my table structure is not an option, as A) I've written...

Update That's a good idea Pat...here's a fairly comprehensive overview of the results I'm getting under various conditions... I have a bound form, bound to tbl_Deliverables, and an unbound form that is simply trying to run an SQL UPDATE query... With the bound form set to "NO LOCKS": - If I...

Uh oh...I am in fact using a Memo field for a few of my tables--tell me more about this bug... :( I think I may be overestimating the transaction volumes this database will be handling, so I'm going to do some testing with No Locks and see how it goes. As far as bulk updates...are my action...

What about the LockEdits property of the .OpenRecordset method? It would suffice for me to be able to specify a locking-type when I open my recordset, and have it persist until I close out that recordset....would this work the way I think it would? Taking a quick look through MSDN, I see...

I'm currently using a textbox on my form described as follows: OLE Class: Microsoft Forms 2.0 Class: Forms.Textbox.1 When I'm entering data in the textbox it periodically--and completely randomly--loses focus in favour of various other controls on the form. I have no timers or other things on...

You caught me Pat :o This is in fact my first Access application. I've done a lot of development previously in C and just feel "right" coding exactly what I want to happen. On the upside, the application works great, and I've got a manageable balance of scalability and low-level control...

Here's my daily question for you geniuses ;) What is the prefered method of saving records in a multi-user environment? My project is nearing completion, and I've begun to turn my attention to recordlocking, and the methods with which I am saving records in general. Currently my code is...

Thanks Nice...thanks Chris. Sam

Hey, thanks for the reply Rich...I was hoping for something I could do FROM the actual form that the listboxes are on...any ideas? Thanks, Sam

I've currently got this working by using the Form_Activate event, however I don't like this method, because it kind of seems dirty... :D I've got a Form with a listbox on it, and a command button right under the listbox...when the user presses the command button it opens another form where the...

Thanks for the replies, I'll try some of those things...however for the most part I think my code is optimized as much as possible--I'm not using any D* functions or anything. Adam--That'd be great if I could get a copy of that linking utility you have...yeah, access's built in utility sucks...

One of my forms is so painfully slow to load/save/do absolutely anything with, that I can literally go get a coffee, and come back to my desk and it's still working. The database is currently being stored and access by me (for developement purposes only) over a 100mbit network, however I'm...

Hey folks, I've got a multi-purpose form that gets called from a bunch of other different forms, and it deals with data on those forms depending on which one called it. I currently have all of the calling forms calling this multi-purpose form by passing it Me.Name, and then in the multi-purpose...

Yeah, it is. All of them are 1-to-many though, and it USED to show up as just a "1", which makes sense. Now it shows up as a "1L" or something...and as far as I know, nothing has changed in the way the tables are related... Have you seen that "1L" before? Sam.

Can't be...I've double checked all the relationships--they're all one-to-many. Sam...

Ahhh...here goes.. Sorry bout the bitmap, I've only got MSPaint... So what does that little "1L" mean beside InitiativeID? I've got other tables in the model that have the same properties, with a ID field linked a similar number of times but it just says "1" instead of "1L".... ??? Sam.

That's a good idea...but I don't have anywhere to host it... is there a way to embed it into my post? Sam.

If use the recordset objects .AddNew method, is the current record of the recordset object then the newly added record? Or do I need to .MoveLast first? EDIT: Also, wouldn't it be much faster to use a stored querydef to INSERT a new record rather than opening the table in a recordset in code...

I know someone must know what this is--cause I'm convinced it's a dumb question! Anyone? Sam.